Business Intelligence for a Film Rental Business
A snowflake model, KPI design and temporal, revenue and customer analytics in Power BI.
- Role
- Student project, INP-HB
- Period
- Mar 2025
- Status
- Academic
- Context
- Relational rental database (actors, films, customers, stores, countries)
01Executive summary
An interactive dashboard to steer a film rental business. I chose a snowflake model to keep the geographic and catalogue hierarchies flexible (country to continent, film to category and actor) and designed the KPIs before the visuals.
02Data modelling
- Snowflake schema around the rental fact, with normalised geography and catalogue dimensions.
- DAX measures for revenue, volumes, growth rates and late returns.
03Technology stack
- Power BI
- DAX
- Power Query
- Snowflake schema
04Results and deliverables
- Revenue by actor, customer, film, country and continent; rankings of customers and actors.
- Monthly and yearly revenue and volume trends; growth rate by store; late-return analysis.
- Dynamic geographic map and a consolidated summary matrix.