Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)
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.
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
Filter and Value Functions
Time Intelligence Functions