📌 AI-Driven-Customer-Value-Intelligence

Interactive Power BI dashboard and Python pipeline for customer value analytics.

Power BI · Python · Data Analytics · Customer Insights

This project is an end-to-end customer analytics and business intelligence solution built using Python (Pandas) and Power BI. It uncovers revenue trends, customer behavior, city performance, payment patterns, and loyalty insights using a fully interactive dashboard.

🚀 1. Project Overview

The goal of this project was to analyze 5,000+ e-commerce transactions and create an intelligent dashboard that helps businesses answer:

Which categories generate the most revenue?

How does monthly revenue trend change?

Which customers contribute the most?

Which cities perform better?

What payment methods do customers prefer?

How many customers are repeat buyers?

This dashboard helps business teams make data-driven decisions using AI-assisted insights.

🧹 2. Data Cleaning & Preparation (Python)

Performed using Pandas & Numpy:

Removed invalid order dates

Filled missing values (mode/median imputation)

Standardized category & payment names

Corrected negative/incorrect values

Converted monetary values to ₹ INR

Created new metrics (frequency, recency, monetary)

Ensured correct data types

Final cleaned dataset: 📄 AI-Driven_Customer_Value_Intelligence_dataset.csv

📊 3. Power BI Dashboard Features ✔ KPI Cards

Total Revenue

Total Orders

Average Order Value

Unique Customers

Repeat Customers

✔ Visualizations

Revenue by Category (Bar chart)

Revenue Trend Over Time (Line chart)

City-wise Revenue Heatmap (Map visual)

Payment Method Distribution (Donut chart)

Top Customers Table (ID, Revenue, Frequency)

✔ Interactivity

Date Range Slicer

Category Slicer

City Slicer

“Clear All” Reset Button

✔ Theme

Premium Black & Gold UI

Rounded cards

Subtle shadows

Professional layout

🔍 4. Key Insights 📈 Revenue

Total revenue: ₹165M

Fashion & Grocery generate highest sales

Electronics has high-ticket orders but lower frequency

👥 Customer Behavior

Unique customers: 1847

Repeat customers: 1427 → strong loyalty

Average order value: ₹33K

🗺 City Performance

Mumbai, Chennai, Hyderabad → top revenue cities

Bangalore & Delhi → moderate performers

Big opportunity in emerging large cities

💳 Payment Patterns

UPI & Cards are most preferred

COD very low → trusted digital customer base

📅 Seasonality

Revenue peaks in January & August

Slower months: March–May

🎯 5. Business Recommendations

Boost marketing in Mumbai, Chennai, Hyderabad

Engage repeat customers with loyalty programs

Push high-margin electronics in slow months

Improve presence in Bangalore/Delhi

Add UPI/Card cashback offers to increase conversion

🛠 6. Tools & Technologies Purpose Tools Data Cleaning Python (Pandas, Numpy) BI Dashboard Power BI Visualization Maps, Bar, Donut, Line Exploration Excel Pivot, EDA Deployment GitHub 📂 7. Project Structure AI-Driven-Customer-Value-Intelligence/ │ ├── 📁 dataset/ │ ├── AI-Driven_Customer_Value_Intelligence_dataset.csv # Final cleaned dataset │ ├── AI-Driven Customer Value Intelligence project.csv # Supporting dataset (preview/export) │ └── AI-Driven_Customer_Value_Intelligence_metadata.json # Metadata & schema info │ ├── 📁 notebooks/ │ └── AI-Driven Customer Value Intelligence project.ipynb # Python cleaning & EDA notebook │ ├── 📁 dashboard/ │ └── AI-Driven Customer Value Intelligence.pbix # Power BI interactive dashboard │ ├── 📁 images/ │ └── AI Driven Customer Value Intelligence Dashboard.png # Final dashboard screenshot │ ├── README.md # Project explanation & insights └── LICENSE (optional)

📸 8. Dashboard Preview ![Dashboard Preview]

🧠 9. Learning Outcomes

Data cleaning & preparation

Exploratory data analysis

KPI design & business thinking

Power BI dashboard building

Storytelling with data

Customer analytics (RFM concepts)

Portfolio-ready BI development

🤝 10. Connect With Me

Kartik Kolhe | AI & Data Analytics Learner Power BI | Python | SQL | Dashboarding