While attending this training program – you take two exams to test and certify for the Microsoft Certified Solutions Expert (MCSE): Business Intelligence official certification. If your goal is to learn how to use SQL BI and pass the certification exams (70-466 / 70-467) – you’ve found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives.
Topics covered in this boot camp:
Describe the components, architecture, and nature of a BI solution.
Create a multidimensional database with Analysis Services.
Implement dimensions in a cube.
Implement measures and measure groups in a cube.
Use MDX Syntax.
Customize a cube.
Implement a Tabular Data Model in SQL Server Analysis Services.
Use DAX to enhance a tabular model.
Create reports with Reporting Services.
Enhance reports with charts and parameters.
Manage report execution and delivery.
Implement a dashboard in SharePoint Server with PerformancePoint Services.
Use Data Mining for Predictive Analysis.
Describe key features and benefits of self-service BI.
Use SQL Server Reporting Services to implement a self-service reporting solution.
Use PowerPivot in Microsoft Excel to create analytical data models.
Use Power Query in Microsoft Excel to import data into a data model.
Use Power View in Microsoft Excel to create interactive data visualizations.
Use Power Map in Microsoft Excel to create geographic data visualizations.
Use Microsoft SharePoint Server to implement collaborative self-service BI solutions.
Provision and use a Windows Azure HDInsight cluster for Big Data analysis.
Use Pig and Hive to analyze big data in Windows Azure HDInsight.
Design and implement Big Data processes to support self-service BI.