A daily commodity price email that nobody has to send.
Zero Touch Commodity Delivery
Before
Daily manual extraction
Now
Zero touch delivery
The challenge
Key commodity, energy and raw material prices were extracted and calculated daily in Excel, then formatted into an email by hand before distribution.
What we built
Calculation moved to source in ZEMA, a Power BI semantic model built in Power Query reads the OData feed, and a scheduled Power Automate flow queries the dataset and generates a structured HTML email. Each commodity group gets its own table.
How it runs
- CalculateLoad shifted to source for speed and accuracy
- ModelPower Query semantic model reads the OData feed
- SendPower Automate builds and sends the HTML email
The result
- 0
- Manual interventions
- Modular
- Commodity groups added without rework
- Daily
- Guaranteed delivery
Built with
- ZEMA
- Power Query
- Power BI
- Power Automate
Run this in Energy & Renewables
The same Workflow & report automation build, scoped to your sources and your reporting lines.