Student Performance Predictive Cohort Analysis Dashboard

Design an advanced Excel dashboard using Power Query and dynamic pivot tables that tracks student cohort performance across multiple academic years. The dashboard should automatically segment students by admission year, program, and demographic characteristics, with predictive trend analysis for early intervention. Include conditional formatting to highlight at-risk student groups, and create a VBA macro that generates automated quarterly risk assessment reports. Incorporate machine learning-inspired prediction formulas to estimate future academic outcomes based on historical performance data.