1 Daijind

Business Intelligence Case Study Hospital Bi Helps Healthcare

Health Care DataWorks partners with Logicalis to implement its advanced healthcare analytics and business intelligence solution for healthcare systems.

Health Care DataWorks (HCD) (www.hcdataworks.com) is a leading provider of business intelligence solutions for healthcare organizations. Its pioneering KnowledgeEdge product suite is an enterprise data warehouse that includes a robust data model along with pre-built analytic dashboards, applications and reports, and provides health systems the analytics they need to provide insights into their operations and help them become more effective and efficient.

KnowledgeEdge Enterprise includes a unified data model built exclusively for healthcare and bundled software, hardware and support that can be implemented at a fraction of the cost and time it would take health systems to build their own. The benefit to hospitals and health systems of all sizes is a broad and seamless view of financial, administrative, clinical and research data for easy analysis and timely decision making.

The KnowlegeEdge solution is delivered as a standalone offering installed in a customer’s data center and remotely monitored and managed by Logicalis or as software as a service (SaaS) hosted on the Logicalis Enterprise Cloud (LEC) platform.

Innovative Partnership
The rapid evolution and market acceptance of KnowledgeEdge are the result of an innovative partnership between HCD and Logicalis that leverages and extends the capabilities of both firms.

The data model inside KnowledgeEdge was originally developed at the Ohio State University Wexner Medical Center. The results of being able to apply advanced analytics to improve operations at one of the largest and most diverse academic medical centers in the country were dramatic. Clinical quality and financial benefits included:

Clearly there was a market for advanced analytics beyond the Wexner Medical Center so the group of data warehouse experts who developed the data model formed Health Care DataWorks to take it to market. They knew at the outset that they couldn’t do it on their own.

"At the university, we had a whole IT shop to lean on," recalls HCD Chief Technology Officer Mike Ostrander. "When we started HCD, we wanted to focus on what we did best – healthcare analytics. We wanted to find a partner for the technical and hardware aspects of the solution."

The founders of HCD applied the same diligence to finding a partner that they employed in developing KnowledgeEdge.

"We identified six criteria a partner would need to meet," Ostrander says. "Basically, we needed one company that could take responsibility for everything from the operating system down— including servers, storage and networking—and implement, as well as monitor and manage, KnowledgeEdge as a standalone solution in our customers’ data centers. Our partner would need to have a national presence and be able to deploy and support our technology locally. We also wanted them to have a consulting arm with specialized people we could tap for extra help to support our sales team and ensure the successful implementation of our product at a customer organization."

"The Sweet Spot"

Ostrander says HCD evaluated several integrators, before concluding that "Logicalis hit the sweet spot of being able to do everything we wanted them to do."

It also helped that Logicalis has a strong presence in healthcare with expertise across the entire IT infrastructure. They were recommended by IBM and Cisco and have demonstrated high-level ITIL best practices during more than a decade of experience providing managed services. They know how to work within HIPAA guidelines and understand healthcare’s need for uptime and security. To top it off, they are a leader in private and public cloud computing and knows how to make a good first impression.

The first big installation they completed together demonstrated that Logicalis was the right choice. "It turned out that technicians from Logicalis were on-site a week before we got there. That kind of scared me," Ostrander recalls. "They were the first contact with my company. In the end, it worked out very well. Logicalis was very professional. They had the required expertise, and they established a good rapport with the customer. By the time I got there, everything was going well."

Taking Care of the Customer
A key message in HCD’s marketing is that they take full responsibility for implementing and integrating the KnowledgeEdge enterprise data warehouse in a customer’s IT environment.

"We assure our customers they won’t have to deal with finger-pointing between hardware and software vendors. We are their one throat to choke if anything goes wrong. And I get the same thing from Logicalis," Ostrander says. "I only have to call one number. I know the escalation path through Logicalis, but I’ve never had to use it. Logicalis is providing services they are very comfortable with, and there are never any issues. The fact that I can lean on a large multi-national organization that does this stuff every day and has a good reputation strengthens the HCD value with our customers."

