Course Description
Module 1: Introduction to Business Intelligence and Data Modeling
This module introduces key BI concepts and the Microsoft BI product suite.
Lessons
- Introduction to Business Intelligence
- The Microsoft business intelligence platform
Lab: Exploring a Data Warehouse
After completing this module, you will be able to:
- Describe the concept of business intelligence
- Describe the Microsoft business intelligence platform
Module 2: Creating Multidimensional Databases
This module describes the steps required to create a multidimensional database with analysis services.
Lessons
- Introduction to multidimensional analysis
- Creating data sources and data source views
- Creating a cube
- Overview of cube security
Lab: Creating a multidimensional database
After completing this module, you will be able to:
- Use multidimensional analysis
- Create data sources and data source views
- Create a cube
- Describe cube security
Module 3: Working with Cubes and Dimensions
This module describes how to implement dimensions in a cube.
Lessons
- Configuring dimensions
- Define attribute hierarchies
- Sorting and grouping attributes
Lab: Working with Cubes and Dimensions
After completing this module, you will be able to:
- Configure dimensions
- Define attribute hierarchies.
- Sort and group attributes
Module 4: Working with Measures and Measure Groups
This module describes how to implement measures and measure groups in a cube.
Lessons
- Working with measures
- Working with measure groups
Lab: Configuring Measures and Measure Groups
After completing this module, you will be able to:
- Work with measures
- Work with measure groups
Module 4.1: Optimizing and Managing Multidimensional Databases (Additional Topic)
This module describes how to deploy and optimize multidimensional databases post deployment.
Lessons:
- Deploying an SSAS database
- Overview of deployment options
- Practice deploying a sample database
- Processing the Database Post Deployment
- Using SSIS Process tasks
- Deploying SSIS projects
- Scheduling SSIS packages
- Optimizing a Multidimensional Database
- Configuring the SSAS instance for Usage Based Optimization
- Performing Usage Based Optimization
- Instructor Led Practice
After completing this module, you will be able to:
- Deploy a multidimensional database
- Use SSIS packages to manage SSAS databases
- Perform usage based optimization of Aggregations
Module 5: Introduction to MDX
This module describes the MDX syntax and how to use MDX.
Lessons
- MDX fundamentals
- Adding calculations to a cube
- Using MDX to query a cube
Lab: Using MDX
After completing this module, you will be able to:
- Describe the fundamentals of MDX
- Add calculations to a cube
- Query a cube using MDX
Module 5.1: Intermediate MDX (Additional Topic)
This module describes in detail the underlying terminology and functionality of MDX allowing students to better write MDX queries and expressions.
Lessons:
- Understanding Members, Tuples, Sets and how they work
- Working with Hierarchies and member “family” functions
- Working with Common MDX Functions
- Creating Named Sets and Custom Calculations
- Instructor Led Hands On Practices with MD Queries and Expressions
After completing this module, you will be able to:
- Describe when to use members, tuples, and sets
- Write more complex MDX queries and expressions
- Create named sets and calculated members
Module 6: Customizing Cube Functionality
This module describes how to customize a cube.
Lessons
- Implementing key performance indicators
- Implementing actions
- Implementing perspectives
- Implementing translations
Lab: Customizing a Cube
After completing this module, you will be able to:
- Implement key performance indicators
- Implement actions
- Implement perspectives
- Implement translations
Module 7: Implementing a Tabular Data Model by Using Analysis Services
This module describes how to implement a tabular data model in PowerPivot.
Lessons:
- Introduction to tabular data models
- Creating a tabular data model
- Using an analysis services tabular model in an enterprise BI solution
Lab: Working with an Analysis services tabular data model
After completing this module, you will be able to:
- Describe tabular data models
- Create a tabular data model
- Be able to use an analysis services tabular data model in an enterprise BI solution
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.
Lessons
- DAX fundamentals
- Using DAX to create calculated columns and measures in a tabular data model
- Going deeper into DAX
- Creating KPIs
Lab: Creating Calculated Columns and Measures by using DAX
After completing this module, you will be able to:
- Describe the fundamentals of DAX
- Use DAX to create calculated columns and measures in a tabular data model
- Create KPIs in tabular data models
Module 9: Connecting to SSAS databases (Additional Topic)
This module describes how to use various tools to connect to SSAS multidimensional and Tabular databases.
Module 1: Introduction to Business Intelligence and Data Modeling
This module introduces key BI concepts and the Microsoft BI product suite.
Lessons
- Introduction to Business Intelligence
- The Microsoft business intelligence platform
Lab: Exploring a Data Warehouse
After completing this module, you will be able to:
- Describe the concept of business intelligence
- Describe the Microsoft business intelligence platform
Module 2: Creating Multidimensional Databases
This module describes the steps required to create a multidimensional database with analysis services.
Lessons
- Introduction to multidimensional analysis
- Creating data sources and data source views
- Creating a cube
- Overview of cube security
Lab: Creating a multidimensional database
After completing this module, you will be able to:
- Use multidimensional analysis
- Create data sources and data source views
- Create a cube
- Describe cube security
Module 3: Working with Cubes and Dimensions
This module describes how to implement dimensions in a cube.
Lessons
- Configuring dimensions
- Define attribute hierarchies
- Sorting and grouping attributes
Lab: Working with Cubes and Dimensions
After completing this module, you will be able to:
- Configure dimensions
- Define attribute hierarchies.
- Sort and group attributes
Module 4: Working with Measures and Measure Groups
This module describes how to implement measures and measure groups in a cube.
Lessons
- Working with measures
- Working with measure groups
Lab: Configuring Measures and Measure Groups
After completing this module, you will be able to:
- Work with measures
- Work with measure groups
Module 4.1: Optimizing and Managing Multidimensional Databases (Additional Topic)
This module describes how to deploy and optimize multidimensional databases post deployment.
Lessons:
- Deploying an SSAS database
- Overview of deployment options
- Practice deploying a sample database
- Processing the Database Post Deployment
- Using SSIS Process tasks
- Deploying SSIS projects
- Scheduling SSIS packages
- Optimizing a Multidimensional Database
- Configuring the SSAS instance for Usage Based Optimization
- Performing Usage Based Optimization
- Instructor Led Practice
After completing this module, you will be able to:
- Deploy a multidimensional database
- Use SSIS packages to manage SSAS databases
- Perform usage based optimization of Aggregations
Module 5: Introduction to MDX
This module describes the MDX syntax and how to use MDX.
Lessons
- MDX fundamentals
- Adding calculations to a cube
- Using MDX to query a cube
Lab: Using MDX
After completing this module, you will be able to:
- Describe the fundamentals of MDX
- Add calculations to a cube
- Query a cube using MDX
Module 5.1: Intermediate MDX (Additional Topic)
This module describes in detail the underlying terminology and functionality of MDX allowing students to better write MDX queries and expressions.
Lessons:
- Understanding Members, Tuples, Sets and how they work
- Working with Hierarchies and member “family” functions
- Working with Common MDX Functions
- Creating Named Sets and Custom Calculations
- Instructor Led Hands On Practices with MD Queries and Expressions
After completing this module, you will be able to:
- Describe when to use members, tuples, and sets
- Write more complex MDX queries and expressions
- Create named sets and calculated members
Module 6: Customizing Cube Functionality
This module describes how to customize a cube.
Lessons
- Implementing key performance indicators
- Implementing actions
- Implementing perspectives
- Implementing translations
Lab: Customizing a Cube
After completing this module, you will be able to:
- Implement key performance indicators
- Implement actions
- Implement perspectives
- Implement translations
Module 7: Implementing a Tabular Data Model by Using Analysis Services
This module describes how to implement a tabular data model in PowerPivot.
Lessons:
- Introduction to tabular data models
- Creating a tabular data model
- Using an analysis services tabular model in an enterprise BI solution
Lab: Working with an Analysis services tabular data model
After completing this module, you will be able to:
- Describe tabular data models
- Create a tabular data model
- Be able to use an analysis services tabular data model in an enterprise BI solution
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.
Lessons
- DAX fundamentals
- Using DAX to create calculated columns and measures in a tabular data model
- Going deeper into DAX
- Creating KPIs
Lab: Creating Calculated Columns and Measures by using DAX
After completing this module, you will be able to:
- Describe the fundamentals of DAX
- Use DAX to create calculated columns and measures in a tabular data model
- Create KPIs in tabular data models
Module 9: Connecting to SSAS databases (Additional Topic)
This module describes how to use various tools to connect to SSAS multidimensional and Tabular databases.
Agenda
Module 1: Introduction to Business Intelligence and Data Modeling
This module introduces key BI concepts and the Microsoft BI product suite.
Lessons
- Introduction to Business Intelligence
- The Microsoft business intelligence platform
Lab: Exploring a Data Warehouse
After completing this module, you will be able to:
- Describe the concept of business intelligence
- Describe the Microsoft business intelligence platform
Module 2: Creating Multidimensional Databases
This module describes the steps required to create a multidimensional database with analysis services.
Lessons
- Introduction to multidimensional analysis
- Creating data sources and data source views
- Creating a cube
- Overview of cube security
Lab: Creating a multidimensional database
After completing this module, you will be able to:
- Use multidimensional analysis
- Create data sources and data source views
- Create a cube
- Describe cube security
Module 3: Working with Cubes and Dimensions
This module describes how to implement dimensions in a cube.
Lessons
- Configuring dimensions
- Define attribute hierarchies
- Sorting and grouping attributes
Lab: Working with Cubes and Dimensions
After completing this module, you will be able to:
- Configure dimensions
- Define attribute hierarchies.
- Sort and group attributes
Module 4: Working with Measures and Measure Groups
This module describes how to implement measures and measure groups in a cube.
Lessons
- Working with measures
- Working with measure groups
Lab: Configuring Measures and Measure Groups
After completing this module, you will be able to:
- Work with measures
- Work with measure groups
Module 4.1: Optimizing and Managing Multidimensional Databases (Additional Topic)
This module describes how to deploy and optimize multidimensional databases post deployment.
Lessons:
- Deploying an SSAS database
- Overview of deployment options
- Practice deploying a sample database
- Processing the Database Post Deployment
- Using SSIS Process tasks
- Deploying SSIS projects
- Scheduling SSIS packages
- Optimizing a Multidimensional Database
- Configuring the SSAS instance for Usage Based Optimization
- Performing Usage Based Optimization
- Instructor Led Practice
After completing this module, you will be able to:
- Deploy a multidimensional database
- Use SSIS packages to manage SSAS databases
- Perform usage based optimization of Aggregations
Module 5: Introduction to MDX
This module describes the MDX syntax and how to use MDX.
Lessons
- MDX fundamentals
- Adding calculations to a cube
- Using MDX to query a cube
Lab: Using MDX
After completing this module, you will be able to:
- Describe the fundamentals of MDX
- Add calculations to a cube
- Query a cube using MDX
Module 5.1: Intermediate MDX (Additional Topic)
This module describes in detail the underlying terminology and functionality of MDX allowing students to better write MDX queries and expressions.
Lessons:
- Understanding Members, Tuples, Sets and how they work
- Working with Hierarchies and member “family” functions
- Working with Common MDX Functions
- Creating Named Sets and Custom Calculations
- Instructor Led Hands On Practices with MD Queries and Expressions
After completing this module, you will be able to:
- Describe when to use members, tuples, and sets
- Write more complex MDX queries and expressions
- Create named sets and calculated members
Module 6: Customizing Cube Functionality
This module describes how to customize a cube.
Lessons
- Implementing key performance indicators
- Implementing actions
- Implementing perspectives
- Implementing translations
Lab: Customizing a Cube
After completing this module, you will be able to:
- Implement key performance indicators
- Implement actions
- Implement perspectives
- Implement translations
Module 7: Implementing a Tabular Data Model by Using Analysis Services
This module describes how to implement a tabular data model in PowerPivot.
Lessons:
- Introduction to tabular data models
- Creating a tabular data model
- Using an analysis services tabular model in an enterprise BI solution
Lab: Working with an Analysis services tabular data model
After completing this module, you will be able to:
- Describe tabular data models
- Create a tabular data model
- Be able to use an analysis services tabular data model in an enterprise BI solution
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.
Lessons
- DAX fundamentals
- Using DAX to create calculated columns and measures in a tabular data model
- Going deeper into DAX
- Creating KPIs
Lab: Creating Calculated Columns and Measures by using DAX
After completing this module, you will be able to:
- Describe the fundamentals of DAX
- Use DAX to create calculated columns and measures in a tabular data model
- Create KPIs in tabular data models
Module 9: Connecting to SSAS databases (Additional Topic)
This module describes how to use various tools to connect to SSAS multidimensional and Tabular databases.