- Introduction to Business Intelligence and Data Modeling
- Creating Multidimensional Databases
- Working with Cubes and Dimensions
- Working with Measures and Measure Groups
- Introduction to MDX
- Customizing Cube Functionality
- Implementing a Tabular Data Model by Using Analysis Services
- Introduction to Data Analysis Expression ï´¾DAXï´¿
- Performing Predictive Analysis with Data Mining
Introduction to Business Intelligence and Data Modeling
- Introduction to Business Intelligence
- The Microsoft business intelligence platform
Creating Multidimensional Databases
- Introduction to multidimensional analysis
- Course details
- Creating data sources and data source views
- Creating a cube
- Overview of cube security
Working with Cubes and Dimensions
- Configuring dimensions
- Define attribute hierarchies
- Sorting and grouping attributes
Working with Measures and Measure Groups
- Working with measures
- Working with measure groups
Introduction to MDX
- MDX fundamentals
- Adding calculations to a cube
- Using MDX to query a cube
Customizing Cube Functionality
- Implementing key performance indicators
- Implementing actions
- Implementing perspectives
- Implementing translations
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
Introduction to Data Analysis Expression ï´¾DAXï´¿
- DAX fundamentals
- Using DAX to create calculated columns and measures in a tabular data model
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