130 likes | 137 Views
Learn how hotspotting, through data segmentation and analysis, can optimize healthcare by targeting specific needs efficiently. This toolkit covers data cleaning, visualization, spatial analysis, and data-driven interventions. Contact for more information.
E N D
Improving Care & Reducing Costs with Hotspotting & Innovative,Local Data Systems
Hotspottingis segmentation. It’s taking big data sets, [and] segmenting them into a strategy so that you can target different pockets of need… Hotspotting is making sure that people who are in need get their needs met… in a rigorous, data-driven way. Dr. Jeffery Brenner, family physician & founder, CCHP “ ”
Getting Started • Overview of claims and administrative data • Securing buy-in from the community • Legal and research frameworks for working with claims data 4) Data specification templates 5) Data security recommendations
Data Cleaning • 80% of the work is cleaning • A framework for data cleaning: structures & strategies • Data cleaning techniques • Probabilistic linkage • Geocoding
Measurement • Developing common measures of high utilization • Constructing patient-level metrics from episode-level data • Cluster analysis and segmentation
Using Diagnosis Codes • Overview of ICD9 codes • Review of various diagnosis groupers (Charlson, Elixhauser) • ICD9 crosswalks and tools
Visualizing Data 1) Principles of good (and bad) data design 2) Claims data visualization templates 3) Tableau exercises
Spatial Analysis Spatial Analysis of Camden Hospital Costs Several buildings (e.g.) annually generate $1+ million in hospital costs. 6% of city blocks account for 18% of patients and 37% of receipts. January 2002 – June 2008
Data-Driven Interventions List 3-5 important points here. No more. Not a screen shot
Follow-up Questions? The Toolkit Website: www.healthcarehotspotting.com Contact: aaron@camdenhealth.org stephen@camdenhealth.org www.camdenhealth.org