Qlik Case Studies DAKOTACARE secures healthy business analysis with QlikView

Edit This Case Study Record

	DAKOTACARE secures healthy business analysis with QlikView Qlik

DAKOTACARE secures healthy business analysis with QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	Healthcare & Hospitals
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Real-Time Location System (RTLS)
Services	Data Science Services System Integration
Challenge	DAKOTACARE, a healthcare leader in South Dakota, manages hundreds of millions of records on subscribers and providers, from coverage to codes to claims. The company was data-rich but information-poor, with staff having to rely on IT for custom reports that would address internal reporting as well as questions from healthcare providers and clients. Their requests were placed in a queue, then prioritized, with the resulting reports coming days or even sometimes weeks later. Much of their information needs were time-sensitive, and by the time people got their questions answered, they no longer needed the information. Representatives would not even ask for data requests knowing that their information needs would not be met prior to a decision deadline. Or, intrepid representatives would try to extrapolate answers on their own, often with varying results. Read More
About Customer	DAKOTACARE is the health care plan of the South Dakota Medical Association, covering every hospital and over 98% of the state’s physicians and pharmacies. A healthcare leader in South Dakota for more than 20 years, DAKOTACARE manages hundreds of millions of records on subscribers and providers, from coverage to codes to claims. The company is committed to providing good customer service and effectively managing the business, which involves processing enormous amounts of data, mostly driven by codes for test and procedure descriptions, diagnoses, provider ID’s and more. The company's staff had to rely on IT for custom reports that would address internal reporting as well as questions from healthcare providers and clients. Read More
Solution	DAKOTACARE deployed QlikView to 50 users in less than two weeks. The new tool compressed a 200 GB database with more than 140 million records into a 500 MB database loaded into the RAM of a 64-bit server. With QlikView Publisher and Server (64-bit), DAKOTACARE now has instant access to rich, detailed information while management is newly empowered with tools to dramatically improve business analyses. QlikView’s patented QVD technology serves as a “meta” reporting application with a virtual data repository for all of the QlikView applications a company builds. DAKOTACARE is using QlikView to pull data from several source systems including SQL Server, Unidata, Pervasive, Oracle, Access, Paradox, and others. QlikView then consolidates the data into QVD files. These base QVD files replicate all the source data into one location. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Healthcare & Hospitals

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Real-Time Location System (RTLS)

Services

Data Science Services

System Integration

Challenge

DAKOTACARE, a healthcare leader in South Dakota, manages hundreds of millions of records on subscribers and providers, from coverage to codes to claims. The company was data-rich but information-poor, with staff having to rely on IT for custom reports that would address internal reporting as well as questions from healthcare providers and clients. Their requests were placed in a queue, then prioritized, with the resulting reports coming days or even sometimes weeks later. Much of their information needs were time-sensitive, and by the time people got their questions answered, they no longer needed the information. Representatives would not even ask for data requests knowing that their information needs would not be met prior to a decision deadline. Or, intrepid representatives would try to extrapolate answers on their own, often with varying results.

About Customer

DAKOTACARE is the health care plan of the South Dakota Medical Association, covering every hospital and over 98% of the state’s physicians and pharmacies. A healthcare leader in South Dakota for more than 20 years, DAKOTACARE manages hundreds of millions of records on subscribers and providers, from coverage to codes to claims. The company is committed to providing good customer service and effectively managing the business, which involves processing enormous amounts of data, mostly driven by codes for test and procedure descriptions, diagnoses, provider ID’s and more. The company's staff had to rely on IT for custom reports that would address internal reporting as well as questions from healthcare providers and clients.

Solution

DAKOTACARE deployed QlikView to 50 users in less than two weeks. The new tool compressed a 200 GB database with more than 140 million records into a 500 MB database loaded into the RAM of a 64-bit server. With QlikView Publisher and Server (64-bit), DAKOTACARE now has instant access to rich, detailed information while management is newly empowered with tools to dramatically improve business analyses. QlikView’s patented QVD technology serves as a “meta” reporting application with a virtual data repository for all of the QlikView applications a company builds. DAKOTACARE is using QlikView to pull data from several source systems including SQL Server, Unidata, Pervasive, Oracle, Access, Paradox, and others. QlikView then consolidates the data into QVD files. These base QVD files replicate all the source data into one location.

Impact #1	Increased data retrieval speed sorting more than one million records per second.
Impact #2	Improved profitability with a dramatic increase in data accuracy – critical to claims processing and provider reimbursements.
Impact #3	Increased customer satisfaction by enabling support reps to provide fast answers and detailed reports to customers.

Impact #1

Increased data retrieval speed sorting more than one million records per second.

Impact #2

Improved profitability with a dramatic increase in data accuracy – critical to claims processing and provider reimbursements.

Impact #3

Increased customer satisfaction by enabling support reps to provide fast answers and detailed reports to customers.

Benefit #1	Compressed a 200 GB database with more than 140 million records into a 500 MB database loaded into the RAM of a 64-bit server.
Benefit #2	Deployed QlikView to 50 users in less than two weeks.

Benefit #1

Compressed a 200 GB database with more than 140 million records into a 500 MB database loaded into the RAM of a 64-bit server.

Benefit #2

Deployed QlikView to 50 users in less than two weeks.

Download PDF Version

Overview

DAKOTACARE secures healthy business analysis with QlikView

Operational Impact

Quantitative Benefit