Womans Healthcare Provider Transform Data Consolidation and Visualizations to Improve Patient Care

Overview


VNB assisted a womans healthcare provider build data warehouse for Meditech EMR data and creates visualizations using PowerBI to improve patient care

Customer Profile

Customer is a healthcare provider with a mission to improve the health of women and infants, currently one of the largest in the United States. It is a private, non-profit organization that is consistently recognized for its innovative programs for women and infants and one of the largest delivery services in the U.S.

Customer Situation


womans-healthcare-provider-customer

Customer had a reporting solution that was tied to the Meditech EMR system which made any reporting or enhancement request time consuming and costly. Customer wanted a modern data warehouse which would allow to bring in data from multiple systems and for better reporting solution. Customer was looking for a partner who was experienced in both DW & Reporting and Healthcare, one who could provide industry standard guidelines, do implementation with short time as a major factor and train the internal team as the project progressed.

VNB Solution


womans-healthcare-provider-customer-vnb-powerbi

After a few initial discovery sessions and analysis, Customer and VNB team decided together that STAR schema would make most sense and sped up the design of the facts and dimensions. Together as one team, the team decided on best approach on how data for the labour and delivery module could be brought in to the DW and what is needed in the PowerBI model for reporting solution. All aspects such as data volume, performance, scalability, usability, security, sharing and collaboration were discussed, and solution designed. VNB team provided industry standard best practices that govern key disciplines of design and development of DW & Power BI reports to help client in future implementations.

Customer Benefits 

  • Cost savings by eliminating older reporting solution & licensing
  • Standardization of report architecture and move to self-service BI mode
  • Ramping up of successful implementation due to experienced VNB engineers
  • In house training for additional implementations for other modules

Related Case Studies


VNB Customer Story

An Electronic Design Automation company implements the 9-Box report using Power BI to assess individual’s potential and performance

VNB assisted the Electronic Design Automation (EDA) company implement the 9-Box report to help Identify High Potential Employees, Support Succession Planning, Improve Talent, and Performance Management.

VIEW DETAILS

A plumbing, heating and industrial supplies company implements automated QA validation process for their modern data warehousing solution using Azure Synapse Analytics & Power BI

VNB assisted major Industrial Supply and Wholesale distribution corporation automate their process for validating and auditing their Statement of Operations.

VIEW DETAILS