Explore Skills

Combining tables safely: cardinality, fan-out and conservation of totals

Someone with this skill predicts what a join, lookup or BI relationship will do to row counts and totals from the cardinality of the entities, then proves after combining that the rows and totals the question depends on are conserved, finding orphans, fan-out and double counting.

5jobs rely on it most

1Path teaches it

1open now

Paths that teach it

Tool Path
SQL for Analysis
Answer real business questions with SQL, from your first query to finding why a number moved.
Modules
5 open
Runs in
Your browser
Start the Path

Jobs that use it

Analytics cookies

Combining tables safely: cardinality, fan-out and conservation of totals

Paths that teach it

SQL for Analysis

Jobs that use it

Data, Analytics & AI 3

Marketing & Communications 1

Commercial & Sales 1