Microsoft Power BI for Advanced Data Analysis, Lab 1: Power Query
Dates: September 9, 2025
Meets: Tue., Sep. 9, 8:30 a.m.-12:30 p.m.
Location: Zoom
Registration Fee: $179.00
Lab 1: Power Query
Learn how to automate the data clean-up process in preparation for data analysis.
The Power Query app inside Power BI is used for data cleanup and structure. In this course, you will be provided with data that needs to be prepared for the Data Visualization section of Power BI Level 2 Reports. With step-by-step instructions, you will learn how to merge queries, create conditional columns, time intelligence functions, simple calculations and much more. You will also set up your Quick Access Toolbar, learn about the background M Code and how to back up your queries. This course is a pre-requisite to PBI Lab 2 and 3.
YOU WILL LEARN how to clean and prep your data, including:
- New and improved tools, like the "UnPivot", "Split Text to Rows", and "Date Transformations"
- Extract data from various filetypes and a website table
- Create conditional columns, similar to IF Functions in Excel
- Backup your Power Query code for safe keeping
SO YOU WILL BE ABLE TO:
- Reuse your Power Query multiple times without re-building it
- Adjust and tweak the steps in plain English (no programming experience necessary)
- Review Power Query steps from start to finish to understand how it was designed
| Fee: | $179.00 |
|---|---|
| Hours: | 4.00 |
| CEUs: | 0.40 |
Zoom