Case study

Vertica delivers adaptive data warehouse and AI-supported datadriven decision making


Barnes-Jewish Hospital’s mission is to take exceptional care of people by providing world-class healthcare in a compassionate, respectful, and responsive way. The Barnes-Jewish Data Management team aims to support this by enabling data-driven decision making at all levels of healthcare delivery.

The Data Management team looked for a solution to integrate data with its sources in an easily reusable fashion, structuring the data according to analysis requirements. Business rules, use cases, and vocabulary are changing continuously, and so this model needs to be flexible enough to adapt easily. The technical challenges the team was facing included an incumbent database with very wide tables (greater than 570 columns), a reporting challenge with dozens of table joins, billions of rows of raw data, and a system with high CPU and memory consumption.


The team designed a new adaptive data warehouse, with common, linkable vocabulary. The data warehouse takes source data from financial, administrative, HR, Electronic Health Records (EHR), operational, and departmental systems. These previously siloed systems all come together in the data warehouse to be leveraged by all clinical business functions.

The data warehouse is underpinned by Vertica Analytics Platform, using Tableau as a presentation layer. Tableau extends Vertica with fine-grained, visual analysis. This seamless integration provides quick and easy big data visualization with interactive dashboards that let users drill-down, to ask real-time questions and receive answers.

Comprehensive data governance has established a clear accountability structure. Team roles and responsibilities, as well as tasks and goals, are clearly defined and agreed. Everyone involved with the data works according to established information sharing policies and data use agreements. A data dictionary and data quality management tools were introduced.

With standardized reports and scorecards throughout the process, data and business owners have joint responsibility for the data quality.


By closely collaborating with frontline clinical business partners, prioritizing goals, modernizing the infrastructure to allow a data-driven approach, and automating processes, the Data Management team supports operational needs while complying with BarnesJewish Hospital’s strict security guidelines.

How can Micro Focus help you to succeed?

Barnes-Jewish Hospital case study

release-rel-2021-1-3-hotfix-5713 | Thu Jan 21 09:20:43 PST 2021
Thu Jan 21 09:20:43 PST 2021