I will do customer segmentation and rfm analysis with a dashboard
Data Analyst Data Cleaning EDA and Dashboards
About this Gig
Do you know which customers actually drive your revenue?
Most businesses spend marketing budget evenly across all customers but usually a small group generates most of the sales. I help you find that group.
I turn your raw sales/transaction data into a clear RFM (Recency, Frequency, Monetary) customer segmentation, so you know exactly who to keep, win back, and stop wasting money on.
What you get:
* Clean, deduplicated data (returns and cancellations handled correctly)
* RFM scoring and clear, labeled customer segments (Champions, At Risk, Lost, etc.)
* An interactive Looker Studio dashboard you can filter and explore
* A short written summary of key findings and what to do next
Why me:
I don't just build segments I check that they actually predict future behavior, so your decisions rest on solid data, not guesses.
What I need from you:
A CSV/Excel file with customer ID, order date, and order amount. That's enough to start.
Tools: Python (pandas), SQL, Looker Studio.
Message me before ordering if you're not sure which package fits happy to help.
My Portfolio
Other Data Analytics Services I Offer
FAQ
What data do you need from me?
A CSV or Excel file with at least three columns: a customer ID, an order/purchase date, and an order amount. If your data is messier than that, no problem — send it and I'll tell you if it works.
I don't have Looker Studio. Can I still use the dashboard?
Yes. Looker Studio is free and works in your browser. I'll share the dashboard with you and can walk you through how to open and filter it.
Is my data kept private?
Absolutely. Your data is used only for your project and never shared. I can delete it after delivery on request.
Which package should I choose?
Basic is best if you just want the segmentation and a summary. Standard adds the full interactive dashboard. Premium includes data cleaning plus written insights and recommendations. Not sure? Message me and I'll help you pick.

