Module 1: Introduction to Business Intelligence and Data Modeling

1. Introduction to Business Intelligence

2. The Microsoft business intelligence platform

Module 2: Creating Multidimensional Databases

1. Introduction to multidimensional analysis

2. Creating data sources and data source views

3. Creating a cube

4. Overview of cube security

Module 3: Working with Cubes and Dimensions

1. Configuring dimensions

2. Define attribute hierarchies

3. Sorting and grouping attributes

Module 4: Working with Measures and Measure Groups

1. Working with measures

2. Working with measure groups

Module 4.1: Optimizing and Managing Multidimensional Databases (Additional Topic)

1. Deploying an SSAS database

2. Overview of deployment options

3. Processing the Database Post Deployment

4. Using SSIS Process tasks

5. Optimizing a Multidimensional Database

6. Instructor Led Practice

Module 5: Introduction to MDX

1. MDX fundamentals

2. Adding calculations to a cube

3. Using MDX to query a cube

Module 5.1: Intermediate MDX (Additional Topic)

1. Understanding Members, Tuples, Sets

2. Working with Hierarchies

3. Working with Common MDX Functions

4. Creating Named Sets and Custom Calculations

5. Instructor Led Hands On Practices

Module 6: Customizing Cube Functionality

1. Implementing key performance indicators

2. Implementing actions

3. Implementing perspectives

4. Implementing translations

Module 7: Implementing a Tabular Data Model by Using Analysis Services

1. Introduction to tabular data models

2. Creating a tabular data model

3. Using an analysis services tabular model in an enterprise BI solution

Module 8: Introduction to Data Analysis Expression (DAX)

1. DAX fundamentals

2. Using DAX to create calculated columns and measures

3. Going deeper into DAX

4. Creating KPIs

Module 9: Connecting to SSAS databases (Additional Topic)

1. How to use various tools to connect to SSAS multidimensional and Tabular databases