Cleaning Azure Marketplace Data with PowerPivot and Predixion Insight

Thanks to some connections at Microsoft I was made aware of some very interesting data that was published on the Windows Azure Data Marketplace by Practice Fusion - deidentified medical records of 5000 patients. Of course, I had to take a look. What I found was a very compelling and interesting set of data, that was more interesting when looked through the lens of Predixion Insight. Of course, as with any data that you may get from anywhere, there are first some issues in the data itself that need to be "corrected" before used for any analysis. In this post I'll show you how to get that data, explore a little bit of it, and clean up one particular part. There's lots more to do, but this is just getting your feet wet. In order to follow along at home, you will need Excel 2010, PowerPivot (get here), Predixion Insight for Excel (get here).