Explains the enterprise bus matrix and conformed dimensions
Business processes as rows with their facts, conformed dimensions as columns; conformance by grain, key and meaning; drill-across through shared conformed dimensions (Kimball and Ross 2013, ch. 4).
Can AI do this?
AI does this well Most of the tested AI models master this. 4 of 4 models in the current benchmark master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 100% | Mastered |
| gemini-3.5-flash-lite | Low cost | 100% | Mastered |
| gpt-6-luna | Low cost | 100% | Mastered |
| claude-haiku-5-5 | Low cost | 100% | Mastered |
Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.
What it looks like in practice
Expected result: Business processes as rows with their facts, conformed dimensions as columns; conformance by grain, key and meaning; drill-across through shared conformed dimensions (Kimball and Ross 2013, ch. 4).
How it is assessed: Answers a written question on the enterprise bus matrix correctly
Related knobits
Builds on
Needed for
- W-301 Recognises a dimension conformed in name only
- W-302 Recognises a business process with no fact
- W-303 Recognises a mart bypassing the conformed dimensions
- W-304 Recognises a drill-across without a shared conformed dimension
- W-308 Recognises a matrix tick the fact cannot carry
- W-331 Judges dimension conformance by grain and key
- W-332 Traces the consequence of a drill-across mismatch
- W-333 Keeps the bus matrix to the given processes
All 14 knobits of Design the bus matrix and data products.
Source: Practice the stage 3 reference and review checklist rest on