Case:
- A Production House want to produce a show that are popular but do not know what kind of shows to produce.
- The platform they are going to use as their main platform is Amazon Prime Video.
To give recommendation to said Production House, we need to gather data from Amazon Prime Video first.
What kind of shows are available?
The data shows that the vast majority of shows available on Amazon Prime Video is a Movie.
Drama is the most popular genre with difference over 1500 entries to the the second most popular genre which is Comedy.
Most shows are rated as PG-13 which means it is mostly aimed toward teenagers.
Most movie that are published to Amazon Prime Video have around 90 minutes of duration.
Recommendation:
Based on the data above, the recommendation for the Production House would be to create a Movie around 90 minutes that are aimed toward teenagers with Drama and Comedy genre.
What I did
- Find the data on kaggle and use the one published by Shivam Bansal titled “Amazon Prime Movies and TV Shows”.
- Import the data to Google Sheets.
- Hide column that are mostly blank and can be deemed irrelevant for this specific case.
- Clean the rating to better fit the Production House origin which is USA, make the rating to use MPA format that are common in the USA.
- Calculate and flag the outlier for movie duration.
- Create Pivot Table and Visualization for Type, Genre, Rating, and Movie Duration.