Introduction

A non-profit health plan provider engaged ProCogia to lead the implementation of a visualization solution and design an enterprise data warehouse (EDW) to expand organizational analytics capabilities. We took a multi-threaded, agile approach that allowed the company to quickly produce high-quality visualizations, while also advancing its core data management and BI infrastructure.

 
 

The Challenge

A non-profit health plan organization needed to improve data quality and expand analytics capabilities to drive better decision-making. The company engaged ProCogia to implement a visualization solution and design an enterprise data warehouse (EDW).  They also needed assistance in recreating and validating their existing reporting infrastructure.

Procogia’s Approach

We took a multi-threaded, agile approach that allowed the company to quickly produce high-quality visualizations and advance its core data management and BI infrastructure. Our process included the following steps:

 

 

  • Identify the business drivers that are important to the various stakeholders
  • Identify the data quality issues that are negatively impacting key business drivers
  • Develop mechanisms to generate reports from the new DW (Data Warehouse) environment
  • Analyze the KPIs to detect discrepancies
  • Validate the percentage of missing and negative values for different variables and data sources

The Results:

The client’s BI program now drives significantly improved decision-making capabilities that have been enthusiastically received by both internal users and community partners. Increased capabilities include:

 

  • Better support to the Information Management business group to ensure Data Quality Services, Outlier Detection and Aberration Monitoring
  • Efficient support processes that merge dashboard data sources into the EDW
  • A framework to extend self-service analytics in sustainable iterations across departments

 
 

Services Used

Data Consultancy

We provide data consultancy to organizations to optimize your investment in people, processes, and technology. This is typically through data strategy engagements, roadmaps, transformations, and independent technology advice.

BI & Analytics

We transform complex and high-volume data into BI reports using dashboards and visualizations, allowing you to make smarter decisions.

Related Blogs

Take a read
 
 

Let’s connect

What can we help you with?
T: +1 425-624-7532

Alternatively, simply fill in this form and we’ll be in touch.