1 / 33

Business Intelligence empowering Health Care Management Clalit Health Services Israel 2008

Business Intelligence empowering Health Care Management Clalit Health Services Israel 2008 Mazal Tuchler - BI Manager. Clalit Health Services. 3.8 million customers (60% Market Share) 0.5 Million senior citizens (72% in Israel) Provides both insurance and health services

lowell
Download Presentation

Business Intelligence empowering Health Care Management Clalit Health Services Israel 2008

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Intelligence empowering Health Care Management Clalit Health Services Israel 2008 MazalTuchler - BI Manager

  2. ClalitHealth Services • 3.8 million customers(60% Market Share) • 0.5 Million senior citizens (72% in Israel) • Provides both insurance and health services • Comprehensive health services: • 14 Hospitals • 1400 Clinics • 450 Pharmacies • 70 laboratories

  3. Enterprise BI - Objectives • Organizational Information Platform • Support Business Strategy and Processes • Integration • Up to date Information • Availability • Flexibility • Simple and independent querying • Reliability - Data quality • Uniform business language Single version of the truth

  4. BI - User Profiles • Policy Unit • District/hospital info units • Marketing • Monitoring & Control • Insurance • Budget • Accounting • Purchase units • Inventory monitoring • HR & payroll • Community: • Doctors • Nurses • Pharmacists Managers (4000) Analysts (370) Operational (500) The Community (indirect 12,000)

  5. Demography Medical Services • Medications • Hospitalizations • ER • Ambulatory • Lab tests • GP visits • Specialists visits • Paramedic • Imaging • Physiotherapy • Private Medical service Suppliers • Demography • Churn • Mailing • Capitation • Customer forecast Human Resources • Manpower • Payroll • Outside Contractors • Independent Doctors Monitoring & Control • General Practitioners • Services Acquisition • Hospital Monitor Units Logistics • Purchases • Inventory • Medical Equipment • Logistic Projects CustomerServices Medical Status • Queues • Supplementary Insurance • Satisfactory Surveys • Call Center Calls • Complaints • Community Diagnosis • Hospital Diagnosis • Chronic illnesses • Severe Illnesses • Medical Markers • Medical Quality KPI’s BI - Information Areas Finance • Clinic Budget • District Budget

  6. BI Evolution  1995  2000  2004  2005  2006

  7. BI Evolution  1995  2000  2004  2005  2006

  8. BI Established • 370 Users (Analysts) • Ad-Hoc Querying - 30,000 / Month • Detailed & aggregated data • Maximum flexibility • Complex Queries • Unix/Informix & Business Objects

  9. BI Evolution  1995  2000  2004  2005  2006

  10. BI Evolution  1995  2000  2004  2005  2006

  11. BINA • BINA = Hebrew for “WISDOM” • Acronym: Decentralization, Knowledge & Mgmt • 4000 Users (Managers) • Principles: • Simple/Intuitive UI & rich functionality • Transparency • Security • A comprehensive environment • MS OLAP + ProClarity • Consulting: Gilon Business Insight

  12. BI Evolution 2003 Migration to SQL Server  1995  2000  2004  2005  2006

  13. BI – Migration to SQL Server Unisys MS OLAP SQL Server DataStage OLD Sun E10000 Files for OLAP DWH Informix ETL Scripts SRC FILES NEW Unisys Unisys MS OLAP SRC FILES DWH SQL Server

  14. BI Evolution  1995  2000  2004  2005  2006

  15. BI Evolution  1995  2000  2004  2005  2006

  16. BINA • Performance measurement for org. units • Monitoring performance versus target • Focus on visuality • Gilon Business Insight (Local/Israeli product)

  17. BI Evolution  1995  2000  2004  2005  2006

  18. BI Evolution  1995  2000  2004  2005  2006

  19. Data Mining Forecast: Medical Deterioration among Elderly Customer Profile in DWH Feedback Treatment Protocols Intervention Programs Start Prediction Model Distribution to Community Customers at high risk

  20. Data Mining • Major enhancement of data analysis capabilities • Forecast capabilities enabling pro-active service • Broad distribution • MS Data Mining • 1st model developedin Microsoft Lab (TAP)

  21. BI Evolution  1995  2000  2004  2005  2006

  22. BI Evolution  1995  2000  2004  2005  2006

  23. Demography Medical Services • Medications • Hospitalizations • ER • Ambulatory • Lab tests • GP visits • Specialists visits • Paramedic • Imaging • Physiotherapy • Private Medical service Suppliers • Demography • Churn • Mailing • Capitation • Customer forecast Human Resources • Manpower • Payroll • Outside Contractors • Independent Doctors Monitoring & Control • General Practitioners • Services Acquisition • Hospital Monitor Units Logistics • Purchases • Inventory • Medical Equipment • Logistic Projects CustomerServices Medical Status • Queues • Supplementary Insurance • Satisfactory Surveys • Call Center Calls • Complaints • Community Diagnosis • Hospital Diagnosis • Chronic illnesses • Severe Illnesses • Medical Markers • Medical Quality KPI’s BI - Information Areas core core back Finance core • Clinic Budget • District Budget back core core back

  24. Demography Medical Services • Medications • Hospitalizations • ER • Ambulatory • Lab tests • GP visits • Specialists visits • Paramedic • Imaging • Physiotherapy • Private Medical service Suppliers • Demography • Churn • Mailing • Capitation • Customer forecast Human Resources • Manpower • Payroll • Outside Contractors • Independent Doctors Monitoring & Control • General Practitioners • Services Acquisition • Hospital Monitor Units Logistics • Purchases • Inventory • Medical Equipment • Logistic Projects CustomerServices Medical Status • Queues • Supplementary Insurance • Satisfactory Surveys • Call Center Calls • Complaints • Community Diagnosis • Hospital Diagnosis • Chronic illnesses • Severe Illnesses • Medical Markers • Medical Quality KPI’s =85% core =15% back BI - Information Areas core core back Finance core • Clinic Budget • District Budget back core core back

  25. SAP-BI embedded in Enterprise BI EDW ProClarity DW Manager LEGACY LEGACY LEGACY WAD Business Objects SAP-BI BEX R/3 Analyst

  26. How do we do it? • People • Data • Technology

  27. How do we do it: people CIO Medical Systems Dept Information Implementation Administrative Systems Dept Infrastructure Dept Help Desk BI EAI DBMotion Systems Analysts ETL & DBA OLAP & VB Data Mining SAP-BI

  28. How do we do it: data deterioration forecast dialysis forecast budget planning total customer cost health quality service quality unit evaluation FI LO HR customer medical data CRM Demography Organizational master data Advanced APPS Integration Event Level insight Data Infrastructure business areas

  29. BPM MS ProClarity MS OLAP How do wedo it: technology MS Data Mining MS Reporting Services BEx/WAD Business Objects SAP BI MS SQL Server MS SQLserver

  30. Are we being useful? Usage Monitoring 1-Medical Quality KPIs entries 8,000 2-Flu Vaccinations (seasonal) 7,400 3-Primary Care Clinic Customer Satisfaction Survey (semi-annual) 4,400 4-Primary Care Clinic Customer Satisfaction Survey (weekly) 4,000

  31. Recipe for Success • Commitment & guidance of CEO and senior mgmt • Districts/hospital decentralization units lead the assimilation process • Intensive training • Users forums • BI Help desk • BI Support Portal

  32. BI Roadmap in Clalit • New unified UI for BINA • BSM • GIS • Meta Stage • and more…  2007  2008  2009

  33. Thank You

More Related