A Data Role Is a Centre of Gravity, Not a Box
A practitioner view of how Data Engineering, Analytics Engineering, BI, Analysis, Architecture and Governance overlap across the data work stack.
Articles
Reporting Trust Articles
Short articles on why business numbers do not match, why teams pay an Invisible Data Tax, and what to inspect first.
Recent additions
Latest articles and technical notes
Newly published notes appear here first so readers and crawlers can reach fresh implementation material without waiting for a topic page to be reorganised.
Why Your Dashboard Does Not Match the Spreadsheet
Why dashboards and spreadsheets show different numbers, and what leaders should inspect before rebuilding reports.
Dashboard Reconciliation Checklist: What to Inspect When Reports Disagree
A practical diagnostic checklist for leaders when dashboards, spreadsheets, and finance packs show different numbers.
AI Memory Needs Data Contracts, Not Just Vector Search
Why durable AI memory needs structured contracts, provenance, tests, and modeled context before agents can safely answer business questions from notes.
Why Your Business Numbers Don't Match
Why dashboards, spreadsheets, and finance packs drift apart, and what to inspect first when leaders stop trusting the numbers.
How to Use AI in Analytics Engineering Without Damaging the Repo
A practical way to use AI for analytics engineering while keeping grain, metric definitions, reconciliation, access, and repository health under human control.
Topic Hub
Problem Symptoms
Articles for leaders searching by the symptom: revenue disputes, finance vs sales mismatch, dashboard disputes, and spreadsheet reconciliation.
Your Spreadsheet Is Your Semantic Layer
Why spreadsheet logic often contains the business meaning AI and dashboards need, and how to turn that hidden semantic layer into Reporting Trust.
Board Pack Numbers Keep Changing: What to Check First
What changing board pack numbers reveal about definitions, ownership, timing, caveats, and reporting trust.
Why Your Dashboard Does Not Match the Spreadsheet
Why dashboards and spreadsheets show different numbers, and what leaders should inspect before rebuilding reports.
Dashboard Reconciliation Checklist: What to Inspect When Reports Disagree
A practical diagnostic checklist for leaders when dashboards, spreadsheets, and finance packs show different numbers.
What to Do When Every Team Has a Different Version of Revenue
How to diagnose revenue reporting disputes when sales, finance, operations, and dashboards all show different numbers.
Revenue Dashboard Does Not Match Finance: What to Check First
What to inspect when a revenue dashboard, sales report, CRM view, spreadsheet, and finance pack show different numbers.
KPI Definition Template: What Leaders Should Agree Before Trusting a Dashboard
A leader-friendly guide to the KPI definition decisions that make dashboards easier to trust, reconcile, and use.
Monthly Reporting Takes Too Long: What It Usually Means
Why month-end reporting slows down, what the delay reveals about reporting trust, and what to inspect before asking for faster dashboards.
Source-to-Report Lineage Explained
What source-to-report lineage means, where it fits inside the Data Value Chain, and what leaders should inspect when business numbers do not match.
The Invisible Data Tax
The hidden business cost of checking, reconciling, rebuilding, and explaining reports that people do not fully trust.
Why Your Business Numbers Don't Match
Why dashboards, spreadsheets, and finance packs drift apart, and what to inspect first when leaders stop trusting the numbers.
Topic Hub
Start Here
Core explanations for leaders trying to understand why trusted reporting breaks.
How to Model JSON Event Data With SQL
A practical walkthrough for exploring semi-structured event data, normalising JSON fields, and building reusable SQL models before answering business questions.
How to Use AI in Analytics Engineering Without Damaging the Repo
A practical way to use AI for analytics engineering while keeping grain, metric definitions, reconciliation, access, and repository health under human control.
AI Memory Needs Data Contracts, Not Just Vector Search
Why durable AI memory needs structured contracts, provenance, tests, and modeled context before agents can safely answer business questions from notes.
How to Diagnose a Disputed Metric
A practical way to inspect one contested KPI when teams disagree about the number, its definition, source, owner, caveats, and safe use.
Looker, dbt, and the Semantic Layer Gate
How dbt models, Looker semantic logic, metric ownership, lineage, and business definitions work together to create Reporting Trust.
AI Across the Data Value Chain
Where AI can help from Capture to Realise, why the Semantic Layer Gate matters, and how to avoid accelerating weak reporting logic.
Reporting Trust vs Semantic Layer Trust
How Reporting Trust and semantic layer trust differ, where they overlap, and why the semantic layer is a control point rather than the buyer-facing outcome.
Why AI Needs a Semantic Layer
Why AI tools need controlled metric meaning, caveats, ownership, and safe-use rules before they can reliably answer business questions.
Your Spreadsheet Is Your Semantic Layer
Why spreadsheet logic often contains the business meaning AI and dashboards need, and how to turn that hidden semantic layer into Reporting Trust.
Board Pack Numbers Keep Changing: What to Check First
What changing board pack numbers reveal about definitions, ownership, timing, caveats, and reporting trust.
Why Your Dashboard Does Not Match the Spreadsheet
Why dashboards and spreadsheets show different numbers, and what leaders should inspect before rebuilding reports.
Dashboard Reconciliation Checklist: What to Inspect When Reports Disagree
A practical diagnostic checklist for leaders when dashboards, spreadsheets, and finance packs show different numbers.
AI Will Not Fix Untrusted Reporting
Why AI makes reporting trust more important, not less, and what teams should fix before automating decisions from messy numbers.
What to Do When Every Team Has a Different Version of Revenue
How to diagnose revenue reporting disputes when sales, finance, operations, and dashboards all show different numbers.
Revenue Dashboard Does Not Match Finance: What to Check First
What to inspect when a revenue dashboard, sales report, CRM view, spreadsheet, and finance pack show different numbers.
KPI Definition Template: What Leaders Should Agree Before Trusting a Dashboard
A leader-friendly guide to the KPI definition decisions that make dashboards easier to trust, reconcile, and use.
Monthly Reporting Takes Too Long: What It Usually Means
Why month-end reporting slows down, what the delay reveals about reporting trust, and what to inspect before asking for faster dashboards.
Source-to-Report Lineage Explained
What source-to-report lineage means, where it fits inside the Data Value Chain, and what leaders should inspect when business numbers do not match.
The Invisible Data Tax
The hidden business cost of checking, reconciling, rebuilding, and explaining reports that people do not fully trust.
Why Your Business Numbers Don't Match
Why dashboards, spreadsheets, and finance packs drift apart, and what to inspect first when leaders stop trusting the numbers.
Topic Hub
Reporting Trust
How teams reduce decision drag, reconcile numbers, and rebuild confidence in priority metrics.
How to Model JSON Event Data With SQL
A practical walkthrough for exploring semi-structured event data, normalising JSON fields, and building reusable SQL models before answering business questions.
How to Use AI in Analytics Engineering Without Damaging the Repo
A practical way to use AI for analytics engineering while keeping grain, metric definitions, reconciliation, access, and repository health under human control.
AI Memory Needs Data Contracts, Not Just Vector Search
Why durable AI memory needs structured contracts, provenance, tests, and modeled context before agents can safely answer business questions from notes.
How to Diagnose a Disputed Metric
A practical way to inspect one contested KPI when teams disagree about the number, its definition, source, owner, caveats, and safe use.
Looker, dbt, and the Semantic Layer Gate
How dbt models, Looker semantic logic, metric ownership, lineage, and business definitions work together to create Reporting Trust.
AI Across the Data Value Chain
Where AI can help from Capture to Realise, why the Semantic Layer Gate matters, and how to avoid accelerating weak reporting logic.
Reporting Trust vs Semantic Layer Trust
How Reporting Trust and semantic layer trust differ, where they overlap, and why the semantic layer is a control point rather than the buyer-facing outcome.
Why AI Needs a Semantic Layer
Why AI tools need controlled metric meaning, caveats, ownership, and safe-use rules before they can reliably answer business questions.
Your Spreadsheet Is Your Semantic Layer
Why spreadsheet logic often contains the business meaning AI and dashboards need, and how to turn that hidden semantic layer into Reporting Trust.
Board Pack Numbers Keep Changing: What to Check First
What changing board pack numbers reveal about definitions, ownership, timing, caveats, and reporting trust.
Why Your Dashboard Does Not Match the Spreadsheet
Why dashboards and spreadsheets show different numbers, and what leaders should inspect before rebuilding reports.
Dashboard Reconciliation Checklist: What to Inspect When Reports Disagree
A practical diagnostic checklist for leaders when dashboards, spreadsheets, and finance packs show different numbers.
AI Will Not Fix Untrusted Reporting
Why AI makes reporting trust more important, not less, and what teams should fix before automating decisions from messy numbers.
What to Do When Every Team Has a Different Version of Revenue
How to diagnose revenue reporting disputes when sales, finance, operations, and dashboards all show different numbers.
Revenue Dashboard Does Not Match Finance: What to Check First
What to inspect when a revenue dashboard, sales report, CRM view, spreadsheet, and finance pack show different numbers.
KPI Definition Template: What Leaders Should Agree Before Trusting a Dashboard
A leader-friendly guide to the KPI definition decisions that make dashboards easier to trust, reconcile, and use.
Monthly Reporting Takes Too Long: What It Usually Means
Why month-end reporting slows down, what the delay reveals about reporting trust, and what to inspect before asking for faster dashboards.
Source-to-Report Lineage Explained
What source-to-report lineage means, where it fits inside the Data Value Chain, and what leaders should inspect when business numbers do not match.
The Invisible Data Tax
The hidden business cost of checking, reconciling, rebuilding, and explaining reports that people do not fully trust.
Why Your Business Numbers Don't Match
Why dashboards, spreadsheets, and finance packs drift apart, and what to inspect first when leaders stop trusting the numbers.
Topic Hub
AI Readiness
What to fix before AI, automation, or generated summaries scale weak reporting logic.
How to Use AI in Analytics Engineering Without Damaging the Repo
A practical way to use AI for analytics engineering while keeping grain, metric definitions, reconciliation, access, and repository health under human control.
AI Memory Needs Data Contracts, Not Just Vector Search
Why durable AI memory needs structured contracts, provenance, tests, and modeled context before agents can safely answer business questions from notes.
Looker, dbt, and the Semantic Layer Gate
How dbt models, Looker semantic logic, metric ownership, lineage, and business definitions work together to create Reporting Trust.
AI Across the Data Value Chain
Where AI can help from Capture to Realise, why the Semantic Layer Gate matters, and how to avoid accelerating weak reporting logic.
Reporting Trust vs Semantic Layer Trust
How Reporting Trust and semantic layer trust differ, where they overlap, and why the semantic layer is a control point rather than the buyer-facing outcome.
Why AI Needs a Semantic Layer
Why AI tools need controlled metric meaning, caveats, ownership, and safe-use rules before they can reliably answer business questions.
AI Will Not Fix Untrusted Reporting
Why AI makes reporting trust more important, not less, and what teams should fix before automating decisions from messy numbers.
KPI Definition Template: What Leaders Should Agree Before Trusting a Dashboard
A leader-friendly guide to the KPI definition decisions that make dashboards easier to trust, reconcile, and use.
Topic Hub
Templates and Diagnostics
Practical inspection points for definitions, source paths, ownership, and reporting quality.
How to Diagnose a Disputed Metric
A practical way to inspect one contested KPI when teams disagree about the number, its definition, source, owner, caveats, and safe use.
Reporting Trust vs Semantic Layer Trust
How Reporting Trust and semantic layer trust differ, where they overlap, and why the semantic layer is a control point rather than the buyer-facing outcome.
Why AI Needs a Semantic Layer
Why AI tools need controlled metric meaning, caveats, ownership, and safe-use rules before they can reliably answer business questions.
Your Spreadsheet Is Your Semantic Layer
Why spreadsheet logic often contains the business meaning AI and dashboards need, and how to turn that hidden semantic layer into Reporting Trust.
Board Pack Numbers Keep Changing: What to Check First
What changing board pack numbers reveal about definitions, ownership, timing, caveats, and reporting trust.
Why Your Dashboard Does Not Match the Spreadsheet
Why dashboards and spreadsheets show different numbers, and what leaders should inspect before rebuilding reports.
Dashboard Reconciliation Checklist: What to Inspect When Reports Disagree
A practical diagnostic checklist for leaders when dashboards, spreadsheets, and finance packs show different numbers.
AI Will Not Fix Untrusted Reporting
Why AI makes reporting trust more important, not less, and what teams should fix before automating decisions from messy numbers.
What to Do When Every Team Has a Different Version of Revenue
How to diagnose revenue reporting disputes when sales, finance, operations, and dashboards all show different numbers.
Revenue Dashboard Does Not Match Finance: What to Check First
What to inspect when a revenue dashboard, sales report, CRM view, spreadsheet, and finance pack show different numbers.
KPI Definition Template: What Leaders Should Agree Before Trusting a Dashboard
A leader-friendly guide to the KPI definition decisions that make dashboards easier to trust, reconcile, and use.
Monthly Reporting Takes Too Long: What It Usually Means
Why month-end reporting slows down, what the delay reveals about reporting trust, and what to inspect before asking for faster dashboards.
Source-to-Report Lineage Explained
What source-to-report lineage means, where it fits inside the Data Value Chain, and what leaders should inspect when business numbers do not match.
The Invisible Data Tax
The hidden business cost of checking, reconciling, rebuilding, and explaining reports that people do not fully trust.
Why Your Business Numbers Don't Match
Why dashboards, spreadsheets, and finance packs drift apart, and what to inspect first when leaders stop trusting the numbers.
All articles
A Data Role Is a Centre of Gravity, Not a Box
A practitioner view of how Data Engineering, Analytics Engineering, BI, Analysis, Architecture and Governance overlap across the data work stack.
How to Model JSON Event Data With SQL
A practical walkthrough for exploring semi-structured event data, normalising JSON fields, and building reusable SQL models before answering business questions.
How to Use AI in Analytics Engineering Without Damaging the Repo
A practical way to use AI for analytics engineering while keeping grain, metric definitions, reconciliation, access, and repository health under human control.
AI Memory Needs Data Contracts, Not Just Vector Search
Why durable AI memory needs structured contracts, provenance, tests, and modeled context before agents can safely answer business questions from notes.
How to Diagnose a Disputed Metric
A practical way to inspect one contested KPI when teams disagree about the number, its definition, source, owner, caveats, and safe use.
Looker, dbt, and the Semantic Layer Gate
How dbt models, Looker semantic logic, metric ownership, lineage, and business definitions work together to create Reporting Trust.
AI Across the Data Value Chain
Where AI can help from Capture to Realise, why the Semantic Layer Gate matters, and how to avoid accelerating weak reporting logic.
Reporting Trust vs Semantic Layer Trust
How Reporting Trust and semantic layer trust differ, where they overlap, and why the semantic layer is a control point rather than the buyer-facing outcome.
Why AI Needs a Semantic Layer
Why AI tools need controlled metric meaning, caveats, ownership, and safe-use rules before they can reliably answer business questions.
Your Spreadsheet Is Your Semantic Layer
Why spreadsheet logic often contains the business meaning AI and dashboards need, and how to turn that hidden semantic layer into Reporting Trust.
Board Pack Numbers Keep Changing: What to Check First
What changing board pack numbers reveal about definitions, ownership, timing, caveats, and reporting trust.
Why Your Dashboard Does Not Match the Spreadsheet
Why dashboards and spreadsheets show different numbers, and what leaders should inspect before rebuilding reports.
Dashboard Reconciliation Checklist: What to Inspect When Reports Disagree
A practical diagnostic checklist for leaders when dashboards, spreadsheets, and finance packs show different numbers.
AI Will Not Fix Untrusted Reporting
Why AI makes reporting trust more important, not less, and what teams should fix before automating decisions from messy numbers.
What to Do When Every Team Has a Different Version of Revenue
How to diagnose revenue reporting disputes when sales, finance, operations, and dashboards all show different numbers.
Revenue Dashboard Does Not Match Finance: What to Check First
What to inspect when a revenue dashboard, sales report, CRM view, spreadsheet, and finance pack show different numbers.
KPI Definition Template: What Leaders Should Agree Before Trusting a Dashboard
A leader-friendly guide to the KPI definition decisions that make dashboards easier to trust, reconcile, and use.
Monthly Reporting Takes Too Long: What It Usually Means
Why month-end reporting slows down, what the delay reveals about reporting trust, and what to inspect before asking for faster dashboards.
Source-to-Report Lineage Explained
What source-to-report lineage means, where it fits inside the Data Value Chain, and what leaders should inspect when business numbers do not match.
The Invisible Data Tax
The hidden business cost of checking, reconciling, rebuilding, and explaining reports that people do not fully trust.
Why Your Business Numbers Don't Match
Why dashboards, spreadsheets, and finance packs drift apart, and what to inspect first when leaders stop trusting the numbers.
Free chapter
Want the fuller framework behind these articles?
Download the opening chapter of Your Numbers Don't Match and start spotting where reporting trust breaks down.