"I’ve got installations in Ohio, Minnesota, Texas, Florida, California and New Mexico and soon in other states," Ostrander adds. "If something goes wrong at one of those locations, somebody has to go out and touch it. Logicalis does this for us. They let us focus on what we’re good at, and they take care of all the rest."

More than just a provider of technology, Logicalis has become a true business partner with HCD. Logicalis, for example, is beginning to leverage its relationship with HCD to expand its own healthcare practice by introducing prospective hospital clients to HCD’s healthcare business intelligence and analytics solutions as a partnership offering that showcases and supports its own portfolio of capabilities. HCD, at the same time, is leveraging its relationship with Logicalis to offer healthcare customers a SaaS version of KnowledgeEdge hosted in the Logicalis Enterprise Cloud.

Cloud Offering
The market is changing quickly, and the adoption of hosted solutions in healthcare is accelerating. In response to this, an important strategy for us is to grow our hosted KnowledgeEdge solution," says HCD Product Manager Pat Bickley. She notes, "Hospitals and health systems of all sizes are trying to find a way to reduce capital budget expenses and the overhead of managing systems in-house. Our hosted offering removes a huge barrier for our potential customers. We expect large growth in this market over the coming couple of years so it’s important to have a partner like Logicalis that can scale with us."

"HCD got to know Logicalis by implementing our solution for customers in their data centers," Bickley says. "We didn’t just jump into the cloud with Logicalis. As a result of that experience, we feel very confident that Logicalis is going to be able to go where we want to go. The cloud is the logical next step for us, and they’re the experts in cloud computing."

"The relationship between Logicalis and HCD is a dynamic, scalable partnership," says Logicalis Healthcare Business Development Manager Karen Burton. "Working together has enriched our individual offerings and opened doors for new opportunities for both companies. We’ve learned from each other, and that has empowered our respective market objectives. It’s a win-win."

What is Business Intelligence

To turn any business establishment profitable, the managers & the work force is highly reliant on decisions & those decisions are dependent on the kind of information available. This is where Business Intelligence comes into picture

Business Intelligence (BI) refers to technologies, applications and practices for the collection, integration, analysis, and presentation of business information and also sometimes to the information itself. The purpose of BI is to support better business decision-making.

BI systems provide historical, current, and predictive views of business operations, most often using data that has been gathered into a data warehouse or a data mart and occasionally working from operational data. Software elements that make up the BI system support reporting, interactive “slice-and-dice” pivot-table analyses, visualization, and statistical data mining.

Importance of BI in healthcare Industry :-

Today, healthcare establishments are also generating a lot of data (Data in healthcare – e.g., encounters, labs, pharmacy, membership, finance, claims, billing, CRM, EMR, HMS, etc). Though, they have lot of data, but information is very less.

There are three broad categories of data that any healthcare organization is interested in : financial, operational & clinical. Healthcare organizations must apply business intelligence to organize clinical, business and operational data for decision-making purposes. This data is used to support programs like disease management, outcomes management, clinical performance and process improvement, cost and waste reduction, quality accreditation and predictive analytics.

Forward-thinking healthcare organizations realize that data—and, thus, business intelligence (BI)—is at the center of informed and precise decision-making that will improve patient and service outcomes in addition to ensuring their organizations’ future, thus, many leading hospitals have already adopted BI

  1. Harvard Medical School, St. Jude Children’s Research, CIBA, & Mutual of Omaha
  2. Blue Cross Blue Shield of Florida
  3. Columbus Children’s Hospital
  4. St. Joseph Medical Center & St. Joseph’s Hospital
  5. International Federation of Red Cross & Crescent
  6. St. Luke’s Medical Clinic, Houston Infectious
  7. Diseases Associated
  8. Denver Health and Hospital Authority (BI is especially crucial to “avoid both waste and having patients fall between the cracks)
  9. Lincolnshire Partnership Foundation Trust (plunged into BI because of a specific need to better analyze the efficiency of its service lines)
  10. Hartford Hospital
  11. Nemours
  12. Hospital for Sick Children in Toronto
  13. University Health Network

