Dynamic Student Performance Tracking Pivot Dashboard

Create an advanced Excel dashboard that automatically tracks student performance metrics across multiple academic years using Power Query and dynamic pivot tables. The dashboard must integrate data from various sources (student information system, learning management system, and standardized test databases), with automated data refresh capabilities. Design conditional formatting to highlight performance trends, including color-coded cells for achievement levels, trend sparklines for individual student progress, and built-in VBA macros to generate executive summary reports. Include functionality to drill down from school-wide metrics to individual student performance, with the ability to filter by grade level, subject, demographic groups, and academic years.