light through trees representing lunavi concept of illuminating your technology path
case study

Data Science Drives Better Healthcare Pricing

Healthcare & Technology
Company Size
The Challenge

A healthcare organization focused on creating provider solutions was looking for ways to help patients find the most cost effective healthcare services in their area. The challenge they faced was that they had large amounts of data that they needed to leverage in order to provide recommendations to their customers. They did not have an easy way to access the different data sources and data formats. The data scientists were also spending too much time getting the data prepped for analysis versus actually doing the analysis.


We worked with this company’s development and data teams to create an Azure solution that provides a single point of consolidated data access for the data scientists. This solution leveraged Azure Data Factory to create the scheduled jobs to pull data from an Azure SQL database, Cosmos Document database, and file drops and push to SFTP locations. We also leveraged Azure Data Lake Analytics with USQL to perform data consolidation and transformation.  This transformed data was then pulled into an Azure SQL Data Warehouse to provide the data scientists the ability to discover and analyze information using tools like Power BI.


This solution enabled the data scientists to spend most of their time identifying and making the best recommendations on customer prices based upon historical data and national trends. This brought down the costs for each customer as they were looking for healthcare service in their area.

Their Azure Data Platform solution was hosted entirely in the cloud which minimized the initial investment needed to get the solution up and running and made ongoing support much simpler for the team.

The Azure Data Warehouse also allowed the company to only pay for what they used and shut down the Data Warehouse when it was not in use to reduce costs.

Related Case Studies

lunavi logo alternate white and yellow
Case Study
Integration Drives New Revenue Streams

A risk management and insurance services firm was looking for ways to increase revenue by streamlining the way customers request their products. They knew that in order to increase the accessibility and efficiency for accessing their services, they would need to integrate with the organizations that are selling their products.

Learn more
lunavi logo alternate white and yellow
Case Study

i-Function sought a long-term partner who could help modernize the FUNSAT platform to take advantage of cloud and coach the company through Agile adoption to test and improve product iterations throughout development and delivery.

Learn more
lunavi logo alternate white and yellow
Case Study

Throughout various projects, Lunavi has helped BCU upgrade to a new Digital Banking platform, while modernizing and migrating dozens of supplemental applications and services.

Learn more