Benefits of using Business Intelligence in a healthcare establishment :-

a. Consolidation & protection of data since there would be a single point access of data Better protection of patient data is also possible by providing access to data only to those with appropriate access levels.

b. Improved Efficiency :- Since any type of information & report, whichever is required at any time. This will enable better decision making and improved efficiency

c. Increased revenue & reduce costs :- BI makes it possible possible to eliminate waste and mine data stores to examine and recoup denied claims in healthcare organizations. Costs of: healthcare professionals, lab equipment and consumables, pharmaceuticals/ medical material, treatment per diagnosis and cost per type of medical intervention (e.g. specific medical operation) can be reduced as well

d. Improved Margins :- BI (BI/balanced scorecard program) helps to improve gross margins of healthcare organizations.

e. Improved patients satisfaction by using BI and analytic tools.

f. Improved Patient Treatment & Care :- Through the use of BI, healthcare professionals have easy access to patient’s data and they can create a variety of classifications/reports based on demographic data, sex, age, and so on. Thanks to the evidence based medicine and capture of medical history of the patient doctors can accurate diagnosis and apply efficient treatment with reduction of risks during treatment (e.g. related to on time admittance, the use of medicine, biomedical equipment, blood transfusions). Timely and effective clinical decisions are better facilitated by increasing the potential of BI.

 g. Reduction of medical errors and improved patients safety. It could be reached by supporting medical research and data treatment. BI systems can support a larger Healthcare system, by the exchange of medical information on a patient. Improved decision-making in the area of comprehensive health care policy by the authorities of the organization of the health sector. It can be reached with monitoring the performance of doctors, departments and medical material requirements. Multiple groups or individuals can be put together by emphasizing the analysis and accurate data, which brings them closer to the point of service in order to enhance decision making & make data actionable.

h. Better data management helps in better patient treatment in terms of timely admittance, diagnosis and risk in casualty.

i. Some other benefits includes supply cost optimization, fraud detection

Main KPIs & Performance Indicators

The main KPIs which can be used to be displayed via reports & dashboards are mentioned below.

Clinical Data KPI

Healthcare establishment can improve clinical quality and resource utilization by effectively monitoring and measuring clinical performance and outcomes data. By delivering analysis from multiple sources at once, BI enables organizations to track large amounts of information stemming from clinical activities and identify the most efficient practices. BI helps providers identify trends and anomalies, and analyze risk in clinical care. With a lot of stakeholders involved like doctors, diagnostic centers, pharmacy etc all of them cant function as independent silos. With BI, all constituents can work from the same data over a secure extranet with information personalized based on security credentials. BI’s unique centralized administration and role-based security assures that healthcare providers have security measures at every layer of the architecture. With secure, essential clinical information, individual practitioners can diagnose and prescribe more quickly and provide top quality care with greater peace of mind.

The different types of reports permissible are

Avg cost per caseClinical outcomes
Cost & clinical dataCost affectiveness
Disease managementIn-patient admission rates
Investment in research programsNo of procedures vs benchmarks
Patient safety & staffingPerformance reporting
Population riskResource cosumption vs benchmark
Response timeTreatment

Patient Care KPI

Healthcare providers want to offer the highest-quality patient care in the most efficient way possible with improved patient access to care. BI enables the right people to access the right information at the right time, delivering a single platform to healthcare providers for sharing information with patients for better decision-making and connecting patients across hospital, nursing home, physician office, and community social support settings. By providing easy, secure access to crucial information, BI supports safe care delivery, assists clinicians in evidence-based clinical decision-making, and facilitates seamless care coordination across clinical settings. Providers use BI to monitor patient diagnoses and use of healthcare services in order to improve patient care, reduce wait times, and administer more effective treatments.

