Build HealthyPeople in the Cloud

1. Build HealthyPeople.gov in the Cloud Dr. Brand Niemann Director and Senior Data Scientist Semantic Community March 7, 2011 (Update with Data.Medicare.gov, March 11, 2011) http://semanticommunity.info/Data.gov/Health.Data.gov

2. Preface • This is a “clickable” prototype – actually a fully functional application that will be finished for the April 27th Go Viral to Improve Health Challenge. • Narrative description of how the app should work – the app puts data within three “clicks”: see the data, search the data, and download the data (see Spotfire Web Player Tutorial). • Next steps for a fully developed product – more team members and databases have been added and this is being linked to Value Added Services for VIVO (see Section 6).

3. Overview • 1. The Challenge • 2. The Cloud Tools • 3. The Team • 4. The Process • 5. The Results • 6. The Next Steps

4. 1. The Challenge • An app that will maximize stakeholders’ ability to improve the health of those they serve with a personalized application of healthypeople.gov that draws from multiple health data sets. • For example, a challenge might highlight a specific health care problem and ask for new ways to solve it. Or you might offer a data set and ask developers to show the most interesting use of it.

5. 1. The Challenge • 1.  Start a Developer Challenge blog! • This Wiki. • See http://health2challenge.org/members/bniemann/ • And http://challenge.gov/challenges/104/submissions/2521-build-healthypeople-gov-in-the-cloud • 2.  Customize your blog • Yes, this Wiki. • 3. Send us a logo • Done. • 4. Recruit team members • Done.

6. 2. The Cloud Tools • I found out about the Healthy People 2020 Challenge on March 4th and the March 7th due date so I had to use my “cloud tools” and build on previous work. • I use two “cloud tools”: • The MindTouchOnDemand Technical Communication Suite Hosted in the Amazon Cloud. • The TIBCO Spotfire Professional, Metrics, and Network Analytics Software Hosted in the Cloud.

7. 2. The Cloud Tools With the power of MindTouch DReAM, MindTouch products excel at loading, transforming and re-mixing data from web services, databases and enterprise applications. http://cloud.mindtouch.com/

8. 2. The Cloud Tools http://goto.spotfire.com/g/?SK3YHYAQFI=clicksrc:home

9. 2. The Cloud Tools http://semanticommunity.info/Data.gov/Health.Data.

10. 2. The Cloud Tools http://semanticommunity.info/HealthDataGov

11. 2. The Cloud Tools TIBCO Spotfire US States

12. 2. The Cloud Tools TIBCO Spotfire US Counties

13. 3. The Team • How BI and Data Analytics Professionals Used Twitter in February: • http://spotfireblog.tibco.com/?p=5328 • Brand Niemann, a retired (Note: I am not retired but still working hard every day) senior enterprise architect at the U.S. Environmental Protection Agency made our Twitter list for his cool visualizations on government data. Here’s one visualization on the number of Tweets mentioning the International Open Government Data Conference. Niemann partners with Mills Davis, another data scientist to extract, transform, and load a number of EPA and federal databases to produce more transparent, open and collaborative business analytics applications.

14. 4. The Process • Surveyed the entire web site for databases that I could build on and integrate with. • Found: http://healthypeople.gov/2020/topicsobjectives2020/default.aspx • Specifically: http://healthypeople.gov/2020/topics...bjectives.xlsx • Added column with link to topic: http://healthypeople.gov/2020/topics...aspx?topicid=1 • Then build a database of the state plans: http://healthypeople.gov/2020/implementing/stateSpecificPlans.aspx and the goals and objectives they have selected • And a databases of the Healthy People Coordinator in your State or Territory: http://healthypeople.gov/2020/consortium/stateCoordinators.aspx • And then import them into Spotfire and link and visualize them. • NOTE: There are a lot more steps than I wrote down here!

15. 5. The Results Turn all of this into the next slide. http://healthypeople.gov/2020/default.aspx

16. 5. The Results http://semanticommunity.info/@api/deki/files/9261/=HealthyPeople2020-AllObjectives.xlsx

17. 5. The Results In addition, turn these three additional web sites into the next slide for this and Other challenges! http://health2challenge.org/ http://www.healthindicators.gov/ https://www.data.gov/communities/node/81/data_tools

18. 5. The Results http://semanticommunity.info/@api/deki/files/9244/=Health2Challenge.xlsx

19. 5. The Results http://semanticommunity.info/@api/deki/files/9252/=HealthDataGov.xlsx

20. 5. The Results http://semanticommunity.info/@api/deki/files/9259/=HealthIndicatorsWarehouse.xlsx

21. 5. The Results PC Desktop Spotfire

22. 5. The Results SpotfireWeb Player

23. 6. The Next Steps • Add Team Members and Databases: • Jaz-Michael King, iPRO Senior Director: • http://blogs.ipro.org/pellucid/author/admin/ • Dan Wendling, Systems Librarian at National Library of Medicine: • http://www.linkedin.com/in/danwendling • http://grants.nih.gov/grants/KM/OERRM/OER_KM_events/wiki_fair.htm?print=yes& • Value Added Services for VIVO: • http://semanticommunity.info/Build_VIVO_in_the_Cloud • http://semanticommunity.info/Build_VIVO_in_the_Cloud/NIH_Workshop_on_Value_Added_Services_for_VIVO

24. Pellucid – Health Care Transparency http://health2challenge.org/members/mynameismonkey/

25. Pellucid – Health Care Transparency http://blogs.ipro.org/pellucid/web-access/

26. Pellucid – Health Care Transparency http://wiki.ipro.org/index.php/Pellucid

27. Pellucid – Health Care Transparency http://pellucid.ipro.org/view_databases/list_tables

28. Pellucid – Health Care Transparency http://pellucid.ipro.org/view_databases/select_table/CA_hospitals

29. Pellucid – Health Care Transparency http://pellucid.ipro.org/view_databases/select_table/CA_hospitals#/pivot:true

30. Pellucid – Health Care Transparency Result for Export to CSV http://pellucid.ipro.org/view_databases/export_table/CA_hospitals/pivot:true

31. Pellucid – Health Care Transparency http://semanticommunity.info/@api/deki/files/9280/=PellucidPubllicViewTables03072011.xlsx

32. Pellucid – Health Care Transparency PC Desktop Spotfire

33. Data.Medicare.gov • Welcome to Data.Medicare.Gov! • Data.Medicare.Gov has been created to allow users to access data in an interactive format. Within each dataset, a user can sort and filter with multiple criteria and share the information using various web sources. Primarily used by health policy researchers and the media, this site is not intended to be used as a search tool. • This site should not be used as a means of obtaining an official Medicare Number, and is not intended for the exchange of Personal Health Information (PHI) such as your Medicare Number. • To help you get started with Data.Medicare.Gov, here are some helpful browse links: • Hospital Compare • Dialysis Facilities • Home Health Agencies • Helpful Contacts • Nursing Home • Medical Equipment Suppliers

34. Data.Medicare.gov http://data.medicare.gov/

35. Data.Medicare.gov http://data.medicare.gov/dataset/Hospital-Medicare-Payment-And-Volume-Measures-Nati/ux4p-jnm7

36. Inventoried the Datasets at Data.Medicare.gov (see table to right) and used it to pick one of interest (see table below) and did a plot of several variables. Average Percent of Patients by State Who Reported YES, They Would Recommend the Hospital. Data.Medicare.gov Mouse – Over for Details. Filter by Hospital Name, City, State, etc. and see results in tables. PC Desktop Spotfire