Reference data is data that helps categorize/classify/label other data. It’s sounds abstract but it’s really simple. Think about that every time you have seen a dropdown, checkbox or a radio button. This is usually used for simple classification. Reference data is commonly known by other names - codes, lookups, lists of values, enums or domains. It’s a subset of Master Data and should also be managed for better data quality, integration and analytics.
Examples of reference data:
Lookup is a collection of values/codes. Every database is full of lookups. Examples: currencies, country codes, document getTypes, order statuses and many more. Dataedo allows you to define those lookups and document their allowed values.
Allow everyone in your organization to understand reference data/lookup by explaining values with titles, descriptions and custom fields.
Create a list of values manually or build lookups automatically from your data sources.
Define multiple instances of columns containing a particular lookup (think currency for example).
See popularity of particular values in specific columns to better understand your data and its data quality.
Dataedo allows you to load new values from the source database into a “For review” section.
Approve or reject values imported from the source.
You can provide cleansing rules for rejected values that were imported from the sources (by mapping incorrect values to the correct ones). Use this metadata for data cleansing.
Expand documentation of business terms by documenting it’s domain of values.
Document reference data from different columns, tables and data sources in a single place. Share complete data documentation with your team.
Easily identify duplicates, wrong values and define cleasing rules for your source data.
Know what values are allowed for different columns. Identify mistakes in reports easily.
Document reference data in one place to create a consistent understanding across the organization.
Enable accurate analytics and reporting with duplicate and mistake-free categorization of data such as countries statuses, currency codes and more.
Simplify data integration between different systems by providing trusted sets of lookup values.
"We jump started all of our Data Governance efforts using the tool. We documented key databases quickly and easily and published the information to our analyst community."
"Dataedo is improving my work a lot. With documentation, the learning curve is smaller and I can have more time to work."
"Thanks to Dataedo I spent more time figuring out the connection string to the instance than I did running the report. It was a great experience."
"Dataedo is an easy to use facility for managing basic metadata centrally and producing enhanced data dictionaries."
"Dataedo helps developers to find descriptions for data very quickly. Seeing documentation progress with every release is really helpful."