Digital health company improves insights into member behaviors
The question remains for many businesses: What do they do once they have that data?
A digital health company was looking to better handle its customers’ needs by providing insights into member behaviors within its texting programs.
Our client provides their customers with various metrics with regard to participation and engagement in their many texting program offerings. As requests come in for new information and/or slight variations in existing reports, our client needed a better way to meet these requests.
The existing process was very manual and prone to errors, sometimes delaying turnaround time in responding to customers’ data requests. This process impeded the client’s ability to create new reports or aggregate reports across multiple programs for each customer. The current reporting could represent a point in time but did not easily allow for trends over time.
Improved Reporting and Data Analytics
OneSix designed and built a Data Warehouse that could handle the client’s current and future needs in both reporting and data analytics. We created a data model that could handle today’s reporting needs while allowing the flexibility to add on later. Using Fivetran, we brought their source data, SQL Server and DynamoDB, into a Snowflake database. Using Matillion, we built a fully automated ETL process with fewer steps and a faster turnaround time to provide up-to-date data. The reporting and analytics are now available in Power BI.
OneSix took advantage of many powerful Data Warehouse technology solutions to create the right arrangement for our client’s needs:
Snowflake was utilized as the Data Warehouse to store engagement and messaging data
Fivetran was leveraged to fully replicate data from AWS DynamoDB and SQL Server on RDS to a Data Warehouse
Matillion was used to efficiently and quickly transform source data into an appropriate schema for reporting needs
Power BI provided the internal and customer facing reports for actionable insights and trends
The client is now able to present trends over time through one or more programs depending on the customer.
This process allows them to scale up to meet their customers’ growing reporting needs while handling new requirements going forward.
They are able to set up a dashboard customized for each of their customers, sourced from Power BI datasets.
My experience was fantastic with OneSix. They listen to your query carefully and then are able to solve your issues within the correct time frame and reasonable price. Super knowledgeable team!
One of my favorite things about One Six is their willingness to work with us on whatever we need. Early on in the project, we determined we needed an additional tactical resource instead of an advisory one, and One Six happily switched out resources for us, ensuring we had what we needed to complete the project.
They dig in and help understand the problem, how to think about it, provide the best technical options of how to solve it, then execute as quickly as possible. This is by far the best way to help me make sure we're successful, and that I know what's being done and how to support it once they're finished.
Discover how we’ve helped our customers build Modern Data Organizations.
Regenerative medicine company improves data-driven decision making across the organization
Data Lakes + Warehouses
Healthcare product company gets a handle on data sprawl
Data Lakes + Warehouses
Healthcare nonprofit launches comprehensive web application