Introduction to SSAS Tabular

£395.00

What Will You Learn?

  • How to use Power Pivot and create tabular data models

Category:

DESCRIPTION

Introduction to SSAS 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.

INSTRUCTOR

MITCHELL PEARSONMITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS, and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

WHAT TO KNOW BEFORE THE CLASS

A background in database development is required, but no previous knowledge of PowerPivot, DAX, or SQL Data Tools is assumed. Some experience using pivot tables and formulas in Excel may be helpful, but is not required.


Duration: 7:59:50
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.
Introduction to SSAS Tabular - What you need to get started
Module 00 - Introduction to SSAS Tabular for Developers
04:39
Module 01A - Introduction to Tabular (Overview)
19:50
Module 01B - Introduction to Tabular (Choosing Tabular vs Multidimensional)
20:20
Module 01C - Introduction to Tabular (Upgrading Power Pivot to Tabular)
14:07
Module 02 - Importing Data into Tabular
26:13
Module 03 - Creating the Data Model
27:27
Module 04A - Creating Calculated Columns with DAX (Introduction to DAX)
19:59
Module 04B - Creating Calculated Columns with DAX (Your First Calculations)
24:49
Module 04C - Creating Calculated Columns with DAX (Navigation Functions)
14:13
Module 05A - Creating Calculated Measures with DAX (Basics)
30:38
Module 05B - Creating Calculated Measures with DAX (Calculate Function)
14:19
Module 06 - Incorporating Time Intelligence
33:24
Module 07 - Building Reports in Excel
34:10
Module 08A - Managing Tabular Models (Perspectives)
10:54
Module 08B - Managing Tabular Models (Partitions)
16:59
Module 08C - Managing Tabular Models (Deployment)
28:26
Module 09 - Securing Tabular Data Models
28:32
Module 10A - Advanced Data Analysis (KPIs)
11:18
Module 10B - Advanced Data Analysis (Role Playing Dimensions)
20:45
Module 10C - Advanced Data Analysis (Many to Many)
22:52
Module 10D - Advanced Data Analysis (Parent-Child)
12:42
Module 11 - Performance Tuning
21:52
Module 12 - Planning and Implementing a Solution
21:22
Class Survey

SYSTEM REQUIREMENTS

  • 2 GB of available RAM (recommended 4 GB or more)
  • GHz CPU (recommended 2 GHz or faster)
  • Windows 7, Windows 8 or Windows 10
  • SQL Server Developer Edition or Enterprise Edition 2012/2014/2016
  • Excel 2010 or greater