Industry
Woman's Healthcare Provider
Technologies Used
STAR Schema
Microsoft Power BI
Key Outcomes
Significant cost savings
Standardization of reporting architecture
VNB assisted a woman's healthcare provider build data warehouse for Meditech EMR data and creates visualizations using Power BI to improve patient care.
Customer Profile
The customer is a prominent healthcare insurance provider serving a vast population. With a rich history in the industry, they are committed to delivering comprehensive healthcare solutions and enhancing member experiences. The organization operates in a highly regulated environment, necessitating robust and compliant systems. Due to the sheer volume of transactions and complex nature of healthcare data, the customer handles a significant workload, demanding efficient and reliable IT operations.
Customer Situation
The customer handled 270/271 Healthcare Eligibility Benefit Inquiry transactions to verify patient healthcare eligibility, coverage, and benefits. The customer relied on custom API interfaces built on Microsoft BizTalk Server to connect with multiple insurance payers. This complex integration environment, characterized by high transaction volumes and frequent changes, was prone to instability. Updates to one payer’s interface often disrupted connections with others. To mitigate this risk, accelerate development and ease the build, deployment and testing process, the customer sought an automated solution that would enable continuous integration and continuous delivery (CI/CD) with robust automated testing.
Customer Profile
The 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
The customer had a reporting solution that was tied to the Meditech EMR system which made any reporting or enhancement request time consuming and costly. They wanted a modern data warehouse which would allow to bring in data from multiple systems and for better reporting solution.
The customer was also 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
After a few initial discovery sessions and analysis, customer and VNB team decided together that STAR schema would make most sense and speed up the design of the facts and dimensions. The team together decided on the best approach on how data for the labour and delivery module could be brought into the DW and what was needed in the Power BI model for the reporting solution. All aspects such as data volume, performance, scalability, usability, security, sharing and collaboration were discussed, and the solution was designed. VNB team provided industry standard best practices that govern key disciplines of design and development of DW & Power BI reports to help the client with 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
