Academy Getting your data in order
Episode 3 of 10
Count before you clean
Do not start cleaning, start counting: duplicates, empty fields, addresses that do not exist.
Check yourself
What is the first step in a master data clean-up?
A count tells you whether this is a project or an afternoon. Then you know what to clean first.
Show text
04 · Basic
Getting your data in order
From loose exports to one version of the truth: master data, one source per field, pipelines, warehouse and migration, and why this decides whether AI works.
0:38Ep. 1Why your numbers do not match
0:39Ep. 2What master data is
0:38Ep. 3Count before you clean
0:36Ep. 4One source per piece of data
0:37Ep. 5Checks at the moment of entry
0:43Ep. 6Who owns this number?
0:37Ep. 7What a data pipeline is
0:38Ep. 8Why a spreadsheet is not a data warehouse
0:37Ep. 9Migrating data without losing any
0:42Ep. 10Is your data ready for AI?
After this series you can:
- You point out where your data drifts apart and count how big the problem is, before you build.
- You record per piece of data which system is the source, who decides, and what is checked at entry.
- You pick what your data question needs: a pipeline, a warehouse or a migration, and require every step checked.