Descriptive Customer Demographic Analysis

Замовник: AI | Опубліковано: 14.11.2025

I have a raw set of customer records and I need a clear, descriptive breakdown of who these customers really are. The dataset is already in spreadsheet form but still messy in places, so the first step will be basic cleaning and validation. Once the data is reliable, I’d like you to run a full descriptive analysis that highlights age bands, location clusters, spending brackets, and any other demographic angles you notice. I’m comfortable if you work in Excel, Python (Pandas / NumPy), R, or another stats-friendly tool, as long as the final insights are easy for a non-technical stakeholder to read. Deliverables • A cleaned version of the original data (same column structure, missing values handled, obvious errors fixed). • A concise report or notebook that walks through the methodology and summarizes key demographic findings in plain language. • At least three clear visualizations—charts or dashboards—that illustrate the most important trends. I will share the file as soon as we start; feel free to suggest any additional fields that could strengthen the analysis before you begin.