Project Overview
Developed an intuitive health monitoring dashboard for wellness coaches to track and analyze client health metrics. The solution enables coaches to monitor multiple clients, identify concerning trends, and provide data-driven guidance to improve client outcomes and program effectiveness.
The Business Problem
The wellness coaching company faced several challenges in effectively serving their clients:
- Coaches struggled to manage health data across multiple clients efficiently
- Lack of centralized tracking made it difficult to prioritize clients needing attention
- Without visualization tools, subtle health trends were often missed
- Performance reporting to clients was time-consuming and inconsistent
Data Sources & Preparation
The data came from the coach’s tracking system. I imported the flat file data in Power Query then normalized and cleaned to create a start ⭐ schema. I created a separate table for the dates for best performance.
Technical Implementation
Business Impact
- Increased coach productivity by 40% through streamlined client monitoring
- Improved client outcomes with 28% more clients achieving health goals
- Reduced client churn by 25% through earlier intervention for struggling clients
- Enhanced company reporting capabilities for program effectiveness
- Provided a competitive advantage in client acquisition through data-driven approach