ERP Master Data Cleansing (SAP, Oracle & Co.): Vendors, Customers & Materials
Profile vendor extracts, normalise names and addresses, find exact and fuzzy duplicates, convert units of measure, run IBAN/VAT/terms validation rules, build golden records and a migration readiness scorecard: 8 hands-on labs at one company, working with export data from systems such as SAP, Oracle, NetSuite or Dynamics, every cell checked instantly.
The first 2 lessons are free — no account needed.
Lessons
- Profiling the Vendor Extract: Filled Fields, Record Scores & Field CompletenessFree
- Normalising Names & Addresses: TRIM, UPPER, SUBSTITUTE & Country MappingFree
- Exact Duplicates: COUNTIFS Keys, Survivors & UNIQUE Pro
- Fuzzy Duplicates: Match Keys without Punctuation & Legal Forms Pro
- Units of Measure: Standard Codes, Conversion Factors & Price per Base Unit Pro
- Validation Rules: IBAN Length, VAT Patterns, Allowed Terms & Required Fields Pro
- Merge Rules: Building the Golden Record from Duplicate Sources Pro
- Capstone: Migration Readiness Scorecard with Traffic Lights Pro