Analyzing Healthcare Open Data with Power BI

Back in December I presented the topic Analyzing Healthcare Open Data with Power BI at the PASS BA Marathon. I want to apologize for not posting this follow up post sooner, December was just a busy month with the holidays, vacations, and after that I just kept putting this off. Well no more, here is the follow up finally. In addition to this post I have also posted the Power BI example I prepared into the Data Stories Gallery.

Here is a screenshot of the demo that I presented which was based on the World Health Organization world wide expenditure data

The presentation material and a recording of the presentation is available on the PASS web site here – Analyzing Healthcare Open Data.

Just a heads up that during the presentation I lost my Internet wifi signal but it was only for a couple of minutes and I was able to get reconnected and resume the content from where I left off.

Here is a list of some of the Healthcare Open Data sites that I shared:

• https://www.data.gov/health
• https://www.healthdata.gov
• https://www.cms.gov/
• https://www.medicare.gov/
• http://www.who.int/en/
• https://datawarehouse.hrsa.gov/
• https://open.fda.gov/

I would have liked to have spent more time on reviewing some of the sites listed above to showcase some of the data that is freely available, but with the technical difficulty I had to skip over that to allow time for the Power BI demo that I had planned and to allow time for Q&A. In the demo I showed some of the new capabilities in Power BI that were released such as the dropdown slicer option, forecasting, clustering, R visuals, Top N filtering, and a few more.

I will plan on revising the content and doing an updated version that hopefully I can present for the PASS Business Analytics Virtual Group later this year. There were a bunch of great questions asked and I am appreciative for the feedback that was provided from all of the attendees. I am glad people were able to walk away with a few nuggets of information regarding Healthcare Open Data and Power BI capabilities.