Blog Post

Educator Developer Blog
1 MIN READ

Use Power Query to Clean, Transform and Clean Data in Power BI

theoyinbooke's avatar
theoyinbooke
Iron Contributor
Jun 21, 2022

 

Microsoft Learn is Rich in Contents

Microsoft Learn is where everyone comes to learn. Discover new skills, find certifications, and advance your career in minutes. with interactive, hands-on learning paths. The ongoing cloud skill challenge contents are all from Microsoft Learn. super interesting, isn't it? and part of our learning content today will be from Microsoft Learn.

 

Intro to Power Query

Answer:  Take this learning content: https://aka.ms/30DLDATPQEditor 

The data used was scraped from the web using this URL https://www.bankrate.com/retirement/best-and-worst-states-for-retirement/ simply Get Data from the Web and use this web address.

 

 

 

Why Power Query?

The answer is simple. It helps to automate the process of cleaning, transforming, and loading data.

Take this learning module: https://aka.ms/30DLDATCleanTransformLoad

This count towards your Cloud Skill Challenge Module Completion 

 

 

 

Assignment

  1. Complete the Lab Exercise in the Learning Module https://aka.ms/30DLDATCleanTransformLoad 
  2. Build a simple Dashboard from this Web Data  https://www.bankrate.com/retirement/best-and-worst-states-for-retirement/  
  3. Document Your Project on GitHub and share it on LinkedIn and Twitter with the hashtag #NG30DaysOfLearning #30DaysOfLearning

 

Additional Resources

 

 

Updated Jun 26, 2022
Version 2.0
No CommentsBe the first to comment