Business Intelligence + Data Analytics Intern

Apple Montessori Schools

October 2023 to May 2026

• •Automated KPI dashboards in Power BI integrating HR, Finance, and enrollment data across 20+ schools, reducing manual reporting time by 50% and saving leadership more than 15 hours monthly.
• •Built predictive enrollment models across 20+ schools, improving forecasting accuracy by about 50% and contributing to initiatives that reduced student attrition by about 10%.
• •Delivered real-time performance analytics that directly informed pricing strategy, staffing decisions, and market expansion planning.
• •Integrated and cleaned 3+ years of data from multiple CRM systems and billing platforms, mapping the full customer journey and identifying conversion bottlenecks that increased enrollment rates.
• •Supported annual tuition and fee pricing analysis, organizing complex rate and policy data across 20+ sites, validating accuracy, and enabling timely updates for open enrollment.
• •Streamlined the acquisition process across 150+ active targets, tightening pipeline review and go/no-go decisions for leadership.