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: 2. Power BI relationships: 3. Excel relationships: 4. AI visuals in Power BI: 5. Survey data in Excel: 6. From Word to slick Sway: 7. From folder to excel table: