Film catalog
The Sakila film catalog — categories, ratings, runtimes and the demand each segment generates.
The catalog dimensions come from the films semantic model (over dim_film,
where the pipeline flattened category and language), and demand metrics come
from the rentals model joined through BSL — the fan-out correctness of
rentals × films is the semantic layer's job, not the page's.
Films in catalog
Avg nightly rate
Avg runtime (min)
Catalog vs demand #
Two sides of one question — how much shelf space each category takes, and how many rentals it earns back:
Seasonality by category #
Runtime and rating #
Top titles #
The table below is the other path to the same warehouse — a plain SQL query
from queries/top_films.sql, sitting next to the semantic-layer charts:
Title-level insights