Student Performance Correlation Dashboard with Dynamic Pivot Analysis

Design a comprehensive SQL-driven spreadsheet dashboard that correlates student performance metrics across multiple academic years. Create a dynamic pivot table that can automatically calculate grade distributions, standardized test score progressions, and departmental performance variations. The solution should include conditional formatting to highlight statistical outliers, with the ability to filter by grade level, subject, and demographic characteristics. Implement a nested query approach that allows drill-down capabilities and generates actionable insights for curriculum development.