This project explored over a century of Oscar Best Picture nominees and winners, identifying historical trends and long-term shifts within the film industry. Using the Oscar Movies dataset from Kaggle, I analyzed patterns in genre, content rating, film duration, and production company dominance to understand what characteristics have historically correlated with recognition at the Academy Awards. The dataset included hundreds of films spanning multiple decades, making it an ideal source for studying how cultural and cinematic preferences have evolved.
I began with an extensive data preprocessing and transformation phase, addressing missing values, redundant entries, and inconsistencies across records. A new Main Genre column was engineered to simplify multi-genre entries, and IMDb ratings were normalized from a 0–10 to a 0–100 scale for analytical consistency. Additional calculated columns, such as the absolute difference between IMDb and Rotten Tomatoes’ Tomatometer ratings, were introduced to measure audience, critic disparities and their potential influence on award outcomes. These data enhancements provided the foundation for accurate and meaningful exploration.
The analytical phase involved creating a series of interactive Power BI visualizations to uncover relationships between variables and highlight recurring trends. A treemap illustrated the most common genres among awarded films, while clustered bar charts revealed which production studios, such as Warner Bros. and Paramount, have dominated nominations and wins. Scatter plots compared IMDb and Tomatometer ratings, providing insights into how fan and critic perceptions align with award success. Additional visualizations, including line charts and histograms, tracked film duration and content rating patterns over time, revealing a gradual trend toward longer, more mature-rated films in recent decades.
By combining statistical rigor with visual storytelling, this project showcased how data visualization can make historical film trends intuitive and accessible. The analysis concluded that drama films, particularly those produced by Warner Bros., between 120–140 minutes long and rated R, are the most likely to receive Oscar recognition, reflecting the Academy’s evolving but consistent preference for emotionally resonant, narratively complex cinema.