/mdm
Master Data Rationalization
Site
1 / 9
Master data intelligence · runs on-prem

Find every version of the same part.
Fix what's wrong. Nothing leaves the building.

Exl Athena searches your master data the way people actually type, grades its health with AI in about a second, and surfaces the exact duplicates and gaps costing you money — using local embeddings and a local LLM, so no catalog data ever leaves your network.

27.6%
of records are duplicates
in a 5,000-item sample catalog
89.7%
overall data-quality score
across 6 quality rules
~1s
to profile all 5,000 records
and score a live sample
Search · reconciles abbreviations & units Assess · instant AI data-quality Consolidate · deep AI dedup
Navigate with or the dots below · Esc-free full-screen for presenting
The problem

Master data is quietly broken — and it costs real money.

The same part gets entered a dozen ways. Abbreviations and unit variants hide the duplicates. Nobody fully trusts the catalog — so teams re-buy what they already have and carry inventory they don't need.

🔁

Hidden duplicates

1,267 duplicate records across 563 groups in a single 5,000-item sample — most invisible to exact search.

🔤

Inconsistent wording

“CS” vs “carbon steel”, 3" vs 3 IN vs “3 inch”. Same item, unrecognisable to a GROUP BY.

🕳️

Silent gaps

Under-specified and mis-classified records that only surface when a purchase or audit goes wrong.

Athena finds it, scores it honestly, and helps you consolidate it — on your own infrastructure.

01 · Search

Search the way people actually type.

One messy query surfaces every recorded variant of the same thing — because the engine normalises language and units before it matches.

CS→

Expands abbreviations: CS → carbon steel, Red → reducer.

=

Reconciles units: 10 in = 254 mm, 3" = 3 IN.

&

Strict match — requires both keyword and size, so no irrelevant rows.

exl-athena · Master Data Search
🗄 Warehouse table📄 File (server path)
Red 10 In
Interpreted as reducer 10 in / 254 mm · 4 full matches · 2 look like the same part recorded differently.
MatchItem codeDescriptionGroup
96%MRO-100231REDUCER 10 IN CSdup #1
94%MRO-104880RED 10" CARBON STEELdup #1
88%MRO-101907REDUCER 254 MM
83%MRO-102544REDUCER 10 IN SS
02 · Instant AI data quality

A full health check in about a second.

One click profiles 100% of the records and scores a representative sample — an honest score you can defend, not an inflated one.

100%

Profiles every record (counts, nulls, duplicate codes) — no sampling on the facts.

Representative sample for the rates — so the % matches whatever your team counts themselves.

6

Score is 6 quality rules; duplicates are reported separately, per commodity.

⚡ AI Data Quality Assessment · assessed in 1.0s
⚡ AI Data Quality Assessmentestimate · representative sample
Overall quality
89.7%
Confidence: High
5,000
Total records
9
Commodities
550 (11%)
Representative sample
0
Missing description
Overall Duplicate %
27.6%
Rules + Deep AI
Rules-level
27.6%
representative sample · dataset estimate
Deep AI (sample)
+3.1%
semantic dups rules miss
CommodityRecordsSampleQualityDuplicate %
MECHANICAL2,88928990%29.4%
ELECTRICAL1,28412888%17.2%
INSTRUMENTATION2592687%15.4%
DRILLING1562091%25.0%
03 · The evidence

Not just a number — the actual problems.

The headline stays honest and defensible. Alongside it, “What we caught” shows the real offenders your team will recognise instantly.

Biggest duplicate groups — click any card to expand every member (badge count = full group size).

Lowest-quality records — concrete under-specified items, ranked worst-first.

Defensible headline + damning evidence is what wins a proof-of-concept.

🔍 What we caught
🔍 What we caughtConcrete problems found in your data.
1,267
Duplicate records
563
Duplicate groups
39
Under-specified
BIGGEST DUPLICATE GROUPS
×5 recordsMECHANICAL · BAR
MRO-100787 BAR 8 IN
MRO-100788 BAR 8"
MRO-103013 BAR 8 IN
▾ Show all 5 duplicates
×4 recordsMECHANICAL · RSTRCTR
MRO-100059 RESTRICTOR 3 IN
MRO-100060 RESTRICTOR 3 IN
MRO-102660 RESTRICTOR 3 IN
▾ Show all 4 duplicates
×4 recordsELECTRICAL · PRTCTR_CBL
MRO-101277 PROTECTOR CABLE 6 IN
MRO-101279 PROTECTOR CABLE 6 IN
MRO-102921 PROTECTOR CABLE 6 IN
▾ Show all 4 duplicates
04 · Deep AI scan

Catch the duplicates that hide behind different words.

The heavy artillery for the cases rules and keyword search can't reach — synonyms, reworded items, cross-unit matches — every verdict explained.

Finds “grub screw” = “set screw” and 2 in = 50.8 mm.

🛡

A hard-identity guard vetoes false merges — different part numbers stay separate.

%

Every group shows confidence + matched / differing attributes and a plain-language reason.

🤖 Deep AI scan · 8 AI-found + 14 rule-found groups
AI · 92% confident ✓ noun✓ size 6 mmΔ wording
“Both are the same fastener — ‘grub screw’ and ‘set screw’ are synonyms; identical thread and length.”
MRO-102310GRUB SCREW M6 X 10
MRO-105774SET SCREW 6 MM X 10 MM
Rules · 100% confident ✓ noun✓ size 2 in
“Unit variant of the same valve — 2 in = 50.8 mm.”
MRO-100944BALL VALVE 2 IN
MRO-103127BALL VALVE 50.8 MM
05 · Identify

Every item, classified to your standard.

One click classifies any row into your ISO-8000-style taxonomy — the noun, the class, and the attributes that actually define the item's identity.

🏷

2,818 classes across 9 commodities — noun + modifier resolved automatically.

Extracts identity attributes (the ones that make two items genuinely different).

Reference is upload-and-refresh — no restart to update the taxonomy.

Master Data Search · Identify
Item codeDescriptionTaxonomy class
MRO-100944BALL VALVE 2 IN CS 150# 🏷 Ball Valve
size: 2 in · material: carbon steel · rating: 150#
MRO-100059RESTRICTOR 3 IN
MRO-102310GRUB SCREW M6 X 10 🏷 Set Screw
thread: M6 · length: 10 mm
The takeaway

Trust your master data again.

Search it, score it, and consolidate it — with AI that never sends a single record off your network.

🔍

Search

Every variant of the same item, in one human query.

Assess

An honest, defensible health score in about a second.

🤖

Consolidate

Deep AI dedup with explained, reviewable suggestions.

Let's run it on your catalog.