← All work

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

  1. 01Mapped the data flows between all five platforms to find where records were being re-entered or lost.
  2. 02Built cross-system integrations and pipelines to move data automatically between departments.
  3. 03Replaced manual reporting with dashboards and scheduled reports.
  4. 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