A six hour daily reporting task now runs with zero human input.
Daily Price Movement Emailer
Before
6 hours, every day
Now
Zero manual steps
The challenge
Daily price movement reporting was built manually, reviewed manually and corrected manually. A Python script linked to the SQL platform had been tried first, but recurring breakages and a heavy dependency on coders for every small change made it unworkable.
What we built
A robust automated system built on low code tooling. Power Query and Power BI handle the data, Power Automate generates and sends the emailer, and stakeholders can adjust the report themselves without going back to a developer.
How it runs
- PullZEMA and Power Query ingest price data on schedule
- BuildPower BI assembles the daily movement view
- SendPower Automate delivers the emailer, ready to edit
The result
- 6 hrs
- Reclaimed every day
- Zero
- Specialist corrections needed
- 99%
- Accuracy
Built with
- ZEMA
- Power Query
- Power BI
- Power Automate
- SharePoint
Run this in Metals & Mining
The same Workflow & report automation build, scoped to your sources and your reporting lines.