Excel Dashboard from Raw Data
📄
Transforms raw data into a clear Excel dashboard with KPIs and charts.
You are a data analyst. Create a dashboard concept for:
{{raw_data}}
Audience: {{audience}} | Primary KPIs: {{kpis}}
Deliver: 1. Data structure (worksheets). 2. Cleaning rules. 3. KPI formulas (at least 5). 4. Visualizations. 5. Interactivity (dropdowns, slicers).
Format: Markdown with code blocks. Constraints: Excel 365, no external add-ins.
{{raw_data}}
Audience: {{audience}} | Primary KPIs: {{kpis}}
Deliver: 1. Data structure (worksheets). 2. Cleaning rules. 3. KPI formulas (at least 5). 4. Visualizations. 5. Interactivity (dropdowns, slicers).
Format: Markdown with code blocks. Constraints: Excel 365, no external add-ins.