Qlik Case Studies DDG improves healthcare management thanks to QlikView

Edit This Case Study Record

	DDG improves healthcare management thanks to QlikView Qlik

DDG improves healthcare management thanks to QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Healthcare & Hospitals
Use Cases	Remote Asset Management
Services	Data Science Services
Challenge	The DDG, General Practitioner (GP) call services, had been using Adastra, a call management and patient registration system specifically designed for GP services. However, Adastra lacked sophisticated analysis functions, making it difficult to generate management information beyond the number of patient contacts and consultations. The organization needed to find out whether they were satisfying the performance criteria for the response to calls. They initially attempted to tackle the problem by developing an Access database themselves, but soon realized that QlikView was a far better option. Read More
About Customer	The DDG, General Practitioner (GP) call services, has been taking care of emergency health calls in Groningen and North Drenthe (the Netherlands) during the evenings, at nights, on weekends and on public holidays since 2002. The DDG consists of 278 GPs with a working area of some 650,000 patients. Every year the DDG receives around 150,000 calls, which result in a telephone consultation or an emergency home visit. The DDG has its own call center, seven GP posts, six fully equipped cars for home visits and an office for administrative support. Read More
Solution	QlikView was implemented in no time. First, all the information from Adastra was fed into the MS Access database. Then, the data from Access was fed into QlikView. This was done for two reasons. First, Adastra was based upon a database that was built by the supplier, so it was difficult to access. Secondly, they reckoned that patient confidentiality and operational continuity might be compromised if they were to link QlikView directly to Adastra. If anything went wrong with the analysis software, their patient database might be jeopardized. The DDG ran fairly smoothly as Addens explains, “The only challenge was when we had to create a table to see whether we were delivering on our 30-minute call-back obligation. But, QlikView helped us sort things out. That was the knock-out criterion.” When the organization had finished building and filling the system in the autumn of 2006, a QlikTech consultant installed everything – including the security – on the web server in just one day. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Healthcare & Hospitals

Use Cases

Remote Asset Management

Services

Data Science Services

Challenge

The DDG, General Practitioner (GP) call services, had been using Adastra, a call management and patient registration system specifically designed for GP services. However, Adastra lacked sophisticated analysis functions, making it difficult to generate management information beyond the number of patient contacts and consultations. The organization needed to find out whether they were satisfying the performance criteria for the response to calls. They initially attempted to tackle the problem by developing an Access database themselves, but soon realized that QlikView was a far better option.

About Customer

The DDG, General Practitioner (GP) call services, has been taking care of emergency health calls in Groningen and North Drenthe (the Netherlands) during the evenings, at nights, on weekends and on public holidays since 2002. The DDG consists of 278 GPs with a working area of some 650,000 patients. Every year the DDG receives around 150,000 calls, which result in a telephone consultation or an emergency home visit. The DDG has its own call center, seven GP posts, six fully equipped cars for home visits and an office for administrative support.

Solution

QlikView was implemented in no time. First, all the information from Adastra was fed into the MS Access database. Then, the data from Access was fed into QlikView. This was done for two reasons. First, Adastra was based upon a database that was built by the supplier, so it was difficult to access. Secondly, they reckoned that patient confidentiality and operational continuity might be compromised if they were to link QlikView directly to Adastra. If anything went wrong with the analysis software, their patient database might be jeopardized. The DDG ran fairly smoothly as Addens explains, “The only challenge was when we had to create a table to see whether we were delivering on our 30-minute call-back obligation. But, QlikView helped us sort things out. That was the knock-out criterion.” When the organization had finished building and filling the system in the autumn of 2006, a QlikTech consultant installed everything – including the security – on the web server in just one day.

Impact #1	Thanks to QlikView, it takes much less time and effort to retrieve figures, analyze them and generate the information needed to strategically manage operations and respond effectively to demand.
Impact #2	The QlikView ‘analysis base’ enables the organization to see at a glance whether the organization is meeting the performance requirements.
Impact #3	Management can retrieve the information themselves. Two to three mouse clicks, and hey presto! No specific knowledge required! QlikView is 100 percent user-friendly for both the IT Department and the management.

Impact #1

Thanks to QlikView, it takes much less time and effort to retrieve figures, analyze them and generate the information needed to strategically manage operations and respond effectively to demand.

Impact #2

The QlikView ‘analysis base’ enables the organization to see at a glance whether the organization is meeting the performance requirements.

Impact #3

Management can retrieve the information themselves. Two to three mouse clicks, and hey presto! No specific knowledge required! QlikView is 100 percent user-friendly for both the IT Department and the management.

Download PDF Version

Overview

DDG improves healthcare management thanks to QlikView

Operational Impact