1 – Introduction to Business Intelligence and Data Modeling
- Introduction to Business Intelligence
- The Microsoft business intelligence platform
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
- Define attribute hierarchies
- Sorting and grouping attributes
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 – Customizing Cube Functionality
- Implementing key performance indicators
- Implementing actions
- Implementing perspectives
- Implementing translations
7 – Implementing a Tabular Data Model by Using Analysis Services
- Introduction to tabular data models
- Creating a tabular data model
- Using an analysis services tabular model in an enterprise BI solution
8 – Introduction to Data Analysis Expression (DAX)
- DAX fundamentals
- Using DAX to create calculated columns and measures in a tabular data model
9 – Performing Predictive Analysis with Data Mining
- Overview of data mining
- Using the data mining add-in for Excel
- Creating a custom data mining solution
- Validating a data mining model
- Connecting to and consuming a data mining model