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

Back To All Courses

91 Lessons

All

Skill Level

5:18h

course Duration

English

Audio

Eng

Subtitles

Share This Class:

Overview

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:

Extract data from multiple tables.
Create connections between the tables.
Develop the model using DAX functions.
Create analyses in Excel.

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 first model

Creating our first model using PowerPivot (Excel)

Using the Tabular Model (SSAS in SQL Server)

Using and developing the model

Developing the Data Model

Pivot Tables functionality

DAX Functions

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

“Was a very good basic, beginner course. I was mostly interested in SSAS Tabular, and I now have a need at work to apply what I have learned. I look forward to putting this to good use.”
Ron
“The instructor made it so easy and simple. I look like an expert now through taking this course. Job well done!! Thank you.”
Rombani
“Very clear lecture. Excellent exercises. Good comparisons. Awareness to pitfalls and software nuances.”
Clint
“In just the first few lessons, I have already been able to apply what I have learned at my job. Thank you for this course!”
Cynthia
Previous
Next

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

91

Lessons

All