light through trees representing lunavi concept of illuminating your technology path
case study
Data Science Drives Better Healthcare Pricing
Industry
Healthcare & Technology
Company Size
100
Employees/Users
SOLUTIONS IMPLEMENTED
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.

THE SOLUTION

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.

THE IMPACT

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
FlexPay

Driven by a strong retail background, FlexPay.io leads the payment salvage industry with advance machine learning models that intelligently determine the best way to recover declined, recurring payment card transactions where the credit card isn’t present.

Learn more
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
Hybrid Cloud Enables More Business with Less Cost

A natural gas marketing company that buys and sells natural gas was looking for a way to increase the number of trading partners they work with while reducing the overall cost.

Learn more