Netflix User Engagement and Revenue Analysis

Project information

CASE STUDY: Netflix User Engagement & Revenue Analysis Project Overview

A comprehensive data analysis project analyzing Netflix-style streaming platform data using SQL for data extraction and Power BI for visualization. The project uncovers key insights about user behavior, content performance, and revenue trends.

PROBLEM STATEMENT

Business Challenge User Engagement: Content Performance Revenue Analysis: User Behavior:

SOLUTION APPROACH

Data Collection & Structure SQL Implementation Power BI Dashboard

KEY INSIGHTS DISCOVERED

Revenue Performance Total Revenue: $246.81 Highest Month: October 2024 ($136.89) Growth: 251% increase from September to October Best Payment Method: Credit Card (45% of revenue)

User Engagement Active Users: 10 users (100% engagement) Average Engagement Score: 52.5 Top User: Alex (Engagement Score: 59) Most Watched Genre: Sci-Fi (5 views)

Content Performance Top Movie: Multiple titles with 2+ views Best Genre: Sci-Fi and Drama (highest ratings) Device Preference: TV and Mobile (40% each) Average Completion Rate: 85.4%

Customer Insights Premium Users: 4 users (40%) Average Lifetime Value: $24.68 Top Reviewer: Multiple users with 3 reviews each Geographic Distribution: 5 countries represented

PostgreSQL PowerBI CSV excel