for Healthcare

1
for Healthcare
BI
Inderjith Davalur
2
BI Definition
Actionable Data
Assumed poetic liberty
3

• Top 3 CIO Priorities
• Strengthening the Information Value Chain
• Building IT business skills
• Getting closer to business
• 1 Technology Priority...
• Business Intelligence

4

• BI selection criteria in Healthcare
• A quick start solution enabling hospitals to
  harness data from key operational systems
  revealing key performance indicators and
  supporting reports in the areas
• Unique in its ability to capture and combine data
  from several source systems and bring it together
  into a single solution allowing for true evidence
  based decision-making

5
Top 10 To Dos

• Team Up- Funds, Leadership?
• Data, Data Everywhere ETL, Analytic sandboxes?
• Business Intelligence Business Value -
  empowerment?
• Failing to Plan is Planning to Fail - Plan, plan
  and then plan some?
• Semper GumbyAlways Flexible - Dynamic
• ETL Extract Transform Load Get a professional
• Data Model Flexibility and Scalability
• Data Must Be Governed Corporate Asset
• End Users Are Not Naïve Content relevance
• Manage Your Program Operations Logistics?

6

• Solid Foundations
• Operations Process Excellence
• HMIS Application
• Technology Partner

7

• BI Needs
• Financial
• Financial Analysis costs, profits, investment,
  risks, cost of capital
• Claims Analysis reimbursement rates management

8

• BI Needs
• Resources Management
• Staffing recruit, retain, satisfaction trend
• Demand analysis balance volumes
• Actuarial Statistics on qualitative trends
• Educational Maximize community value

9

• BI Needs
• Operational Management
• Clinical quality reporting and analysis -
  standards
• Supply chain efficiency control costs, optimize
  processes

10

• KPI Examples
• Patient Administration
• Time to register
• Waiting time for encounter (with a care provider)
• Time to bed (from admit order)
• Time to discharge (from discharge order)
• Time to bill (from discharge order)
• Time to response (to a request call center,
  appointment request, calling a care provider)

11

• KPI Examples
• Billing Accounting
• Time to generate bill
• Time to settle bill
• By Patient
• By Responsible Party (Individual, e.g. patient
  representative)
• By Insurance
• Overdue (by amount, by time) wrt all or by payers
• Costs Incurred
• Accounts Receivable

12

• KPI Examples
• Clinical Areas
• Time to evaluate (from beginning of encounter)
• Time to diagnose
• Time to report (from order or sample collection)
• Average length of stay

13

• KPI Examples
• Clinical Administration (includes nursing)
• Time to needle (from entering the premises)
• Occupancy Rate
• Turnaround Time (for bed)
• Time to sample collection (after order) both
  technician draw nurse draw
• Time to medicine administration (after order)
• Time in recovery (post procedure)

14
Axiom Healthcare BI Customer experience
15
Sample screenshots
16
Thank you!