Qlik > Case Studies > DAKOTACARE secures healthy business analysis with QlikView

DAKOTACARE secures healthy business analysis with QlikView

Qlik Logo
Customer Company Size
Large Corporate
Region
  • America
Country
  • United States
Product
  • QlikView
Tech Stack
  • Oracle
  • SQL Server
  • Unidata
  • Pervasive
  • Access
  • Paradox
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Customer Satisfaction
  • Productivity Improvements
  • Cost Savings
Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Healthcare & Hospitals
Applicable Functions
  • Sales & Marketing
  • Business Operation
Use Cases
  • Real-Time Location System (RTLS)
Services
  • Data Science Services
  • System Integration
About The 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.
The 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.
The 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.
Operational Impact
  • Increased data retrieval speed sorting more than one million records per second.
  • Improved profitability with a dramatic increase in data accuracy – critical to claims processing and provider reimbursements.
  • Increased customer satisfaction by enabling support reps to provide fast answers and detailed reports to customers.
Quantitative Benefit
  • 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.
  • Deployed QlikView to 50 users in less than two weeks.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.