• Describe the components, architecture, and nature of a BI solution.
• Create reports with Reporting Services.
• Create reusable report items that simplify self-service reporting.
• Manage report execution and delivery.
• 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 PowerPivot.
• Use DAX to query a tabular model.
• Implement a Tabular Database.
• Use PowerView to create interactive data visualizations.
• Use Data Mining for Predictive Analysis 

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions.  Primary responsibilities include:

• Implementing reporting solutions by using SQL Server Reporting Services.
• Implementing multidimensional databases by using SQL Server Analysis Services.
• Creating tabular semantic data models for analysis by using SQL Server Analysis Services.
• Create visualizations of data by using PowerView.
• Create data mining solutions by using SQL Server Analysis Services.

This course prepares for the exam 70-466.

Module 1: Introduction to Business Intelligence and Data Modeling
Module 2: Implementing Reports with SQL Server Reporting Services
Module 3: Supporting Self Service Reporting
Module 4: Managing Report Execution and Delivery
Module 5: Creating Multidimensional Databases
Module 6: Working with Dimensions
Module 7: Working with Measures and Measure Groups
Module 8: Introduction to MDX
Module 9: Customizing Cube Functionality
Module 10: Implementing a Tabular Data Model with Microsoft PowerPivot
Module 11: Introduction to DAX
Module 12: Implementing an Analysis Services Tabular Data Model
Module 13: Creating Data Visualizations with Power View

• At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
• Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
• Some exposure to basic programming constructs (such as looping and branching).
• An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.