Skip to main content

Microsoft SQL Server Analysis Services (SSAS)

Intermediate8 Hours 56 Minutes50 Course Videos75 Test Questions

$249.00

Learn to build cubes and tabular models in SQL Server Analysis Services (SSAS) with MDX and DAX. For data and BI staff who know basic SQL, with 8 hours 56 minutes across 50 videos.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

Download the course outline (PDF)

Microsoft SQL Server Analysis Services (SSAS) is an intermediate course that shows you how to build the analytical models that sit behind business reports. It is for BI analysts, data analysts and SQL Server developers who want to move past basic reports and design shared, trusted metrics. The course runs for 8 hours 56 minutes across 50 videos, with 75 practice questions.

What you will learn

  • Explain business intelligence, the Microsoft BI platform, data warehouses and data models
  • Create and configure multidimensional cubes with data sources and data source views
  • Design dimensions, attribute hierarchies and slowly changing dimensions
  • Set up measures, measure groups and storage
  • Write MDX queries and add calculations to a cube
  • Add KPIs, actions, perspectives and translations
  • Build tabular data models with relationships and attributes
  • Use DAX for calculated columns, measures, time intelligence and parent-child hierarchies
  • Create, check and use data mining models
  • Apply cube security so the right people see the right data

Course outline

  1. Introduction to Business Intelligence and Data Modeling: the Microsoft BI platform, data warehouses and data models.
  2. Multidimensional Databases: cube security, creating cubes, data sources and dimensions.
  3. Cubes and Dimensions: hierarchies, sorting, grouping and slowly changing dimensions.
  4. Measures and Measure Groups: measures, relationships and storage.
  5. Introduction to MDX: MDX basics, calculations and querying a cube.
  6. Customizing Cube Functionality: KPIs, actions, perspectives and translations.
  7. Tabular Data Models: building and setting up a tabular model for enterprise BI.
  8. Data Analysis Expressions (DAX): calculated columns, measures, time intelligence and KPIs.
  9. Data Mining: building, validating and using data mining models.

Who this course is for

  • Business intelligence analysts and BI developers
  • Data analysts who want to build models, not just reports
  • SQL Server developers and database administrators
  • Analytics engineers working on Microsoft data platforms

Before you start

You should be at ease with basic SQL and know how tables, keys and joins work. Some knowledge of data warehouses helps but is not required. A good next step before this course is a SQL querying course if you are new to T-SQL.

Jobs this course supports

  • Business Intelligence Analyst
  • BI Developer
  • Data Analyst
  • SQL Server Developer
  • Database Administrator
  • Analytics Engineer

Skill level

Intermediate
Duration

8 Hours 56 Minutes
Videos

50 Course Videos
Questions

75 Test Questions
Prerequisites

Basic SQL and an understanding of tables, keys and joins.
Best for

BI analysts, BI developers, data analysts, SQL Server developers, database administrators
Topics covered

Business intelligence and data warehouses, multidimensional cubes, dimensions and measures, MDX, KPIs and perspectives, tabular models, DAX, data mining
Format

Online video lessons, self-paced
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this course

9 modules and 50 lessons. Here is the full outline.

Module 1 - Introduction to Business Intelligence and Data Modeling6 lessons
  1. 1.1 Course Introduction
  2. 1.2 Module 1 Introduction
  3. 1.3 Introduction to Business Intelligence
  4. 1.4 The Microsoft Business Intelligence Platform
  5. 1.5 Exploring a Data Warehouse
  6. 1.6 Exploring a Data Model
Module 2 - Multidimensional Databases7 lessons
  1. 2.1 Module 2 Introduction
  2. 2.2 Introduction to Multidimensional Analysis
  3. 2.3 Overview of Cube Security
  4. 2.4 Creating and Configuring a Cube
  5. 2.5 Data Sources
  6. 2.6 Data Source Views
  7. 2.7 Adding a Dimension to a Cube
Module 3 - Cubes and Dimensions5 lessons
  1. 3.1 Module 3 Introduction
  2. 3.2 Dimensions
  3. 3.3 Attribute Hierarchies and Relationships
  4. 3.4 Sorting and Grouping Attributes
  5. 3.5 Slowly Changing Dimensions
Module 4 - Measures and Measure Groups4 lessons
  1. 4.1 Module 4 Introduction
  2. 4.2 Measures
  3. 4.3 Measure Groups and Relationships
  4. 4.4 Measure Group Storage
Module 5 - Introduction to MDX4 lessons
  1. 5.1 Module 5 Introduction
  2. 5.2 MDX Fundamentals
  3. 5.3 Adding Calculations to a Cube
  4. 5.4 Querying a cube using MDX
Module 6 - Customizing Cube Functionality5 lessons
  1. 6.1 Module 6 Introduction
  2. 6.2 Key Performance Indicators
  3. 6.3 Actions
  4. 6.4 Perspectives
  5. 6.5 Translations
Module 7 - Tabular Data Models5 lessons
  1. 7.1 Module 7 Introduction
  2. 7.2 Introduction to Tabular Data Models
  3. 7.3 Creating a Tabular Data Model
  4. 7.4 Configure Relationships and Attributes
  5. 7.5 Configuring Data Model for an Enterprise BI Solution
Module 8 - Data Analysis Expressions (DAX)8 lessons
  1. 8.1 Module 8 Introduction
  2. 8.2 DAX Fundamentals
  3. 8.3 Calculated Columns
  4. 8.4 Relationships
  5. 8.5 Measures
  6. 8.6 Time Intelligence
  7. 8.7 KPI
  8. 8.8 Parent - Child Hierarchies
Module 9 - Data Mining6 lessons
  1. 9.1 Module 9 Introduction
  2. 9.2 Overview of Data Mining
  3. 9.3 Custom Data Mining Solutions
  4. 9.4 Validating a Data Mining Model
  5. 9.5 Consuming a Data Mining Model
  6. 9.6 Course Wrap Up

Your learning path

Where Microsoft SQL Server Analysis Services (SSAS) fits. Build your skills one step at a time.

Take firstLearn SQL Server 2019 - Querying SQL ServerTake firstIntroduction to Microsoft Power BI
You are hereMicrosoft SQL Server Analysis Services (SSAS)
Next stepMicrosoft 70-466: Implementing Data Models & Reports with SQL Server

Frequently asked questions

What is SQL Server Analysis Services used for?

SSAS is used to build analytical models, called cubes or tabular models, that give business users fast, consistent figures for reports and dashboards.

Does the course cover both multidimensional and tabular models?

Yes. Early modules build multidimensional cubes with MDX, and later modules build tabular models with DAX.

What is the difference between MDX and DAX?

MDX is the query language for multidimensional cubes. DAX is the formula language for tabular models and is also used in Power BI.

What do I need to know before I start?

You should know basic SQL and how tables, keys and joins work. Data warehouse knowledge helps but is not required.

Is data mining included?

Yes. The last module covers building, validating and using data mining models in SSAS.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Related courses

$249.00
Buy course