Metric Maven: Power Query Pro
by Metric Maven
Automate data prep in Excel with 80+ Power Query lessons, Power Pivot and 3 mini projects
+1 more
Take the manual work out of data prep. Power Query Pro answers questions like how to automate your data cleaning process in Excel, compare two datasets, combine data from multiple files into one table, and refresh your reports with a single click.
With over 80 lessons of bite-sized videos and mini projects, you'll learn how to connect to your data, clean and reshape it, create new columns, combine and compare data, and write M code. The course also introduces Power Pivot, including the Data Model, relationships, calendar tables, and DAX. No Power Query experience is needed.
Outcomes
- Automate data cleaning in Excel
- Combine data from multiple files into one table
- Refresh your reports with a single click
- Get started with Power Pivot and DAX
What's included?
80+ Bite-Sized Lessons
Videos covering connectors, combining files, cleaning and reshaping data, new columns, query management, and M code.
Intro to Power Pivot
Seven lessons on the Data Model, relationships, calendar tables, DAX measures, and calculated columns.
3 Mini Projects
Practice with real scenarios: data cleaning, test score analysis, and real estate listings analysis.
Who is this for?
- Excel users who spend hours on manual data prep
- Analysts who need to combine and compare datasets
- Professionals who want one-click refreshable reports
- Beginners with no prior Power Query experience
About the creator
Metric Maven
Excel training and coaching for real-world spreadsheet skills
Metric Maven is Shelby Bennion's Excel education brand, built to make spreadsheet skills approachable through hands-on practice rather than dense theory. The brand grew out of a simple idea: people learn Excel faster by working through real problems...