PowerPivot
Learn from a 30+ Year Data Expert
4.08 (26 reviews)
7,256
students
5.5 hours
content
Aug 2020
last update
$44.99
regular price
What you will learn
How to use PowerPivot from a 30+ year Data Analysis professional. You will go from Beginner to Advanced
Get familiar with the Excel Data Model and learn fundamental Data Modelling concepts
Understand how to load data into the Data Model from a variety of sources, such as Excel Tables, External Databases and much more
Learn how to use Pivot Tables in conjunction with PowerPivot including set up of Relationships
What are measures and why they are so fundamental to PowerPivot and how to add implicit or explicit measures such as Autosum
Working with Iterator functions such as TOPN and REATEDTABLE
The importance of Hierarchies in a Pivot Table: Drill paths, Related columns and best practices with Hierarchies
How to best leverage PowerPivot’s Calculation Engine using Data Analytics Expressions (DAX)
Advanced data manipulation with the use of Context and Filter functions
Use Time-Intelligence functions to manipulate data using time periods, such as days, months, quarters and years compare calculations over those periods
Screenshots
Related Topics
3346124
udemy ID
7/19/2020
course created date
8/19/2020
course indexed date
Bot
course submited by