<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Introduction to Azure Analysis Services

Master Azure Portal navigation, create/deploy tabular data models with SQL Server Data Tools. Learn data modeling, DAX language, and administrative topics: partitions, perspectives, row level security in this class.

Introduction to Azure Analysis Services
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

This Introduction to Azure Analysis Services class will take users through the Azure Portal to get a basic understanding of navigation and Azure services. This course covers creating and deploying tabular data models using SQL Server Data Tools to Azure Analysis Services. Also we will look at basic data modeling concepts as well as a little of the Data Analysis Expression (DAX) language. This class also covers administrative topics such as partitions, perspectives and row level security. Lastly we will also explore how to connect to Azure Analysis Services using Excel and Power BI. Users should have a good understanding of Azure Analysis Services and whether it is a good option for them.

Course Outline ( Free Preview)

Introduction to Azure Analysis Services - What you need to get started

Module 00 - Class Introduction

Module 01 - Azure Analysis Services Overview

Module 02A - Getting Started with Azure (Navigating the Azure Portal) 11 min.

Module 02B - Getting Started with Azure (Resource Groups) 9 min.

Module 02C - Getting Started with Azure (Azure SQL DB and Azure Storage Account) 27 min.

Module 03 - Provisioning Azure Analysis Services 23 min.

Module 04A - Setting Up The Environment (SSMS & SSDT Overview) 38 min.

Module 04B - Setting Up The Environment (Using SSDT to Create Tabular Project) 23 min.

Module 05 - Importing Sources (Getting Data and Power Query Editor) 43 min.

Module 06 - Understanding the Data Model 43 min.

Module 07A - DAX (Calculated Columns) 35 min.

Module 07B - DAX (Calculated Measures) 23 min.

Module 07C - DAX (Time Intelligence) 31 min.

Module 08 - Deploying and Processing 26 min.

Module 09 - Data Gateway 23 min.

Module 10A - Managing the Tabular Data Model (Partitions) 22 min.

Module 10B - Managing the Tabular Data Model (Perspectives) 11 min.

Module 10C - Managing the Tabular Data Model (Row Level Security) 29 min.

Module 11 - Building Reports on Azure Analysis Services 15 min.

This course includes:

  • 7+ hours of training
  • 20 Modules
  • * Access on mobile and browser
  • Certificate of Completion