Catalog Availability

Netflix: Report how many titles each region could show on the first of each month, and where the catalog is weakest.

Assignment

The regional content team is preparing its renewal budget and wants to know how the size of each region's catalog has moved over the first half of the year. They have shared two exports from the rights system: the licensing windows held for each title, and the list of titles themselves.

Deliverables

• The number of titles available in each region on the first of each month, January to June.
• Which region has the smallest catalog, and which one is the least stable.
• Your recommendation on what to prioritize for renewal, and a short closing report for the content team covering the reasoning and anything they should fix in the rights records.

Data Description

license_windows.csv is the licensing the rights system holds:

• window_id
• title_id
• region
• starts_on - the date the license takes effect
• ends_on - the date the license expires

catalog_titles.csv has one row per title:

• title_id
• title_name
• genre

A title can be shown in a region on a given date when a license covers that date.

Practicalities

You can solve this in Python, SQL, or a mix of both — StrataScratch notebooks support both languages in the same notebook.

Assume this data comes directly from the rights system and hasn't been cleaned, so review it carefully before relying on the numbers. When something looks off, work out what it is and decide how to handle it; when a definition or a final decision is genuinely ambiguous, choose a reasonable option and explain why. There's often more than one valid way to compute a result, so explain the approach you take and the reasoning behind your choices.

What's assessed: your results, and how clearly you explain what you see in the data and justify the choices you make.