Tuesday, December 21, 2010

Healthcare and Business Intelligence

Nice Links

1. KPI for Healthcare

2. Business Intelligence for Healthcare

3. the Time is still(now)

http://www.divurgent.com/images/KonschakBI.pdf

http://hosteddocs.ittoolbox.com/KP90806.pdf

Healthcare KPIs

http://www.onwardsystems.com/files/Healthcare%20Business%20Intelligence%20-%20Onward%20Systems%20Inc.pdf

Objectives
1.Effective Treatment of Patients
2. Reimbursement for Treatments
3. Reduction of Administrative Cost
4. Effective record and Track Medical’s History
5. Efficient Management of Health Care delivery Schedules for practitioner

Sample KPIs for Health care Industry
1. Average Length of Stay
2. Maintained Bed Occupancy
3. FTE’s per adjusted occupied bed
4. Case-mix Index
5. Monthly Surgical Cases(Inpatient and Outpatient)
6. Inpatient and Outpatient revenues
7. Cost per adjusted Patient day(Inpatient and Outpatient)
8. Percentage of Revenue from Charitable Sources
9. Revenue and Expense per Physician
10. Margin per Department
11. Admitting-process performance

There are also performance metrics that can be used as benchmarks for tracking performance. These can be broken down into categories, such as :-
Emergency Room
1. Door to Provider Time
2. Admission to Provider Time
3. Length of Stay
4. Wait Time for Ambulances
5. Throughput(Urgent/Non-Urgent)
6. Triage to Initial Assessment
7. Bed Turnover
8. Staff Applied to Each Type of Patient
9. Type of Cases

Operating Room
1.Utilization Rates
2.Customer Satisfaction
3.Wait Time
4.Quality of Physicians
5.Cleanliness
6.Food Taste

Learning and Growth
1.Licenses Udates
2.Continuing Physicians Credentials

Interaction with Patients

Revenue indicators
1.Outpatient Revenues to Total Revenues
2.Patient Deductions
3.Medicare Inpatient Payer Mix
4.Medicare Outpatient Payer Mix
5.Medicare Outpatient Cost to Charge
6.Medicare Revenue per Day

Cost Indicators
1. Salaries to Total Expenses
2. Average Age of Plan
3. FTEs per Adjusted Occupied Bed

Utilization Indicators
1. Average Daily Census Swing – SNF Beds(Skilled Nursing Facility)
2. Average Daily Census Acute Beds

Sunday, December 19, 2010

BI in Healthcare

http://download.microsoft.com/download/8/A/8/8A89DAA9-BA03-473B-BF57-AED28AFCCF98/Business_Intelligence_in_Health_Whitepaper.pdf
• Without Business Intelligence, Health organization will continue to be data rich but information poor.
• To take advantage of BI, organization must take an enterprisewide, strategic approach vs tackling small tactical projects.
• We need to integrate Financial, operational and clinical data for effective BI results
• Main drivers are cost saving and improving patient outcomes
• Successful Business Intelligence Implementation requires involvement of Top Executives , Physicians and Nurses

Focus Area
1. Clinical Performance:-
2. Financial Performance:- (Including Service Line Analysis)
3. Overall Operation Performance (including asset management and customer management)

Useful Measures:
1. Denied Claims –Number, Amount


2. Service Line Focus
Even though healthcare organizations typically manage resources, staff and billing through service line – such as emergency medicine, intensive care and cardiac surgery.
Most providers have been unable to get a clear view whether service lines are efficient or profitable.
Service Line Managers can see issue quickly and act quickly
Now, managers are notified if a patient who should be seen in two weeks hasn’t been scheduled after week one, allowing them to take action.

3. Sealing the cracks
A strategic approach to BI identifies and plugs gaps that appear within chain of activities and lead to inefficient or substandard care.

Executive Team can define goals for performance improvement.
Dashboard are performance management tool that measures small operation activities that are aligned to enterprise vision and strategy.
BI provides the real-time data that enables managers to monitor the performance and make rapid course adjustments.