Importance of Data Dictionary

Sowhardh Honnappa
3 min readMay 20, 2020
Image Credits: https://dataedo.com/product/data-dictionary-tool

Data Dictionary

What is a Data Dictionary?

Data Dictionary provides a metadata about the data explaining the meaning of each and every field, data types of the field, sample values etc. Understanding the business context of fields in the data helps one to use appropriate features in the model. Data Dictionaries play an important role in understanding the data before we dive deep into it. In order to get started with Modelling, it is very important to understand the data.

Following are the crucial fields to be included in a Data Dictionary: -

1. Data Types of fields

2. Sample values of fields

3. Business Unit responsible for capture of the field

4. Point of Contact from the responsible business Unit for every field.

5. Detailed Business context, understanding of every field.

There are 2 advantages of constructing a Data Dictionary: -

1. Metadata to build data models and extend the database for the Database Team

2. Business understanding of the data which helps the Analytics team in an organization.

--

--