{"id":2082,"date":"2017-03-30T15:57:47","date_gmt":"2017-03-30T19:57:47","guid":{"rendered":"https:\/\/solutionsreview.com\/data-integration\/?p=2082"},"modified":"2018-11-30T12:56:54","modified_gmt":"2018-11-30T17:56:54","slug":"youre-spending-way-too-much-time-on-data-preparation","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/","title":{"rendered":"You’re Spending Way Too Much Time on Data Preparation"},"content":{"rendered":"

\"You're<\/p>\n

In a recent executive study by TDWI, 37 percent of respondents said they spent anywhere from 61 to 80 percent of their time doing data preparation instead of analysis and interaction. The survey\u00a0TDWI Best<\/a> P<\/a>ractices<\/a> Report: Improving Data Preparation for Business Analytics<\/a>\u00a0<\/em>also revealed that 28 percent of those polled spend 41 to 60 percent of their time doing the same. If we extrapolate those numbers, we can see that analysts are spending way too much time doing data prep and not enough time on the\u00a0analytics\u00a0itself.<\/p>\n

\t\t\t

\"Download<\/a><\/p>\n<\/div>\n\t\t<\/div><\/div>\n

After spending virtually all their time doing data prep as a pre-process to analytics, it’s no surprise that more than four-fifths of those polled consider hastening this process to be their number-one priority. Additionally, users cite ETL and Data Integration\u00a0as slow and key barriers to improving data preparation projects. Other data-prep related wish list items for analysts include improving operational efficiency for end-users and making enterprise vital data more widely available.<\/p>\n

In a related study last year, Blue Hill Research recorded similar trends. According to their report\u00a0Quantifying the Case for Enhanced Data Preparation<\/a>,\u00a0<\/em>the typical data analyst spends two hours per day exclusively on data preparation, accounting for nearly 500 hours per year. In conjunction, 28 percent of all a data analyst\u2019s time is spent doing data preparation, accounting for roughly $22,000 worth of a typical data analyst\u2019s yearly salary.<\/p>\n

It’s unclear if the TDWI study polled individuals and organizations currently utilizing dedicated data preparation platforms, but Blue Hill’s research showed that those who deployed standalone or embedded data prep tools reported saving considerable time. To this point, Blue Hill recommends that organizations look into data prep tools to help alleviate some of the time that data analysts must commit to preparation.<\/p>\n

It wouldn’t be a post at Solutions Review if we didn’t at least point you in the direction of some tools to meet what’s becoming a time-sink for many. Analyst house Forrester Research recently released the latest version of its Data Preparation Tools\u00a0Wave Report for Q1 2017<\/a><\/em>. Researcher Cinny Little identifies\u00a0the seven providers whom are most significant in the category.\u00a0The Wave details their research\u00a0and examines how each vendor meets (or falls short of) Forrester\u2019s evaluation criteria.<\/p>\n

<\/div><\/p>\n
Widget not in any sidebars
\n","protected":false},"excerpt":{"rendered":"

In a recent executive study by TDWI, 37 percent of respondents said they spent anywhere from 61 to 80 percent of their time doing data preparation instead of analysis and interaction. The survey\u00a0TDWI Best Practices Report: Improving Data Preparation for Business Analytics\u00a0also revealed that 28 percent of those polled spend 41 to 60 percent of […]<\/p>\n","protected":false},"author":23,"featured_media":3109,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[3],"tags":[343],"acf":[],"yoast_head":"\nYou're Spending Way Too Much Time on Data Preparation<\/title>\n<meta name=\"description\" content=\"Organizations are spending too much time (and money) on data preparation, and the overwhelming majority of data analysts know it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tim King\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/\"},\"author\":{\"name\":\"Tim King\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\"},\"headline\":\"You’re Spending Way Too Much Time on Data Preparation\",\"datePublished\":\"2017-03-30T19:57:47+00:00\",\"dateModified\":\"2018-11-30T17:56:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/\"},\"wordCount\":394,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2017\/03\/oie_30185317ofjSE0cE.jpg\",\"keywords\":[\"Data Preparation\"],\"articleSection\":[\"Data Integration News\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/\",\"name\":\"You're Spending Way Too Much Time on Data Preparation\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2017\/03\/oie_30185317ofjSE0cE.jpg\",\"datePublished\":\"2017-03-30T19:57:47+00:00\",\"dateModified\":\"2018-11-30T17:56:54+00:00\",\"description\":\"Organizations are spending too much time (and money) on data preparation, and the overwhelming majority of data analysts know it.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2017\/03\/oie_30185317ofjSE0cE.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2017\/03\/oie_30185317ofjSE0cE.jpg\",\"width\":799,\"height\":400,\"caption\":\"You're Spending Way Too Much Time on Data Preparation\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-integration\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"You’re Spending Way Too Much Time on Data Preparation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"name\":\"Best Data Integration Vendors, News & Reviews for Big Data, Applications, ETL and Hadoop\",\"description\":\"Data Integration Buyers Guide and Best Practices\",\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\",\"name\":\"Solutions Review\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"width\":225,\"height\":90,\"caption\":\"Solutions Review\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\",\"name\":\"Tim King\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg\",\"caption\":\"Tim King\"},\"description\":\"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \\\"Who's Who\\\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/author\/timking\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"You're Spending Way Too Much Time on Data Preparation","description":"Organizations are spending too much time (and money) on data preparation, and the overwhelming majority of data analysts know it.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/","twitter_misc":{"Written by":"Tim King","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#article","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/"},"author":{"name":"Tim King","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c"},"headline":"You’re Spending Way Too Much Time on Data Preparation","datePublished":"2017-03-30T19:57:47+00:00","dateModified":"2018-11-30T17:56:54+00:00","mainEntityOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/"},"wordCount":394,"commentCount":0,"publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2017\/03\/oie_30185317ofjSE0cE.jpg","keywords":["Data Preparation"],"articleSection":["Data Integration News"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/","url":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/","name":"You're Spending Way Too Much Time on Data Preparation","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2017\/03\/oie_30185317ofjSE0cE.jpg","datePublished":"2017-03-30T19:57:47+00:00","dateModified":"2018-11-30T17:56:54+00:00","description":"Organizations are spending too much time (and money) on data preparation, and the overwhelming majority of data analysts know it.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2017\/03\/oie_30185317ofjSE0cE.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2017\/03\/oie_30185317ofjSE0cE.jpg","width":799,"height":400,"caption":"You're Spending Way Too Much Time on Data Preparation"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-integration\/youre-spending-way-too-much-time-on-data-preparation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-integration\/"},{"@type":"ListItem","position":2,"name":"You’re Spending Way Too Much Time on Data Preparation"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-integration\/#website","url":"https:\/\/solutionsreview.com\/data-integration\/","name":"Best Data Integration Vendors, News & Reviews for Big Data, Applications, ETL and Hadoop","description":"Data Integration Buyers Guide and Best Practices","publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/solutionsreview.com\/data-integration\/#organization","name":"Solutions Review","url":"https:\/\/solutionsreview.com\/data-integration\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","width":225,"height":90,"caption":"Solutions Review"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c","name":"Tim King","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2023\/12\/tk.jpg","caption":"Tim King"},"description":"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \"Who's Who\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.","url":"https:\/\/solutionsreview.com\/data-integration\/author\/timking\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/2082"}],"collection":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/comments?post=2082"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/2082\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media\/3109"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media?parent=2082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/categories?post=2082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/tags?post=2082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}