Health Karma reached out to Data Sleek with the goal of designing and building their data warehouse and centralizing and unifying their data. The ultimate goal was to be able to provide self service analytics, query reliable data, and build analysis dashboards. Because of the large amounts of data points or attributes, we advised to build a data dictionary to define each field from different sources, ensuring that all necessary data is accounted for during the ingestion.
Services
Health Karma
May 10, 2023
Introduction
Health Karma is a private healthcare technology company that aims to simplify and personalize healthcare for individuals, employers, associations, and municipalities by providing them with tools and resources to manage their health and wellness. They specialize in making these offerings available for anyone, with or without access to insurance. Their platform gives customers access to a variety of services such as personalized health assessments, digital coaching, health goal tracking, and access to virtual care services. Customers can also connect with healthcare providers and receive tailored recommendations based on their health needs and goals.
As a company dealing with healthcare data, Health Karma has unique data compliance requirements, and since they partner with an extensive network of providers, they also have access to a wide range of data sources.
Problem
Solutions
The Data Sleek team analyzed Health Karma’s existing infrastructure running on MySQL, Redshift, and Snowflake, and introduced the following new tools to their tech stack, to improve performance:
Segment
Segment is a customer data platform that helps businesses collect, unify, and use their customer data from various sources, such as websites, mobile apps, and other software tools, to improve customer experiences and drive business growth. It was deployed to help Health Karma gain a more comprehensive understanding of their customers' behavior and preferences, and use that information to enhance the customer experience and improve conversion rates.
DBT
DBT (Data Build Tool) is a popular open-source tool used for implementing dimensional modeling and managing data transformation pipelines in a data warehouse. It enables businesses to define their data models as code, automate the transformation of data, and test and validate the data to ensure its accuracy and completeness. It was used for reverse ETL (Extract, Transform, Load) by defining transformations that reshaped data from the warehouse into a format that could be consumed by downstream operational systems.
Apache Superset
Apache Superset is an open-source data exploration and visualization platform that enables users to create and share interactive dashboards and data visualizations. This tool was utilized to allow Health Karma’s team explore statistical information visually, through dashboards co-created with Data Sleek. An important factor for Health Karma was the ability to explore needs and behaviors of customers with different profiles: individual healthcare consumers, those who came to the company via employer partnerships, and those joining via some other form of organizational membership. Apache Superset enabled accessing and sharing these insights.
Results
Health Karma’s partnership with Data Sleek resulted in a finely tuned system for tracking the performance of enrollment procedures. Now there are efficient data flows in place that enable operational data, such as sending registered user’s data to Mailchimp, for continued customer engagement. The dashboarding system in place allows business stakeholders to gain insights independently, using simple queries, yielding elegant summary data and visualizations.