Home

Sakila Dashboard

Welcome to the Sakila Movie Rental Dashboard.

🎬 Sakila Dashboard

An interactive analytics dashboard built with Evidence, DuckDB, and Python to explore movie rentals, customer behavior, and revenue trends.

This dashboard provides a clear and structured overview of key insights from the Sakila database, including:

  • Revenue by Movie Category
  • Customer Rental Behaviour
  • Top Customers and Top-Rented Films
  • Patterns in Rental Duration and Activity

How to Use This Dashboard

  • Use the menu on the left to navigate sections
  • Select filters from dropdowns
  • Explore charts and tables interactively
  • Review insights below each visualization

What This Dashboard Shows

The Sakila database is a fictional movie rental dataset commonly used for data analysis practice. In this dashboard, you will discover:

  • Which movie categories generate the highest revenue
  • Which customers are the most active and most profitable
  • Which films are rented the most
  • How rental durations differ between customers and categories

About This Project

This project was built using Evidence.dev, DuckDB, and Python. SQL and Python queries were used to transform and analyse the dataset before visualising the results.

Database Structure

This diagram shows the relationships between films, actors, customers, and rentals used in this dashboard.

Project Objectives

  • Analyze rental behavior
  • Identify high-value customers
  • Compare category performance
  • Understand revenue seasonality

This diagram shows the relationships between films, actors, customers, and rentals used in this dashboard.

Skills Demonstrated

  • SQL joins and aggregations
  • Data modeling and normalization
  • Interactive dashboard development
  • Data storytelling and visualization
  • Performance optimization with DuckDB

About the Author

This dashboard was created by Lilit Ajoyan an aspiring MLOps engineer with a strong interest in data analytics, SQL, and Python-driven insights, as part of a data analytics project focusing on interactive visualization.

Project Repository

You can view the full source code for this project on GitHub:

👉 Sakila Dashboard Repository

Dashboard built using Evidence.dev, DuckDB, and the Sakila sample database.

Continue to the next pages to see detailed insights, charts, and tables.