Financial Analytics
Gym Franchise Financial Analysis
SQLExcelPower BI
A gym franchise was crippled by 5 years of unorganized offline paper records, leading to blind management decisions, severe billing leakages, and unpredicted customer churn.
Manually digitized 5 years of paper records, built a reliable Power BI Star Schema, and created three modules: Overview, Product Analysis, and Financial Analysis (assessing CAGR and Break-Even Point).
Revealed a -28% CAGR decline despite cost-cutting, identified 93,000 EGP in billing leakages, a 43% loss in supplement pricing, and 80% monthly membership churn. Offered key billing controls and retention strategies.
Note: If the Microsoft Power BI service is blocked on your network, use the media tabs above.