Original subtitles

Welcome to this section on the power of your query editor.

Now, the power of your query editor is the tool that allows you to transform and clean up your data

before you actually even bring in the data into Power BI.

So it allows you to work on that data.

You can filter the data, you can remove columns, so you can do a lot of cleaning up to look at your

data types.

You can correct your data types.

You can also do custom calculations, so you can create new data types to bring into your actual power

BI for your report.

So what you're going to see with Power BI query editors, the way that it works is as a set of applied

steps.

So it's very much like a macro, but you set of steps and you say first do this, then do this, then

do this.

So once you've got that set of steps, every time you apply it, it will redo those steps each time.

So as I said, this is really useful when you bring it in your data into Power BI to clean this up.

So the last poll we're going to be looking at is we're going to load the data into Power BI from our

query editor.

But yet again, let's jump into the lessons and let's see how we do this.

I'll see you there.