By Avi Singh [Twitter]
Folks, May 21st is being celebrated as Red Nose Day across USA. Goal is to have some fun and raise money for children living in poverty. We at PowerPivotPro mix a bit of black humor in today’s post and promise to donate a portion of the proceeds from our upcoming PowerPivot Online Class (Jun 8-9) to Red Nose Day.
For today’s special, we were inspired by the CDC released graph showing distinctive causes of death by state. Not content to stare at a picture, we rebuilt the model from scratch using Power Query, Power Pivot and Power Map. Which lets us slice and dice and visualize the data various ways to our heart’s content.
Our results match closely with that of CDC, slight differences may exist since we use 10 year span from 2004-2013, whereas CDC researchers reportedly used 2001-2010.