A data dictionary is a short explanation about each of the attributes of a data set that allows an outsider (or someone less familiar with the data) to understand what each column or attribute means. Not all data sets have a data dictionary. Often, when exporting data to a .CSV, many have column headers in the first row, a data dictionary in the second row and then the real data starts on row three.
Creating a Data Dictionary
- Import your data
- When importing data into Numetric using the .CSV uploader, it is important to delete out any rows (including data dictionaries) besides the header row and the actual data.
- Go to your Datasets tab
- Click on the “Fields” tab in the upper part of the screen
- Select an individual field on the left
- Fill in the “Description” for each field in the data set.
Now, anyone who has access to the data set (Viewers or Editors) can understand what each field represents and how it was created.
*Note: You do not need to reindex the data in order for the description to be saved.
Suggestion: If the field is a calculated value, it’s a great practice to include the formula in the description so everyone knows how the number was created.