Student Performance Cohort Analysis with Advanced Segmentation

Design a dynamic Excel workbook that tracks student performance cohorts across multiple academic years, using advanced pivot tables and Power Query. Create a sophisticated segmentation model that automatically classifies students into performance tiers (high achievers, at-risk, average) based on weighted academic indicators. The model should include conditional formatting to highlight trends, with the ability to drill down into granular performance metrics by grade level, subject, and demographic characteristics. Include a predictive component that forecasts potential academic interventions using regression analysis techniques.