Lesson 14 of 15 · Lab
What is data governance? Owners and change notes
Data governance means deciding who owns each definition, who may change it and how a change is recorded. In a small team it can be one table and a habit. Add more only when the number of reports and people demands it.
| Date | Change | Decided by | Effect |
|---|---|---|---|
| March 3 | Refunds now subtract from net sales | Finance lead | Q1 down 2 points; history recalculated |
At fictional Vandelay Coffee Supply, the October refresh dropped Starhopper's part-paid INV-1013 and the Q3 total fell to €11,198. Don Tremendous in Sales says part-paid is obviously a sale. Sydney Swell in Finance says it's owed but not settled.
Apply a definition change
INV-1013 is worth €900 after Starhopper's rebate. If part-paid counts, does Vandelay reach its €12,000 target?
Yes, at €12,098, which is 100.8%. So whether the KPI is met comes down to the decision rather than the data, which is why it can't be made quietly.
Sydney owns the metric, and she decides that part-paid counts, because the KPI measures what was sold, not what has been collected.
- Filter is selected in this live flow in Strata, Oplema's browser app for data prep. In Expression, click at the end of the first line and press Shift+Home.
- Type
status IN ('booked', 'part-paid'), then select the Filter block. - Select Summarize, the last block, and compare
netwith your prediction. - Write the change note, then compare it with the model below.
Swipe sideways to see the canvas, or open this page on a larger screen to work with it.
In an expression, press Esc to apply it and move on (press it twice if a suggestion list is open).
Compare with a model note
November 2. Part-paid counts as booked, decided by Sydney. Q3 net value €11,198 to €12,098, or 100.8% of target. Affects INV-1013.
One short table of owners
Every incident in this course had a natural owner. Writing them down is most of the job.
| Owner | Decides | This course's incidents |
|---|---|---|
| Source: Don | Register contents | Initech missing, Dunder Mifflin listed twice |
| Metric: Sydney | Definition, target | Part-paid, pending, the period |
| Report: you | Page, audience, dates | Which visuals, who gets it |
One person can hold several roles. What matters is that nobody has to guess.
How governance goes wrong
- Quality checks that only test the run. A new status passes through a healthy pipeline. Check expected values and relationships too.
- Silent changes. Say what changed and whether history was recalculated, or last quarter's chart quietly disagrees with last quarter's report.
- Access by convention. Decide who may read, edit and publish, and apply that in the system that enforces it. A label saying "internal" enforces nothing.
- Too much process. A committee for five reports means people route around it, with spreadsheets.
Use more formal governance when numbers go to regulators or investors, or when several teams change the same metric. The test stays simple: when the number moves, can someone say who changed what, and why?
What Oplema covers, and what stays with you
Oplema Cloud gives you part of this. Projects have owner, admin, editor and viewer roles, only an Admin or the Owner can publish, and saved versions can be compared. Oplema has no approval step or metric catalog, so the owner table and change notes live with your team. There's also no row-level security, so give people access only to what they may read.
Other tools draw this line differently. Power BI and Tableau offer row-level security, plus certified semantic models (Power BI) and data sources (Tableau), and a warehouse controls access with SQL grants. None of them decides what part-paid means.