Sales Analysis

This customer analytics project analyzes e-commerce customer behavior, retention, and lifetime value (LTV) using PostgreSQL to uncover actionable business insights. The analysis focuses on customer segmentation, cohort performance, and churn detection to identify high-value customers, revenue trends, and retention challenges. By applying SQL queries and cohort analysis techniques, the project reveals that a small percentage of customers generate the majority of revenue, while retention rates remain consistently low across cohorts. The project provides strategic recommendations such as loyalty programs, personalized promotions, and proactive churn prevention strategies to help businesses improve customer retention and maximize long-term revenue growth.