Energy — Coal Procurement & Commerce
Reduction in invoice processing / reconciliation time
Improvement from pricing optimisation
About
Apraava Energy's Commerce Department procures coal from multiple depots, each invoicing in its own format and on its own timeline. We streamlined invoice intake from the various coal depots, built an ETL pipeline taking raw procurement and coal-quality data through to a unified dashboard, and supported pricing optimisation — giving the team a single, current view of coal rate and grade changes across depots instead of reconciling it by hand.
Industry
Energy — Coal Procurement & Commerce
Company size
1,000+ employees
Founded
2020
The Company
A Commerce Department buying coal across multiple depots
Apraava Energy's Commerce Department procures raw coal from a network of depots to supply its generation assets. Each depot invoiced independently, in its own format, making it difficult to build a single, current view of pricing and quality across the network.
The challenge
Invoices and coal-quality data that never lined up
Invoices arrived from various coal depots in inconsistent formats, requiring manual reconciliation before the Commerce Department could see accurate landed pricing. Coal rate and grade data lived separately from the invoicing data, so spotting a shift in quality or price meant pulling numbers from multiple sources by hand.
The Solution
An ETL pipeline from raw depot data to a live pricing dashboard
We streamlined invoice intake from the various coal depots, built an ETL pipeline moving raw procurement and coal-quality data into a unified warehouse, and layered a dashboard on top so the Commerce Department can track coal rate and grade changes and support pricing optimisation from one current view.
The Results
A single, current view across every depot
The Commerce Department now tracks coal rate and grade changes across depots from one dashboard instead of reconciling invoices by hand, with pricing optimisation built directly on top of the unified data.
We finally have one number for what coal is costing us, instead of a dozen spreadsheets that never quite agreed.
Commerce Department, Apraava Energy
KEEP READING
Explore more studies on AI, analytics, and enterprise intelligence.
