CleanDims

04 / Organize

Finer levels roll up so sources meet at the right one.

Finer levels roll up so sources meet at the right one.

Example

Raw valueSource levelShared join level
New York Countycountystate: New York
NYstatestate: New York
New Yorkstate or city?waits for review

Use it when one source reports by state and another by county, or datasets use different hierarchy levels.

Hierarchy.

“New York” is a state and a city. One source reports by state, another by county, and nothing says which.

Hierarchy-aware joins.

Stable IDs, hierarchy levels and aliases for places, industries and vendors. Store sales by state and population by county now join at state level.