Power Query, Power BI, and Power Pivot demystified
These "Power" tools are revolutionary in the field of data analysis. They sound similar but have very different functionalities. Power Query and Power Pivot are actually both sub-components of the Power BI & Excel, so I demo each one in this video. Links below contents
It really summarises things but to go deeper into certain aspects here are links:
1. Excel interactive dashboard: • Interactive dashboard in Excel
2. Power BI relationships: • Power BI relationships explained
3. Excel relationships: • Excel table relationships
4. AI visuals in Power BI: • All 3 AI visuals in Power BI (Q&A, ke...
5. Survey data in Excel: • Analyse Excel survey ratings with Pow...
6. From Word to slick Sway: • Sway: Immersive, mob friendly animate...
7. From folder to excel table: • POWER QUERY: From folder to table in ...