Power Query #1: Introduction to Power Query & Data Analysis in Excel & Power BI

Topics:
1. (0:00) Introduction.
2. (01:50) Why do we use Power Query?
3. (02:23) What Power Query can do.
4. (03:15) Teaching pedagogy of Mike “excelisfun” Girvin
5. (03:43) What is data analysis?
6. (05:33) Steps in the data analysis process and where Power Query fits in.
7. (08:34) Define Data.
8. (09:25) Default Alignment.
9. (10:16) Number Formatting.
10. (11:38) Data Types and M Code Values.
11. (12:54) Data is NOT Information.
12. (13:16) Define Table.
13. (14:18) What is not a table?
14. (15:43) Copilot & AI and Power Query
15. (17:50) Types of tables.
16. (20:07) Granularity of tables.
17. (21:07) Summary.
18. (21:17) Preview of next video.
19. (21:44) Mike Girvins Power Query Book
20. (22:05) Closing.

#excelisfun #MikeGirvin #PowerQuery #Excel #PowerBI #PowerBIDesktop #Excel365 #LearnPowerQuery #freeclass #DataAnalysis #BusinessIntelligence #Microsoft #powerquery #powerqueryeditor #powerquerytutorial