← 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%+
Regional submissionsSharePointPython ETLPower BI
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