SSAS

Overview SSAS

Developing SQL Data Models course imparts core skills to implement multidimensional databases using SSAS (SQL Server Analysis Services), and create tabular semantic data models for analysis. This SSAS training is meant for database professionals who create enterprise BI solutions in order to fulfil the role of a BI Developer. This SQL Data Model Development course is also suitable for power users, information workers and data analysts.

Course Objectives

• Understand the architecture, components and features of BI solution
• Use analytics of SSAS to create a multidimensional database
• Deploy dimensions into a cube
• Deploy measures and measure groups into a cube
• Implement MDX syntax
• Perform customizations on a cube
• Create a tabular database
• Query tables using DAX
• Conduct predictive analysis using data mining

Module 1: 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 2: 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 3: 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: 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: 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 6: 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 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