Result

Digital health company improves insights into member behaviors

The question remains for many businesses: What do they do once they have that data?

Overview

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.

 

doc text

Our solution

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:

Results

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.

results

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!

Ayush J.
SEP 28 2022

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.

Pamela E.
NOV 8 2021

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.

Brandon H.
OCT 20 2020

Transform your data org

Schedule a free consultation with the team.