LANGKAH 6: Sekarang suruh ChatGPT BINA dashboard terus

Create a complete professional Excel dashboard from the uploaded workbook. Use the cleaned dashboard-ready dataset and build the dashboard directly inside the Excel workbook. REQUIREMENTS DATA - Preserve the original da…

Create a complete professional Excel dashboard from the uploaded workbook.
Use the cleaned dashboard-ready dataset and build the dashboard directly inside the Excel workbook.
REQUIREMENTS
DATA
- Preserve the original dataset
- Use the cleaned Excel Table as the dashboard data source
- Do not invent any data
- Ensure calculations update correctly when data changes
DASHBOARD
Create a dedicated worksheet named 'Dashboard'.
Include:
1. Clear dashboard title
2. Reporting period
3. 4-6 important KPI cards
4. At least one time-trend visualization where date data exists
5. Category or segment comparison
6. Top/bottom performer analysis where relevant
7. Contribution or composition analysis where meaningful
8. Supporting summary table if useful
9. Filters or slicers for important dimensions where technically appropriate
VISUAL DESIGN
Use a clean, modern business dashboard style.
Maintain:
- consistent typography
- consistent number formatting
- clear information hierarchy
- adequate whitespace
- aligned dashboard elements
- readable chart titles
- minimal chart clutter
- professional formatting
Do not use:
- unnecessary 3D charts
- excessive colors
- decorative charts with no analytical purpose
- duplicated information
TECHNICAL QUALITY
Use appropriate Excel features such as:
- Excel Tables
- PivotTables
- PivotCharts
- slicers
- formulas
- conditional formatting
- dynamic ranges
Choose whichever method provides the most reliable and maintainable workbook.
FORMATTING
Apply suitable formats for:
- currency
- percentage
- whole numbers
- decimals
- dates
QUALITY CONTROL
Before finishing:
- verify every KPI
- verify chart sources
- verify totals
- verify formulas
- check filters
- check chart labels
- check for broken references
- check dashboard alignment
- check that no important information is hidden
Return the completed dashboard as a downloadable .xlsx file.
After creating it, briefly explain the dashboard sections and what each visualization shows.

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

More Data analysis prompts