Excel Customer Segmentation Analysis
₹100-150 INR / hour
Posted 1 minute ago
•
Ends in 6 days
₹100-150 INR / hour
I have a sales-and-customer spreadsheet that needs to be transformed into clear, data-driven insights. The priority is understanding customer groups and their buying habits so I can target promotions and stock more effectively—all inside Excel, no external BI tools required. You’ll start by tidying the file: remove duplicates, standardise dates, fix inconsistent product names, and generally make the data analysis-ready. From there, build an Excel-based model (Power Query, PivotTables, dynamic formulas—whatever you prefer) that automatically clusters customers by behaviour: purchase frequency, average basket value, product affinity, and recency. Deliverables • A cleaned, well-structured workbook ready for ongoing use. • Dynamic segmentation logic that updates when new transactions are added. • Visual summaries—pivot charts, conditional-format heat maps, or similar—that highlight each customer group’s key metrics at a glance. • An in-workbook note explaining the methodology and refresh steps. Acceptance criteria • No formula or refresh errors when opened in Excel 365. • Segments recalculate correctly after I paste in fresh data. • Insight figures match manual spot-checks within a 2 % tolerance. Share examples of similar Excel data-mining projects you’ve handled, and let’s turn this raw sales file into actionable customer insight.
Project ID: 40827534
About the project
Open for bidding
Remote project
Active 57 yrs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