{"id":9945,"date":"2020-04-15T07:00:00","date_gmt":"2020-04-15T15:00:00","guid":{"rendered":"http:\/\/formtek.com\/blog\/?p=9945"},"modified":"2020-02-19T10:26:29","modified_gmt":"2020-02-19T18:26:29","slug":"data-prep-the-80-drudge-factor-holding-back-analytics","status":"publish","type":"post","link":"https:\/\/formtek.com\/blog\/data-prep-the-80-drudge-factor-holding-back-analytics\/","title":{"rendered":"Data Prep: The 80% Drudge Factor Holding Back Analytics"},"content":{"rendered":"\n

GIGO — Garbage In, Garbage Out<\/a> — simply means that data analysis and decision making based on poor raw data or information will necessarily result in a flawed analysis.<\/p>\n\n\n\n

The need for accurate data<\/a> is increasingly important as businesses adopt tools based on AI, business analytics, and Big Data. Data preparation is the process of cleaning data before being passing off for processing and analysis. Data prep involves transforming and reformatting the data, making corrections to it, and combining data to enrich the source data.<\/p>\n\n\n\n

Stewart Bond<\/a>, research director of the Data Integration and Integrity Software service at IDC, said that<\/a> “It’s the complexity of data environments in this day and age. There’s multiple different data types: There’s transactional data, master data, social media data, structured data, unstructured data, log file data, graph data. There’s all different kinds of data that is out there and there’s all different kinds of technologies that these data are being stored in.”<\/p>\n\n\n\n

Assigning metadata to data sets can also make data more useful and enable “data intelligence.” Bond said that<\/a> “It’s the intelligence to know where the data is, what the data means, who’s using it, who can get access to it, why we have the data, how long we need to keep the data, and how people are using it.”<\/p>\n\n\n\n

A report by CrowdFlower\/Figure-Eight in 2016<\/a> found that data preparation accounts for about 80 percent of the time spent by analysts. Since then, this is a stat that has stuck and is frequently quoted, and despite new prep tools, data prep time continues to be a roadblock that has to be passed before real data analytics can be done.<\/p>\n

\"Digg<\/a><\/div>
\"Reddit<\/a><\/div>
\"Stumble<\/a><\/div>
\"Buzz<\/a><\/div>
\"Vote<\/a><\/div>
\"Share<\/a><\/div>
\"Bookmark<\/a><\/div>
\"Kick<\/a><\/div>
\"Shout<\/a><\/div>
\"Share<\/a><\/div>
\"Bookmark<\/a><\/div>
\"Post<\/a><\/div>
\"Google<\/a><\/div><\/div>","protected":false},"excerpt":{"rendered":"

GIGO — Garbage In, Garbage Out — simply means that data analysis and decision making based on poor raw data or information will necessarily result in a flawed analysis. The need for accurate data is increasingly important as businesses adopt…<\/span><\/p>\n

Read more ›<\/a><\/div>\n

<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9945","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/9945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/comments?post=9945"}],"version-history":[{"count":2,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/9945\/revisions"}],"predecessor-version":[{"id":9947,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/9945\/revisions\/9947"}],"wp:attachment":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/media?parent=9945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/categories?post=9945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/tags?post=9945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}