Subscription - based Analysis

Objective

A subscription-based streaming service wants to analyze user subscriptions to understand plan performance, churn risk indicators, and revenue trends.

Tools Used

• Excel
• SQL
• Python (Pandas, Matplotlib)
• Power BI

Dataset

• UserID
• JoinDate
• City
• Plan
• MonthlyFee
• MonthsActive
• Device
• PaymentType

Analysis Performed

• Calculated total revenue
• Analyzed revenue by Plan
• Compared revenue across cities
• Evaluated Device-wise revenue distribution
• Created visualizations for business insights

Key Insights

• TV generates the highest revenue among all other Devices
• Premium plan has dominated the other subscription plans
• Mumbai City had the highest revenue among all cities
• 14 January 2026 had the peak revenue
• Revenue distribution varies significantly across users

Files in Repository

• Dataset.xlsx - Dataset
• Queries.sql - SQL analysis queries
• Analysis.py - Python analysis and visualization
• Dashboard.pbix - Power BI Dashboard
• Screenshot.png - Screenshot of Dashboard