Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)




Skill Level


course Duration





Share This Class:


This course covers one of the most useful add-ins in Microsoft Excel, PowerPivot, and the Tabular model in SQL Server Analytical Services.

We’ll activate PowerPivot if you have the right version of Excel, and if not, then we’ll install SQL Server on your computer, which can do the same job. We’ll install the Developer edition, which used to cost $100, for free.

After PowerPivot is activated, or SQL Server is installed, we’ll create our first analysis in Excel in just a matter of minutes.

After only these first few minutes, you will be streets ahead of anyone who doesn’t know anything about Power Pivot.

After this introduction, we’ll go into some detail into PowerPivot or SSAS – the initial data, and the various options that are available to you. We will go into advanced options that most people don’t even know about, but which are very useful.

Then we’ll develop DAX formulas, to further extend the model. A lot of the formulas are based on Excel formulas, but there are several additional things too.

By the end, you will be an Expert user of both PowerPivot and SSAS, able to create reliable analyses which are able to be drilled-down quickly, and you’ll be able to help others with their data analysis.

Completing this course will help you:

Who is the course for?

This course is for people who want to create analyses.

You either want to do this in Excel, or you want to learn about SQL Server Analytical Services (Tabular edition).

This course isn’t for you if you want to learn SSAS (MDX version) – there are other courses for this.

Learning Path

Creating our first model using PowerPivot (Excel)

Using the Tabular Model (SSAS in SQL Server)


Developing the Data Model

Pivot Tables functionality

An introduction to DAX functions, including Logical functions

Statistical functions

Mathematical functions

Text functions

Information Functions

Filter and Value Functions

Time Intelligence Functions

What people are saying

Are You Ready To Start?

More Courses

You might also be interested in these courses

Database Fundamentals in 8 hours

Learning Database Fundamentals with Microsoft SQL Server

Database Fundamentals in 8 hours

View Course

Microsoft SQL Server Reporting Services

Learn to create reports in SSRS

SQL Server Reporting Services

Learn how to create reports in SSRS
View Course