Mining · Drill & Blast Report

Drill and Blast Performance Reporting: Linking Fragmentation to Downstream Mining Efficiency

1 June 202610 min readPerth, Western Australia

Short answer

Drill and blast performance reporting tracks drill productivity (metres drilled per hour and per shift), blast design compliance (burden, spacing and powder factor vs plan), fragmentation outcomes (P80 size and oversize percentage), and the downstream effects - dig rate, truck cycle time and crusher feed size - that connect blast quality to overall mining efficiency. Done well, it provides the feedback loop that allows blast engineers to continuously improve the relationship between blast design and downstream outcome. SolveBI builds drill and blast dashboards on Power BI and Microsoft Fabric that unify blast management systems, drill monitoring data, fragmentation image analysis and dispatch records into one blast-performance view.

A row of blast holes drilled and loaded ready for initiation at an open-cut mine - the output of the drill and blast process whose design parameters and fragmentation outcomes are tracked in performance reporting.

Why drill and blast is where open-cut mining efficiency begins - and where it is most often under-reported

Drill and blast is the first transformation in the open-cut mining value chain. Every shovel cycle time, every truck load factor, every crusher feed rate and every SAG mill throughput figure downstream is partly a function of the fragmentation quality produced in the last blast. Yet in many operations the performance feedback on blast design is limited to a post-blast visual assessment and a dig-rate observation that is rarely linked back to the specific blast design that produced it.

Systematic drill and blast reporting closes this feedback loop. It tracks drill productivity, blast design compliance, fragmentation outcomes and downstream effects in one place - so the blast engineer can see whether a design change that increased powder factor actually improved dig rate and crusher throughput as intended, or whether it produced finer fragmentation in one area at the cost of oversize and increased secondary breaking in another.

10–15%
Typical SAG mill throughput improvement achievable from optimised feed fragmentation on hard-rock gold operations
Powder factor
The primary blast design variable - kg of explosive per tonne of rock; the most direct input to fragmentation outcome
P80
The fragmentation size at which 80% of the rock passes; the primary fragmentation KPI linking blast to mill

The metrics that belong on a drill and blast performance dashboard

  • Drill productivity (m/hr and m/shift) - by drill rig, rock type and hole diameter; the primary drill fleet efficiency metric
  • Blast design compliance - burden, spacing and sub-drill vs design plan; the connection between design intent and execution
  • Powder factor (kg/tonne and kg/BCM) - actual explosive consumption per tonne and per BCM; compared to design and benchmarked by rock type
  • Fragmentation P80 (mm) - the size at which 80% of the broken rock passes; from image analysis or laser sizing
  • Oversize percentage (%) - proportion of material above crusher feed size; drives secondary breaking cost and throughput bottlenecks
  • Dig rate (BCM/hr) - excavator productivity post-blast; the most sensitive and direct downstream measure of fragmentation quality
  • Misfires and blast incidents - safety and regulatory reporting on blast events

Rock type and domain: why one powder factor does not fit all

Open-cut mines typically encounter multiple rock types and geological domains with different hardness, fracture density and blastability characteristics. A powder factor that produces optimal fragmentation in soft, highly fractured mineralised ore may produce unacceptably coarse fragmentation in harder, competent waste rock - or over-crush softer material to produce fines that increase mill load without improving throughput. Drill and blast reporting that breaks design compliance and fragmentation outcomes down by geological domain and rock type allows the blast engineer to calibrate powder factor and design parameters to the specific blasting characteristics of each zone.

Connecting blast outcomes to downstream efficiency: the full value chain view

A Power BI drill and blast dashboard showing the relationship between blast powder factor, fragmentation P80, post-blast dig rate and crusher feed rate - connecting blast design to downstream mining efficiency.
The value of drill and blast reporting is in the downstream connection. The same dashboard that shows blast design compliance should show what dig rate, cycle time and crusher throughput that blast produced.

