Power Pivot is one of the revolutionary features of Excel & Power BI. In this free masterclass, learn how to get started with Power Pivot. We will cover below concepts:

* What is Power Pivot, how to enable and use it in Excel?
* 15 simple & useful measures you can create in minutes
* Understanding DAX (Data Analysis Expressions) and writing your own measures
* What are data model, star schema & table relationships
* How to use Power Pivot window in Excel
* Power Pivot in Excel vs. Power BI
* Next steps for learning and using Power Pivot in your work

Sample files here:
===============
Blank Excel file - [ Ссылка ]
Blank & completed file - [ Ссылка ]

Recommended books:
==================

Supercharge Power BI by Matt Allington - [ Ссылка ]
The Definitive Guide to DAX by Marco & Alberto - [ Ссылка ]

Other Power Videos
================
Introduction to Power Query - [ Ссылка ]
Power Pivot example measures - [ Ссылка ]

Web pages & Courses:
===================

Completed Data Analysis & Adv. Excel course - [ Ссылка ]
Power BI, Power Pivot & Power Query - [ Ссылка ]


Note: The book links use my affiliate code on Amazon.


#PowerPivot

свернуть