Clinical OutcomesDay to next appointment
Dispatch request & monitoringPatient functionality
Patients wait time in admissionPatients wait time in pharmacy
Service complaintsService Level Agreement reporting
Services performedTimeliness of service

Financial KPI

Healthcare organizations need visibility into the full scope of their financial operations. BI provides full transparency, analysis, and delivery of financial and operational data. BI enables healthcare providers to drill from reports into detailed analyses of costs and revenues, view data underlying cash flow statements, and compare planned versus actual income and margin. BI’s analytical capabilities allow providers to analyze current care practice patterns to identify unnecessary or under-utilized services, execute cash flow analysis, forecast collections, and monitor underwriting requirements. In addition, BI enables healthcare organizations to meet statutory reporting requirements and ensure accountability from financial analysts to business unit management, executives, and directors.

Accounts payableAccounts receivable
Accrued expensesAssets in current vs prior period
Bad debt as % of net revenueBudget variance analysis
Capital expenditure growth rateCash & equivalents
Cash collected vs targetCash on hand
Current asset turnoverCurrent Ratio
Customer Plan migrationNet assets
Net incomeOperating margin
% of capital expenses% of cash flow to total debt
% of cash flow to total liabilities% of charitable revenue
% of debt to capitalization% of out patient revenue

Quality & Performance KPI

Providing safe, quality care is a top priority for healthcare organizations. BI allows providers to improve performance by leveraging evidence-based performance data, tracking variations in quality, providing patient dashboards, setting alerts, and checking drug interactions. Providers can use BI to monitor the quality of their care according to the Health Plan Employer Data and Information Set (HEDIS) standards established by the National Committee for Quality Assurance to allow for performance comparisons across quality, patient access, patient satisfaction, utilization, and financials. Additionally, Dashboard can be used for improving quality at healthcare organizations, which empowers managers to make more timely decisions and participate in on-the-spot quality improvements. BI allows providers to identify the presence or absence of interventions recommended by evidence based medicine.

DoseFrequency of attacks
Handling costsAvg length of stay for patients
Length of visit with nurse practitionerLength of visit with physician
Medication errorMonthly drug cost
% of follow upsNo of emergency room visits
No of hospitalizationsNo of patients admitted
No of patients referred outsideNo of patients with infections
No of patients with vaccinationsNo of physicians visit
Packaging costPatients satisfaction

Marketing KPIs:-

With a No. of hospitals, clinics & nursing centers, healthcare providers must place a greater focus on their marketing efforts to stay competitive. BI helps analyze the success of marketing efforts designed to demonstrate the clinical effectiveness of their products and services, create an increased feeling of overall wellness, and reduce workplace absenteeism. BI also allow providers to determine the most cost-effective marketing techniques by tracking campaign costs against budget, calculating the return on investment for campaigns, and comparing performance against goals. In addition, BI allows healthcare providers to use dashboards to show which products and services are profitable in specific patient segments and measure how their marketing efforts and corporate communications alter brand perception and affect brand performance.

AcquisitionAdvertising budget per procedure
Avg visit length to websiteBrand Management
Churn AnalysisCustomer Profitability
Customer SegmentationDemographic Analysis
Loyalty ProgramMarket Share by Business
Marketing Focus group scoresNo of visit to website
Patient satisfactionPhysician practices
Preference & permission bundlingRetention

Above mentioned are some of the commonly used KPIs. Keeping a tab on them via selecting a proper Business Intelligence tool & correct implementation, can surely help them to rise above the competition & deliver a world class service to the patients.

For any query regarding Business Intelligence implementation, plz mail [email protected]



This entry was posted in Business Intelligence and tagged balance scorecard, Business Intelligence, chart, dashboard, ETL, Healthcare, ireport, jasper, map, OLAP, petaho, talend by Nikhilesh. Bookmark the permalink.

Leave a Comment


Your email address will not be published. Required fields are marked *