Half the effort a join would take by hand.
Size the join and say how hard it would be for your team. The CleanDims price is set by the size of the job. Only the manual estimate moves with difficulty and analyst cost.
What does the join need?
Pick one or both. A join with no common key usually needs both.
Size the job
The price depends only on these.
CRM, ERP, warehouse, open data portals…
Columns in scope across all of them
e.g. place, industry, vendor
Distinct raw values across those dimensions
If your team did this by hand
These change the manual estimate only.
A typical data analyst costs about $45/h
Your CleanDims price
For the whole join: columns matched and values canonicalised
Effort saved
258 hoursAbout 32 working days of analyst time freed
Cost saved
$7,75467% less than doing it by hand
Like for like. Review and approval time is left out of both sides. CleanDims keeps a person in the loop to approve mappings, so that effort exists either way.
How we estimate the manual effort
- Matching columns: 3 h per dataset or system to get access and extract its schema.
- 0.2 h per column to understand what it holds, and 0.1 h per column to match it against each other source.
- Difficulty multiplier: straightforward 0.85×, typical 1×, challenging 1.5×. The total is then reduced by 20% to keep the estimate conservative.
- An analyst handles about 300 simple, 60 synonym, 15 ambiguous and 100 junk values per hour.
- Share of values by type (simple / synonyms / ambiguous / junk): straightforward 70% / 22% / 6% / 2%, typical 55% / 30% / 12% / 3%, challenging 40% / 35% / 20% / 5%.
- Plus 4.5 h per dimension to profile it and agree canonical values, and 15% for QA and rework. The total is then reduced by 4% to keep the estimate conservative.
- CleanDims price: hours for a typical job × $30/h × 50%, whatever difficulty or analyst cost you choose.
- Review and approval with data owners is left out of both sides.
Prices exclude taxes. Estimates are indicative. Joins on dimensions you have already mapped take less work, so they cost less.
Have two datasets that should join and don’t?
Tell us what they are. We will tell you whether they join, at which level, and what the join would cost.