Challenge
Important operating data was locked inside an ERP without a public API.
Solution
We developed an automated data collection and transformation workflow feeding management dashboards.
Outcome
A consistent reporting system with automatically refreshed business metrics.
Under the hood
An unattended Playwright job signs in to the ERP, extracts the data every day, and cleans it with pandas before a Flask app serves the dashboards. Leadership opens them without asking anyone for an export.