Real-world dashboards, automation tools, and data workflows built to reduce manual work,
improve reporting accuracy, and turn messy operational data into usable systems.
PYTHON TOOLDEPLOYED
SDR Zip Sorter
Desktop automation tool for organizing state assessment files.
> Problem
District SDR assessment files required manual extraction and sorting across multiple
testing categories, creating repetitive work and inconsistent folder structures.
> Solution
Built a Python/Tkinter desktop tool that allows users to select an SDR ZIP file,
choose TestHound or ODS mode, select an output folder, and automatically sort files
into standardized folders with an unsorted file log.
Standardized SDR folder output for assessment workflows.
Created a simple GUI for non-technical users.
Generated logs for unsorted files and review.
POWER BIANALYTICS
Campus Snapshot Dashboard
Multi-year accountability and student demographic reporting.
> Problem
Campus leaders needed a fast way to view accountability ratings, enrollment,
demographics, and student group indicators without digging through multiple reports.
> Solution
Designed a Power BI dashboard that combines accountability rating history,
enrollment counts, grade-level distribution, demographic groups, and student support
indicators into one interactive campus view.
Power BIDAXData ModelingTEA AccountabilityOperational Reporting
> Impact
Created a single-page view for campus performance context.
Improved leadership access to accountability and demographic data.
Enabled filtering by student groups and campus indicators.
Supported data-informed conversations with campus teams.
POWER BIEARLY WARNING
Graduation Early Warning System
Operational dashboard for monitoring cohort progress.
> Problem
Graduation monitoring required visibility into student-level credit progress,
cohort status, campus distribution, and support indicators across multiple groups.
> Solution
Built an interactive Power BI dashboard to track cohort counts, credits,
grade-level distribution, EB and SPED indicators, ethnicity breakdowns, and student
detail records for intervention planning.
Power BIDAXStudent AnalyticsData ModelingExecutive Reporting
> Impact
Improved visibility into cohort progress and risk indicators.
Supported campus-level intervention planning.
Combined summary KPIs with student-level drilldown detail.
Helped transform static reports into an actionable monitoring tool.
