A Power BI project analyzing workout data from 20 gym-goers across 480 logged sessions to identify which exercises, equipment types, and conditions (time of day, cardio timing, protein intake) produce the highest muscle "pump."
Star schema with 3 tables:
- Person_Dim — 20 people (demographics, experience level, gym)
- Exercise_Dim — 52 exercises across 7 muscle groups
- Workout_Log — 480 workout entries (fact table)
Relationships: Person_ID and Exercise_ID connect the fact table to
both dimension tables.
- Evening workouts consistently show higher pump ratings than morning sessions, across almost every muscle group
- Barbell and Dumbbell exercises outperform Machine exercises for pump
- Legs — highest pump in the evening with no cardio
- Chest — pumps hardest with cardio done before the evening session
- Biceps — Concentration Curls and Hammer Curls deliver the strongest pump
- Shoulders — light up most in the evening, especially with cardio skipped
- Protein timing (within 30 min vs later) shows only a mild effect on pump rating
- Overview — KPIs and high-level comparisons across Muscle Group, Equipment Type, Time of Day, Cardio Timing, and Protein Timing
- Deep Dive — Interactive matrix filterable by Muscle Group, Cardio Timing, and Time of Day, with conditional formatting highlighting top-performing exercises
- Key Insights — Summary findings and final recommendation
Power BI Desktop, DAX, Excel (dummy data source), Python (synthetic data generation)
