Blog Posts

Latest news and updates from our team

Managing Finance Reporting Hierarchies - Best Practice
Latest Post

Managing Finance Reporting Hierarchies - Best Practice

One set of Cost Centers, three rollup trees. Managing multiple reporting hierarchies is difficult. Best Practice: Using governed reference data instead of fragile spreadsheets.

Jules West
Read article

More Articles

Reference data in data integration. why code mappings sink integration projects

Reference data in data integration. why code mappings sink integration projects

Hard-coded code mappings are a top reason data integration projects fail. Governed crosswalks with versioning and validation are the fix.

Jacob Wilson
How to Choose Reference Data Management Tools (Without Getting Lost in MDM)

How to Choose Reference Data Management Tools (Without Getting Lost in MDM)

A practical evaluation framework for RDM tools, with a comparison of spreadsheets, dbt seeds, MDM platforms, and purpose-built RDM.

Jacob Wilson
Why dbt Seed Files Are the Wrong Place for Reference Data

Why dbt Seed Files Are the Wrong Place for Reference Data

dbt is brilliant at transformation. Seed files are not a reference data management strategy. Here's why the workaround breaks, and what to use instead.

Sienna Gilmore
The Reference Data Layer Your Data Warehouse Is Missing

The Reference Data Layer Your Data Warehouse Is Missing

Your warehouse has a staging layer, a transformation layer, and a presentation layer. It doesn't have a reference data layer. That's why your dimensions are a mess.

Sienna Gilmore
Your Lookup Tables Shouldn't Live in Excel

Your Lookup Tables Shouldn't Live in Excel

Every data team has them. Nobody manages them properly. Here's why that's a bigger problem than you think, and what to do about it.

Sienna Gilmore

Your lookup tables deserve better than a shared spreadsheet.

Set up your first managed reference data table in under 10 minutes.

Sign Up Free →