Excel Customer Segmentation Analysis
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted41 minutes ago
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.
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.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.