Netflix Userbase Dashboard

In the ever-evolving landscape of streaming services, Netflix stands tall as a frontrunner, captivating millions worldwide with its diverse content library. 

Understanding user behavior within this vast ecosystem is crucial, and a comprehensive analysis was undertaken using Microsoft Excel to shed light on key insights driving viewer engagement.

Dataset Overview

The dataset procured for this analysis encapsulates a plethora of information, ranging from user demographics to viewing patterns and preferences. It includes variables such as:

• User demographics (age, gender, location)

• Subscription types and durations

• User engagement metrics

Methodology

1. Data Cleaning and Preparation

Initial steps involved meticulous data cleaning to rectify discrepancies, handle missing values, and ensure data consistency. Following this, the dataset underwent a structured organization, allowing for seamless analysis.

2. Exploratory Data Analysis (EDA)

Employing various Excel functionalities, extensive exploratory analysis was conducted. This involved:

• Descriptive Statistics: Calculate the mean, median, mode, and standard deviation for key variables to gain a comprehensive understanding of the dataset's characteristics.

• Pivot Tables and Charts: Utilizing Excel's pivot tables and charts to visualize user demographics, popular genres, binge-watching behaviors, and subscription trends.

• Correlation Analysis: Determining relationships between variables such as age, viewing time, and favorite genres to unveil potential patterns.

3. Dashboard Creation

The culmination of the analysis led to the creation of an interactive dashboard using Excel. The dashboard serves as a one-stop interface, offering a dynamic overview of:

• User Demographics: Visual representation of age groups, gender distribution, and geographic concentration of Netflix users.

• Viewing Patterns: Insights into the most-watched genres, binge-watching habits, and popular shows across different demographics.

• Subscription Trends: Analysis of subscription types, durations, and their correlation with user engagement.

Key Findings

Top Countries by Monthly Revenue

• Analysis revealed the highest revenue-generating countries per month, showcasing the geographic distribution of Netflix's financial success. This insight aids in targeted marketing and localization efforts.

Subscription Type by Age Group

• Understanding subscription preferences across different age groups unveiled distinctive patterns, indicating varying preferences for subscription tiers. This insight guides strategic pricing and marketing strategies for different demographics.

Monthly Generated Revenue by Age Group/Gender

• Detailed analysis showcased the revenue generated per month, categorized by both age group and gender. This comprehensive view sheds light on specific demographic segments contributing significantly to monthly revenue, enabling personalized marketing campaigns and content recommendations.

Device Type Usage per Subscriber

• Insights into device preferences per subscriber emerged, outlining the primary device types utilized for streaming. This understanding facilitates user experience optimization across different devices and informs platform development strategies.

Top Generating Months

• Identification of the months generating the highest revenue within the dataset highlighted seasonal patterns or specific content releases driving increased subscriber engagement. Leveraging this information enables targeted promotions or content launches during peak revenue-generating periods.

Dashboard