Latest Enterprise DNA Initiatives

Power BI Challenge 11 - Covid 19 Reporting from Brad

Here’s Brad’s entry for Power BI Challenge 11. @bradsmith , feel free to add other details of your work.

brad7

Here’s how Brad described it:

I decided to specialize my report to my home state of Minnesota in the United States to add a personal touch to the report and allow for a deeper dive into the data. This also allowed for me to take direct inspiration from the Tableau reports and one Power BI report the Minnesota Department of Health already use to report to the public. Combining these reports into a single comprehensive report, as well as incorporating the Minnesota COVID-19 model developed by an interdisciplinary team at the University of Minnesota School of Public Health and the Minnesota Department of Health, this allows for a single source for all COVID-19 data in the state as well as allowing for someone to split the report into multiple parts to improve performance.

Now, let’s dive into the report itself! The report has 5 distinct parts: Case Overview, Preparation and Response, Impact on Demographics, Vaccines, and Advanced Modeling. Below you will see a brief summary for each page and a screenshot of the complete page. Some of the pages are very tall, but as all the information is related I chose to keep them on one page and allow the user to scroll.

Home
Basic landing page with icons to direct the user to the appropriate report.

Summary

Case Overview
This is really the single quick view that higher ups and the general public would look at. Basic stats, clean, and minimalistic. This would most likely answer most peoples questions that aren’t looking for much more information.

Summary

Preparation and Response
This is the operation side of the pandemic (i.e. capacity, economics, public reactions, etc.). There’s five pages in this section including: Response Capacity, Public Health Risks, Economic & Food Security, Social Distancing, and Critical Care Supplies.

Summary

Vaccines
Now that the vaccines have been created and distribution is in full swing, we are no longer simply trying to hold off the virus, but bringing the fight to it. Demand for the vaccine is of course very high so this section of the report includes a high level vaccine summary, demographics on who is getting vaccinated, supply and distribution, and administration of the vaccine across the state.

Summary

Demographics
This is probably the most fascinating part of the report in my opinion. This analyzes the impact COVID has had by demographics with a special focus on its effects by race/ethnicity in different facets of life. This section touches on the effect COVID has had on different demographics not only by the number of cases and deaths, but also by unemployment, worker characteristics, and homelessness.

Summary

Advanced Modeling
I wish I could show you this visual, but I am having major network issues so this model isn’t able to connect to the source data, but it’s an incredible model. When my connectivity issues are resolved I’ll update this page.

A little bit about the model itself - the model used is a SEIR (susceptible-exposed-infectious-recovered) model and the interesting part about their model is that it contains a lot of flexibility around uncertainty which has really had a big impact on the spread and treatment of the virus. I was going to implement some additional what-if parameters to allow for a user to see directly how things like the availability of ICU beds, increases/decreases in travel, and funding impact the spread and treatment of the virus over time, but I since the code for this model is publicly available I am planning to incorporate that into some training videos for everyone. The model is rather easy to implement so I think it will be great for everybody to see the implementation of a model like that and how to add parameters to a machine learning model in Power BI.

Summary

I hope you like it!

To learn about the real-life scenario presented for the challenge, be sure to click on the image below.

power-bi-chal-1

2 Likes

Here’s the complete report with a bit more detail. Since some of the images are quite long I split them into multiple images in order to provide more detail:

Home

Case Overview

Preparation and Response

Response Capacity



Public Health Risks



Economic & Food Security

Social Distancing


Critical Care Supplies


Vaccines

Summary

Who’s Getting Vaccinated

Distribution

Vaccines Administered

Demographics

Intro

COVID-19 Cases




Unemployment


Worker Characteristics
Race/Ethnicity


Gender


Income


Group Setting



Advanced Modeling



[/details]

2 Likes

Nice one Brad this looks like a report straight out of a consultants playbook!

How you have represented all of the information here is superb, I can look at the high-level info but also dive into more granular aspects of what is going on with the information easily and effectively.

It seems like you have taken a different tack here and work with specific data in the US.

I appreciate the out of the box thinking and how you have gone about creating a dynamic report experience that any user would be able to make informed Insights from.

Love the advance analytics work. Inspiring!

Sam