Resources
Can you trust the numbers in your report?
Follow a worked example from your industry. Download the sample records, check the arithmetic and see which decisions change when a figure is wrong.
Data reconciliation: how to sign off a report when two systems disagree
A practical guide to choosing the control total, tracing a difference and deciding when a replacement report is ready to use.
First pass yield: why one batch can produce three different percentages
Use five inspections to separate first-time quality from successful rework and decide where to investigate.
How to measure on-time pickups when trips have missing timestamps
A dispatcher has five trips and three measured pickups. Work out what the punctuality figure can tell you before changing the rota.
How to calculate rental occupancy rate when a flat is under refurbishment
Follow three flats through September and measure the effect of vacancies and repairs on a portfolio report.
Sales reconciliation: why £445 in retail exports becomes £275 in the sales report
Rebuild a monthly sales total from six invoice arrivals. Identify a repeated line, a price correction and a genuine credit.
Turn the trend into shipped software
I contract as a senior fullstack and data engineer, building the production systems your customers and your reporting depend on.