Master Your Data with Power Query in Excel and Power BI

Table of Contents

1. The Data Revolution
2. Power Query Fundamentals
3. Query Management
4. Data Types and Errors
5. Moving Queries Between Excel & Power BI
6. Importing from Flat Files
7. Importing Data from Excel
8. Simple Transformation Techniques
9. Appending Data
10. Combining Files
11. Merging Data
12. Web Based Data Sources
13. Relational Data Sources
14. Reshaping Tabular Data
15. Conditional Logic in Power Query
16. Power Query Values
17. Understanding the M Language
18. Parameters and Custom Functions
19. Date and Time Techniques
20. Query Optimization
21. Automating Refresh