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
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.
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?
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