This is my third case study analysis of The Movies Dataset on Kaggle for my Capstone project for the Google Data Analytics professional certificate. I am working on a capstone case study project acting as a junior data analyst to study the analysis of a ‘Movie Dataset’ which is Metadata about 45,000 movies, with data points including cast, crew, plot keywords, budget, revenue, ratings, release dates, languages, production companies, and more.

So I am looking first on what kind of clear statement of the business task can be selected to investigate, what problem can be solved using this dataset, What metrics can be used to measure your data to achieve my objective, who can be the stakeholders and audience, and what insights can help the clients to make decisions. On top of that I have been asked by my boss to lead a project for a brand new client — this will involve everything from defining the business task all the way through presenting your data-driven recommendations. I am going to ask the right questions, identify a fresh dataset and ensure its integrity, conduct analysis, create compelling data visualizations, and prepare a presentation.

Identify the business task: Clear statement of the business task To identify the factors that determine the success of a movie in terms of budget, revenue, return on investment(ROI), ratings . Budget: To analyze the relationship between the budget of a movie and its revenue, ratings, and return on investment (ROI) to determine if a high budget leads to higher revenue and ratings, and if there is a threshold beyond which higher budgets do not result in higher returns.

What is the problem you are trying to solve?

• Determining the key factors that contribute to the success of a movie and how these factors impact the revenue and ratings of a movie.

What metrics will you use to measure your data to achieve your objective?

• Revenue, ratings, budget, return on investment (ROI), profit margins, and audience engagement metrics such as views, likes, comments, shares.

Who are the stakeholders and audience?

• Film production companies, filmmakers, investors, film distributors, film critics, and movie audiences.

• My insights will help my clients to decide on which factors contribute: the most to the success of a movie, o the most profitable genres, and recommendations for future movie investments.

## `geom_smooth()` using formula = 'y ~ x'

1. On the first analysis it appears that there is a positive relationship between budget and revenue, meaning that, on average, a higher budget leads to higher revenue. However, there is no relationship between budget and ROI.
2. The analysis of average revenue and budget by genre shows that certain genres, such as Animation, Adventure, Fantasy, and Family, tend to have higher revenue and budget, while others, such as Foreign, Documentary, movies have lower revenue and budget. The highest net return were Animation and Family and for ROI were Mystery, War and Documentery, while the lowest net return and ROI were found for History and Foreign, and Foreign for ROI
3. The relationship between ratings and budget or ROI is also not definitive meaning there were no clear relationship was noted between budget, ROI, and ratings.

My top high-level insights and recommendations based on my analysis: Based on the findings, there is no one definitive answer that can predict a movie’s success. The relationship between budget and revenue is positive, but the relationship between budget and return on investment (ROI) is not significant. The average revenue, budget, net return, and ROI of different movie genres vary, with some genres having higher values than others. The relationship between ratings and budget or ROI is also not definitive. It appears that while there may be some general trends in terms of which genres tend to have higher budgets, revenues, and net returns, these relationships are not always clear-cut. Additionally, there does not seem to be a clear relationship between budget, ratings, and ROI.

Therefore, it may be advisable for production companies to take a more nuanced approach to decision-making, taking into account factors such as genre, target audience, and other relevant variables, rather than relying solely on budget, ratings, or other simplified metrics. It may also be beneficial for production companies to conduct further research and analysis to better understand the complexities of the film industry and the various factors that contribute to a movie’s success.

DAGEM