Skip to content

README.md

Latest commit

 

History

History
69 lines (45 loc) · 3.29 KB

README.md

File metadata and controls

69 lines (45 loc) · 3.29 KB

Netflix Shows MySQL Analysis

This repository contains an analysis of the Netflix Shows dataset using MySQL.

pitch deck link: https://gamma.app/docs/Netflix-Shows-MySQL-Analysis-zlg3vgaytxdvtiz

Table of Contents

  1. Dataset Description
  2. Importing Dataset into MySQL Workbench
  3. Difficulties Encountered
  4. Interesting Observations
  5. Future Work
  6. Insights Learned
  7. Charts and Visualizations
  8. SQL Queries Document

Dataset Description

The Netflix Shows dataset includes information about various shows available on Netflix, including details such as title, director, cast, country, date added, release year, rating, duration, and more.

Importing Dataset into MySQL Workbench

  1. Creating a New Database:

    • Open MySQL Workbench and connect to your MySQL server.
    • In the Schemas tab, right-click and select Create Schema.
    • Name your schema (e.g., netflix_shows) and apply.

  2. Importing the Dataset:

    • Right-click on your database (schema) in the Schemas tab and select Table Data Import Wizard.
    • Select the CSV file (netflix_titles.csv).
    • Map the columns from the CSV to the table columns in MySQL. You can let MySQL Workbench create a new table for you during the import process.

Difficulties Encountered

One difficulty encountered during the import process was ensuring the correct data types for each column, especially for columns like date_added and release_year. It was necessary to adjust the data types to properly reflect the nature of the data.

Interesting Observations

One interesting observation about the Netflix Shows dataset is the diverse range of countries represented in the content available on Netflix. This highlights Netflix's global reach and diverse content library.

Future Work

In the future, further analysis could be performed on this dataset, such as:

  • Analyzing trends in content over the years.
  • Examining the distribution of content ratings.
  • Investigating the representation of different genres and countries.

Insights Learned

Charts and Visualizations

Top 5 Countries:

The top 5 countries producing the most content on Netflix include the United States, India, the United Kingdom, Japan, and South Korea. This indicates a strong production base in these countries. top5 countries

Top 5 Genres:

The top 5 genres with the most content on Netflix are International Movies, Dramas, Comedies, International TV Shows, and Documentaries. This shows a diverse range of popular genres on the platform. genres

Total Shows by Rating:

The top rating with the most shows on Netflix is TV-MA. This shows more adult content is on-demand and popular on the platform.

rating

SQL Queries Document

All the SQL queries and their results are documented in the SQL_Queries_and_Results.txt file.