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 ...