After completing this course, students will be able to:
Module 1: Introduction to Business Intelligence and Data Modeling
This module introduces key BI concepts and the Microsoft BI product suite.
Lessons
Lab : Exploring a BI Solution
Module 2: Creating Multidimensional Databases
This module describes how to create multidimensional databases using SQL Server Analysis Services.
Lab : Creating a multidimensional database
Module 3: Working with Cubes and Dimensions
This module describes how to implement dimensions in a cube.
Lab : Working with Cubes and Dimensions
Module 4: Working with Measures and Measure Groups
This module describes how to implement measures and measure groups in a cube.
Lab : Configuring Measures and Measure Groups
Module 5: Introduction to MDX
This module describes the MDX syntax and how to use MDX.
Lab : Using MDX
Module 6: Customizing Cube Functionality
This module describes how to customize a cube.
Lab : Customizing a Cube
Module 7: Implementing a Tabular Data Model by Using Analysis Services
This module describes how to implement a tabular data model in Power Pivot.
Lab : Working with an Analysis Services Tabular Data Model
Module 8: Introduction to Data Analysis Expression (DAX)
This module describes how to use DAX to create measures and calculated columns in a tabular data model.
Lab : Creating Calculated Columns and Measures by using DAX
Module 9: Performing Predictive Analysis with Data Mining
This module describes how to use data mining for predictive analysis.
Lab : Using Data Mining
The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.
Primary responsibilities will include: