Excel-Based Customer Predictive Analysis
Budget: ₹12,500 – ₹37,500 INR
I have a raw customer dataset that needs to be transformed into clear, forward-looking insight. Using Excel as your main workspace, I want you to clean the data, build an appropriate predictive model, and present findings that help me anticipate future customer behaviour—think churn likelihood, purchase propensity, or lifetime value, depending on what the patterns suggest.
The finished workbook should be fully self-contained: organised data sheets, transparent calculations, scenarios or what-if analysis where relevant, and easy-to-read charts that illustrate the key drivers behind the predictions. A short narrative summary inside the file (or as a separate page) explaining your approach, assumptions, and the practical meaning of the results will round it out.
Accuracy, clarity, and a structure I can follow and tweak later are essential. If you enjoy pushing Excel’s analytical limits with functions, PivotTables, regression tools, or add-ins like Solver, this will be a straightforward yet interesting project.
The finished workbook should be fully self-contained: organised data sheets, transparent calculations, scenarios or what-if analysis where relevant, and easy-to-read charts that illustrate the key drivers behind the predictions. A short narrative summary inside the file (or as a separate page) explaining your approach, assumptions, and the practical meaning of the results will round it out.
Accuracy, clarity, and a structure I can follow and tweak later are essential. If you enjoy pushing Excel’s analytical limits with functions, PivotTables, regression tools, or add-ins like Solver, this will be a straightforward yet interesting project.