Tools: SQL, Power BI, LLMs

Dashboard Link: Live Dashboard Here

GitHub Link: Check SQL Queries, and more from here

View Data Schema: Data Schema

Note: After clicking on Live Dashboard, please select the “Fit to Page” or “Full Screen Mode” option on the live screen so that the dashboard can adjust according to your desktop or laptop system.

Overview:

This is an end-to-end Product Analytics solution. It focuses on the entire pipeline for product analytics, including the Main Executive Overview, Revenue Analysis, Customer Analysis, and Cohort & Product Analysis.

Situation

The company doesn’t have an analytics solution to track various information about its products.

Task

Create a dashboard covering revenue analytics, product & cohort analytics, and customer analytics across different products.

Action

LLM is used for data generation. Data Warehousing is done using a combination of the STAR and Snowflake schemas (fact & dimension tables). Data is modelled in SQL and Power BI. The dashboard is developed in Power BI

Result

The dashboard focuses on the Executive summary page, revenue analytics, customer analytics, cohort & product analytics tracking over 50M of events, over 1000 B2B customers, $4.8M in ARR, 133% NRR, $403K MRR, $102K churned revenue, and much more.

Some Quantifiable Achievement

• Identified a +79.38% YoY growth in MRR (July 25 vs July 24), enabling leadership to double down on Analytics Pro (a product), which contributes 58.39% of total revenue.
• Tracked churned revenue by industry, revealing $50K losses in Retail. This led to targeted retention efforts, contributing to an overall NRR of 133% and a churn rate of just 2.40% YTD.
• Exposed that Enterprise customers drive 51% of the total active base (463 out of 910), guiding sales to prioritize Enterprise & Large Mid-Market, which together contribute $284K in revenue.
• Monitored 88.6% seat utilization and 960 auto-renewals (~90% of subscriptions), ensuring upsell opportunities and preventing revenue leakage from unused licenses.
• Dashboard highlighted 45.31% feature adoption and low mobile usage (Web: 56.97% vs iOS: 32.49% & Android: 28.37%), which guided the product to focus on improving mobile engagement, boosting long-term stickiness.