Data Warehouse Automation - Advanced Tips & Tricks

As I create new How-To guides specific to data warehouse automation, I'll add them here.

Fuzzy Lookups

Fuzzy Look-ups allow business to match and conform data to a reference set.

Use Cases:

• A government organisation had several databases for employees including temp hires, contractors, and diverse databases for various civil services.  They also identified challenges when employees left an organisation and came back as contractors or new EmployeeID's.  
• An entertainment venue with online marketing systems, retail stores, customer loyalty programs, and web sales to track create a unified view of customers while consolidating duplicate entries across the systems.
• A parcel delivery and courier service had issues with rampant data entry issues for order intake.     Fuzzy logic in conjunction with geocoding addresses  facilitated location-based analytics and faster / more accurate deliveries.

In this video, we use the Jet Data Manager, a data warehouse automation tool, in conjunction with SSIS and Visual Studio to rapidly implement a data quality architecture.