Attendance Data Reporting

End to end ETL attendance staff data reporting on a weekly, monthly, and quarterly cadence.

FY 24 Actuals

Importing FY 24 expenses from a PDF using the tabula-py package, aggregating by campus, and creating a Sankey diagram using the matplotlib.pyplot Sankey package

Budget Balance Tracking

Data extraction, cleaning, and manipulation to track budget line items and campus budgets from PDFs exported from accounting software using the tabula-py package.

Alma Data Pipeline

Establishing an API connection with Alma to perform ETL and create a data pipeline to BigQuery to automate reporting workflows.