Netflix Analysis
Netflix is is an American over-the-top content platform .Netflix was founded in 1997 by Reed Hastings and Marc Randolph in Scotts Valley, California. The company’s primary business is a subscription-based streaming service offering online streaming from a library of films and television series, including those produced in-house. Here we have a dataset to analyze Netflix data throughout the years.
Tools used
MS-EXCEL
TABLEAU
DATA
Download the dataset from kaggle.com
This is categorical data.
Data Analysis
Checked for missing values and removed them as it is categorical data , split the date column to month and year for trend analysis.
Problem statements
1.Since the launch of Netflix, when were the maximum no. of tv shows/movies were aired?
2.Which genre in TV shows has been released the most?
3.What should be optimum duration of any new show to be released?
4.What time duration do movies have frequently?
5.Which rating category in movies has been aired the most?
6.Which rating category in tv shows has been aired the most?
7.Which are top 3 genres in tv show/movie?
8.Which country has highest no. of series released and in what rating?
9.Which TV show/movie genre has been least aired?
10.Which rating category in movies/tv show has been least aired on Netflix?
Pivot Table
Select insert -> pivot table -> on top left corner.
Dragging different fields to column and rows and building different tables.
Inserted different charts according to data.
Added slicer to filter every chart on dashboard so that dashboard can be interactive.
Dashboard
Tableau Dashboard
Imported data to tableau
Build parameter like dynamic dimension to sort data according to Rating ,type and Genres and parameter Top 3 to list top 3 genres according to filter type.
Insights
Dramas , Action and adventure , comedies are the top genres.
In the year 2019, the highest no. of shows/movies were telecasted.
United States has highest no. of telecasts.
R , TV-MA,TV-14 , movies of these ratings are higher in count.
International Tv shows has the highest count of all the genres in TV-shows