Articles by Julien Kervizic
- Master Data Management, how to match and merge records to unify your data
Master Data Management aims at creating a single source of truth for different entities. At the heart of MDM projects lies the concept of matching and merging records to unify data. This involves identifying duplicate records that represent the same real-world entity and combining them into a single record. Matching and merging records accurately is crucial for MDM to provide a consistent view of data across systems. Effective techniques include string comparisons, phonetic algorithms and machine learning models to identify duplicate records and consolidate them. With MDM, businesses can gain a unified view of critical data for improved decision making and analytics.
- Your SQL is not like my SQL
Julien explains which jobs frequently use SQL, and the different SQL skills needed for each: Transactional SQL for software engineers Analytical SQL for data analysts Data Engineering SQL for data engineers