Getting started with Power Pivot & DAX - 15 Useful Measures - FREE & Live Masterclass

Опубликовано: 07 Октябрь 2024
на канале: Chandoo

140,877

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 - https://chandoo.org/wp/wp-content/upl...
Blank & completed file - https://chandoo.org/wp/powerpivot-dax...

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

Supercharge Power BI by Matt Allington - https://amzn.to/3wJfWdA
The Definitive Guide to DAX by Marco & Alberto - https://amzn.to/3wDqTO0

Other Power Videos
================
Introduction to Power Query - • Power Query Tutorial - What is it, ho...
Power Pivot example measures - • Different calculation for subtotals -...

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

Completed Data Analysis & Adv. Excel course - https://chandoo.org/wp/excel-school-p...
Power BI, Power Pivot & Power Query - https://chandoo.org/wp/power-bi-play-...

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

#PowerPivot