BI Governance
Dashboard sprawl, certified reports, and the number the board is allowed to see.
5 to work through
-
intermediate Multiple choice
A company certifies 400 of its 4000 dashboards with a badge an owner and a review at the moment the badge is granted. Eighteen months later an audit finds the certified set has the highest proportion of reports whose underlying model has changed since certification. Review the design. Which single change matters most?
2 min answer -
intermediate
A travel company has thousands of dashboards, several conflicting definitions of the same metric, and a large BI bill. Diagnose it.
1 min answer -
intermediate
Two dashboards disagree about revenue. What mechanism would have prevented it, and what would not?
2 min answer -
advanced Multiple choice
At 09:10 an executive dashboard shows yesterday's conversion down 38%. By 09:40 every pipeline is confirmed healthy, row counts are normal and no schema changed. At 10:50 someone finds a pull request merged at 23:38 that changed the semantic layer's definition of a converted session. Fourteen experiments were mid-flight. Which design change most directly prevents a repeat?
3 min answer -
advanced
Booking.com has described running more than 1,000 concurrent experiments in a 2017 paper on democratising experimentation. Before you let a thousand teams define their own metrics at that concurrency, what must be true of the semantic layer and the pipelines underneath?
2 min answer
4 terms in this topic
BI Governance
Keeping business intelligence trustworthy — through certified definitions and a semantic layer, without preventing analysts from working.
practiceCertified Report
A small set of reports explicitly endorsed as authoritative, with an owner and a review cadence, distinguished from everything else people have built.
practiceMetric Certification
Marking a small set of metrics and datasets as governed and authoritative, so that exploration stays free while anything asserted about the business …
metricZero-Audience Report
A published dashboard with no viewer in a defined window, which is the only decommissioning candidate that can be retired without an argument - and t…
Neighbouring topics
Data Governance & Semantics
General material on ownership, meaning, quality and control of data at enterprise scale.
Data Mesh
Domain ownership, data as a product, self-serve platform, and federated governance.
Data Products
A dataset with an owner, an interface, an SLO, and consumers who can rely on it.
Data Contracts
Producers committing to schema, semantics and freshness, and breaking builds when they do not.
Data Catalog
Discovery, ownership and technical metadata, and why catalogues go stale.
Business Glossary
Agreeing what a term means before arguing about which number is right.
Semantic Layer
Metric definitions held once and served to every tool that asks.
Master Data Management
One authoritative record for a customer or product across systems that each have their own.
Reference Data
Code lists, hierarchies and currencies — small, shared, and quietly load-bearing.
Data Quality Dimensions
Completeness, accuracy, timeliness, consistency, validity and uniqueness as testable claims.
Data Observability
Freshness, volume, schema and distribution monitoring for pipelines that fail silently.
Data Stewardship
The operating model that makes ownership a role rather than a slide.
Data Access Models
Role, attribute and purpose-based access over analytical data, and how they compose.
Row & Column-Level Security
Restricting slices of a table rather than the whole table, and where it is enforced.
Tokenisation & Masking
Dynamic masking, deterministic tokens, and preserving joinability without exposure.
Retention & Purge
Deleting from an append-only estate, and proving the deletion happened.
Data Sharing & Clean Rooms
Collaborating on data neither party may hand over, with computation as the interface.
Sensitivity Labelling
Propagating a classification through joins and derived tables so controls follow the data.
Self-Service vs Governed
Letting analysts move fast without four teams reporting four different revenues.