LANGKAH 9: Minta ChatGPT audit dashboard yang dah siap

Perform a final quality-assurance audit on the completed Excel dashboard. Check: DATA ACCURACY - KPI calculations - totals - averages - percentages - date calculations - ranking logic EXCEL LOGIC - formulas - PivotTable…

Perform a final quality-assurance audit on the completed Excel dashboard.
Check:
DATA ACCURACY
- KPI calculations
- totals
- averages
- percentages
- date calculations
- ranking logic
EXCEL LOGIC
- formulas
- PivotTable sources
- PivotChart sources
- slicer connections
- broken references
- dynamic ranges
VISUALIZATION
- correct chart selection
- accurate axes
- readable labels
- misleading scales
- duplicated information
- unnecessary chart elements
DESIGN
- alignment
- spacing
- hierarchy
- number formats
- consistency
- readability
USABILITY
- filters work
- dashboard is understandable without explanation
- important insights can be identified quickly
Fix any issues you find.
Do not change correct calculations merely for cosmetic reasons.
Return the final corrected .xlsx workbook and summarize the issues that were fixed.

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

More Data analysis prompts