Executive Dashboard Questions

 

41. Top 5 Customers Per Region

DENSE_RANK()
PARTITION BY Region

---

42. Top 5 Products Per Region

Same logic.

---

43. Revenue Rank

RANK()
OVER(ORDER BY Revenue DESC)

---

44. Profit Rank

DENSE_RANK()

---

45. Monthly KPI Dashboard Query

Typically includes:

• Revenue
• Customers
• Orders
• Growth %

in one query.

---

46. Revenue vs Target

Actual - Target

---

47. Revenue Achievement %

Actual/Target*100

---

48. Top Revenue Quarter

GROUP BY Quarter

---

49. Revenue Forecast Baseline

Uses:

Moving Average

---

50. Executive Interview Favorite

Build a Sales Dashboard Dataset

Metrics:

• Total Revenue
• Total Orders
• Total Customers
• Avg Order Value
• MoM Growth
• YoY Growth
• Top Products
• Top Customers

Expected SQL Skills:

✅ Joins
✅ Aggregations
✅ Window Functions
✅ Ranking
✅ Date Functions
✅ Business Logic

---

Most Asked Business SQL Questions

1. Top Customers
2. Customer Churn
3. CLV (Customer Lifetime Value)
4. MoM Growth
5. YoY Growth
6. Running Total
7. Pareto Analysis
8. Revenue Contribution %
9. Top Products
10. Dashboard Dataset Creation