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.
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:
Snowflake
Snowflake was utilized as the Data Warehouse to store engagement and messaging data
Fivetran
Fivetran was leveraged to fully replicate data from AWS DynamoDB and SQL Server on RDS to a Data Warehouse
Matillion
Matillion was used to efficiently and quickly transform source data into an appropriate schema for reporting needs
Power BI
Power BI provided the internal and customer facing reports for actionable insights and trends
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.
Discover how we’ve helped our customers build Modern Data Organizations.
Healthcare
Regenerative medicine company improves data-driven decision making across the organization
Data Lakes + Warehouses
Healthcare
Healthcare product company gets a handle on data sprawl
Data Lakes + Warehouses
Healthcare
Healthcare nonprofit launches comprehensive web application
Application Modernization
Transform your data org
Schedule a free consultation with the team.