LANGKAH 5: Minta ChatGPT rancang layout dashboard

Design a professional one-page Excel dashboard layout based on the uploaded dataset and recommended KPIs. Create a clear visual hierarchy. Suggested structure: TOP SECTION: - Dashboard title - reporting period - importa…

Design a professional one-page Excel dashboard layout based on the uploaded dataset and recommended KPIs.
Create a clear visual hierarchy.
Suggested structure:
TOP SECTION:
- Dashboard title
- reporting period
- important slicers or filters
KPI SECTION:
- 4 to 6 KPI cards showing the most important metrics
ANALYSIS SECTION:
- primary trend chart
- category or segment comparison
- performance ranking
- contribution or composition analysis
INSIGHT SECTION:
- key observations
- exceptions
- areas requiring attention
BOTTOM SECTION:
- supporting detail or summary table if useful
For every dashboard element, specify:
- exact purpose
- metric shown
- recommended chart type
- X-axis
- Y-axis
- series
- filters
- placement
- approximate size
- reason for choosing that visualization
Avoid redundant charts, 3D charts, decorative elements that add no analytical value, and excessive colors.

Exact prompt text captured from the public post/author comments on facebook.com/kelasmultimediaofficial. · Attribution: Kelas Multimedia

More Data analysis prompts