From the course: Learning Data Analytics: 1 Foundations

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Cleaning data with Power Query

Cleaning data with Power Query

From the course: Learning Data Analytics: 1 Foundations

Start my 1-month free trial Buy for my team

Cleaning data with Power Query

“

- [Instructor] When you start to learn Power Query, it is impossible to not use it for even the basic things you do all the time to clean data. It's so much easier than recording macros, and just as powerful. It connects to data naturally because that's what it's been built to do, and it's much easier to work with once you learn a little bit about it. Let's open up CleanSpending in our chapter folder. We'll connect to the Spending Trends data in the same folder. This way when we have new data, we can either replace that file or change the connection to the new data. Okay. So I'll navigate to Data. I'll choose Get Data From File. And because the source of my file is Excel, I'll choose From Workbook. And I'll choose the Spending Trends Survey. Okay, I'll choose my Original Data. And then I have two options. I can go ahead and load it to the spreadsheet so I can see it, or I can go directly to Transform Data. Since we're going to focus on cleaning, we'll go straight to Transform Data. We…

Contents