This week has been an intense week of Dashboard and Blogs exercise. To finish this week off, we have data from the CDC(Centres for Disease Control and Prevention).

To give you a brief introduction, the dataset includes 2017, 2016 model-based small area estimates for 27 measures of chronic disease related to unhealthy behaviours, health outcomes, and use of preventive services. I decided to use the latest data from 2017 as the primary focus of my dashboard.

Following the news this Wednesday about Coronavirus being declared as a pandemic by WHO (World Health Organization), I have been thinking about creating visualizations related to Coronavirus.

As we all know, people of all ages can be infected by the new coronavirus (2019-nCoV), out of all, older people are most valuable and have a higher risk of death after being infected by the coronavirus.

In the meantime, people with pre-existing medical conditions (such as asthma, diabetes, heart disease) appear to be also more likely to become severely ill with the virus.

Based on the above information, I thought it will be interesting to utilize this dataset, together with US Census data from 2010 to investigating US weakest states and cities that will be potentially impacted by Coronavirus.

After creating the map view of popular over 65 yo, I decided to incorporate Drilldown Parameter Actions to make the dashboard more interesting and allowing the user to select between state and cities focus.

Step One is to create an excel dataset with below rows and then add it to my workbook as the second data source.

I then create a new sheet with below view.

I then add this sheet to my dashboard and created parameter action to change between City and State.

To make the dashboard more interactive, I decided to add another button called Reset to control the other two parameters, Selected City and Selected State.

The reset button acts to deselect any state or city so that the scatter plots are bar chart won’t appear.

I must admit I am quite a fan of hide and show techniques by using either dashboard actions or rearrange containers.

The last thing I did before touching up on the formatting details is to swop between my main dashboard and second dashboard using goto sheet dashboard action.

Some of the interesting findings are while having a large percentage of older people at West Virginia (according to 2010 census’s data), people living there are also having a high chance of having pre-existing conditions( asthma, diabetes and heart disease). More interestingly, the top 10 states for all categories are always the same, as you can see below.

 

Here is the link to the Viz if you would like to explore the dashboard a little yourself.