This lesson's interactive features are locked, please to keep using them

Power Query

Power Query is where data cleaning and preparation happen in Power BI. It lets you connect to different data sources, transform messy data, and shape it before loading it into your dashboards.

You'll often hear this part of the process called ETL – Extract, Transform, Load. Power Query handles the first two steps: getting data and preparing it for analysis.

Assignment

In Power BI, go to Home → Get Data → Text/CSV and load your sales.csv file.
Click over to the Table view and open the sales table.
Right click on sales in the Data pane and click "Edit query." This will open the Power Query editor in a new window.

Take a look at the top ribbon and the "Applied Steps" pane on the right side. The top ribbon is where we'll make the transformations to the data.

You can leave the Power Query editor open for now; we'll use it in an upcoming lesson.

The "Applied Steps" section records each transformation and allows us to undo, reorder, or reuse them later. Notice that it first "Promoted Headers" (extracted the column names out of the first row), then "Changed Type" in the rows (auto-detected that numbers are numbers, booleans are booleans, etc.).

Save the project and, from the course directory, submit the CLI tests.