SSAS Training Course

This Lecture describes the steps required to create a multidimensional database with analysis services.

·      Lessons

·      Introduction to multidimensional analysis

·      Course details

·      Creating data sources and data source views

·      Creating a cube

·      Overview of cube security

·      Lab : Creating a multidimensional database

·      After completing this Lecture, you will be able to:

·      Use multidimensional analysis

·      Create data sources and data source views

·      Create a cube

·      Describe cube security

This Lecture 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 Lecture, you will be able to:

·      Configure dimensions

·      Define attribute hierarchies.

·      Sort and group attributes

This Lecture 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 Lecture, you will be able to:

·      Work with measures

·      Work with measure groups

This Lecture 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 Lecture, you will be able to:

·      Describe the fundamentals of MDX

·      Add calculations to a cube

·      Query a cube using MDX

This Lecture describes how to customize a cube.

·      Lessons

·      Implementing key performance indicators

·      Implementing actions

·      Implementing perspectives

·      Implementing translations

·      Lab : Customizing a Cube

·      After completing this Lecture, you will be able to:

·      Implement key performance indicators

·      Implement actions

·      Implement perspectives

·      Implement translations

This Lecture describes how to implement a tabular data model in Power Pivot.

·      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 Lecture, you will be able to:

·      Describe tabular data models

·      Create a tabular data model

·      Analysis services tabular data model in an enterprise BI solution

This Lecture 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

·      Lab : Creating Calculated Columns and Measures by using DAX

·      After completing this Lecture, you will be able to:

·      Describe the fundamentals of DAX

·      Use DAX to create calculated columns and measures

This Lecture 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 completing this Lecture, you will be able 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