The dashboard transforms your fitness dataset into a comprehensive business intelligence platform with 12+ interactive visualizations across a striking red and blue color scheme. Here's what's included:
KPI Ribbon (6 animated cards) — Total Members, Active Members, Total Revenue (₦4.09M), Total Expenses (₦1.17M), Net Profit (₦2.92M), and Average BMI (28.8). Each card features animated count-up effects and trend indicators.
Revenue vs Expenses — Stacked area chart showing monthly financial performance with blue revenue streams and red expense indicators, revealing a strong 71.3% profit margin.
Membership Distribution — Donut chart breaking down Silver, Gold, and Platinum tiers with center total display.
Demographics Analysis — Age distribution bar chart, gender split pie chart (Male vs Female in blue/red), and fitness goals horizontal bar (Weight Loss, Muscle Gain, Maintenance).
Health Metrics — BMI category breakdown with color-coded health status indicators (green for normal, red for obese).
Trainer Performance — Horizontal bar chart showing member allocation per trainer, highlighting load balancing needs.
Payment Insights — Payment mode donut (Cash/Online/Card) with transaction counts.
Expense Breakdown — Category pie chart for Rent, Salaries, Electricity, Maintenance, and Miscellaneous expenses.
Strategic Insights Panel — 8 data-driven business recommendations including retention crisis alerts, profit margin opportunities, revenue growth trends, weight loss market dominance, BMI health alerts, trainer load balancing, digital payment shifts, and Q4 retention strategies.
Interactive Member Table — Sortable by any column, searchable, filterable by gender/status/membership tier, with pagination and CSV export functionality.
Global Period Filter — Switch between All Year, Q1, Q2, Q3, and Q4 2024 views to dynamically filter all charts and KPIs.
1
12
My work focuses on 3 outcomes:
Profit Visibility — identify revenue leakage, pricing inconsistencies, and weak-performing segments
Reporting Automation — reduce time spent building reports manually
Decision Clarity — give CEOs and managers one place to monitor KPIs
Projects I handle include:
Sales Performance Dashboards
Financial Analysis Reports
Customer Retention Analytics
Inventory & Logistics KPI Dashboards
SQL Data Cleaning and Business Query Reports
Executive Power BI Reporting Systems
0
2
I help businesses stop guessing and start seeing what their data is saying. Using Power BI, SQL, and Excel, I build dashboards that uncover revenue leaks, automate reporting, and track KPIs in real time. From sales performance to logistics cost analysis, I turn raw spreadsheets into decision-making systems. Based in Lagos, Nigeria. Available for remote US/UK client work
0
10