Seven Billion AnalyticsContact Us
Client logo

Energy

Coal Invoicing Dashboard for a Power Company

Coal Invoicing Dashboard for a Power Company

72%

72%

Reduction in invoice processing / reconciliation time

100%

100%

Improvement from pricing optimisation

52%

Coal depots consolidated into the unified dashboard

Automating coal tariff lineage and multi-depot price reconciliations gave our operations and finance teams total clarity.

Dinesh Singh Lodhi

Commerce Department

Apraava Energy

Client logo

About

An Indian power generation company cut coal invoice reconciliation time 72% with one ETL dashboard tracking coal invoices, rates and grades across its depots.

Industry

Energy

Company size

1,000+ employees

Founded

2020

Business Context

Business context and operating model

A Commerce Department buying coal across multiple depots The client'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.

Problem Definition & Framework

Current State

Failure Modes

Decision Criteria

KPI Baseline

Problem definition and framework

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.

  • Decision framed: How can depot invoices, coal quality data, and pricing changes be reconciled into one current view for commerce and procurement decisions?

  • Framework used: Procurement data lineage, invoice reconciliation, and coal grade/rate exception taxonomy

  • Baseline mapped: current process, failure modes, handoffs, data owners, and decision latency.

  • Success criteria tied to business KPIs, adoption behavior, and operating cadence changes.

How it works

Before / After

var(--variable-hWXsjrXo2)

Architecture

var(--variable-bl988V6Ac)

Process Flow

Data Pipeline

Results

var(--variable-hSfiUIv6W)

Delivery Timeline

Engagement Method & Process Diagram

01 Discovery

02 Data Audit

03 Baseline

04 Prototype

05 Pilot

06 Production

07 KPI Monitoring

Engagement method and process diagram

  • Process diagram: Depot invoices + coal-quality data + procurement records -> ETL normalization -> reconciliation checks -> pricing/grade dashboard -> exception review -> pricing optimization support

  • Engagement method: Invoice format inventory; depot-data mapping; ETL and validation rules; pricing dashboard design; exception workflow; commerce-team adoption review.

  • Delivery pattern: discovery, data audit, baseline measurement, prototype, pilot workflow, production rollout, and KPI monitoring.

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.

Architecture, Results & Measurement

Solution architecture, results, and measurement

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.

  • Measured outcome: 72%: Reduction in invoice processing / reconciliation time

  • Measured outcome: 100%: Improvement from pricing optimisation

  • Measured outcome: 52%: Coal depots consolidated into the unified dashboard

  • Measurement loop: compare weekly operating behavior against baseline, surface exceptions, and review model/workflow drift with business owners.

We finally have one number for what coal is costing us, instead of a dozen spreadsheets that never quite agreed.

Commerce Department, Indian power generation company

KEEP READING

See How Other Teams are

Winning with Seven Billion

See How Other Teams are

Winning with Seven Billion

Explore more studies on AI, analytics, and enterprise intelligence.

The lowest-risk way to find out if AI is right for your business.

Phase 0 is a two-week discovery that tells you exactly which problems AI can solve, what it will take to build, and what it will cost. No obligation beyond it.

ABOUT Seven Billion

Seven Billion is an Applied AI company — a team of data scientists and AI engineers who build and deploy AI systems that run in production.

OFFICE

World Tech 83, First Floor, IT City, Mohali 140603

Intelligence that delivers starts here.

Whether you are mapping your first AI use case or scaling AI across the enterprise, we will help you cut through the noise and build something that actually ships.

ABOUT Seven Billion

Seven Billion is an Applied AI company — a team of data scientists and AI engineers who build and deploy AI systems that run in production.

OFFICE

World Tech 83, First Floor, IT City, Mohali 140603

The lowest-risk way to find out if AI is right for your business.

Whether you are mapping your first AI use case or scaling AI across the enterprise, we will help you cut through the noise and build something that actually ships.

ABOUT Seven Billion

Seven Billion is an Applied AI company — a team of data scientists and AI engineers who build and deploy AI systems that run in production.

OFFICE

World Tech 83, First Floor, IT City, Mohali 140603