Excel Descriptive Analysis Dashboards

I have a dataset sitting in Excel and I need clear, insightful descriptive analysis that rolls up the key summary statistics into an interactive dashboard. Think averages, medians, counts, minimums-maximums and any other relevant metrics that let a non-technical stakeholder grasp the story at a glance.

Your task is to:

• Clean and structure the raw sheet if needed
• Run the full set of summary statistics using native Excel tools or Power Query / Power Pivot where useful
• Build a polished dashboard (slicers, pivot charts, conditional formatting – whatever makes the insights pop) that updates automatically when I refresh the data

While the core requirement is descriptive analysis, I’m open to light trend or distribution visuals if they enhance the view, so feel free to suggest creative touches.

Deliverables are the final Excel file with the dynamic dashboard plus a brief note explaining any formulas, pivot logic, or VBA you include so future updates remain painless.