The full case for drill and blast reporting is made when blast design parameters are connected to downstream outcomes in the same dataset. When the blast engineer can see that a 10% increase in powder factor in the north pit produced a 15% reduction in P80 and a 12% improvement in excavator dig rate - but the same design change in the south pit produced minimal fragmentation improvement at 15% higher explosive cost - they have the data needed to make confident blast design decisions rather than engineering judgement calls.

Blast report log vs a systematic drill and blast dashboard

Blast report log vs unified drill and blast dashboard

AspectBlast report logDrill and blast dashboard
Design compliance visibilitySummarised in post-blast report; rarely trendedContinuous - burden, spacing and powder factor vs plan on every blast
Fragmentation linked to designSeparate records; linked manually if at allP80 and oversize joined to the blast that produced them
Downstream connection (dig rate)Known qualitatively by excavator operators; not quantifiedExcavator dig rate from dispatch linked to each muck pile blast
Rock type breakdownSingle site-wide averagePer geological domain and rock type
Trend and optimisation analysisRetrospective; done in annual reviewContinuous - design changes visible in outcome data within the period

The Power BI and Fabric architecture behind drill and blast reporting

On a typical SolveBI deployment we integrate blast management system exports (Orica ShotPlus, Dyno Nobel ARES, DetNet), drill monitoring system data, fragmentation image analysis results (Split Engineering, Wipfrag), dispatch dig-rate records and crusher feed data into Microsoft Fabric, then build a drill and blast performance model in Power BI. The blast engineer sees design compliance and fragmentation by domain; the drill supervisor sees drill productivity; the mine planner sees the downstream efficiency impact of blast design choices - all from one consistent dataset.

Common mistakes in drill and blast performance reporting

  1. Reporting blast events without fragmentation outcomes. Knowing that a blast was fired to design plan says nothing about what it produced downstream.
  2. No dig-rate linkage. Dig rate is the most sensitive and immediately available measure of blast quality - but it requires the dispatch and blast records to be joined.
  3. Site-wide powder factor averages. Averaging powder factor across rock types obscures the domain-specific calibration that blast optimisation requires.
  4. Fragmentation measured visually only. Visual assessments are useful but subjective and not reproducible. Image analysis or laser sizing produces a defensible, quantitative P80.
  5. No feedback loop from downstream to blast design. If the blast engineer never sees the crusher feed size, mill throughput or dig rate data from their blasts, there is no systematic learning from outcomes.

From a post-blast visual assessment to a systematic feedback loop connecting blast design to downstream efficiency.

Book a free 30-minute consultation with a SolveBI consultant. We'll map your blast management, fragmentation and dispatch data, and design a drill and blast dashboard that closes the loop from explosive design to mill throughput.

Frequently Asked

Common Questions

Can it integrate with ShotPlus, ARES, and other blast management systems?
Yes. We connect to blast management system exports and, where available, direct integrations to import blast design parameters, initiation sequence data and explosive consumption records into Microsoft Fabric alongside fragmentation analysis results and dispatch dig-rate records.
How do you integrate fragmentation image analysis systems?
We connect to fragmentation analysis platforms (Split Engineering, Wipfrag, others) via their export APIs or output file formats to import P80, P50 and oversize percentage results for each measured blast. These are joined to the blast design records by blast ID and location.
Can the dashboard link blast outcomes to crusher and mill throughput?
Yes. Where crusher feed rate and SAG mill throughput data from the process historian are available in the same Fabric dataset as the blast records and fragmentation results, we build a correlation view that shows the relationship between blast fragmentation quality and downstream throughput performance.
Can it break results down by geological domain and ore type?
Yes. Where geological domain classifications are available at the blast pattern or block level - typically from the grade control model - we tag each blast by its primary geological domain so design compliance, powder factor and fragmentation outcomes can be compared across domains and rock types.
How long does a drill and blast dashboard take to deploy?
Typically five to eight weeks for a working blast design compliance and fragmentation dashboard. Adding downstream dig-rate linkage from dispatch data adds two to three weeks, depending on how blast locations and muck pile areas are identified in the dispatch system.