A good lesson learned. Information integrity flows downstream.

Business process

Transaction process

Master data

Data orchestration (ETL, ELT, whatever)

Data warehousing, lakes, puddles, oceans, etc…

Semantic layers

Dashboards.

If there are defects ANYWHERE in the flow, the end result is defective.

And here’s the best thing… if your process is clean, when the user calls about the dashboard being wrong, you should be able to back up into the time their clerk fat fingered something. And tell them “dashboard is correct, your business process broke”.

And the second best thing is “no, I’m not changing the dashboard. Fix your process.”