Learn
Data Glossary
Data concepts explained in plain English.
Data Foundations
The building blocks every data-driven organisation needs to get right first.
Data Foundation
The infrastructure, processes, and standards that make your business data reliable, accessible, and ready to drive decisions – the bedrock everything else is built on.
Learn more →Single Source of Truth
One agreed-upon set of numbers that everyone in the business trusts – so your sales team, finance team, and CEO are all looking at the same reality.
Learn more →Data Maturity
A measure of how well your organisation collects, manages, and uses data to make decisions – from ad-hoc spreadsheets all the way to predictive analytics.
Learn more →Data Quality
The degree to which your data is accurate, complete, consistent, and timely – in short, whether you can actually trust the numbers your team relies on.
Learn more →Data Governance
The rules, roles, and processes that determine who can access what data, how it is maintained, and who is responsible when something goes wrong.
Learn more →Data Architecture
How data moves, where it lives, and how systems connect.
Data Warehouse
A central database designed specifically for reporting and analysis – one place where all your numbers live so you can query across departments, systems, and time periods.
Learn more →Data Lake
A storage system that holds large volumes of raw data in its original format – structured spreadsheets, unstructured documents, images, logs – until you need to analyse it.
Learn more →Data Pipeline
An automated process that moves data from where it is created (your CRM, ERP, website) to where it needs to be analysed – reliably, on schedule, without anyone manually exporting CSVs.
Learn more →ETL
Extract, Transform, Load – the three-step process of pulling data out of source systems, cleaning and reshaping it, and loading it into a warehouse or database for analysis.
Learn more →Data Integration
Making your separate business tools talk to each other automatically – so data flows between your CRM, accounting, ERP, and other systems without manual re-entry.
Learn more →Medallion Architecture
A layered approach to organising data: raw data lands first (bronze), gets cleaned (silver), then shaped into business-ready tables (gold) – so your team always knows which numbers are trustworthy.
Learn more →Data Lakehouse
A modern data platform that combines the cheap, flexible storage of a data lake with the structured querying power of a data warehouse – so you get the best of both without maintaining two separate systems.
Learn more →Data Modelling
The process of designing how your data is structured and related – setting up tables, fields, and connections so your warehouse answers business questions quickly and accurately.
Learn more →Schema Design
The specific structure of your database – which tables exist, what columns they have, what types of data each column holds, and the rules that keep data consistent.
Learn more →Data Lineage
The ability to trace any number on a dashboard or report all the way back to its original source – knowing exactly where it came from, what changed it, and when.
Learn more →Analytics & AI
Turning clean data into decisions, predictions, and automation.
AI Readiness
A measure of whether your organisation has the data quality, infrastructure, and processes in place to actually use artificial intelligence – not just talk about it.
Learn more →Business Intelligence
The dashboards, reports, and analysis tools that turn raw data into clear answers – so your team can see what is happening in the business without waiting for someone to build a spreadsheet.
Learn more →Master Data Management
The practice of creating and maintaining one clean, authoritative version of your core business entities – customers, products, suppliers, locations – across all your systems.
Learn more →Entity Resolution
The process of figuring out when two records in different systems refer to the same real-world thing – the same customer, the same product, the same supplier – even when the data does not match exactly.
Learn more →Data Strategy
A clear plan that connects your business goals to specific data initiatives – what to build, in what order, and what return to expect – so data investment drives measurable outcomes.
Learn more →Data Quality
Making sure the numbers you rely on are actually correct.
Data Observability
Continuous monitoring of your data pipelines and warehouse so you know when something breaks, what broke, and where – before your stakeholders notice the numbers are wrong.
Learn more →Data Deduplication
The process of finding and merging duplicate records in your data – the same customer entered twice, the same invoice recorded in two systems, the same product with three different spellings.
Learn more →Data Migration
Moving your data from one system to another – whether upgrading your ERP, switching CRMs, or consolidating databases – without losing records, breaking integrations, or corrupting historical data.
Learn more →Data Silo
When each department stores its data in its own separate system with no connection to the rest of the business – so finance, sales, and operations each have their own version of the truth.
Learn more →Analytics Engineering
The discipline that sits between data engineering and data analysis – building the clean, tested, documented data models that analysts and dashboards consume, so reporting is reliable and self-serve.
Learn more →Tools & Platforms
The software and services that power modern data stacks.
dbt
A tool that lets your data team write, test, and document data transformations using SQL – turning raw data into business-ready tables with version control, like code reviews for your numbers.
Learn more →Data Orchestration
The scheduling and coordination of your data pipelines – making sure the right data is extracted, processed, and delivered in the right order, at the right time, every day.
Learn more →Data Catalogue
An organised inventory of all the data in your organisation – what exists, where it lives, what it means, and who owns it – so people can find and understand data without asking around.
Learn more →API Integration
Using standardised connection points (APIs) to make your business systems share data automatically – getting your CRM, accounting, and operations tools to talk to each other without manual exports.
Learn more →Change Data Capture
A method of detecting and capturing only the data that has changed in a source system since the last update – so your warehouse stays current without re-processing everything every time.
Learn more →Have a question about your data?
We explain things in plain English – no jargon, no sales pitch.
Book a Call