← Back to Portfolio
📊

English Learner Outcomes Analysis

Data Analysis • Machine Learning • Education Research

Comprehensive longitudinal analysis examining how English Learner status and program duration impact various high school outcomes. This multi-year study tracks 2,800+ students across five years, providing critical insights for district equity initiatives.

SQL R ggplot2 Statistical Analysis Data Visualization
Key Impact
  • Informed superintendent-level policy decisions on EL support services
  • Identified gaps in acadmeic outcomes between EL categories
  • Presented findings to school board for resource allocation
View Interactive Dashboard →
📈

COVID-19 Taskforce Analytics

Public Health • Data Visualization • Executive Reporting

Led data infrastructure for state Department of Health COVID-19 response, creating real-time executive dashboards and automated survey systems. Supported critical public health decision-making during pandemic response.

Tableau Python Qualtrics SQL Server Survey Design
Key Achievements
  • Delivered real-time dashboards to DHS executive leadership
  • Automated daily data collection across 50+ facilities
  • Reduced reporting lag from 48 hours to 4 hours
  • Supported resource allocation decisions affecting 3M+ residents
🔄

Assessment Data Pipeline & Automation

Data Engineering • ETL • Workflow Automation

Automated ETL pipeline connecting multiple assessment systems (ACT, state tests, interim assessments) to district data warehouse. Processes 50,000+ test records annually with data quality validation and error handling.

SQL Server R Excel Integration ODBC Data Quality
Key Impact
  • Reduced manual data entry from 40+ hours to zero per cycle
  • Eliminated data transcription errors (previously 3-5% error rate)
  • Enabled same-day reporting for assessment results
  • Created reusable workflow now used across 5 assessment types