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.
