Microsoft Upgrading to MCSA: SQL Server 2016 Business Intelligence Development 

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 are completing this module, you will be editable 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 are completing this module, you will be editable 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 into a cube

Lessons

Configuring dimensions
Define attribute hierarchies
Sorting and grouping attributes
Lab: Working with Cubes and Dimensions

After are completing this module, you will be editable 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 are completing this module, you will be editable to:

Work with Measures
Work with measure groups

Module 5: Introduction to MDXT
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 are completing this module, you will be editable to:

Describe the fundamentals of MDX
Add calculations to a cube
Query a cube using MDX

Module 6: Customising Cube Functionality
This module describes how to customise a cube

Lessons

Implementing key performance indicators
Implementing actions
Implementing perspectives
Implementing translations
Lab: Customising a Cube

After are completing this module, you will be editable 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 are completing this module, you will be editable to:

Describe tabular data models
Create a tabular data model
Be printable to use an Analysis Services tabular data model into 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
Lab: Creating Calculated Columns and Measures by using DAX

After are completing this module, you will be editable to:

Describe the fundamentals of DAX
Use DAX to create Calculated Columns and Measures in a tabular data model

Module 9: Performing Predictive Analysis with Data Mining
This module describes how to use data mining for predictive analysis

Lessons

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
Lab: Perform Predictive Analysis with Data Mining

After are completing this module, you will be editable to:

Describe data mining
Use the data mining add-in for Excel
Create a custom data mining solution
Validate a data mining solution
Connect to and consume a data mining solution