Case Study: Rocky Mountain Health Plans

Wednesday, April 27, 2016 - 14:00

Inquidia worked with Rocky Mountain Health plans, helping them bring their analytics infrastructure to a new level. Inquidia implemented a robust data warehouse, using the Pentaho Data Integration platform for end-to-end data management.

Business Challenges

  • Required a robust integration and consolidation of disparate data sources. Enforcing data quality rules was time and resource consuming.

  • Governance of a large technology footprint was extremely difficult. A legacy data warehouse, local Microsoft Access databases, multilayered processes, and manual data intervention not only strained communication between departments but also consumed resources that could have been spent on analysis and data discovery.

Pentaho Solution

  • Pentaho Data Integration’s flexibility is a valuable asset. Requiring less technical background than other development options, Pentaho’s intuitive interface reduces development and maintenance coding overhead. Pentaho partner Inquidia Consulting helped RMHP navigate the implementation of this plan.

Value Added

  • Single source of truth enables confident decision-making - Integration of legacy databases, web sources, and flat files allows for a consolidated data hub. Business users across the enterprise confidently trust this source for making data-driven decisions.

  • ETL rules centralized and streamlined - Reduction of manual intervention and an automated nightly ETL run frees up analysts to interact with their data. Data discovery supplements standard reporting, adding new perspectives to the data.

  • Data quality assurance check - A nightly data quality validation system written in PDI facilitates transparency between agile developers and the data governance team. Communication enables development of new additions to code while keeping the production environment pristine.

Why Pentaho

  • Pentaho’s agility makes adjusting to changing requirements easier. The development team implemented the most integral features first and continues to add features and data sources as the data ecosystem and reporting requirements evolve.


Contact us today to find out how Inquidia can show you how to collect, integrate and enrich your data. We do data. You can, too.

Would you like to know more?

Sign up for our fascinating (albeit infrequent) emails. Get the latest news, tips, tricks and other cool info from Inquidia.