What's included in the course?
This course is comprised of 12 one-hour Power Query Series webcasts:
Module 1: Introduction and First Connection (PQS1)
The first course in the Data Analytics with Power Query package, PQS1 is designed to begin the Excel user’s data analytics journey with an introduction to the Power Query business intelligence tool.
Module 2: Making Connections (PQS2)
This module explores the workflow of making connections to various data sources using the Excel version of Power Query.
Module 3: The User Interface of Power Query (PQS3)
PQS3 introduces users to the Power Query Editor and includes a hands-on transformation exercise using this data preparation experience.
Module 4: Data Transformations (PQS4)
This module teaches the user how to perform hands-on data transformations.
Module 5: Adding Columns for Data Enrichment (PQS5)
This module teaches users how to add columns using Power Query (Excel version) using a variety of hands-on exercises.
Module 6: More Transformations and Load Options (PQS6)
This module uses hands-on exercises to explore the data transformation process, focusing on data cleaning and data enrichment as well as explaining query loading options and processes.
Module 7: Append Queries (PQS7)
Module 7 discusses best practices for creating append queries (combining two or more queries into one combined output query) and includes hands-on exercises to enable the user to demonstrate what they have learned.
Module 8: Merge Queries (PQS8)
This module discusses best practices for creating merge queries (combining two queries that have a common column or columns) and includes hands-on exercises to enable the user to demonstrate what they have learned.
Module 9: Useful Transformations (PQS9)
Module 9 covers useful transformations to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users to practice these skills.
Module 10: Use Cases (PQ10)
This module presents five use cases for specific data issues a user may encounter in Power Query. Through hands-on examples, users are guided through the process of overcoming each of these issues.
Module 11: Formulas, M Language, and Error Handling (PQ11)
This module presents the fundamentals of using formulas and introduces users to the “M” language in Power Query, as well as types of errors that users may encounter. Hands-on examples provide active learning and reinforce these concepts.
Module 12: Data Modeling and Next Steps (PQ12)
This module covers advanced features in Power Query (Excel version), including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts.