Microsoft Excel - Power Pivot
What is Power Pivot?
Acquiring Power Pivot and Power Query
Unfortunately Excel is not just Excel anymore. What you get depends on which "SKU" you have installed. In this module we will look at how to ensure you have the correct SKU as well as the other components you may need to download to build best in class solutions.
Video time: 06m 25s
A Sneak Peek at Your Future
As there are many steps to build a great model, it can take some time before you see the results. For that reason we thought it might be a good idea to inspire you with our "end game" and show you the final model that we will build throughout this course.
Video time: 03m 17s
Pivot Table Skill Review
Getting Data for Power Pivot
Data Modeling Techniques
Building Measures with DAX (Power Pivot's Formula Language)
Understanding Measure Calculation
Creating measures is all very well, but you need to understand why they return what they do. In this module we will explain how to identify the filter context applicable to your data point, and how that influences the way measures are calculated.
Video time: 05m 20s