BUSINESS INTELLIGENCE
Michael Bohl, Radiology Group, PC, SC Brian Hart, Merge Healthcare
Tuesday, August 28, 2012
session objectives & discussion points
Understand the basics of business
intelligence and why it is essential to you
Definition
Rules for Success
Discuss some best practice examples of how RBMA and Radiology Group have used data to drive better decisions
Understand how Merge Dashboards™
technology has progressed to better support business intelligence in outpatient radiology
“Competing on Analytics” Harvard Business Review; 2006; Davenport, Tom
“Our organization doesn’t want to build
its entire strategy around analytics, but
we would like to become more analytical
business intelligence definition
Business Intelligence (BI) is defined as the ability of an organization to:
1. Take all its capabilities and
2. Convert them into knowledge, with the goal of
3. Getting the right information to the right people at the right time.
business intelligence basics
In its simplest sense, BI can be broken down into three stages:
Data – raw data is gathered and processed into
Information – which must be filtered and arranged into meaningful
patterns resulting in
Knowledge – that helps form the business intelligence for the group
Data
Information Knowledge
why BI? why now?
Industry is
undergoing
intense
evolutionary
change
• DRA • MPPR • Utilization Rate Changes • Bundling • Code consolidations • Practice Expense Changes• RUC being short-circuited
• SGR fix & potential for “buckets”
why BI? why now?
Business
intelligence
tool
Data into
insights
Insights
into
decisions
Decisions
into
actions
9rules for success
Identify a champion
Get a commitment from key stakeholders Be selective in the BI program you choose
Use charts and graphs to monitor key operational benchmarks whenever possible – a Dashboard Deliver the information to the right people
Start small and build over time
best practices
Radiology Group initiatives
RBMA data gathering
Radiology Group background
15 physician radiology group
Three hospitals 17 sites of service Billing Company Three clients 24 radiologists 9 hospitals 28 sites 450,000 procedures/year
Joint venture with hospital
Two imaging centers
Radiology Group BI uses
Volume trend analysis
Site, modality, time of day Denial Management
Work Queue Management Receipts per unit of service
By modality, site, dept . . .
Accounts-receivable management Billing cost/procedure
Number of new & total number of referrers Referral trends by physician by modality Room Utilization
Imaging Center Cost Analysis
Physician productivity by days worked
Work in progress
Physician Compensation per Unit of Service and RVU
Radiology Group ad hoc uses
Support practice on new initiatives
Estimate coverage needs
Project reimbursements from new potential business
Determine impact of new PC business on billing office
Joint Venture (Powerful Information)
I am providing much better trend and referral information and far quicker than hospital
Referring physician information Volume by site by modality by day
Show how and where volumes are changing
Parsed by hospital-employed vs. non-hospital physicians; parsed by payor; site
Support marketing initiatives as well as to support operational changes we believe are necessary!
RBMA ad hoc uses
Supporting Radiology Advocacy in D.C .
Can either directly, or with a little manipulation, answer advocacy-related questions
Able to estimate MPPR impact by practice by modality
RBMA and ACR shared the results with CMS
Supports RBMA Data Benchmarking Surveys
“Competing on Analytics” Harvard Business Review; 2006; Davenport, Tom
“Our organization doesn’t want to build
its entire strategy around analytics, but
we would like to become more analytical
Michael Bohl, Radiology Group, PC, SC; 2012
“No matter how much research is done or
how much internal and external information
is gleaned from using a BI tool, it is the
analysis, discussion, understanding, and
calls to action that result from its use that
creates the value of benchmarking and the
Brian Hart, VP of Development
Radiology Workflow and Perioperative Solutions
MAXIMIZING BI WITHIN MERGE
RADIOLOGY SOLUTIONS
our radiology vision
1. Integration
2. Market-based innovation 3. Business Practicality
it continues to come together
Fusion RIS
Practice Analysis
Merge RIS
Report Generator
Dashboards 3.1
Merge Financials
Sentinel
Merge RIS 7.0, 7.1,
7.2
Merge Dashboards
3.3, 3.3.1
MRP 2.0, 2.1
MDM 1.1, 1.1.1
Merge Financials
6.1.1-4
Merge PACS 6.
22Merge Dashboards module roadmaps
Q3 2013 Q1 2013 Q4 2012 Q3 2012 Q2 2013 New Features › DB2 to SQL database conversion › Cognos 10.1 upgrade Dashboards 4.0 New Features › Installer improvements › Stability release Dashboards 3.3.1 Dashboards 4.1 New Features › Potential additional integrations › Customer-requested enhancementsCautionary Notice Regarding Forward-Looking Statements This slide contains forward-looking statements, which could involve a number of risks and uncertainties. Actual results could differ
materially from those expressed in, or implied by, such forward-looking statements. The Company undertakes no obligation to update such factors or to publicly announce the results of any of the forward-looking statements. New Features › MU Stage 2 improvements Dashboards 3.4 New Features
› Sentinel and RIS-specific fixes
› Last version with DB2 database
Dashboards 3.3.3
23
Merge Dashboards 4.0 planned scope
Cognos 10.1 upgrade
Cognos Auditing feature incorporation Replacement of DB2 database with SQL MU report improvements
Additions to RIS datatree
Enhancements to Age Trial Balance New balancing tool for FIN
Improvements to various canned reports
interactive, performant, stand alone reporting applications
IBM Cognos Active Reports
IBM Cognos Active Reports are interactive, intuitive, stand-alone reports with the ability to be highly-formatted. New Capabilities within Report Studio allow developers to create these sophisticated report applications.
Key Capabilities
Richer set of controls for Professional Report Authors to build interactive dashboards for the business
Saved MHT applications allow for fast consumption and offline consumption
Schedule and burst applications to broad and diverse users Self-contained output…all data and visuals in a single .MHT file
Benefits
Improved time-to-decision through a more interactive and richer user experience Improved user satisfaction through performance improvements gained through a saved MHT output
Improved productivity by being able to work while not being physically “connected” to reporting application
new unified workspace
What is Business Insight?
New Unified Workspace for users to easily assemble Workspaces, view/interact/collaborate, analyze and
share the results to follow a train of thought and generate a unique perspective around information
Key Capabilities
Assemble and Format – Drag-and-drop trusted content, filters, and other content. Modify and arrange layout, add colors and text, add comments, and personalize widgets
Interact and Analyze – User can change display, add calculations, filter/prompt, drill up/down, and sort data and seamlessly move to analysis from any area
Share and Collaborate – Dashboards are consumable by others, dashboard objects can be shared and distributed, and integrated with Lotus Connections
Benefits
Enhances self-service – Easy dashboard creation and assembly empower business users Deeper insight into performance – Powerful analysis capabilities for continual and in-place data exploration
Reduces IT bottlenecks – Facilitate self-service while leverage information from trusted and properly IT governed content
single intuitive interface for ad-hoc query and analysis
What is Business Insight Advanced?
New ad-hoc query and analysis interface for business users
Provides a consistent, simplified, and rich interface for self-service reporting and analysis
Key Capabilities
Single intuitive interface for ad-hoc query and analysis Flexibility for presentation options
Single report spec for integration with Report Studio Professional Author
Benefits
Improve business agility through timely access and richer insights into information
Greater user satisfaction through improved self-service
Lower IT costs by offloading information requests while maintaining proper IT governance
IBM Cognos Mobile
What is Cognos Mobile?
Cognos Mobile allows business users to consume and interact with trusted and secure Cognos 10 content on mobile devices
Key Capabilities
Modern and interactive user experience on BlackBerry Android, iPhone/iPad devices
Author Once, Consume Anywhere Support for Prompted Reports Support for all Drill types
Location aware reporting
Benefits
Broad mobile platform support: BlackBerry, iPhone / iPad, Win Mobile, Symbian, Android
With the ability to “author once, consume anywhere” developers do not need to re-work or re-format reports for users to consume them
The C10 Web Application (for the iPhone) makes it easy for IT to deploy and maintain Cognos Mobile
session objectives – met?
Understand the basics of business
intelligence and why it is essential to you Learn the data elements you “can’t live without”
Discuss some best practice examples of how RBMA and Radiology Group have used data to drive better decisions
Understand how Merge technology has progressed to better support business intelligence in outpatient radiology.
resources
RBMA Accounts Receivable and Imaging Center Surveys
Managing By Benchmarks: Making the Case for Accountability; Radiology Business Journal; Davis & Palmer; May 01, 2009
http://www.imagingbiz.com/articles/view/managin
g-by-benchmarks-making-the-case-for-accountability/
Michael Bohl, Radiology Group, PC, SC Brian Hart, Merge Healthcare