CleanDims

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

$45/h

Your CleanDims price

$3,877

For the whole join: columns matched and values canonicalised

With CleanDims$3,877
By hand, by your team$11,632

Effort saved

258 hours

About 32 working days of analyst time freed

Cost saved

$7,754

67% 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.