Tabular and PowerPivot for Developers (Online)

Tabular and Power Pivot for Developers is an intensive four-day course that is designed to get you up to speed using Power Pivot quickly and productively. 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. It includes plenty of hands on labs designed to give you practical experience using Power Pivot and creating tabular data models.

IMPORTANT: When you purchase a seat in this class you also receive 1 hour of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionnaire, fill it out, and send it as an attachment to This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.

All virtual training students are provided a previously recorded version of the class that are available for 7 days after the end of the class.


Day 1:

  • Module 1: Introduction to Power Pivot 

    • Why use Power Pivot?
    • Who Should Use Power Pivot?
    • Why is Power Pivot so Fast?
  • Module 2: Importing Data into Power Pivot 

    • Data Source Options
    • Linked Tables
    • Refreshing the Data
    • Hands on Lab- Loading Data into Power Pivot
  • Module 3: Creating the Data Model 

    • What is a Data Model?
    • Creating Table Relationships
    • Creating Hierarchies
    • Usability Enhancements
    • Hands On Lab – Creating a Data Model in Power Pivot 
  • Module 4: Creating Calculations with DAX

    • Introduction to DAX
    • Functions for String Manipulation
    • Conditional and Logical Functions
    • Navigation Functions
    • Hands on Lab – Adding Calculated Columns with DAX

Day 2:

  • Module 5: Creating Calculated Measures with DAX 

    • Creating Aggregates
    • Understanding Filter Context
    • Using the Calculate Function
    • Hands on Lab – Creating Calculated Measures with DAX
  • Module 6: Incorporating Time Intelligence 

    • Creating Date Tables
    • Time Intelligence Functions
    • Comparing Data over Time
    • Semi-Additive Measures
    • Hands on Lab – Adding Time Intelligence
  • Module 7: Building Power Pivot Reports

    • PivotTable Fundamentals
    • Working with PivotCharts
    • Sorting, Filtering and Formatting Reports
    • Using Sets and Adding Banding
    • Hands on Lab – Visualizing the Data

Day 3:

  • Module 8: Introduction to the Tabular Model

    • Why Upgrade to Tabular?
    • Query Mode Options
    • Creating Tabular Model Projects
    • Which Model Should I use?
    • Hands On Lab – Upgrading from Power Pivot
  • Module 9: Managing Tabular Data Models

    • Implementing Perspectives
    • Creating Partitions
    • Deploying Tabular Models
    • Processing Techniques
    • Hands On Lab - Managing the Tabular Model
  • Module 10: Securing Tabular Data Models

    • Using Role Based Security
    • Implementing Row Level Security
    • Testing Security Roles
    • Hands on Lab – Securing the Tabular Model

Day 4

  • Module 11: Advanced Data Analysis

    • Creating KPI's
    • Working with Role Playing Dimensions
    • Parent- Child Relationships
    • Many to Many Relationships
    • Hands On Lab – Creating KPI's and Parent-Child Hierarchies
  • Module 12: Performance Tuning

    • Understanding Query Processing Architecture
    • Techniques for Improving Query Performance
    • Optimizing Processing
    • Tuning SSAS Tabular Server Settings
  • Module 13: Make it Real- Planning and Implementing a Solution

    • Project Requirements Review
    • Choosing the Proper Architecture 
    • Real-Time BI with DirectQuery Mode
    • Source Control
    • Tool Integration 
    • Project documentation 


The target audience of this class is the database developer or DBA who is tasked with providing a self-service BI environment to the rest of the business. 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.


  • 1 GB of available RAM (recommended 4 GB or more)
  • GHz CPU (recommended 2 GHz or faster)
  • Windows XP Professional, Windows Vista, Windows Server 2008, Windows 7, Windows Server 2012 or Windows 8
  • SQL Server Developer Edition or Enterprise Edition 2012/2014
    • SQL Server Database Engine
    • SQL Server Analysis Services Tabular
    • SQL Server Data Tools
    • SQL Server Management Studio
    • Follow this installation guide to ensure all items are installed correctly
  • Excel 2010  or greater Professional Plus

Some of our clients