SaaS_Subscription_Revenue

📊 SaaS Subscription & CRM Data Analysis Portfolio Project, featuring data cleaning, VLOOKUP metrics, cohort churn tracking, and an interactive business dashboard.

SaaS Subscription Performance Portfolio Project

An end-to-end data analytics portfolio project focusing on SaaS (Software as a Service) subscription performance, customer behavior, and churn analysis. This project demonstrates advanced Excel capabilities in transforming raw CRM data into dynamic business insights.

📁 Project Architecture & Data Pipeline

The project is structured across 5 core sheets, reflecting a standard professional data analysis workflow:

1. Raw_CRM_Subscriptions: Unprocessed source data containing customer metrics, signup dates, support tickets, and geographic locations.
2. Plan_Details_Lookup: A reference dataset mapping specific subscription tiers (Starter Basic, Growth Professional, Enterprise Scale) with prices, user limits, and SLA levels.
3. Cleaned_Data: The engineered dataset where text is standardized (e.g., country names), dates are unified, and lookup metrics (like revenue per tier) are merged.
4. Pivot_tables: Deep-dive analysis tables computing critical SaaS KPIs such as Churn Rate, Average Support Tickets per Plan, and Revenue by Country.
5. Dashboard_Saas: An executive-ready dynamic dashboard with interactive slicers for stakeholders to visualize active users, subscription growth, and risk factors at a glance.

📈 Key Metrics & Concepts Analyzed

• SaaS Customer Churn: Identifying which subscription tiers or regions have the highest cancellation rates.
• Customer Support Load: Correlation between support tickets and customer retention.
• Plan Segmentation: Performance and revenue contribution of Basic vs. Pro vs. Enterprise plans.