Customer Analytics Dashboard for Sales Data (Oct 2020 - Sep 2021)

Project Overview

This Power BI project provides comprehensive customer analytics for sales data from October 2020 to September 2021. The dashboard offers valuable insights into customer behavior, segmentation, and performance metrics to support data-driven decision-making in sales and marketing strategies.

Key Performance Indicators (KPIs)

• New Customers
• Recurring Customers
• Last Quarter Churn Rate
• Last Quarter Retention Rate
• Customer Lifetime Value (CLV)
• Average Revenue Per Person (ARPP)

Charts and Visualizations

1. Top 100 Customers
2. Total Customers Over Time (Line Chart)
3. Customer Loyalty Segments Based on Tenure
4. Average Revenue Per Person Trend
5. Geographical Segmentation
6. Total Revenue by Gender
7. Total Orders by Gender
8. Total Orders by Age
9. Total Revenue by Age
10. Customer Preferred Payment Methods (Pie Chart)
11. Customers by Category
12. RFM (Recency, Frequency, Monetary) Score Histograms
13. Relationship between Recency, Frequency, and Monetary Value
14. Monetary Value by RFM Customer Segments
15. Orders by RFM Customer Segments

Data Source

The data used in this project covers sales transactions from October 2020 to September 2021. Ensure that your data is in the correct format and up-to-date before using this dashboard.

Setup and Usage

1. Clone this repository to your local machine.
2. Open the .pbix file using Power BI Desktop.
3. Refresh the data source connection if necessary.
4. Interact with the visualizations to gain insights into customer behavior and performance.

Requirements

• Power BI Desktop (latest version recommended)
• Access to the sales data source