Case Studies
Practice real-world case studies for CAT, interviews, and professional growth. Submit solutions and get evaluated by industry experts.
6 KPIs That Measure 3 Things: Executive Dashboard Redundancy
UrbanMart's executive dashboard displays 6 sales KPIs. But Revenue and (New Customers × AOV) tell th...
Designing Row-Level Security Rules for an IT Dashboard
NexGenIT's new operations dashboard shows incident data for all 5 teams — but each team should see o...
The 95% Coverage That Hides Empty Benches: School Meal KPI D...
A school meal program dashboard reports 95% coverage — meals served vs meals planned. But the analys...
Is 70% Good Enough? RDA Compliance Threshold Critique
The district nutrition dashboard reports 82% RDA compliance for energy intake. But the compliance de...
Which Store Is Best? A Multi-Metric Performance Diagnosis
UrbanMart's monthly dashboard ranks 8 stores by revenue. Store A is #1 with ₹1.2 crore. But Store A ...
SOC Analyst Alert Fatigue — Metric Deep-Dive
SecureNet's SOC dashboard shows "mean time to detect (MTTD) improved 40% this quarter." But the SIEM...
Cloud Cost Runaway Diagnosis
CloudFin Corp's AWS bill jumped sharply in one month. The manager must trace the cause across servic...
Multi-Criteria Project Filter Dashboard
Global Project Management Inc. needs an interactive dashboard to filter active projects by multiple ...
Multi-Branch Sales Dashboard
A retail company has 3 branch teams each maintaining their own Sales Sheet. Puneet Arora demonstrate...
Multi-City Weather Import Dashboard — WeatherWise Analytics
WeatherWise Analytics monitors temperature, rainfall, and air quality across 4 cities. Students buil...
Financial Portfolio Analytics Dashboard
Build a comprehensive investment portfolio analytics dashboard with risk metrics, performance tracki...
E-Commerce Sales Dashboard: Data Analytics Case Study
Analyze e-commerce sales data to identify trends, customer behavior patterns, and revenue optimizati...