<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 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.

  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

Introduction to Tabular is an intensive course that is designed to get you up to speed using Analysis Services Tabular quickly and efficiently. You will start from basic concepts and move to complex data models and DAX formulas. In addition, this course covers creating and deploying tabular data models using SQL Server Data Tools. Once deployed, Tabular data models can be used by data analysts, decision makers, and information workers for ad-hoc reporting and data exploration. By the end of this course, you will feel confident using this powerful toolset to analyze and gain insight from your business data.

Course Outline ( Free Preview)

Introduction to SSAS Tabular - What you need to get started

Module 00 - Introduction to SSAS Tabular for Developers

Module 01A - Introduction to Tabular (Overview)

Module 01B - Introduction to Tabular (Choosing Tabular vs Multidimensional)

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 of training
  • 24 Modules
  • * Access on mobile and browser
  • Certificate of Completion