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

Published Jun 20 2022 11:11 PM 2,477 Views
Microsoft

Slide18.PNG

 

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.

 

theoyinbooke_0-1655769451647.png

 

 

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 

 

theoyinbooke_1-1655770474607.png

 

 

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

 

 

Co-Authors
Version history
Last update:
‎Jun 26 2022 01:06 PM
Updated by: