Dynamic Student Performance Tracking Pivot Dashboard

Create an advanced Excel dashboard that dynamically tracks student performance across multiple dimensions using nested pivot tables and Power Query. The dashboard should automatically update when new grade data is imported, with conditional formatting that highlights performance trends, calculates cumulative GPA, and generates visual performance comparisons by subject, semester, and individual student progression. Include data validation rules to prevent manual entry errors and develop a macro that can generate automated summary reports for academic administrators.