Netflix
Analytics Reporting Track · Medium · 25 min
Quarterly Headcount Change
People analytics wants the most recent quarter-over-quarter headcount change for each team. Return team_name, current_headcount, prior_headcount, and headcou...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a Netflix-tagged business scenario.
Approach
Use this track to train on SQL that mirrors day-to-day analytics workflows and recurring reporting asks.
Company context
Company labels are directional practice context, not official interview guidance.
People analytics wants the most recent quarter-over-quarter headcount change for each team. Return team_name, current_headcount, prior_headcount, and headcount_change using the latest quarter available for each team. Sort by team_name.
team_headcount
| team_name | ||
|---|---|---|
| Content Ops | 2024-01-01 | 42 |
| Content Ops | 2024-04-01 | 45 |
| Content Ops | 2024-07-01 | 47 |
| Platform | 2024-01-01 | 58 |
| Platform | 2024-04-01 | 60 |
| Platform | 2024-07-01 | 57 |
| Studio Data | 2024-01-01 | 24 |
| Studio Data | 2024-04-01 | 26 |
| Studio Data | 2024-07-01 | 29 |
SQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.