Johanna Schmidle
Guilty of binge watching
Netflix from time to time

Goal: Market Analysis. Understanding Netflix subscription trends provides valuable insights into market behavior, helping to predict future industry patterns and consumer preferences.

Metrics and Dimensions

• Total Subscriptions: total subscription sales from all plan types
• Plan Type: Basic, Premium, and Standard
• Country: Australia, Brazil, Canada, France, Germany, Italy, Mexico, Spain, UK, and US
• Plan Device: Device on which the subscription will be used. Laptop, Smart TV, Smartphone, and Tablet

• Part 1: General Data Cleaning in SQL
• Part 2: Interactive Dashboard
  

Summary of Findings

Plan Type:

• Basic plans are the most popular plan.
• Near the end of June 2022 all plan types saw a significant spike and the basic plan type hit a high of $811.00. These spikes significantly decreased until the end of October 2022 when all plan types spiked again, and Premium and Standard plan types hit highs of $576.00 and $727.00 respectively.
• All plan types seemed to drop off after this second spike completely.

Plan Country:

• Spain and the US are the top two countries with subscription totals of $5,664 and $5,662 respectively.
• Most countries followed the same spike and decrease pattern as the plan types (spikes in June 2022 and late October 2022) except France which hit its high in August 2022, and Germany which hit its high at the beginning of October 2022.

Plan Device:

• All four devices are evenly popular for Netflix Subscriptions, each getting a total of around $7,700.
• The devices followed the same spike and decrease pattern as the other two graphs (spikes in June 2022 and late October 2022) with Smartphones and Tablets peaking in June, and Smart TVs and Laptops peaking in October.

Recommended Next Steps

• Investigate why the people aren't joining in the months between June and October
• Certain countries make up larger percentages of new subscriptions during different times of year, investigate why this may be the case.

Database Information

Database: https://www.kaggle.com/datasets/arnavsmayan/netflix-userbase-dataset
The dataset provides a snapshot of a sample Netflix userbase. It has the following columns:

• User ID: the ID of the user
• Subscription Type: Basic, Premium, and Standard
• Monthly Revenue: The amount of revenue from the users subscription(s)
• Join Date: The date the user subscribed
• Last Payment Date: The last time the user paid
• Country: The country the user is in
• Age: The age of the user
• Gender: The gender of the user
• Device: The device the subscription will be used. Laptop, Smart TV, Smartphone, and Tablet
• Plan Duration: The duration of the plan the user selected