Skip to content
Projects · Aug 2022 – Dec 2022 · PES University

IMDb MySQL Database + Streamlit Front End

IMDb dataset loaded into MySQL with optimized queries and a Streamlit UI for exploration — a full data‑to‑app workflow.

Relational Modeling Query Optimization Data Apps Visualization

Overview

A database‑centric project that stores the IMDb dataset in MySQL and exposes it through an interactive Streamlit front end for exploration and analytics.

Problem

Large datasets become valuable only when they’re queryable and approachable. The challenge: design a clean schema, write performant queries, and build a UI that invites exploration.

Approach

Modeled the dataset into relational tables and implemented queries for common analytical questions. Built a Streamlit UI to visualize results and make the database feel “alive.” Documented the setup end‑to‑end so others can reproduce the database and run the app.

Impact

Demonstrates full‑stack data skills — schema design, SQL reasoning, and user‑facing visualization — which translates directly to analytics engineering work.