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 address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

用 HomepageTab 新标签页关注 RSS,打开浏览器就能看到更新。

安装 HomepageTab