PROBLEM STATEMENT: Tried to establish on what factors can the movie makers focus on in order to generate higher revenues. Factors such as what affects the imdb rating, most preferred genre of the movie and the ideal actor director combination have been considered to determine what can help in improved revenues.
TOOL USED: R, Excel
DATA IMPORT AND MERGED: • Imported all years Financials worksheet • Appended all the dataset from different Financials worksheet into one master dataset • Imported BollywoodMovieDetail dataset • Merged master dataset and BollywoodMovieDetail dataset on Movie Name