Mckesson Corporation · NYSE:MCK
Mckesson — CHLA Explorer Webinar (January 2014)
47 slides from Mckesson's conference presentation, Jan 14, 2014
Slide 1: Accelerating the Delivery of Valuable and Relevant Healthcare Analytics
Connected Care & Analytics Accelerating the Delivery of Valuable and Relevant Healthcare Analytics John Shewell Executive Product Manager Enterprise Intelligence McKesson Connected Care & Analytics
Slide 2: Accelerating the Delivery of Valuable & Relevant Healthcare Analytics
Accelerating the Delivery of Valuable & Relevant Healthcare Analytics Carl Urasaki, Director, Decision Support Robert Capulong, Manager, Business Systems
Slide 3: Transform data into information, and information into insight
“The goal is to transform data into information, and information into insight.” -Carly Fiorni, President of Hewlett Packard 1999-2005 In 6 months of having McKesson Performance Analytics Explorer™: • Engaged VPs, C-Level executives and board members • Centralized and illustrated data from multiple s
Slide 4: CHLA Background
CHLA Background • Inpatient • Outpatient – Over 13,000 IP admissions / year – Over 250,000 OP visits / year – ALOS – 7.5 / CMI 1.9 – 75,000 ED visits / year – 75% Medi-Cal / Medi-Cal Mgd Care – ECMO Services – PICU/NICU – Cardiac / BMT / Oncology • Trauma Center / Magnet Hospital / Leapfrog Recognit
Slide 5: Department Background: Decision Support Services
Department Background Decision Support Services Quality Budgeting Resource /Productivity Utilization Decision Product Line Support Physician Profile /Business /Profitability Plans Managed Care Negotiations Ambulatory /Analysis 1/21/2014 4
Slide 6: Department Background: Decision Support Systems
Department Background Decision Support Systems Manage/Administer data from various systems, creating the “bridge” between each system for data analysis Cerner McKesson STAR/ Surgery Performance Compass Analytics/ Decision Explorer Support TBS / Kaufman PHIS Hall 1/21/2014 5
Slide 7: McKesson Analytics Decision Support
McKesson Analytics Decision Support • STAR (billing source system) • McKesson Performance Analytics – Performance Manager (financial reporting system) – Business Insight (centralized reporting portal) • PCON (contract management) • McKesson Performance Analytics Explorer (integrated analytics) 6
Slide 8: McKesson Performance Analytics Explorer Benefits
McKesson Performance Analytics Explorer Benefits • Healthcare focused user community • Leveraging creation of templates • Dynamic data creation • Ease of use • Time to market from concept to development in days/weeks • Dynamic presentation capability • Multiple data sources in one analysis 7
Slide 9: McKesson Performance Analytics Explorer: What We Did
McKesson Performance Analytics Explorer What We Did…. Decision Support • 12 McKesson Performance Analytics Explorer licenses (6 core) • Trained by McKesson: June 2013 • First analysis rolled out 2 weeks after training: Managed Care • Source of data: Various (McKesson, Cerner, Kaufman Hall, Peoplesof
Slide 10: McKesson Performance Analytics Explorer Dashboards
McKesson Performance Analytics Explorer Dashboards • July – December 2013 • In Development – Managed Care – Ancillary – Readmissions – Executive – Access Center (Transport) – Utilization Management – Surgical Product Line – Oncology – IP Product Lines – Resource Consumption • Conversion – Patient Da
Slide 11: McKesson Performance Analytics Explorer Rollout
McKesson Performance Analytics Explorer Rollout • Initial Rollout Process: (Based on Recurring Monthly Reports) – Build dashboard based on previous departmental requests – Meet with DSS Team to review data and provide feedback internally – Meet with department to showcase dashboard and receive feedb
Slide 12: Rollout Process: Readmissions
Rollout Process Readmissions Objective: Provide readmission volume and trends, along with identifying a patient’s readmission patterns. Audience: Quality, Readmissions Committee *Data validated with and published for Quality group and Readmissions committee Next Steps: Updated Monthly 1/21/2014 11
Slide 13: Radiology
Children’s Hospital LOS ANGELESS We Treat Kids Better Radiology
Slide 14: Radiology Analysis Process
Radiology Analysis Process • Idea for Radiology analysis came from the McKesson Performance Analytics Explorer monthly user meeting (web seminar) – Showed McKesson template – CHLA Downloaded template – Demoed template to CHLA Radiology Director • Assembled team to translate McKesson template to Cern
Slide 15: McKesson Radiology Template Instructions
McKesson Radiology Template Instructions 14
Slide 16: Radiology: Volume by Selected Area / Most Common Exam by Modality
Radiology Volume by Selected Area / Most Common Exam by Modality All Priority Levels 15
Slide 17: Radiology: Volume by Modality by Selected Area
Radiology Volume by Modality by Selected Area, All Priority Levels Selected End User Filters on Left vs. Development Filters on Right 16
Slide 18: Radiology: CT Volume by Selected Area with Turn Around Time
Radiology CT Volume by Selected Area with Turn Around Time 17
Slide 19: Radiology: CT Volume by Day of Week
Radiology CT Volume by Day of Week Time of Day Exam Start to Completion 18
Slide 20: Radiology: MRI Volume by Radiologist with Turnaround Time
Radiology MRI Volume by Radiologist with Turnaround Time 19
Slide 21: Radiology: MRI Volume by Zip Code
Radiology MRI Volume by Zip Code Managed Care vs. Medi-Cal 20
Slide 22: Radiology Analysis Benefits
Radiology Analysis Benefits • Productivity analysis – Provides user friendly dashboard – Provides essential productivity metrics and analytics • Exam turn-around-times, diagnostic report turn-around-times, staff productivity, etc. – Provides useful drill down options on all data points • Information
Slide 23: Readmissions
Children’s Hospital LOS ANGELESS We Treat Kids Better Readmissions
Slide 24: Readmissions Analysis Process
Readmissions Analysis Process • CHLA joined the Ohio Collaborative – Focus on quality metrics including readmissions • Analysis generated to present to our newly formed committee • Focus on unplanned readmissions • Goal to understand where readmissions were occurring • Patients with high frequency o
Slide 25: Readmissions Overview – by Month
Readmissions Overview – by Month 24
Slide 26: Seizure Readmissions and Resulting Volume by Length of Stay
Seizure Readmissions and Resulting Volume by Length of Stay 25
Slide 27: Original Admission of Seizure, Subsequent Readmission
Original Admission of Seizure Subsequent Readmission (in blue) 26
Slide 28: Seizure Readmission Original Admission
Seizure Readmission (in blue) Original Admission 27
Slide 29: Severity Level – Most Readmissions
Severity Level 3 – Most Readmissions 28
Slide 30: Readmissions: Previous Admission Severity Level
Readmissions Previous Admission Severity Level 1 (in green) Distribution of Readmission by Severity Level (pie chart) 29
Slide 31: Top Patients Readmitted
Top 10 Patients Readmitted 30
Slide 32: Readmissions Analysis Benefits
Readmissions Analysis Benefits • Readmission analysis new to CHLA • Medi-Cal currently does not have a financial penalty for readmissions • Higher readmissions than compared to our peers • Evolution of this information is to integrate infection control information • Gained efficiencies by utilizing
Slide 33: I/P Service Lines
Children’s Hospital LOS ANGELESS We Treat Kids Better I/P Service Lines
Slide 34: I/P Service Lines Process
I/P Service Lines Process • Developed standard template to analyze and showcase service lines and payer information • Presented to Boards, Executives and Directors • Focus on visualizations, understand trends and actionable information • Service line template is a combination of self developed and M
Slide 35: Service Line Overview by Quarter
Service Line Overview by Quarter 34
Slide 36: APR-DRG Overview-All Payers
APR-DRG 160 Overview-All Payers 35
Slide 37: Digestive Diseases Service Line Discharges
Digestive Diseases Service Line Discharges by Quarter / by Month / Change from Prior Quarter 36
Slide 38: Neonatal Care Service Line CMI
Neonatal Care Service Line CMI by Quarter / by Month / Change from Prior Quarter 37
Slide 39: Service Lines Comprising Managed Care
Service Lines Comprising Managed Care Payer Mix Trend Oncology Payer Mix and Yearly Trend 39
Slide 40: Cost Opportunity by Service Line
Cost Opportunity by Service Line Compare Average to 25th Percentile Ability to Exclude Outliers 40
Slide 41: Service Line Evaluation of Direct Cost by Expense Category
Service Line Evaluation of Direct Cost by Expense Category 41
Slide 42: Viewing Changes in Demographics by Service Line and APR-DRG
Viewing Changes in Demographics by Service Line and by APR-DRG 42
Slide 43: Inpatient Service Line Benefits
Inpatient Service Line Benefits • Previous to Explorer – Data lived in decision support – Provided on an ad hoc basis – Routine “reporting” to administration • Post Explorer – Visualizations present information in a controlled environment – More eyes on the data – Data is now used constantly and mor
Slide 44: Summary
Summary • Owned the product 6 months • FTE’s remained the same • Engaging our VP’s and Directors – Develop dashboards and scorecards – Information wanted but unable to obtain • Providing our VP’s, Directors and Managers information: a) Never seen before b) Requests on an ad hoc basis c) To make oper
Slide 45: Taking the Test Drive is Easy
Connected Care & Analytics Taking the Test Drive is Easy Go to Complete the form www.mckesson.com/explorertestdrive
Slide 46: Taking the Test Drive is Easy
Connected Care & Analytics Taking the Test Drive is Easy Receive e-mail with easy-to-use instructions Getting started with loaded templates
Slide 47: Additional Information
Connected Care & Analytics Additional Information Fabio Fornaro fabio.fornaro@mckesson.com 404-338-3693 Brad Wilson bradford.wilson@mckesson.com 404-338-3575 Past webinars recordings can be found at www.mckesson.com/enterpriseintelligence