From the course: Learning Data Analytics: 1 Foundations

Challenge: Rename headers in Power Query

From the course: Learning Data Analytics: 1 Foundations

Challenge: Rename headers in Power Query

“

(upbeat electronic music) - [Instructor] Now that we know that there are cleaning routines that we can leverage in VBA code, we can turn around and clean them in Power Query using the skills you just gained. So here's the challenge. There's a file in your folder called RWS_Study.xlsm and then there's some challenge data. What I want you to do is use that RWS_Study file. Look at the VBA code and then open a new file and create a new workbook in Power Query that cleans based on what you discovered in that VBA code. Now, this challenge may take you more than a few minutes but it should take less than 10. Go ahead and take a look. You can see how I handled this in the next video.

Contents