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.
Lunavi was selected by Print On Demand platform developer Nymbl to help migrate backend infrastructure to the cloud and architect a scalable, multi-tenant eCommerce web platform for future growth.
Learn moreThroughout various projects, Lunavi has helped BCU upgrade to a new Digital Banking platform, while modernizing and migrating dozens of supplemental applications and services.
Learn moreA 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