This report presents the findings from an extensive analysis of Netflix data to uncover viewer behaviours, content trends, and strategic insights for optimizing content strategies and enhancing user experience on the platform.
• Improve data quality through cleaning and normalization.
• Analyze genre preferences and director contributions.
• Provide actionable insights for strategic decision-making at Netflix.
The project covers data collection, cleaning, preparation, storage, and in-depth analysis using SQL queries to address key business questions related to content production, audience engagement, and operational efficiency.
• Utilized a comprehensive Netflix dataset containing information about movies, TV shows, directors, genres, countries, duration, and ratings.
• Imported data into Python for initial preprocessing and then transferred it to SQL Server for storage and subsequent analysis.
• Modified the data type of the "Title" column to 'nvarchar' to accommodate foreign characters, ensuring all data is accurately represented.
• Implemented procedures to eliminate duplicate entries, enhancing data integrity and reliability.
• Converted the "Date Added" column from varchar to date for consistent data handling and analysis.
• Utilized the director column to populate missing values in the "Country" column, ensuring completeness of geographical data.
• Corrected misattributed values in the "Duration" column using a CASE statement, resolving inconsistencies and improving data accuracy.
• Established separate tables for multi-value attributes such as "Listed In," "Director," "Country," and "Cast" to optimize data organization and querying efficiency.
• Stored initial data imports for preservation and future reference.
• Maintained cleaned and transformed data, and prepared for detailed analysis and reporting.
-
Count of Movies and TV Shows by Director o Identified Rajiv Chilaka as the director with the highest number of movies released in 2021 (17 movies) and Jan Suter with the highest number in 2018 (12 movies).
-
Directors Creating Both Horror and Comedy Movies o Identified 55 directors who have created both horror and comedy movies, with Poj Arnon and Kevin Smith noted for their substantial contributions to both genres.
-
Country with the Highest Number of Comedy Movies o Determined that the United States leads with 685 comedy movies, reflecting strong audience preference for this genre.
-
Average Duration of Movies by Genre • Found that classic movies have the longest average duration (118 minutes), while movies have the shortest average duration (45 minutes). Yearly Release Analysis
• Analyzed yearly releases to identify trends in directorial output, supporting strategic planning and content scheduling decisions.
• Content Preferences: Highlighted the popularity of comedy movies in the United States, guiding localized content acquisition strategies.
• Directorial Excellence: Recognized prolific directors and their impact on Netflix’s content diversity and viewer engagement.
• Genre Analysis: Provided insights into viewer preferences based on genre and average duration, informing content curation strategies.
• Strategic Content Acquisition: Recommends focusing on acquiring comedy content from the United States to meet viewer demand.
•Director Partnerships: Suggest collaborating with directors like Rajiv Chilaka and Jan Suter to diversify content offerings and enhance viewer engagement.
• Optimized Content-Length: Proposes balancing the catalogue with varying movie durations to cater to diverse viewer preferences and maximize engagement.
• Detailed SQL queries used for data analysis and insights generation.
Data Dictionary Table: Netflix table
Columns :
• show_id
• type
• title
• director
• cast
• country
• date_added
• release_year
• rating
• duration
• listed_in
• description