Table of Contents

  1. Introduction to Power Query
  2. Connect to File-Based Data Sources
  3. Connect to Web-Based Data Sources
  4. Connect to Database Sources
  5. Connect to Third-Party Data Sources
  6. Managing Data Types
  7. Transforming Columns
  8. Cleansing Columns
  9. Creating New Columns
  10. Combining and Manipulating Queries
  11. Using Python, R, and AI
  12. Indexing
  13. Parameters
  14. Functions
  15. Advanced Web Connections
  16. Manipulating Supporting Queries