Good afternoon/evening everybody!
I was having some network issues yesterday so I didn’t get to post this on the forum. I was able to send my submission on time, but I wanted to wait till today to see if I could get the report to work using the direct connection to the source data. But anyways… below you’ll find my submission for Challenge 11. 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.
Basic landing page with icons to direct the user to the appropriate report.
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.
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.
Response Capacity focuses on if we currently have enough available beds, staff, or supplies to meet demand.
Public Health Risks
The Public Health Risks page focuses on tracking the spread of the virus and includes positive test rate, case growth rate, testing rate, hospitalization rate, and the rate of spread. Minnesota has established high risk and critical measures for each of these so we can see if we are not only flattening the curve but are getting to manageable levels.
Economic & Food Security
This is a high level look at how COVID has affected Minnesotans livelihoods by tracking new unemployment claims, total existing unemployment claims, and applications for the Supplemental Nutrition Assistance Program (SNAP).
Yes, it’s not truly ‘social distancing’ since it tracking if people are staying 6 feet apart would be pretty invasive, but we can see how travel increases exposure, spread, and new COVID cases by county.
Critical Care Supplies
This page tracks the inventory, supply, and shipment of critical care supplies in the state. The state itself is working with the private and public sector to ensure that healthcare professionals have all the essential supplies they need to fight the virus even if demand for these supplies increases.
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.
The summary answers most questions people have around the administration and supply of the vaccine (how many people have been vaccinated, how much of each type do we have, how many doses have been administered).
Who’s Getting Vaccinated
Currently very basic since the data is just starting to come in, but breaks out vaccine dose administration by gender and age group.
Tracks the available supply of the vaccine, supply shipped to Minnesota providers, and supply shipped for the CDC Long-Term Care Vaccination Program. They just released more information on this so I wish I could have included that in my submission but I felt like that would be cheating.
Breaks out the administered doses of the vaccine by product type and provider type.
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.
This section starts with a basic overview of the purpose of this analysis and the need for such analysis when looking at the affect the virus has had.
This is a detailed breakout of the main overview page, but analyzes COVID-19 cases, hospitalizations, and deaths by race/ethnicity. This is one of the longest pages as it’s really three pages stacked on top of each other.
Takes a look at how COVID has affected employment by race/ethnicity. I would have liked to eventually add a correlation heatmap to this page to prevent any misinterpretation of the data, but the data does speak for itself here.
The next three pages all reflect the impact COVID has had on worker characteristics (essential/non essential workers, ability to work from home, vulnerability to layoffs, etc.). The difference is in how you want to see the data: race/ethnicity, gender, income range. The top chart is a high level look for quick analysis and the bottom chart is industry specific.
This page focuses on the impact COVID has had on homelessness in regards to race/ethnicity. It also lays out the effects it has had on healthcare staff treating the homeless by race/ethnicity.
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.
I hope you like it!