Customer Satisfaction Data Analysis

I have an Excel workbook full of raw customer data and I need it turned into a clear customer-satisfaction report. The task is strictly data analysis and reporting: no data entry, no re-keying—just solid analytical work that helps me understand how happy (or unhappy) my customers really are.

Here is what I’m looking for:

• Clean and prep the customer records where needed so calculations are reliable
• Run a customer satisfaction analysis using Excel tools such as PivotTables, charts, formulas, or Power Query—whatever you prefer, as long as the steps are transparent
• Highlight key metrics: average satisfaction score, distribution of ratings, top pain points, recurring themes, and any noticeable trends over time
• Deliver a concise dashboard or summary sheet inside the same file plus a short written summary (PDF or separate sheet) explaining your findings and recommendations

Acceptance criteria
1. Calculations must reconcile with the source data (I’ll spot-check random rows).
2. All formulas remain editable; no hard-coded values unless clearly noted.
3. Visuals are easy to read and print on A4 without manual adjustment.

If you’re comfortable digging into customer data and presenting insights in a straightforward way, I’d love to see how you would approach this job.