- Healthcare & Life Sciences
Uncovering insights into member engagement for a digital health company
Overview
Streamlining insights into member behavior
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
Building a flexible data warehouse with automated ETL
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.
Technologies Implemented
- 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.
Results
A single source of truth for decision-making and trend analysis
With this solution and knowledge transfer, the organization is able to leverage the analytics output from our project as a template for building future reporting. A single source of truth from the cloud data warehouse allows the business to look at the numbers with confidence for decision-making.
Key financial metrics are available to view by snapshot, trends, as well as drill-down to more granular components in a visual, easy-to-digest method. The labor reporting has already yielded insight into better management of overtime for the workforce.
Ready to unlock the full potential of data and AI?
Book a free consultation to learn how OneSix can help drive meaningful business outcomes.
