Sand Dance in the US: Understanding trends at the County Level
03-13-2017 11:52 AM - last edited 04-12-2017 14:19 PM
03-13-2017 11:52 AM - last edited on 04-12-2017 02:19 PM by Jessica
Over the past 3 years, I have collected data at the US County Level. In this dataset, I have over 100 columns of data for every county in the United States (> 3,100 counties). This includes data from the US Census, Center for Disease Control, the Bureau of Labor Statistics and presidential election results from the 2008, 2012 and 2016 elections.
Sand Dance is a Power BI Custom Visual produced by Microsoft Research. It is a great tool for analyzing many distinct entities (counties at the row level) with many separate measures (columns of data). Sand Dance facilitates the rapid exploration of data by making it very easy to switch data columns as well as chart types.
I have made both the PBIX file and the base excel file available on One Drive in the following folder: (https://1drv.ms/f/s!At1c2HEDxgPQdhOdCszvd2KMRJs). The Sand Dance visual is availabe in the Custom Visuals Gallery (https://app.powerbi.com/visuals/). To see a YouTube video of file, go to https://www.youtube.com/watch?v=5c_Q6OP_4U0&t=23s, or search for "Jeff Lumpkin Power BI" on YouTube.
Please try it out and let me know what you think.