Project Details

Fitness Center Analytics Dashboard

Project Overview

The Fitness Center Analytics Dashboard, built in Power BI, enables fitness managers and trainers to monitor memberships, engagement, finances, and member wellness. By integrating user demographics, payments, expenses, and activity data, the dashboard provides a holistic view of gym performance. It is designed with three modules: Overview, Member, and Calculator, ensuring both operational and individual-level insights.


Overview Page Fitness Center Analytics Calculator Fitness Center Analytics Member Page Fitness Center Analytics Data Model

Situation

Fitness centers often struggle with fragmented data spread across multiple spreadsheets or systems. Tracking memberships, renewals, financial performance, and member health progress requires manual reporting, which is time-consuming and prone to errors.

Task

The objective was to design a unified solution that automates reporting and enables stakeholders to:

  • Track membership activity and renewal trends.
  • Monitor financial performance such as revenue, expenses, and profit.
  • Provide member-level insights into BMI, BMR, and calorie goals.
  • Enhance decision-making through interactive and dynamic analytics.

Action

The project was executed by designing both a robust data model and an engaging set of dashboard pages.

  • Data Model

    • The central Users table stores demographics, health metrics (BMI, BMR, weight, goals), and trainer assignments.
    • Payments and Expenses tables manage financial transactions, linked with a Calendar table for time intelligence such as monthly revenue and profit trends.
    • Slicer tables (AgeSlider, GenderSlider, WeightSlider, HeightSlider, ActivityFactor) enable dynamic filtering for personalized analytics.
    • A dedicated measure table consolidates all DAX measures including BMI calculation, calorie recommendations, membership splits, and engagement score.

  • Dashboard Pages

    • Overview Page: Provides KPIs such as users, trainers, active members, engagement score, financial outcomes (revenue, expenses, profit), and membership breakdowns.
    • Member Page: Offers insights into user distribution by age, gender, and membership, with detailed member-level information such as BMI, goals, progress, and trainer linkage.
    • Calculator Page: Contains an interactive BMI and Calorie Calculator where users input weight, height, age, and activity levels. Outputs include BMR, TDEE, and calorie goals for maintenance or weight loss.

Result

The Fitness Center Analytics Dashboard delivers:

  • A centralized analytics hub for membership, financial, and health data.
  • Automated insights that replace manual reporting with real-time dashboards.
  • Actionable metrics on member engagement and trainer performance.
  • Personalized tracking of BMI and calorie intake, supporting fitness goals.
  • Improved decision-making through dynamic filtering and drill-through analysis.

By combining a well-structured data model, automated DAX calculations, and user-friendly visuals, this solution empowers fitness centers to drive member engagement, optimize financial performance, and support individual wellness journeys.