Home / SQL Server / Introduction to SSAS Tabular
Introduction to SSAS Tabular
Master basics, advanced models, DAX formulas in our intensive SSAS Tabular course. Create, deploy tabular data models with SQL Server Data Tools. Empower data analysts, decision-makers with ad-hoc reporting.
- What you'll learn
- Course Description
- Course Outline
- Instructor
- System Requirements
- What to know beforehand
What you'll learn
This course includes:
- 7+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Description
This course includes:
- 7+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Course Outline
Introduction to SSAS Tabular - What you need to get started
Module 00 - Introduction to SSAS Tabular for Developers 5 min.
Module 01A - Introduction to Tabular (Overview) 20 min.
Module 01B - Introduction to Tabular (Choosing Tabular vs Multidimensional) 20 min.
Module 01C - Introduction to Tabular (Upgrading Power Pivot to Tabular) 14 min.
Module 02 - Importing Data into Tabular 26 min.
Module 03 - Creating the Data Model 27 min.
Module 04A - Creating Calculated Columns with DAX (Introduction to DAX) 20 min.
Module 04B - Creating Calculated Columns with DAX (Your First Calculations) 25 min.
Module 04C - Creating Calculated Columns with DAX (Navigation Functions) 14 min.
Module 05A - Creating Calculated Measures with DAX (Basics) 31 min.
Module 05B - Creating Calculated Measures with DAX (Calculate Function) 14 min.
Module 06 - Incorporating Time Intelligence 33 min.
Module 07 - Building Reports in Excel 34 min.
Module 08A - Managing Tabular Models (Perspectives) 11 min.
Module 08B - Managing Tabular Models (Partitions) 17 min.
Module 08C - Managing Tabular Models (Deployment) 28 min.
Module 09 - Securing Tabular Data Models 29 min.
Module 10A - Advanced Data Analysis (KPIs) 11 min.
Module 10B - Advanced Data Analysis (Role Playing Dimensions) 21 min.
Module 10C - Advanced Data Analysis (Many to Many) 23 min.
Module 10D - Advanced Data Analysis (Parent-Child) 13 min.
Module 11 - Performance Tuning 22 min.
Module 12 - Planning and Implementing a Solution 21 min.
This course includes:
- 7+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
Instructor
Mitchell Pearson has been with Pragmatic Works for 11 years as a Data Platform Consultant, Trainer and Team Lead. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform, Microsoft Azure and Fabric.
This course includes:
- 7+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
System Requirements
This course includes:
- 7+ hours hours of training
- Access on mobile and browser
- Certificate of Completion
What to know before class
This course includes:
- 7+ hours hours of training
- Access on mobile and browser
- Certificate of Completion