Customer Purchase Patterns Excel Analysis

I have a batch of raw customer purchase records that must be keyed into a clean, well-structured Excel workbook and then analysed. Once the data is in place I need meaningful insights on purchase patterns, specifically: • how often each customer buys (frequency) • their average basket value • their product preferences Alongside the figures, I would like clear proof of the work inside the file itself—formulas left visible, pivot tables intact, and any charts or dashboards directly linked to the underlying data—so I can trace every total back to its source. A concise written summary of the findings in a final worksheet will round things off. If you are comfortable with Excel functions, pivot tables, and simple data-visualisation tools, this should be a straightforward project. Accuracy on data entry is critical; insightful, easy-to-read analysis is what will make the file truly useful to me.

Project ID: 40540006