Understanding the data preparation process
Research shows that the data preparation process is estimated to take up to 80% of the overall analysis time. For businesses, this continues to be a major barrier to getting a quick and accurate analysis. The data preparation process allows anyone to quickly turn any raw data from multiple sources into refined information assets so it can be used for accurate analysis and valuable business insights. The self-service data preparation process is quickly becoming a skill that is required for an increasing number of data analysts, data scientists, and business users. These individuals have been learning and adopting this new skill to support their daily business intelligence activities and analytic initiatives. To date, the tools available have been somewhat limited to Excel or other spreadsheet applications. As a result, it’s not always clear what a data preparation process should be, who’s responsible for it and how it fits with the current analytics practice.