Home
/
Business Intelligence
/
Mission 15
caseSQL
Business Intelligence Path · Mission 15 of 31
Medium
Tenure and salary — any correlation?
Use date arithmetic to compute tenure and combine with analytical bucketing
Unlock with Pro
→
Back to Business Intelligence
The Brief
You'll practice
Date arithmetic
Bucketing
← Previous
Mission 14
Next →
Mission 16
All 31 missions in Business Intelligence Path
↓
1.
Board deck needs revenue by quarter
2.
Who is hitting their sales targets?
3.
Product mix is shifting
4.
Which region should we expand next?
5.
The dashboard numbers don't add up
6.
Discount tiers need a reality check
7.
Which categories are actually selling well?
8.
Find reps outselling their department average
9.
How many unique customers per region?
10.
Tag every sale by size
11.
Rank the sales team
12.
Who reports to whom?
13.
Monthly revenue trend with growth rate
14.
Pivot revenue by category and year
15.
Tenure and salary — any correlation?
16.
Top 2 products per category
17.
Find products with no sales last quarter
18.
Three-table join: who sold what where?
19.
Correlated check: reps beating their own average
20.
Running revenue total by month
21.
Year-over-year revenue by quarter
22.
Three-month moving average
23.
Hire cohort performance analysis
24.
Percentile ranking across the sales force
25.
The executive summary query
26.
Why is our leaderboard off by 12x?
27.
YoY revenue decomposition — price vs volume
28.
Tenure-adjusted attainment scorecard
29.
Dirty-dim audit — category casing reconciliation
30.
Same-rep regional growth — apples-to-apples YoY
31.
BI executive capstone — board KPI panel