Student Performance Predictive Cohort Analysis Dashboard

Design an advanced Excel dashboard that tracks student performance predictive metrics across multiple cohorts, integrating conditional formatting and custom VBA macros. The dashboard should incorporate historical academic data, standardized test scores, attendance records, and predictive risk algorithms to identify students likely to underperform. Include dynamic visualization techniques that allow administrators to drill down into granular performance segments, with automated color-coded risk stratification from green (low risk) to red (high intervention needed).