Lesson 06 of 7 · Standalone tables
Some tables stand alone on purpose.
Four tables have no relationships at all. In most models that's a bug. Here, each one is a choice.
1
Four tables, no lines
In Model view, four tables have no relationships at all. In most models that's a mistake. Here each one is deliberate, because none of them describes rows in a fact table.
_MeasuresThe home for every measure. No data to relate.
DimMeasureBasisThe register. It describes measures, not trade or prices.
FactReleaseGateThe checklist of release checks shown on the assurance page.
MigrationCandidatesThe table-by-table plan shown on the migration page.
A table has no relationships. A commodity slicer is on the same page. What does the slicer do to it?
Answer the question above to unlock this.
What if the register were joined to Commodity?
A toy version: three tiles, each with an information button that reads its text from the register.
2
Sort by a hidden order
Text sorts A to Z. Stages of a process don't. So two text columns are sorted by a number column next to them: FactFacilities[State] by StateOrder, and a pipeline Stage column by StageOrder. You set it in Table view with Column tools > Sort by column.
Illustrative state names.
0 / 2
Which of these tables should have relationships?
Where should the StateOrder column be created?
The ruleA table that describes the model, not the data, stands alone. When text has a natural order, sort it by an order column made in gold.