Customer Shopping Behavior Analysis – Python - Pandas, SQL & Power BI Dashboard
Summary
Freelancer Client is hiring: Customer Shopping Behavior Analysis – Python - Pandas, SQL & Power BI Dashboard.
Location: Remote
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:
Skills needed: Python, Pandas, PostgreSQL, Power BI, Data Analysis
Skills: Python, SQL, PostgreSQL, Data Analysis, Power BI, Pandas
Budget: $75000–$150000 USD
Source: Freelancer Client via Remote / Online. Apply on the source website.
Original
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
Location & Details
Apply on source →About this listing
This remote opportunity was imported from Freelancer and is shown here for discovery. To apply, follow the link to the original posting.