Skip to content
All projects

Movie Database Analytics

SQL and Tableau dashboards over a 211,000-movie PostgreSQL database.

Source on GitHub
Built
2025
For
Personal project
Stack
PostgreSQL, SQL, Tableau
Tableau dashboard of comedy budgets and revenue by year

Practice in SQL and reporting on the Open Media Database: about 211,000 movies in PostgreSQL, explored with SQL and turned into Tableau dashboards.

The repo includes the queries behind each chart and a script that restores the database snapshot. CI restores it into a fresh Postgres 17 and runs every query on each push.

Comedy dashboard
Top genres, and comedy budget against revenue since 1950
Releases dashboard
Releases per year and by genre, 1900–2019