Designing Self-Service Business Intelligence And Big Data Solutions

Our Designing Self-Service Business Intelligence and Big Data Solutions course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to use Microsoft SQL Server Reporting Services, Microsoft Excel, and Microsoft Office 365 to deliver a self-service BI solution, and how to use Microsoft Windows Azure HDInsight to incorporate Big Data analysis into a BI scenario. Microsoft Azure and Office 365 are required or used as part of the lab for this course, which may not be available in all countries

Pre-requisites

Before attending this course, students must have:

A basic understanding of dimensional modeling (star schema) for data warehouses.
The ability to create Integration Services packages that include control flows and data flows.
The ability to create a basic multidimensional cube with Analysis Services.
The ability to create a basic tabular model with PowerPivot and Analysis Services.
The ability to create Reporting Services reports with Report Designer.
The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services.
Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel.

Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:

10777A: Implementing a Data Warehouse with Microsoft SQL Server 2012
10778A: Implementing Data Models and Reports with Microsoft SQL Server 2012

Course Content

• Module 1: Introduction to Self-Service Business Intelligence
• Module 2: Self-Service Reporting
• Module 3: Self-Service Data Modeling by Using PowerPivot
• Module 4: Importing Data with Power Query
• Module 5: Visualizing Data with Power View in Microsoft Excel
• Module 6: Visualizing Geographic Data with Power Map
• Module 7: Collaborative BI with Microsoft SharePoint Server
• Module 8: The Microsoft Azure Marketplace Data Market
• Module 9: Cloud Collaboration with Microsoft Power BI for Office 365
• Module 10: Introduction to Big Data and Microsoft Azure HDInsight
• Module 11: Processing Big Data with Pig and Hive
• Module 12: Implementing Big Data Processing Solutions with Microsoft Azure HDInsight

Exam to be taken after completing the 5 day Designing Self-Service Business Intelligence and Big Data Solutions 2014 (M20467)

• Exam 70-467 - Designing Self-Service Business Intelligence and Big Data Solutions 2014