Paper Contents
Abstract
In many research fields, including social sciences one needs to prepare quality data by pre-processing the raw data. An essential step in the data analysis process is data preparation. The raw data which we collect never comes in a form that can be used immediately. We have to take data and draw some useful information by compiling data into right format without errors. Data preparation can be broadly classified into three phases, extract, transform and load. While extracting we are focused on connecting and joining data. In transforming stage, we do some simple auditing to see what we are working with and finding the loopholes in the data. In last phase which is loading, we ultimately end up with the complete data set ready for analysis in tableau. In this book chapter, we have tried to explain the various steps involved in data preparation beginning from questionnaire checking to storage of data.
Copyright
Copyright © 2023 Satwik Sahay Bisarya. This is an open access article distributed under the Creative Commons Attribution License.
