BUILD COMPLETE DASHBOARD

Act as a senior education data analyst and Excel dashboard developer. Using the uploaded cleaned student dataset, create a complete professional Student Performance Dashboard as a downloadable .xlsx file. Do not explain…

Act as a senior education data analyst and Excel dashboard developer. Using the uploaded cleaned student dataset, create a complete professional Student Performance Dashboard as a downloadable .xlsx file.
Do not explain how to build it. Create the actual workbook. Use only data available in the file. Do not invent marks, grades, pass thresholds, assessment weights, student information, or academic rules.
OBJECTIVE
The dashboard must show: overall class performance, performance by subject, performance of each student, student vs class average, highest and lowest scoring areas, and trends if multiple assessments exist.
WORKBOOK
Create where appropriate: Dashboard, Student_Dashboard, Subject_Analysis, Cleaned_Data, and Helper_Data.
MAIN DASHBOARD
Create available KPI cards for Total Students, Total Subjects, Class Average, Highest Score, Lowest Score, and Pass Rate if valid criteria exists.
Create an Overall Subject Performance chart showing the average score for every subject.
Where supported by the data, also show subject average, highest score, lowest score, median, student count, and pass rate.
STUDENT DASHBOARD
Create ONE interactive dashboard with a dropdown to select any student.
When a student is selected, automatically update: Student Name, Overall Average, Highest Subject Score, Lowest Subject Score, Total Subjects, Class Average, Difference From Class Average, and Rank if fairly calculable.
Create a chart comparing the selected student's score against the class average for every subject.
If multiple assessment periods exist, add a performance trend chart.
SUBJECT ANALYSIS
Create a summary table for every subject showing available metrics such as Average, Highest, Lowest, Median, Student Count, and Pass Rate.
Add only useful charts and avoid redundant visuals.
AUTOMATIC INSIGHTS
Where possible, automatically identify the student's highest-scoring subject, lowest-scoring subject, subjects above class average, and subjects below class average.
Keep all insights strictly data-driven. Do not make psychological, behavioural, intelligence, or learning-disability conclusions from marks.
INTERACTIVITY
Use reliable Excel features such as Excel Tables, formulas, PivotTables, PivotCharts, named ranges, dynamic references, and data-validation dropdowns. Use slicers only if they can be implemented reliably.
DESIGN
Use a clean, modern, professional education-dashboard design with readable fonts, clear KPI cards, consistent spacing, concise chart titles, and logical grouping.
Avoid 3D charts, excessive colors, clutter, tiny text, unnecessary borders, and misleading chart scales.
QUALITY CHECK
Before delivery, verify that all valid students and subjects are included, averages are correct, the dropdown works, student charts update correctly, chart ranges are accurate, no valid data is missing, and no #REF!, #DIV/0!, #VALUE!, or #N/A errors remain.
FINAL DELIVERABLE
Return the completed .xlsx workbook.
The teacher must be able to open it, view overall class performance, compare subjects, select any student, and instantly compare that student's results with class averages.
Briefly state the sheets created, analyses included, interactive controls added, and any limitations caused by missing data.
Do not provide instructions, mockups, or sample code. Build the actual dashboard and provide the finished Excel file for download.

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

More Data analysis prompts