Interactive Student Performance Predictive Dashboard with Machine Learning

Design a multi-sheet Google Sheets dashboard that uses predictive analytics to forecast student performance based on historical academic data. Implement advanced regression models using Apps Script that dynamically update predictions as new grade inputs are received. Include confidence intervals, feature importance visualization, and automated early intervention flags for at-risk students. The solution should handle complex data transformations, integrate machine learning algorithms, and provide actionable insights for academic administrators.