Excel Customer Segmentation Analysis

via Freelancer ·

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.
visual basic data processing excel statistics data mining business intelligence data visualization data analysis
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.