ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
Search

Data Warehouse Automation - Advanced Tips & Tricks

5/10/2016

0 Comments

 
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.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact