NEED HELP? TALK TO AN EXPERT (904) 638-5743

Introduction to Azure Analysis Services

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • How to create and deploy tabular data models using SQL Server Data Tools to Azure Analysis Services
  • Explore basic data modeling concepts as well as the Data Analysis Expression (DAX) language
  • Administrative topics such as partitions, perspectives and row level security
  • How to connect to Azure Analysis Services using Excel and Power BI
This course includes:

Course Description

Get ready to learn how to create and deploy tabular data models using SQL Server Data Tools to Azure Analysis Services. Students will also explore basic data modeling concepts as well as the Data Analysis Expression (DAX) language. This class also covers administrative topics such as partitions, perspectives and row level security. Lastly, we will 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.

Outline

 

Module 00 | Course Introduction
04m 36s total

 

Module 00A | Course Introduction
04m 36s

 

Module 01 | Azure Analysis Services Overview
37m 41s total

 

Module 01A | Azure Analysis Services Overview
37m 41s

 

Module 02 | Getting Started with Azure
46m 43s total

 

Module 02A | Navigating the Azure Portal
11m 03s

 

Module 02B | Resource Groups
09m 04s

 

Module 02C | Azure SQL DB and Azure Storage Account
26m 36s

 

Module 03 | Provisioning Azure Analysis Services
22m 48s total

 

Module 03A | Provisioning Azure Analysis Services
22m 48s

 

Module 04 | Setting Up The Environment
59m 79s total

 

Module 04A | SSMS & SSDT Overview
37m 49s

 

Module 04B | Using SSDT to Create Tabular Project
22m 30s

 

Module 05 | Importing Sources
42m 44s total

 

Module 05A | Getting Data and Power Query Editor
42m 44s

 

Module 06 | Understanding the Data Model
43m 22s total

 

Module 06A | Understanding the Data Model
43m 22s

 

Module 07 | DAX
89m 11s total

 

Module 07A | Calculated Columns
35m 02s

 

Module 07B | Calculated Measures
23m 09s

 

Module 07C | Time Intelligence
31m 00s

 

Module 08 | Deploying and Processing
26m 04s total

 

Module 08A | Deploying and Processing
26m 04s

 

Module 09 | Data Gateway
22m 38s total

 

Module 09A | Data Gateway
22m 38s

 

Module 10 | Managing the Tabular Data Model
61m 03s total

 

Module 10A | Partitions
21m 54s

 

Module 10B | Perspectives
10m 31s

 

Module 10C | Row Level Security
29m 18s

 

Module 11 | Building Reports on Azure Analysis Services
15m 21s total

 

Module 11A | Building Reports on Azure Analysis Services
15m 21s


Instructor

MANUEL QUINTANA

Training Content Manager
As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.

 

System Requirements

  • Microsoft Azure Account (Paid or Trial)
  • SQL Server Management Studio 17.5+
  • Windows 7, Windows 8, or Windows 10
  • 2 GHz or faster CPU
  • 2 GB of available RAM (recommended 4 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2012/2014/2016/2017/2019
    • SQL Server Database Engine
    • SQL Server Integration Services
    • SQL Server Data Tools (SQL 2012/2014/2016/2017/2019) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Follow this installation guide to ensure all items are installed correctly

What to Know Before Class

We recommend first taking our Introduction to SSIS course prior to taking this one.

REVIEWS
"I find it very helpful, and the demonstrations are great."

Maria M.

Pending reviews - check back later

Pending reviews - check back later

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!