Grid View

A pivot table for mining data. Fix one dimension — company, KPI, or time period — and see everything else in a dense, scannable matrix.

Concept

Three dimensions, fix one

Mining data has three dimensions: which company, which metric, and which time period. The Grid locks one of these three and spreads the other two across rows and columns. This creates a dense matrix where patterns jump out visually — especially with the heatmap turned on.

Three Modes

Fix Company, Fix KPI, Fix Period

1

Fix Company

Rows = KPIs · Columns = Years

Select a single company — say Newmont (NEM). The grid shows every KPI that company reports as rows, and every year as columns. Each cell contains the year-over-year percentage change. At a glance, you see the full operational story: production going up while costs go down, or grade declining while throughput compensates. Everything about one company, in one view.

Each KPI in the sidebar has an expandable dropdown showing the definition names that company uses. Click a specific definition to filter to just that methodology — useful when a company has changed how it calculates AISC over time.

2

Fix KPI

Rows = Companies · Columns = Years

Select a single KPI — say gold production. The grid shows every company that reports gold production as rows, with each year as a column. This is the cross-company comparison view: which companies grew production in 2023 while others contracted? Where did the industry diverge?

3

Fix Period

Rows = Companies · Columns = KPIs

Select a single comparison period — say 2023 to 2024. The grid shows every company as rows and every selected KPI as columns. This is the snapshot view: for one year of change, see every metric for every company. Who had a good 2024 across the board? Who improved on costs but lost on production?

Visualization

Heatmap and absolute values

Toggle the heatmap to color every cell on a green-to-red gradient based on the percentage change value. Patterns emerge instantly: a column of green cells tells you an entire industry had a good year. A row of red tells you one company struggled across every metric.

Toggle absolute values to see the raw numbers alongside the percentages. Each cell can show both “+12.4%” and the underlying “5,900 koz” so you understand both the magnitude of change and the scale of the company.

Window Metrics

Summary statistics per row

Each row in the grid has optional summary columns computed across the visible year range:

Avg YoY%

The mean of all year-over-year changes in the visible range. Shows the average annual growth rate.

Consistency

The percentage of years that showed improvement. 100% means the company improved every single year in the range.

Acceleration

The difference between the most recent YoY% and the previous one. Positive means improvement is speeding up.

Use Cases

Questions Grid answers

How did Barrick perform across all its KPIs over the last 5 years?

Fix Company → Barrick (ABX). See gold production, AISC, grade, recovery, throughput, realized price — all as YoY% changes across 2020–2025. The heatmap instantly shows which years were good and which were bad.

Which iron ore producers grew shipments while cutting costs in 2024?

Fix Period → 2023 to 2024. Select iron_ore_shipped and aisc_fe as columns. Filter to iron ore companies. Companies with green in both columns achieved the ideal: more volume, lower cost.

How does the entire gold sector look on AISC trends?

Fix KPI → AISC (gold). See all 65 gold producers as rows, with each year as a column. The heatmap shows whether the industry is experiencing cost inflation or deflation.

Did Freeport trade production growth for higher costs?

Fix Company → Freeport-McMoRan (FCX). Look at copper_produced and c1_cost_cu side by side across years. If production is green and costs are red, they scaled at the expense of efficiency.

Explore the grid

Fix a company, KPI, or time period. See the patterns that numbers alone can't show.

Open Workspace