Interactive Excel KPI Dashboard | SaaS & App Performance Analytics
An interactive Excel performance dashboard that turns raw monthly data into clear KPI cards, trend charts and automatic insights, built for SaaS, app and subscription businesses.
Pick any month from the dropdown and the KPI cards update instantly, each compared with the previous month. They cover active users, new users, revenue, revenue per user, 30-day retention and average session length.
Developed an interactive Power BI dashboard to analyze sales performance, customer behavior, and business KPIs. The solution transforms raw data into actionable insights through dynamic visualizations and automated reporting.
Key Features:
Interactive KPI cards for Revenue, Inforce Policy Orders, and Growth
Sales analysis by State, Product Category, and Policy Segment
Dynamic slicers and drill-through functionality
Year-over-Year (YoY) performance tracking
Profitability and trend analysis using DAX measures
Data modeling with relationships and star schema design
Automated data refresh and optimized report performance
Tools & Technologies:
Power BI Desktop
Power Query
DAX
SQL / Excel Data Sources
Data Modeling & Visualization
Skills Tags🔥
Power BI • DAX • Power Query • Data Visualization • Business Intelligence • Dashboard Design • SQL • Data Analytics