{"id":1453,"date":"2019-11-11T13:40:30","date_gmt":"2019-11-11T13:40:30","guid":{"rendered":"http:\/\/xtract.io\/blog\/?p=1453"},"modified":"2025-01-21T07:58:33","modified_gmt":"2025-01-21T07:58:33","slug":"data-quality-data-preparation-mistakes","status":"publish","type":"post","link":"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/","title":{"rendered":"Five Data Preparation Mistakes to Avoid Like the Plague"},"content":{"rendered":"\n<p>Let\u2019s play a quick puzzle game.<\/p>\n\n\n\n<p><strong>Question:<\/strong>&nbsp;Name the company.<\/p>\n\n\n\n<p><strong>Clue 1:<\/strong>&nbsp;This company is one of the big 4 technology companies on the globe along with Amazon, Apple, and Google.<\/p>\n\n\n\n<p><strong>Clue 2:<\/strong>&nbsp;It sprouted out in 2004.<\/p>\n\n\n\n<p><strong>Clue 3:<\/strong>&nbsp;It reported global revenue of&nbsp;<a href=\"https:\/\/www.statista.com\/statistics\/268604\/annual-revenue-of-facebook\/\" target=\"_blank\" rel=\"noopener\" aria-label=\" (opens in a new tab)\">$55.8 billion as of 2018<\/a>.<\/p>\n\n\n\n<p>That should\u2019ve been a piece of cake! (I have no presents for you, though&nbsp;:\/).<\/p>\n\n\n\n<p><strong>The answer<\/strong>: Facebook<em>.<\/em><\/p>\n\n\n\n<p>Apart from these well-known facts about Facebook, I\u2019d like to take you back to a few years.<\/p>\n\n\n\n<p>It was 2004 when Mark Zuckerburg along with his four Harvard University friends founded Facebook. Two years went by and the team was pulling out all the stops to grow their company. In 2006, Zuckerburg hired the first Data Scientist\u200a\u2014\u200aJeff Hammerbacher, a math nerd who was fresh out of college. He was given a princely title of a research scientist, whose role was to primarily find out how people use social networking service.<\/p>\n\n\n\n<h3><strong>Five Data Preparation Blunders You Need to Get Rid&nbsp;<\/strong><\/h3>\n\n\n\n<p>In a&nbsp;<a rel=\"noopener\" href=\"https:\/\/www.bloomberg.com\/news\/articles\/2011-04-14\/this-tech-bubble-is-different\" target=\"_blank\">Bloomberg interview<\/a>, Jeff shared his experience on crunching data and building a new class of analytical technology when Facebook had no tools to do these yet. He later channelized his data science proficiency to provide better cancer treatments by&nbsp;analyzing large biological datasets&nbsp;after leaving facebook.<\/p>\n\n\n\n<p>All Data Scientists like Jeff, end up spending a lot of their time on data preparation rather than channelizing their time and technical know-how into modeling, computation, and training.<\/p>\n\n\n\n<h2><strong>Why Faulty Data&nbsp;Makes Your Castles Wonky<\/strong><\/h2>\n\n\n\n<p>Data preparation is a tedious task. It involves a ton of time and effort and is required to be error-free to make ingenious inventions.&nbsp;Data Science&nbsp;is taking a direction towards applications of data in transforming infrastructure, transportation, environment, medicine, and many other significant arenas for a better and advanced living.<\/p>\n\n\n\n<p>Today, I\u2019m going to take you through certain common data preparation mistakes that are costly and cause serious repercussions like wrong insights and strategy, iterations of complex models, and dysfunction of analytical models.<\/p>\n\n\n\n<h3><strong>Five Data Preparation Blunders You Need to Get Rid&nbsp;<\/strong>off<\/h3>\n\n\n\n<h4><strong>1. Losing the context of the use case\u200a\u2014\u200aWhy deviation is dangerous<\/strong><\/h4>\n\n\n\n<p>The technical expertise vested with the IT departments enables operations and implementation of data preparation. While a combination of this control between IT and business departments gives a healthy blend of business know-how and technical expertise, data preparation completely vested with the IT department has a minor setback.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p> <strong>T<em>o continue reading, head to<a rel=\"noopener\" href=\"https:\/\/www.kdnuggets.com\/2019\/10\/data-labeling-facilitates-ai-models.html?utm_source=data-labeling&amp;utm_medium=CTA&amp;utm_campaign=Blog\" target=\"_blank\">&nbsp;<\/a><a href=\"https:\/\/dzone.com\/articles\/5-data-preparation-mistakes-to-avoid-like-the-plag?utm_source=data-preparation-mistakes&amp;utm_medium=CTA&amp;utm_campaign=Blog\" target=\"_blank\" rel=\"noopener\" aria-label=\"DZone (opens in a new tab)\">DZone<\/a>&nbsp;where this article was originally published.<\/em><\/strong> <\/p><\/blockquote>\n\n\n<div\n\t\t\t\tclass=\"hustle-ui hustle-inline hustle-palette--midnight hustle_module_id_2 module_id_2  \"\n\t\t\t\t\n\t\t\tdata-id=\"2\"\n\t\t\tdata-render-id=\"0\"\n\t\t\tdata-tracking=\"disabled\"\n\t\t\t\n\t\t\t\tdata-intro=\"no_animation\"\n\t\t\t\tdata-sub-type=\"shortcode\"\n\t\t\t\t\n\t\t\t\tstyle=\"opacity: 0;\"\n\t\t\t><div class=\"hustle-inline-content\"><div class=\"hustle-optin hustle-optin--compact\"><div class=\"hustle-optin-content\"><div class=\"hustle-success\" data-close-delay=\"false\" style=\"display: none;\"><span class=\"hustle-icon-check\" aria-hidden=\"true\"><\/span><div class=\"hustle-success-content\"><\/div><\/div><div class=\"hustle-layout\"><div class=\"hustle-layout-body\"><div class=\"hustle-image hustle-image-fit--contain\" aria-hidden=\"true\"><img src=\"http:\/\/xtract.io\/blog\/wp-content\/uploads\/2019\/11\/subscribe-2.png\" alt=\"\" class=\"hustle-image-position--centercenter\" \/><\/div><div class=\"hustle-layout-content\"><div class=\"hustle-content\"><div class=\"hustle-content-wrap\"><div class=\"hustle-group-title\"><span class=\"hustle-title\">Stay in the know! Always!!<\/span><\/div><div class=\"hustle-group-content\"><p>Get the latest tips and tricks on data, analytics, and technology delivered directly into your inbox.<\/p>\n<\/div><\/div><\/div><form class=\"hustle-layout-form\" novalidate=\"novalidate\"><div class=\"hustle-form hustle-form-inline\"><div class=\"hustle-form-fields hustle-proximity-joined\"><div class=\"hustle-field hustle-field-icon--static hustle-field-required \"><label for=\"hustle-field-email-module-2\" id=\"hustle-field-email-module-2-label\" class=\"hustle-screen-reader\">Your email<\/label><input id=\"hustle-field-email-module-2\" type=\"email\" class=\"hustle-input \" name=\"email\" value=\"\" aria-labelledby=\"hustle-field-email-module-2-label\" data-validate=\"1\" data-required-error=\"Your email is required.\" data-validation-error=\"Please enter a valid email.\" \/><span class=\"hustle-input-label\" aria-hidden=\"true\" style=\"flex-flow: row nowrap;\"><span class=\"hustle-icon-email\"><\/span><span>Enter your Email Id<\/span><\/span><\/div><button class=\"hustle-button hustle-button-submit \" aria-live=\"polite\" data-loading-text=\"Form is being submitted, please wait a bit.\"><span class=\"hustle-button-text\">Submit<\/span><span class=\"hustle-icon-loader hustle-loading-icon\" aria-hidden=\"true\"><\/span><\/button><\/div><\/div><input type=\"hidden\" name=\"hustle_module_id\" value=\"2\"><input type=\"hidden\" name=\"post_id\" value=\"0\"><input type=\"hidden\" name=\"hustle_sub_type\" value=\"shortcode\"><label for=\"hustle-gdpr-module-2-0\" class=\"hustle-checkbox hustle-gdpr \"><input type=\"checkbox\" name=\"gdpr\" id=\"hustle-gdpr-module-2-0\" data-required-error=\"Please accept the terms and try again.\"  \/><span aria-hidden=\"true\"><\/span><span>I consent to add my email to your mailing list |\u00a0<a href=\"https:\/\/www.xtract.io\/privacy-policy\" target=\"_blank\">Privacy Policy.<\/a><\/span><\/label><div class=\"hustle-error-message\" style=\"display: none;\" data-default-error=\"Please fill out all required fields.\"><\/div><\/form><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Let\u2019s play a quick puzzle game. Question:&nbsp;Name the company. Clue 1:&nbsp;This company is one of the big 4 technology companies on the globe along with Amazon, Apple, and Google. Clue 2:&nbsp;It sprouted out in 2004. Clue 3:&nbsp;It reported global revenue of&nbsp;$55.8 billion as of 2018. That should\u2019ve been a piece of cake! (I have no<\/p>\n","protected":false},"author":4,"featured_media":2418,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[265],"tags":[85,86,87,88,244],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>5 Common Data Preparation Mistakes<\/title>\n<meta name=\"description\" content=\"Data preparation is an essential process befor building analytical models. But, there are some common mistakes that happen during the process that can completely ruin the output.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 Common Data Preparation Mistakes\" \/>\n<meta property=\"og:description\" content=\"Data preparation is an essential process befor building analytical models. But, there are some common mistakes that happen during the process that can completely ruin the output.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog | Xtract.io\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-11T13:40:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-21T07:58:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.xtract.io\/blog\/wp-content\/uploads\/2019\/11\/x-tract-data-preparation-banner-2398x859-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"912\" \/>\n\t<meta property=\"og:image:height\" content=\"451\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nandhini TS\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nandhini TS\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"5 Common Data Preparation Mistakes","description":"Data preparation is an essential process befor building analytical models. But, there are some common mistakes that happen during the process that can completely ruin the output.","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:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/","og_locale":"en_US","og_type":"article","og_title":"5 Common Data Preparation Mistakes","og_description":"Data preparation is an essential process befor building analytical models. But, there are some common mistakes that happen during the process that can completely ruin the output.","og_url":"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/","og_site_name":"Blog | Xtract.io","article_published_time":"2019-11-11T13:40:30+00:00","article_modified_time":"2025-01-21T07:58:33+00:00","og_image":[{"width":912,"height":451,"url":"https:\/\/www.xtract.io\/blog\/wp-content\/uploads\/2019\/11\/x-tract-data-preparation-banner-2398x859-1.jpg","type":"image\/jpeg"}],"author":"Nandhini TS","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nandhini TS","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.xtract.io\/blog\/#website","url":"https:\/\/www.xtract.io\/blog\/","name":"Blog | Xtract.io","description":"Web data extraction and aggregation services","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.xtract.io\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/#primaryimage","url":"https:\/\/www.xtract.io\/blog\/wp-content\/uploads\/2019\/11\/x-tract-data-preparation-banner-2398x859-1.jpg","contentUrl":"https:\/\/www.xtract.io\/blog\/wp-content\/uploads\/2019\/11\/x-tract-data-preparation-banner-2398x859-1.jpg","width":912,"height":451},{"@type":"WebPage","@id":"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/","url":"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/","name":"5 Common Data Preparation Mistakes","isPartOf":{"@id":"https:\/\/www.xtract.io\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/#primaryimage"},"datePublished":"2019-11-11T13:40:30+00:00","dateModified":"2025-01-21T07:58:33+00:00","author":{"@id":"https:\/\/www.xtract.io\/blog\/#\/schema\/person\/a73a353615eca72059ccfd87583b0df3"},"description":"Data preparation is an essential process befor building analytical models. But, there are some common mistakes that happen during the process that can completely ruin the output.","breadcrumb":{"@id":"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.xtract.io\/blog\/data-quality-data-preparation-mistakes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.xtract.io\/blog\/"},{"@type":"ListItem","position":2,"name":"Five Data Preparation Mistakes to Avoid Like the Plague"}]},{"@type":"Person","@id":"https:\/\/www.xtract.io\/blog\/#\/schema\/person\/a73a353615eca72059ccfd87583b0df3","name":"Nandhini TS","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.xtract.io\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/701634c99621f598c306aaee216663e5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/701634c99621f598c306aaee216663e5?s=96&d=mm&r=g","caption":"Nandhini TS"},"description":"I am a product marketing associate. I am passionate about creating, managing, and marketing content. In my time off, I have my nose buried in growing my side hustles and binge-watching dinosaur documentaries.","url":"https:\/\/www.xtract.io\/blog\/author\/nandhini\/"}]}},"_links":{"self":[{"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/posts\/1453"}],"collection":[{"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/comments?post=1453"}],"version-history":[{"count":6,"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/posts\/1453\/revisions"}],"predecessor-version":[{"id":1533,"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/posts\/1453\/revisions\/1533"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/media\/2418"}],"wp:attachment":[{"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/media?parent=1453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/categories?post=1453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xtract.io\/blog\/wp-json\/wp\/v2\/tags?post=1453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}