With staff working from home, many institutions are prioritizing data quality projects. Originally presented at Collective Imagination 2012, this presentation has been updated to reflect changes to The Museum System (TMS), and the availability of new low-cost or free tools. It provides insights into how to prevent, clean, and monitor data quality, with techniques for power users, system administrators, and SQL experts alike.
Presented as a webinar for Gallery Systems. 16 June 2020.
Tag: data profiling
-
How Clean is your Database?
-
Standardizing your Constituent Phone Numbers
Did you ever notice that American and Canadian phone numbers are both prefaced with the international calling code of “1”? This is because twenty countries, primarily in North America and the Caribbean, participate in the North American Numbering Plan (NANP). Let’s examine how these numbers are structured, establish standards for data entry and then apply those standards to our existing records.
(more…)