Sand Dance in the US: Understanding trends at the County Level

Frequent Visitor
2301 Views
Highlighted
Frequent Visitor
Posts: 4
Registered: ‎06-14-2016

Sand Dance in the US: Understanding trends at the County Level

[ Edited ]

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.

 

Thanks,

 

Jeff

 

 

 

Attachment
Established Member
Posts: 194
Registered: ‎04-13-2016

Re: Sand Dance in the US: Understanding trends at the County Level

Amazing job - Congrats !

I am really impressed. Sand Dance is definitely a game changer !

Advisor
Posts: 280
Registered: ‎06-28-2015

Re: Sand Dance in the US: Understanding trends at the County Level

An impressive dataset, and the first time I've seen Sand Dance make any sense as an analysis tool. Thanks!