CREATE_CHART

2023 Education Sector Performance Radar: Student Flow & Retention Metrics

Description

Evaluate 4 education subsectors (Basic, Vocational, Higher, Continuing Education) across 6 key metrics (2023 Student Flow, 2023 Retention Rate,2022-2023 Flow Growth, 2022-2023 Retention Change, 3-Year Avg Flow, 3-Year Avg Retention) for 2023. Identify high-performing subsectors and areas requiring intervention in student mobility and retention.

Input Settings

Action: chartDeep Think: false

Recommended Prompt

Create a radar chart using Education_Data_Table.xlsx.
Filter to Target_Year = 2023.
Use exactly these 4 subsectors as comparison groups (do not auto-select): Basic Education, Higher Education, Continuing Education, Special Education.
Use only existing columns from the table as radial axes:

Student_Flow (scale 0–15000)
Retention_Rate (scale 0–100)
Flow_Level mapped to numeric (Excellent=4, Good=3, Fair=2, Needs Improvement=1; scale 1–4)
Retention_Level mapped to numeric (same mapping; scale 1–4)
Do not create or infer any additional metrics such as Growth/Change or Avg metrics.

Sample Datasets

Education_Data_Table.xlsx

6.10 KB