slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Enterprise Business Intelligence PowerPoint Presentation
Download Presentation
Enterprise Business Intelligence

Loading in 2 Seconds...

play fullscreen
1 / 56

Enterprise Business Intelligence - PowerPoint PPT Presentation


  • 128 Views
  • Uploaded on

Enterprise Business Intelligence. Ben Kimmel Assistant Director, Fiscal Services. Cleveland Clinic. 3.6 million patient visits 160,000 admissions 42,000 employees 2,700 physicians and scientists. Current EBI Infrastructure. Phase I implemented 2006 SQL Server platform

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Enterprise Business Intelligence' - rianne


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Enterprise Business Intelligence

Ben Kimmel

Assistant Director, Fiscal Services

cleveland clinic
Cleveland Clinic
  • 3.6 million patient visits
  • 160,000 admissions
  • 42,000 employees
  • 2,700 physicians and scientists
current ebi infrastructure
Current EBI Infrastructure
  • Phase I implemented 2006
  • SQL Server platform
  • Business Objects presentation layer
  • 18 TB data
  • 40 FTEs
  • 93% data load frequency < weekly
  • 6,000 total users, ~1k/week
agenda
Agenda
  • Cleveland Clinic performance management evolution
  • Example dashboards
  • EBI infrastructure
  • Governance
slide5

Web Based Wheels

Dashboard

Tools and

Data Warehouse

Monthly Wheels

Institute

Scorecards

Executive Dashboard

Monthly Operational Indicators

Continuous Improvement Summits

Short

Cycle

Daily Dashboard

PM

DSS

Dept DBs

EBI

The CC EBI Evolution

1993

1995

1998

2002

2004

2005

2006

2008

2010-12

ebi performance management
EBI & performance management

Performance Management

  • Using data to manage business
  • Feedback loops & accountability
  • Predictive modeling
  • Enterprise level

Business Intelligence

  • Using DW data in fact based analytics
  • Augment data with KPIs, business imperatives & scorecarding
  • Key metrics & trending analysis
  • Division / function specific

Data Warehouse

  • Automated processes that feed a central data warehouse with data from disparate source / transaction systems
  • Single source of information
  • Initiative driven

Functional

Systems

  • Stand alone, functionally specific applications
  • DSS applications
  • Financial consolidation tools
dashboard architecture
Dashboard Architecture

Finance

& Statistics

Quality

Patient Access

Operational Dashboards

Operational Dashboards

  • Summary
  • P&L by Entity
  • Financial Metrics
  • Key Statistics
  • Reports
  • Service Line
  • Summary
  • Core Measures
  • Patient Experience
  • Hand Hygiene
  • Outpatient Access
  • Days Wait
  • Appt when wanted
  • Physicians
  • Institute Chair
  • Department
  • Nursing
  • Clinical Operations
  • Patient Support Services
  • Finance
  • Statistics
  • Patient Access
  • Quality
  • Patient Experience
  • High Level
  • Indicator Driven
  • Visual & Intuitive
  • Focused
  • Flexible

Executive Dashboard

slide9

Executive Quarterly Review

  • Align strategic objectives
  • Common scorecard platform
  • Transparency
  • Best practice sharing
  • Continuous Improvement
slide14

Clinic Access

  • Template Management
  • Appointment Days Wait
  • Appointment When Wanted
  • Same Day Access
slide22

Short Cycle

  • Near “real-time”
  • Quicker delivery to clinical managers
  • Summarized nursing unit performance
hf education
HF Education

2009

2010

2011

scip hair removal
SCIP: Hair Removal

2009

2010

2011

scip normothermia
SCIP: Normothermia

2009

2010

2011

icu operations
ICU Operations
  • ICU Ops Team created in 2006
  • Expanded in 2009
    • Oversight committee formed
    • 30+ ICUs
    • 350 beds
    • 30,000 admissions/year
icu clabsi rate
ICU CLABSI Rate

Rate

50% reduction

slide41

Blood Utilization

  • Scarce resource
  • High cost
  • Clinical risk
slide44

Physician

Level Detail

information delivery environment before ebi
Information Delivery Environment Before EBI

Previous environment characterized by:

Heavy reliance on packaged technology solutions with limited integration

Data stores developed and owned by independent departments – duplicative and expensive

Inefficient and untimely delivery of information

Disjointed approach to information access & display (reports, online tools, excel, crystal, etc.)

Multiple representations of data with inconsistent definitions – no single source of truth

DSS

Billing

ODS

ORIS

Crystal

Excel

GL

SC

CIS

Data “Stores” / Applications

Information Access / Display

Data

Sources

current information delivery environment
Current Information Delivery Environment

Current environment characterized by:

Coordinated approach regarding:

Data ETL and storage

Data visualization and reporting

Data stores developed and owned by independent departments

Efficient and timely delivery of information

Coordinated representations of data with consistent definitions – moving towards a single source of truth

Billing

ORIS

GL

SC

DSS

CIS

Medops

Others

Others

Others

Consistent Information Access / Display

Distributed Enterprise Data Warehouse

Data

Sources

key areas of responsibility
Key Areas of Responsibility

Source ETL:

IT

Warehouse: Finance

Dashboard: Med Ops

Infrastructure: IT

  • Distributed Functionality for Flexibility
  • Marts
  • Dashboards
  • Tools

Infrastructure Configuration & Access

Infrastructure Configuration & Access

slide52

Our EBI Strategy Guiding Principles

Consistent Process

Continuous Innovation

Proactive & Adaptable

Effective Governance

Utilize proven, best practice methodologies and metrics to facilitate predictable and repeatable outcomes

Continually strive to increase innovation and drive toward creativity and thought leadership

Focus on planning and resource allocation to permit flawless execution even amid unforeseen events

Align enterprise resources to strategic goals and priorities and drive accountability to achieve highest-value business impact

the role of executive sponsor
The Role of Executive Sponsor
  • Drive Strategic Priorities
  • Embrace Key Performance Indicators
  • Issue Resolution
  • Secure Funding & Resources
  • Espouse Operational Changes Based on Fact-based Findings
  • Executive ‘Champion’ of EBI
iterative execution

Plan

Planning Change Process

Analyze

Requirements Change Process

Design

Design Change Process

Develop

Test Case Development

Code Control

Launch Preparation

System Test

Deploy

Support Training & Preparation

Iterative Execution

1

2

3

4

5

Milestone 1– Project Initiation

Milestone 2– Vision & Scope, Data Model & Report Layout, Preliminary Schedule

Milestone 3– Business Rules, Final Design, Test Plans, Final Schedule

Milestone 4– Code Complete (Database & Reports), System Test Initiation

Milestone 5– System Test, Documentation, & Training Complete, Production Deployed

driving toward high performance key take aways
Driving Toward High PerformanceKey Take-aways
  • Transition from data-rich to information-rich
  • Common source of truth
    • Business Intelligence
  • Alignment with organizational goals
    • Safety, quality, operational excellence
  • Transition from transparency to operational excellence
  • Culture of continuous improvement