UCSF Analytics Strategies, Processes & Technologies : Synergistic Partnerships that Improve Care and Operations Sandra Ng, MSN, RN-BC Assistant Director Business Intelligence Program UCCSC 2014 August 3, 2014 00100000 Years of IT Collaboration
Agenda • Background • Journey, strategy and approach • Tool used & applications developed • Outcomes accomplished • Lessons Learned / Next steps
• Two site, 650 bed academic medical center • Ranked #8 in 2014 U.S News & World Report • ANCC Magnet Accredited Institution • Children’s Hospital – within – a – Hospital (180 beds) • Feb 2015, +289 bed Children, Women & Cancer hospitals • 102 clinics with ~775,000 ambulatory visits annually • ~177k patient days • ~28k discharges • ~17k home health visits • ~37,500 emergency visits • About faculty and staff (full & part time) • ~2,750 RNs – (includes non union RNs) • 2,100 Credentialied physicians and surgeons • 400 Allied Health Professionals • Over 75 adult specialties and 50 pediatric specialties
Project Goals • Enhance clinical enterprise performance improvement & reporting capacity • Select a technology solution to support data management & analytical work products • Produce meaningful reports and templates to reflect performance, provide transparency & increase accountability • Shift employee efforts from data collection and manipulation to performance improvement activities • Create standardized repeatable process to produce analytical work products Access to and analysis of data is the number one underserved IT need across UCSF Joe Bengfort – UCSF CIO 4
Journey, Strategy & Process • Internal / External Team • Virtual Provide • Reporting • Low hanging fruit Value • Scope – 60 days Process • Iterative
Enterprise BI & DW Domains Patient Care Data Marts Finance & Administration HR/ Data Data Payroll Marts Marts Core EDW Research Data Data Education Marts Marts 6
Dashboard Creation Process Request Intake Prioritize & Governance Develop Dashboard Dashboard Intake Form • Prioritized using criteria on • Assign project team Online the Prioritization Worksheet • Intake Form • Iterative development • BI Steering Committee • Change Request Form • Requirements prioritizes dashboards to be • Identify data sources developed • Design ETL & data mgmt • Design UI • Dashboard prototype • User testing/validation • Launch, Train & Communicate 7
Dashboard Status – as of 8/1/14 Dashboards - Live Name Description FlashDash Operational Metrics (LOS, Volume, Cash, Case Mix) FlashDash + Research Operational Metrics w/ Research patient specific data DischDash Discharges before noon metrics QualDash v1.2 388 Metrics (Infection, Core Measures, Safety, Patient Sat Service Line Volumes / Costs by Service Line Research Data Browser De-identified Research cohort selection tool Dashboards - in Development Name Description Verbal / Telephone Orders Communicates performance Balanced Scorecard Quality, Finance, Operations and Patient Satisfaction IT Service Now Internal IT metrics HB Revenue Cycle Replace other report needs School of Medicine Medical student competency scores for students and Education advisors 8
Accomplishments & Outcomes by 6/26/14 Data / Metrics Applications Users 550 Twelve Discharges Executive Quality Service Line 923 Sources Live Optimized Development Research 9 Avg days for Sessions application Research Team development Service Line Discharges Reports streamlined Quality Twenty Eight Executive Analysts time saved 18hours/mo Resources Days team in place External Internal 67% New Requests since launch 33% 393 38 9
Lessons Learned • Executive sponsorship • Ownership / data governance • Clear purpose • Scope & Expectations • Iterative • Measure success • Celebrate / disseminate Thanks to Accolade Advisors, Kloud Data & Prominence The perfect is Advisors with tool expertise & the enemy of knowledge transfer! the good 10
Demo Quality Dashboard 11
Accessing dashboard via EHR 12
Quality Dashboard – High level view Displays process with outcome metrics – Nurse sensitive and global quality Unit/service breakdown 13
Metric Detail tab – drills / views Unit specific: 13L, Oct 2013, Bundle Compliance 14
Metric Detail tab – drills / views Unit specific: 13L, All 2013, Bundle Compliance w/ graph 15
Patient Detail tab with link to Epic 16
Hyperspace integration – opens patient chart in Epic • Provided Full transparency • Self Service 17
Other dashboards • Discharges before noon (DishDash) • Research Data Browser • Executive Dashboard (FlashDash) • Service Line Dashboard 18
DischDash improved patient flow 19
Research Data Browser – cohort selection 20
Executive Dashboard – daily view of operational indicators • High level volume & financial metrics • Keeps a pulse on performance daily 21
Service Line Dashboard - costs 22
Appendices 23
Intake Form Online • Intake Form • Change Request Form 24
Prioritization & Governance • Prioritized using criteria on the Prioritization Worksheet • Business Requirements • Data Requirements • BI Build Requirements VS. • Impact to organization • BI Steering Committee - Prioritizes dashboards to be developed based on analysis 25
Dashboard Development Process - Iterative • Assign project team • Iterative development • Requirements • Identify data sources • Design ETL & data mgmt • Design UI • Dashboard prototype • User testing/valida- tion • Launch, Train & Communicate 26
Questions? Contact Sandra Ng, MSN, RN-BC Sandra.Ng@ucsf.edu
Recommend
More recommend
