Selected Projects
Oct 2024
Conducted an in-depth SQL analysis of all 144 episodes across 7 seasons of Buffy the Vampire Slayer, extracting quantitative insights from the series’ data. Key components include:
- Conducted data cleaning and preprocessing in order to optimize dataset for analysis
- Designed and implemented a relational database schema with four interconnected tables to efficiently store and query episode information
- Wrote 20+ complex SQL queries, including subqueries and window functions, to analyze trends in ratings, viewership, and engagement.
- Uncovered patterns in episode ratings, writer and director performance in terms of ratings, and season-over-season changes in viewership and ratings.
- Created eight visualizations of key findings using MS Excel, including season-over-season changes in ratings, the distribution in ratings among episodes, and ratings differences in season premieres vs finales.
This project showcases proficiency in data modeling, SQL query optimization, and deriving actionable insights from entertainment data.
Further details on the project can be found on GitHub and on this blog post.