Designed and developed an end-to-end, interactive SaaS Performance Metrics Dashboard to track β¬17.73M in annual revenue, subscriber retention, acquisition channels, and team performance across 12 months. Built on a robust backend data architecture powered by 23 interconnected Pivot Tables, enabling seamless dynamic filtering via Monthly and Account Manager slicers.
Key Business Metrics & Insights Tracked:
Revenue & Subscription Health: Monitored β¬17.73M Total Revenue (Peak: β¬1.71M/month, Avg: β¬1.48M/month) alongside 617 Active Subscribers (77% retention) vs. 23% Churn rate (183 subscribers) and 2,569 Active Products.
Customer Acquisition Channels: Analyzed ROI across 5 core channelsβidentifying Paid Social (β¬4.89M) and Organic Search (β¬4.15M) as top revenue drivers, followed by Affiliate (β¬3.22M), Website (β¬2.94M), and Email Campaigns (β¬2.51M).
Team & Account Manager Performance: Evaluated individual contributions, highlighting top-performing Account Manager (Sarah β β¬4.98M) and Top 5 Customer Success Representatives (CSR Leader: Adam β β¬1.66M).
Operational Efficiency & SLA: Tracked monthly Average Ticket Resolution Time (03:45 min avg, ranging from 03:30 to 04:03) to ensure high customer satisfaction and lower churn.
Product, Contract & Regional Breakdown: Visualized multi-dimensional trends across Subscription Plans (BE, CNI, FC, GK), Contract Types, Regional distribution (Radar Chart), and 5 Marketing Campaigns.
Technical Highlights:
Engineered a complex backend using 23 Pivot Tables and advanced formulas for automated calculations.
Designed a modern Dark Mode UI/UX with custom radial bar charts, line/area trends, radar charts, and dynamic KPI cards for executive-level storytelling.
Integrated interactive Monthly and Account Manager Slicers for instant drill-down analysis.
I co-designed High Drop Sum (HDS), a KPI that tracked attendance drops class by class in a free 10-day intro course, with yellow and red alerts that triggered tiger team outreach. I mapped every departmentβs touchpoints, cut early sales pressure, and led the data analysis. Course attendance rose 10%, with fewer cancelled cohorts.