Microsoft Certified Solutions Expert: Business Intelligence 2012 Training

• Implementing Data Models and Reports with Microsoft® SQL Server®
• Designing Self-Service Business Intelligence and Big Data Solutions

• Describe the components and architecture of BI solutions
• Define the features and benefits of Self-Service Business Intelligence and Big Data Solutions
• Use Analysis Services and create a multidimensional database
• Use Reporting Services to create reports and enhance them to provide geographic and interactive data visualizations

• Use PowerPivot and Power Query in Microsoft Excel to create analytical data models and import data into a data model

• Use PerformancePoint Services in SharePoint Server to implement a dashboard
• Use Data Mining for Predictive Analysis
• Use Microsoft SharePoint Server to design and implement Big Data processes  to support collaborative self-service BI solutions
• Use Pig and Hive to analyze big data in Windows Azure HDInsight.

• Database Professionals
• Business Intelligence Developers/Professionals
• Data Analysts
• Reporting Engineers

• Atleast two years of work experience using relational databases
• Knowledge of data modeling  and data warehousing principles
• Familiarity with Microsoft SharePoint Server 2013 and Microsoft Excel
• Basic understanding of key business priorities such as financial accounting, revenue, and profitability

1. Introduction to Business Intelligence and Data Modeling

• Elements of an Enterprise BI Solution
• The Microsoft Enterprise BI Platform
• Planning an Enterprise BI Project

2: Creating Multidimensional Databases

• Introduction to Multidimensional Analysis
• Creating Data Sources and Data Source Views
• Creating a Cube
• Overview of Cube Security

3: Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Hierarchies

4: Working with Measures and Measure Groups

• Working with Measures
• Working with Measure Groups

5: Introduction to MDX

• MDX Fundamentals
• Adding Calculations to a Cube
• Using MDX to Query a Cube

6: Enhancing a Cube

• Working with Key Performance Indicators
• Working with Actions
• Working with Perspectives
• Working with Translations

7: Implementing an Analysis Services Tabular Data Model

• Introduction to Analysis Services Tabular Data Models
• Creating a Tabular Data Model
• Using an Analysis Services Tabular Data Model in the Enterprise

8: Introduction to DAX

• DAX Fundamentals
• Enhancing a Tabular Data Model with DAX

9: Implementing Reports with SQL Server Reporting Services

• Introduction to Reporting Services
• Creating a Report with Report Designer
• Grouping and Aggregating Data in a Report
• Publishing and Viewing a Report

10: Enhancing Reports with SQL Server Reporting Services

• Showing Data Graphically
• Filtering Reports by Using Parameters

11: Managing Report Execution and Delivery

• Managing Report Security
• Managing Report Execution
• Subscriptions and Data Alerts
• Troubleshooting Reporting Services

12: Delivering BI with SharePoint PerformancePoint Services

• Introduction to SharePoint Server as a BI Platform
• Introduction to PerformancePoint Services
• PerformancePoint Data Sources and Time Intelligence
• Reports, Scorecards, and Dashboards

13: Performing Predictive Analysis with Data Mining

• Overview of Data Mining
• Creating a Data Mining Solution
• Validating a Data Mining Model
• Consuming Data Mining Data