Customer Shopping Behavior Analysis – Python - Pandas, SQL & Power BI Dashboard
Budget: ₹75,000 – ₹150,000 INR
Description:
I have a retail dataset with 3,900 customer purchase records and 18 columns including demographics, product details, and shopping behavior. I need a complete data analysis project that includes:
1. Data Cleaning (Python/Pandas):
Handle missing values in the Review Rating column
Rename columns, create age groups, and engineer new features
Connect to PostgreSQL database
2. SQL Analysis (PostgreSQL):
Revenue by gender and age group
Customer segmentation (New, Returning, Loyal)
Top products by rating and category
Subscription vs non-subscription spending comparison
Discount usage and impact analysis
3. Power BI Dashboard:
Interactive dashboard showing all key insights
Filters by category, gender, season, and subscription status
Deliverables:
Clean Python script
SQL queries with results
Power BI.pbix dashboard file
Short summary report of findings
Skills needed: Python, Pandas, PostgreSQL, Power BI, Data Analysis
I have a retail dataset with 3,900 customer purchase records and 18 columns including demographics, product details, and shopping behavior. I need a complete data analysis project that includes:
1. Data Cleaning (Python/Pandas):
Handle missing values in the Review Rating column
Rename columns, create age groups, and engineer new features
Connect to PostgreSQL database
2. SQL Analysis (PostgreSQL):
Revenue by gender and age group
Customer segmentation (New, Returning, Loyal)
Top products by rating and category
Subscription vs non-subscription spending comparison
Discount usage and impact analysis
3. Power BI Dashboard:
Interactive dashboard showing all key insights
Filters by category, gender, season, and subscription status
Deliverables:
Clean Python script
SQL queries with results
Power BI.pbix dashboard file
Short summary report of findings
Skills needed: Python, Pandas, PostgreSQL, Power BI, Data Analysis