This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Power BI (160 exercises)
Topic ==>	Query editor (9 exercises)
Level ==>	Average difficulty
Subject ==>	Power BI training

Using the Query Editor to transform data

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Open a blank Power BI file and import data from the file called Car parts.xlsx in the folder above.

On the Navigator dialog choose Transform Data to launch the Power Query Editor. If you forget to do this, you can choose Home | Transform data from the Power BI ribbon instead.

The Power Query Editor screen.

You should see the transforms already made in the APPLIED STEPS list.

The things that have already happened to the data.

Apply filters to the following columns:

Last ordered date less than 01/01/2024
Stock not equal to 0
Remove any rows where the Instructions value is empty

Rename your Applied steps with appropriate names and continue to do so for the rest of the exercise.

Remove the GBP element from the Price column (don't forget that Replace Values is case-sensitive!) and set the data type to Fixed decimal.

Use the Split Column transform on the Part number column to get 2 separate columns and rename them as Country and Ref. Set the Ref column data type to Text.