New Enterprise DNA Initiatives

Power BI Challenge 11 – Covid 19 Reporting

Hello All, I trust you are well and keeping safe.

It’s been a manic start to the new year with more lockdowns and restrictions being placed on many of us.

Last year we made some amazing strides with the Enterprise DNA Challenge and want to continue that momentum into this year.

We have some fantastic ideas and challenges lined up for the community and really cant wait to get going.

As always if you have any suggestions or comments, we are always happy to listen. Please feel free to reach out to myself or the Enterprise DNA team.

Check out the post below to learn about the challenge.

First time participant winner

Really simple, its open to all Enterprise DNA members. All you must do is let us know it’s your first challenge.

There is some amazing loot on offer not to mention the learning opportunity and free membership on offer.

We really want to see more of you get involved so even if it’s a post to the forum to join the conversation please do get involved.

To learn more about the challenge and how it works be sure to check out the forum below!

About the Power BI Challenges category

If you’re not sure of anything just reach out to me.

Remember: The weekly winner will receive a complimentary membership to the platform that they can share with anyone and the opportunity for your work to be showcased across our channels.

The Brief

Right lets get to it!

So as you’re all aware there is currently a little something known as CV19 that is changing the face of the world as we know it.

Businesses and livelihoods are trying to cope as best as they can, so what is the current status of CV19 across the globe and for any selected country? Is it getting better, worse, do we need to take some action?

Well now hopefully you as an analyst can help!

There are some amazing resources available online covering the CV19 pandemic and none better than the John Hopkins University (JHU) reporting which is used across the globe to report cases, deaths, and recoveries. News outlets and business across the globe use the JHU data for their reporting.

See the link below to see the dashboard produced by the JHU team.

A pretty awesome dashboard?

They haven’t only produced a great dashboard they have also made the data that sits behind it openly available.

So we are going to now use this data and create our very own dashboard in Power BI.

The key objectives are:

Connect to open-source data

Import and create a data model

Create a 1 page report of what the current situation is.

The JHU team have made the data available in GitHub and we are interested in the time series data available at the following link.

Within this data set there are three key files that we are interested in pulling in for our analysis. The files we are interested in are listed below. I have also placed the URL of the required CSV.

Confirmed - https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv

Deaths - https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv

Recovered- https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_recovered_global.csv

The ask is that you pull this data in and build 1 page report covering what you believe to be the key statistics.

We are not looking for pages and pages of analysis think summary, C-level reporting a 1 page snapshot which lets us know what’s happening.

I have created a PBIX file where I have pulled this data in so nobody is starting from a blank canvas or completely lost. (wink, wink the Dimcountry dimension could require some further work and tidying).

Challenge 11.pbix (814.4 KB)

I also did my first video for the challenges and went through how to pull the data in so be sure to check it out if you’re stuck. NOTE: In my video I did a merge which under the pressure of creating a video I got wrong I have since corrected it in the PBIX (Sorry).

Power BI Challenge 11 Announcement

Right over to you guys, I hope I have been clear in the ask if not please do not hesitate to get in touch.

SUBMISSION DUE DATE - Tuesday, 26th January 2021 (PST)

Please can you all submit your PBIX files to powerbichallenge@enterprisedna.co

Best of luck!

Any issues or questions please reach out.

Haroon
Enterprise DNA

9 Likes

Hi All,

There is also a great blog post available on this topic at: https://oexwp.azurewebsites.net/2020/04/19/utilising-power-bi-to-connect-to-open-data-sources-covid-19-reporting/

Thanks
Haroon

1 Like

Hi @haroonali1000, Can I used a different data source for this challenger?, I want to try this one
https://covid.ourworldindata.org

Jose Bressan

HI Haroon,
Can I participate in this challenge? It would be my first time participating.
Thanks,
Emmanuel

2 Likes

@emercado777,

Absolutely! We encourage everyone to participate. I guarantee that regardless of where you are in your Power BI journey, you will learn a ton and have a great time in the process. Welcome to the Challenges!

  • Brian

P.S. First-time Challenge entrants are also eligible for some great prizes:

Challenge Participants,

For those interested, I have attached a modified version of Haroon’s PBIX file with the ISO 3 country codes added to the Country dimension table. This will make it much easier to build out your dimension table with additional country information if you choose to do so, since ISO 3 represents a consistent standard, while country name does not.

In addition, I added the ISO 3 code to the fact table, though you can easily hide or remove that with no impact if you’d like.

I hope this is helpful.

– Brian
Challenge 11 w ISO.pbix (818.7 KB)