Data Analysis Challenge: Impact of Weather Conditions on Air Quality
Published Jan 23 2023 12:39 AM 11.3K Views
Microsoft

DA Scenario 1.png

 

Quick Question

How Good are you with answering business questions using Microsoft Power BI? You don't have to rate yourself on any scale, I have a challenge for you.

Consider the use case described below and the accompanied data, carry out a detailed analysis using Microsoft Powr BI. This is the only way to convince me how good you are with answering business questions.

 

Use Case Description

 

use case description.png

 

A company in the environmental consulting industry is seeking to analyze the air quality in a specific city during hot and cold weather, during high-wind conditions and during precipitation. They are interested in making recommendations to the government and businesses in the region on how to mitigate the impact of weather conditions on air quality.  

 

As a Data Analyst, you are expected to analyze the data provided, seek insights and make recommendations to achieve the set objectives.

Additionally, kindly use this dataset to analyze the historical impact of weather conditions on air quality, and make predictions on air quality during specific weather conditions. This information could be used to inform emergency response plans and prepare for potential air quality issues.

 

Feel free to explore your creativity while solving this challenge.

 

Challenge Dataset

 

Tech Blog Ads (3).png

 

The data set can be found here 

This data set has been sourced from the Machine Learning Repository of University of California, Irvine Beijing PM2.5 Data Set (UC Irvine).
The UCI page mentions the following publication as the original source of the data set:

Liang, X., Zou, T., Guo, B., Li, S., Zhang, H., Zhang, S., Huang, H. and Chen, S. X. (2015). Assessing Beijing's PM2.5 pollution: severity, weather impact, APEC and winter heating. Proceedings of the Royal Society A, 471, 20150257

 

Project Documentation

 

documentation.png

 

 

Intro to GitHub

Watch this Intro session to get familiarized with GitHub for beginners

 

 

 

Document Your Project

Watch this video to guide you  step-by-step on documenting your project

 

 

 

 

Let's Spotlight Your Project

 

Cloud Skill Challenge (1).png

 

Kindly submit the link to your project repository by clicking here or click on the image above

 

 

 

We have an upcoming series to help you get the best from this effort. We will show you how you can properly document and showcase your project using GitHub. Kindly find the details of the session below:

 

Session Image Topic RSVP
theoyinbooke_3-1675208371811.jpeg GitHub for Data Analysts and Power Platform Developers Intro https://aka.ms/GitHub4Me-Pt1 
theoyinbooke_4-1675208371835.jpeg Documenting Data Analysis Projects on GitHub https://aka.ms/GitHub4Me-Pt2 
theoyinbooke_5-1675208371836.jpeg Documenting Power Platform Projects on GitHub https://aka.ms/GitHub4Me-Pt3 

 

 

More Challenge

You can complete our dedicated Cloud Skills Challenge

 

 

Connect with Others

 

Connect with others.png

 

You are not alone in working on this project. use the hashtag #GitHub4Me while sharing on twitter and LinkedIn for your content to become more discoverable. Use it while posting your questions, use it while answering other people's questions.

 

 

Earn Badges and Trophies

 

Cloud Skill Challenge.png

 

Earn Badges and trophies from Microsoft when you complete a module and learning path respectively. This is another way to show a recruiter, your potential employer, or your current employer of your commitment to continuous learning.

 

Click here to participate in the cloud skill challenge. You can as well click on the image above

 

 

Amazing FREE Offer for Student: GitHub Student Pack

 

Cloud Skill Challenge.png

 

The GitHub Student Pack is FREE for verifiable STUDENTS and help you learn using real-world development tools. You get to use GitHub Pro while you are a student, enjoy amazing valuable offers from GitHub Partners, etc...

Click here or on the image above to claim this offer.

 

 

Project Submission

You will be wondering how you get to submit your project. For now, you should share your work by taking screenshots and using the hashtag #GitHub4Me while posting on Twitter and LinkedIn. We have an upcoming Live session to guide you on how to properly showcase and document your work on GitHub.

 

Details of the session below

 

Session Image Topic RSVP
theoyinbooke_0-1675208347348.jpeg GitHub for Data Analysts and Power Platform Developers Intro https://aka.ms/GitHub4Me-Pt1 
theoyinbooke_1-1675208347354.jpeg Documenting Data Analysis Projects on GitHub https://aka.ms/GitHub4Me-Pt2 
theoyinbooke_2-1675208347354.jpeg Documenting Power Platform Projects on GitHub https://aka.ms/GitHub4Me-Pt3 

 

Once we are done with the sessions, you will be able to go through the process and make your project portfolio worthy by documenting it on GitHub.

 

We will also provide the Link for you to submit your documented project. Since we want you to get the best from this effort, the most missing part is how you communicate your final work through documentation, this is where you will shine brighter this time. 

 

We are excited for you already and can't wait to see what you get to do at the end. Kindly check back this blog for details about the forthcoming Live sessions.

 

 

Additional Resources

Microsoft Student Hub - https://aka.ms/learnstudent   
Learn more with our dedicated Cloud Skills Challenge

FREE Advance Certifications for Nigerians - https://aka.ms/NGFreeCertification

FREE Learning Resources to Help You Kickstart Your Tech Journey - Begin Now!

FREE Certification for Students Around the Globe - Learn More

FREE Certification for Students in the UK - Learn More Here

Setup a Microsoft 365 Developer Account - https://aka.ms/SetupM365Developer 

 

 

 

 

Version history
Last update:
‎Mar 15 2023 09:45 AM
Updated by: