CLIENT
Meridian Resource Partners
INDUSTRY
Minerals
THE CHALLENGE
Data everywhere, insight nowhere
No single source of truth — price, production, and supply exposure data for Lithium, Graphite, Manganese, and Cobalt lived across exchange feeds, trade reports, and individual mine disclosures
Manual rebuild every cycle — analysts recreated the same spreadsheet each reporting period instead of working from a shared source
Hidden concentration risk — without a purpose-built view, a single country or supplier dominating a commodity's output was easy to miss until it became a problem
OUR APPROACH
One warehouse, one source of truth
Unify the data
A Python pipeline ingests and standardizes every regional feed into one clean, reconciled dataset.
THE PLATFORM
Built on Snowflake, delivered in Power BI
Three-layer Snowflake warehouse — a raw landing zone mirroring source structure, a core star schema built around commodity, geography, and supplier dimensions, and a reporting schema exposing only pre-aggregated, business-ready views
DirectQuery to Power BI — Power BI connects live to the reporting schema through a read-only service role, so the semantic model never touches raw or core data
Built-in risk scoring — report measures include year-over-year price movement and a Herfindahl-Hirschman Index (HHI) reading on supply concentration, replacing ad hoc "looks concentrated" judgment calls with a standard, defensible metric
THE OUTCOME
Built-in risk visibility
Always-current reporting — DirectQuery means the report reflects the latest data load with no separate refresh schedule to manage or monitor
One source of truth — a single governed warehouse replaces scattered exchange feeds, trade reports, and manual spreadsheet rebuilds every cycle
Faster analyst turnaround — pre-aggregated reporting views mean the same data question that took a spreadsheet rebuild now takes a filter click
Faster, more confident decisions
Standardized risk read — the HHI-based concentration score gives procurement and strategy teams a shared, repeatable number to discuss instead of competing spreadsheet interpretations
Cycle-over-cycle consistency — the same reporting views are used every period, so comparisons are apples-to-apples rather than rebuilt from scratch
A foundation that grows
Add commodities without rework — new minerals, geographies, or supplier feeds slot into the existing raw → core → reporting layers
Governance built in from day one — access control and schema separation don't need to be retrofitted as the warehouse grows
WALKTHROUGH
Inside the dashboard
The live dashboard opens on a market overview tracking Lithium, Graphite, Manganese, and Cobalt side by side, with indexed price trend lines for each commodity.
TESTIMONIALS
The team truly exceeded all my expectations.
IT & Innovation Leader
British Multinational Consumer Goods Company
RUSA Analytics gave us visibility we never had before. Their demand forecasting model cut our overstock by 31% in the first quarter alone. The team is deeply embedded in retail operations — they don't just deliver dashboards, they deliver outcomes.
Head of Supply Chain Analysis
Pan-India Retail Chain
We evaluated three vendors before choosing RUSA. Their risk modeling framework was the only one that could handle our data complexity without a 12-month implementation. We were live in 8 weeks and the fraud detection accuracy exceeded our internal benchmarks.
Chief Risk Officer
Leading Private Sector Bank
MORE WORK
Explore other case studies
