Power BI dashboard analyzing customer retention using cohort analysis and lifecycle decay trends. 📊 Customer Cohort Retention Analysis Dashboard

🔎 Project Overview

This project presents a Customer Cohort Retention Analysis built using Power BI to analyze customer behavior over time. The dashboard identifies retention trends, lifecycle decay patterns, and cohort performance to help understand long-term customer engagement.

🎯 Business Objective

The goal of this analysis is to: Measure customer retention across acquisition cohorts Identify retention decay over lifecycle months Compare cohort sizes over time Provide insights into long-term customer engagement

This helps businesses: Evaluate customer loyalty Detect churn patterns Improve acquisition strategy Optimize retention initiatives

🛠 Tools & Technologies Used Power BI DAX (Data Analysis Expressions) Data Modeling Cohort Analysis Techniques Interactive Slicers & Visualizations

📌 Key Metrics (KPIs)

Average Retention % Total Customers New Customers (Acquisition Month) Total Cohorts

📈 Dashboard Components 1️⃣ Cohort Retention Heatmap

Visual representation of customer retention percentage by acquisition month and lifecycle month. 2️⃣ Retention Decay Curve

Line chart showing how retention declines over lifecycle months. 3️⃣ Cohort Size Distribution

Column chart displaying customer acquisition volume by cohort month. 4️⃣ Interactive Cohort Filter

Dropdown slicer allowing dynamic cohort-level analysis. 💡 Key Insights

Retention drops sharply after initial lifecycle months. Later cohorts show variation in early-stage retention. Cohort sizes fluctuate across acquisition months. Long-term retention stabilizes at lower percentages.