← All Work

Healthcare

Automated KPI Reporting Workflow

Submission, transformation and reporting connected into one automated workflow across 50 markets and 10 brands.

Company
Lynx Analytics
Year
2023
Role
Designed and built end-to-end
Result
95%+

The Problem

Spreadsheets everywhere.

Regional leaders submitted patient-model KPIs as multiple Excel files; consolidating them was slow and manual.

What I Built

One connected workflow.

Power Apps submission interface into SharePoint; Power Automate + Python ETL; Power BI auto-refresh.

The Outcome

95%+ less time.

95%+ less submission and extraction time.

Power Apps · Python · Power BI