20467, Designing Self-Service Business Intelligence and Big Data Solutions

Module 1: Introduction to Self-Service Business Intelligence

Extending Enterprise BI
Microsoft Self-Service BI and Big Data Technologies

Module 2: Self-Service Reporting

Introduction to Self-Service Reporting
Shared Data Sources and Datasets
Report Parts

Module 3: Self-Service Data Modeling with PowerPivot

Creating Data Models in Excel with PowerPivot
Using DAX in a PowerPivot Data Model

Module 4: Importing Data with Power Query

Introduction to Power Query
Using Power Query to Import Data

Module 5: Visualizing Data with Power View in Microsoft Excel

Introduction to Power View
Creating Dynamic Data Visualizations

Module 6: Visualizing Geographic Data with Power Map

Introduction to Power Map
Using Power Map

Module 7: Collaborative BI with Microsoft SharePoint Server

Sharing PowerPivot Workbooks
Managing PowerPivot Services in SharePoint Server
Using Power View in SharePoint Server

Module 8: The Windows Azure Marketplace Data Market

Introduction to the Windows Azure Marketplace
Using Windows Azure Marketplace Data in Microsoft Excel

Module 9: Cloud Collaboration with Power BI for Microsoft Office 365

Introduction to Power BI
Natural Language Queries with Q&A
Sharing Queries
The Data Management Gateway

Module 10: Introduction to Big Data and Windows Azure HDInsight

Introduction to Big Data
Windows Azure HDInsight

Module 11: Processing Big Data with Pig and Hive

Processing Big Data with Pig
Processing Big Data with Hive

Module 12: Implementing Big Data Processing Solutions with Windows Azure HDInsight

Automating Big Data Processing Tasks
Integrating Windows Azure HDInsight with Enterprise Data

This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

The primary audience for this course is database and business intelligence (BI) professionals who are familiar with data warehouses and enterprise BI solutions built with SQL Server technologies. Experienced data analysts who want to learn how to use Microsoft technologies for self-service analysis and reporting will also benefit from attending this course.

This course requires that you meet the following prerequisites:

• Knowledge of data warehousing and data modeling principles.
• Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

Currently there are no Q&As for this course. Be the first to ask a question.