Analytics · 2025
Cross-Platform Integrations
Utah State University
Data integrations and automated reporting built across five software systems at Utah State’s Analytics Solutions Center, leading a team of four analysts.
Problem
Departments ran on disconnected financial, clinical, and grant systems. Data moved by hand, definitions drifted between teams, and reporting was slow and inconsistent.
Approach
- 01Mapped the data flows between all five platforms to find where records were being re-entered or lost.
- 02Built cross-system integrations and pipelines to move data automatically between departments.
- 03Replaced manual reporting with dashboards and scheduled reports.
- 04Led four analysts through the rollout, splitting ownership by system.
Outcome
Data entry and reporting efficiency improved by 25%+, with cohesive, trustworthy data flow between departments.
Stack
- SQL
- Power Query
- Tableau
- Python