Project- Rotten Tomatoes Movie Rating Analysis

Project - Rotten Tomatoes Movie Rating Analysis

Welcome to the Excel data analysis report, which examines the Rotten Tomatoes Movie Rating datasets from the Kaggle platform- https://www.kaggle.com/datasets/shivavashishtha/movies-data

This data analysis project report has to identify the trends and patterns that were discovered by analyzing more than 15,000 plus movies from Rotten Tomatoes reviews and their ratings for potential commercial gain. The data includes film details (title, description, rating, genre, directors, cast, release date, studio, runtime, etc.), as well as featured reviews, "Tomatometer" status, and audience ratings.

Recommended Analysis-

1. What does the distribution of films look like by rating? By primary genre?

2. What percentage of films received a Certified Fresh Tomatometer rating? What about Rotten?

3. Explore new film releases over time. How has the volume of releases by month trended over time? What year/month were the most new films released?

4. Compare average Tomatometer ratings by Studio. Which studios produce the highest rated films, on average? The lowest?

5. Compare the Tomatometer ratings against audience ratings. Which films showed the largest discrepancies between audiences and critics?

6. Explore the critics consensus rating: what language is used most often?

To conduct this analysis, I used advanced Excel tools and techniques such as Data Cleaning, Pivot Tables, Charts, Various functions, Sorting, Filtering, Azure Machine Learning (add-ins) to extract insights that can inform data-driven decision-making.

The report is designed to be informative, and engaging, and provide a starting point for further analysis and strategic planning.

Conclusion-

This project addressed the lack of comprehensive analysis of movie ratings on Rotten Tomatoes and provided valuable insights into the influence of ratings on moviegoers' preferences. The findings and recommendations presented in this report can assist entertainment organizations in making informed decisions and maximizing their commercial gains.

I am confident that the insights provided will be valuable for properly informing decisions for commercial gain. Should you have any questions or require additional feedback, please do not hesitate to contact me. Your satisfaction is of utmost importance, and I am here to assist you every step of the way.