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

Introduction to SSAS Tabular

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • Use Power Pivot and create Tabular data models
  • Create calculated columns and calculated measures with DAX
  • Managing and securing Tabular models
  • Advanced data analysis to gain insight from your business data
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

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

 

Click here for a downloadable PDF

Outline

 

Module 00 | Introduction to SSAS Tabular for Developers
04m 39s total

 

Module 00A | Introduction to SSAS Tabular for Developers
04m 39s

 

Module 01 | Introduction to Tabular
53 77s total

 

Module 01A | Overview
19m 50s

 

Module 01B | Choosing Tabular vs Multidimensional
20m 20s

 

Module 01C | Upgrading Power Pivot to Tabular
14m 07s

 

Module 02 | Importing Data into Tabular
26m 13s total

 

Module 02A | Importing Data into Tabular
26m 13s

 

Module 03 | Creating the Data Model
27m 27s total

 

Module 03A | Creating the Data Model
27m 27s

 

Module 04 | Creating Calculated Columns with DAX
58m 21s total

 

Module 04A | Introduction to DAX
19m 59s

 

Module 04B | Your First Calculations
24m 49s

 

Module 04C | Navigation Functions)
14m 13s

 

Module 05 | Creating Calculated Measures with DAX
44m 57s total

 

Module 05A | Basics
30m 38s

 

Module 05B | Calculate Function
14m 19s

 

Module 06 | Incorporating Time Intelligence
33m 24s total

 

Module 06A | Incorporating Time Intelligence
33m 24s

 

Module 07 | Building Reports in Excel
34m 10s total

 

Module 07A | Building Reports in Excel
34m 10s

 

Module 08 | Managing Tabular Models
55m 39s total

 

Module 08A | Perspectives
10m 54s

 

Module 08B | Partitions
16m 59s

 

Module 08C | Deployment
28m 26s

 

Module 09 | Securing Tabular Data Models
28m 32s total

 

Module 09A | Securing Tabular Data Models
28m 32s

 

Module 10 | Advanced Data Analysis
66m 57s total

 

Module 10A | KPIs
11m 18s

 

Module 10B | Role Playing Dimensions
20m 45s

 

Module 10C | Many to Many
22m 52s

 

Module 10D | Parent-Child
12m 42s

 

Module 11 | Performance Tuning
21m 52s total

 

Module 11A | Performance Tuning
21m 52s

 

Module 12 | Planning and Implementing a Solution
21m 22s total

 

Module 12A | Planning and Implementing a Solution
21m 22s

Instructor

MITCHELL PEARSON

Training Content Manager
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. 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 and Microsoft Azure.

 

Click Here To Learn More About Mitchell And See Certifications And Reviews

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
  • SQL Server Database Engine
  • SQL Server Analysis Services Tabular
  • SQL Server Data Tools
  • SQL Server Management Studio
  • Follow this installation guide (https://file.ac/QVCxDobvqlQ/Tabular%20and%20Power%20Pivot%20Installation%20Guide.docx) to ensure all items are installed correctly
  • Excel 2010 or greater

What to Know Before 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.

REVIEWS

The most outstanding trainer I have ever seen.

Varun K.

Speaker is very good!!! Clear and concise. Knows his material. Can tell he has real-world experience.

Anonymous

This was a well detailed class. Very good.

Anonymous

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required