Documenting reference data (lookups, codes) and how it helped me fix data quality

Download presentation from the webinar

Almost no one knows what a reference data is, but everyone has seen and used it many times. Those are all those codes, lists of values, lookup, or dropdowns that we have all filled in on numerous forms. Those are all those vague status, type or flag columns. What does status = ‘D’ mean? Is it ‘Disabled’ or ‘Deleted’? What values are even allowed? Those and more questions can be answered with a convenient documentation.

Learn how to get your lookups under control. From this webinar you will learn:

  • What is reference data
  • See examples of reference data
  • Why documenting reference data is crucial for analytics and data quality
  • How to document reference data using Dataedo
  • See how I fixed a report with a simple lookup definition