Day 9 of 30 Days of Learning Data Analysis Using Power BI for Students

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

30DL-DA_Day9.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

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.