Data Automation – Part 1
Data automation is the process of updating data programmatically. Automating the process of data handling is important for the long-term sustainability of any data program. There are three common elements to data automation: E xtract, T ransform, and L oad. E xtract : the process of extracting your data from one or many sources’ systems Transform : the process of transforming your data into the necessary structure. Load : the process of loading the data into the final system. In these three parts of write-up, first we will take up how to extract the data or methods of collecting the data before diving into the technical nitty-gritty of data automation. Having a complete clarity beforehand about all the three elements will help you to pick the right process and engage the right people at the right time within your project management initiate. In general Data capture is the process of extracting information from a source and converting it into data readable by a...