What is Data Preparation?

By on

Data PreparationData Preparation describes the process of getting data ready for use in analytics. In the past, Data Preparation was a time-consuming task handled by the IT team, involving “Data Extraction, Transformation and Loading (ETL), access to Data Warehouses and Data Marts, and lots of complicated massaging and manipulation of data across other data sources,” says Kartik Patel, but organizations are increasingly turning to sophisticated Self-Service Data Preparation tools that allow business users to prepare data themselves.

Other Definitions of Data Preparation Include:

  • A“pre-processing step in which data from one or more sources is cleaned and transformed to improve its quality prior to its use in business analytics.” (Infomatica)
  • Technology that allows administrators to make faster and better decisions through Data Quality and data access. (Jon Pilkington, DATAVERSITY®)
  • “Data preparation is the process of collecting data from a number of (usually disparate) data sources, and then profiling, cleansing, enriching, and combining those into a derived data set for use in a downstream process.” (Paxata)
  • A process to “identify and separate the relevant data items from a large body of data, so the separate items can be used in analytics queries.” (Mary Shacklett, TechRepublic)
  • The “most time-consuming task in analytics and BI [that] is evolving from a self-service activity to an enterprise imperative.” (Ehtisham Zaidi, et al., Gartner)
  • “The process of collecting, cleaning and consolidating data into one file or data table, primarily for use in analysis.” (Datawatch)

Businesses Use Data Preparation to:

Photo Credit: Harry Huber/Shutterstock.com

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept