08-07-2017 21:03 PM - last edited 08-07-2017 21:33 PM
This is a re-creation of an existing data viz on the International Health Metrics and Evaluation website.
Allow me to briefly lay out the features of this viz:
1. Slicers at the top allow you to slice the data on Mortality Type (e.g. Cardiovascular Disease), State, and Year.
2. A color scale just below the slicers provides context to the visuals. I created this color scale with a 100% stacked column chart. I just hid the x and y axes and used the mortality rankings as the values and as the color saturation.
3. The heatmap was created using the matrix. Typically you would have years across the top (columns); however, since there are much fewer years than states (note: District of Columbia, though not a state, is included in the dataset), it made more sense to have the states on the columns and the years on the rows. This way it spans the entire width of the page. The heatmap, which is colored by mortality ranking (1/dark red=high mortality rate helps you see; 52/dark blue=low mortality rating), helps you see changes over the years by each state.
4. The choropleth map provides insight into regional mortality rates.
5. Then you have your standard bar chart with mortality rate on color saturation. You can drill down to the county level.
6. Lastly, you have a scatterplot across the bottom, but only the x-axis is utilized (by mortality rate) and is color formatted by mortality rate. This helps you see the distribution of the data. You can also drill down to the county level. I wanted to use the Play Axis, but it doesn't seem to work if you only use one axis. If anyone knows any way around this, please let me know.
I hope you enjoy the data viz. Please let me know if you have any recommendations or if you notice any errors. Thank you.
You can check out more of my Power BI creations at Make It PBI.