Data Collection and Integration

Identify the Data Sources

Identify and document all relevant data sources (internal and external). This can include databases, ERP Systems, Digital Data, CRM systems, IoT sensors, social media, Excel files, etc. Gather information on the frequency of load, volume of data, and the quality of data. Identify any data gaps, inconsistencies, or quality issues. Create a data mapping that gives the details of all data sources and entities in each of them.

The following template helps in mapping the data sources. A master sheet that lists all the data sources with a reference to the detailed description of each.