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.

A change note for a small team
DateChangeDecided byEffect
March 3Refunds now subtract from net salesFinance leadQ1 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.

  1. 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.
  2. Type status IN ('booked', 'part-paid'), then select the Filter block.
  3. Select Summarize, the last block, and compare net with your prediction.
  4. 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.

Three kinds of owner
OwnerDecidesThis course's incidents
Source: DonRegister contentsInitech missing, Dunder Mifflin listed twice
Metric: SydneyDefinition, targetPart-paid, pending, the period
Report: youPage, audience, datesWhich 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.