{"id":79,"date":"2026-05-09T20:33:17","date_gmt":"2026-05-09T18:33:17","guid":{"rendered":"https:\/\/nachoastorga.com\/blog\/?p=79"},"modified":"2026-05-10T19:11:49","modified_gmt":"2026-05-10T17:11:49","slug":"el-arte-de-limpiar-antes-de-pintar","status":"publish","type":"post","link":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/","title":{"rendered":"El arte de limpiar antes de pintar"},"content":{"rendered":"\n

Por q\u00fae tu SQL define la calidad de tu gr\u00e1fico en tu an\u00e1lisis de datos<\/h2>\n\n\n\n

<\/p>\n\n\n\n

Si ya cuentas con algo de experiencia como Analista de datos,<\/strong> sabr\u00e1s que un dashboard brillante suele esconder detr\u00e1s un SQL muy aburrido. Muchos analistas junior cometen el error de volcar datos \u00absucios\u00bb en su herramienta de visualizaci\u00f3n pensando que posteriormente todo se podr\u00e1 ir solucionando con filtros o campos calculados. <\/p>\n\n\n\n

La realidad es que la visualizaci\u00f3n comienza en la terminal. Si tu WHERE no es preciso o si no has gestionado correctamente los NULL, t\u00fa gr\u00e1fico ser\u00e1 en el mejor de los casos, lento; y en el peor, ofrecer\u00e1 datos falsos.<\/p>\n\n\n\n

El SQL es tu base, la visualizaci\u00f3n es tu fachad<\/strong>a<\/p>\n\n\n\n

En mis inicios, muchas veces ca\u00eda en la tentaci\u00f3n de ir directo al \u00abcolor\u00bb, a ponerme con el dise\u00f1o de las gr\u00e1ficas lo antes posible.Pero un analista que comience a ser consciente de lo que tiene entre manos pasar\u00e1 al menos el 70% del tiempo optimizando la consulta. No se trata solo de que el gr\u00e1fico se vea bien, se trata de que sea escalable<\/strong>. Si tu consulta tarda 40 segundos en devolver 1000 filas, tienes un problema t\u00e9cnico que debes solucionar lo antes posible.<\/p>\n\n\n\n

Antes de abrir Tableau, Power BI, Seaborn…., aseg\u00farate que tu tabla sea lo m\u00e1s parecida a lo que vas a pintar posteriormente. Menos transformaciones en \u00abcaliente\u00bb significan menos errores y m\u00e1s velocidad.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a>
Data cleaning con SQL y Python<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

Por q\u00fae tu SQL define la calidad de tu gr\u00e1fico en tu an\u00e1lisis de datos Si ya cuentas con algo de experiencia como Analista de datos, sabr\u00e1s que un dashboard brillante suele esconder detr\u00e1s un SQL muy aburrido. Muchos analistas junior cometen el error de volcar datos \u00absucios\u00bb en su …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-79","post","type-post","status-publish","format-standard","hentry","category-analisisdedatos"],"yoast_head":"\nEl arte de limpiar antes de pintar - Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"El arte de limpiar antes de pintar - Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos\" \/>\n<meta property=\"og:description\" content=\"Por q\u00fae tu SQL define la calidad de tu gr\u00e1fico en tu an\u00e1lisis de datos Si ya cuentas con algo de experiencia como Analista de datos, sabr\u00e1s que un dashboard brillante suele esconder detr\u00e1s un SQL muy aburrido. Muchos analistas junior cometen el error de volcar datos \u00absucios\u00bb en su …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-09T18:33:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-10T17:11:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nachoastorga.com\/blog\/wp-content\/uploads\/2026\/05\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png\" \/>\n<meta name=\"author\" content=\"nachoastorga\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"nachoastorga\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/\"},\"author\":{\"name\":\"nachoastorga\",\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/#\\\/schema\\\/person\\\/9bafff8cf907157c6cdee83c682fbe09\"},\"headline\":\"El arte de limpiar antes de pintar\",\"datePublished\":\"2026-05-09T18:33:17+00:00\",\"dateModified\":\"2026-05-10T17:11:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/\"},\"wordCount\":263,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png\",\"articleSection\":[\"An\u00e1lisis de datos\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/\",\"url\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/\",\"name\":\"El arte de limpiar antes de pintar - Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png\",\"datePublished\":\"2026-05-09T18:33:17+00:00\",\"dateModified\":\"2026-05-10T17:11:49+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/#\\\/schema\\\/person\\\/9bafff8cf907157c6cdee83c682fbe09\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/#primaryimage\",\"url\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png\",\"contentUrl\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png\",\"width\":647,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/analisisdedatos\\\/el-arte-de-limpiar-antes-de-pintar\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"El arte de limpiar antes de pintar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/\",\"name\":\"Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos\",\"description\":\"Nunca pienses que ya lo sabes todo\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/#\\\/schema\\\/person\\\/9bafff8cf907157c6cdee83c682fbe09\",\"name\":\"nachoastorga\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ca3495bbdfae29efa3d2d750322c4bebe230f75d93f37fcf2e72fdff1d805d13?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ca3495bbdfae29efa3d2d750322c4bebe230f75d93f37fcf2e72fdff1d805d13?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ca3495bbdfae29efa3d2d750322c4bebe230f75d93f37fcf2e72fdff1d805d13?s=96&d=mm&r=g\",\"caption\":\"nachoastorga\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ignacio-astorga-ciruelos\\\/\"],\"url\":\"https:\\\/\\\/nachoastorga.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"El arte de limpiar antes de pintar - Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos","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:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/","og_locale":"es_ES","og_type":"article","og_title":"El arte de limpiar antes de pintar - Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos","og_description":"Por q\u00fae tu SQL define la calidad de tu gr\u00e1fico en tu an\u00e1lisis de datos Si ya cuentas con algo de experiencia como Analista de datos, sabr\u00e1s que un dashboard brillante suele esconder detr\u00e1s un SQL muy aburrido. Muchos analistas junior cometen el error de volcar datos \u00absucios\u00bb en su …","og_url":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/","og_site_name":"Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos","article_published_time":"2026-05-09T18:33:17+00:00","article_modified_time":"2026-05-10T17:11:49+00:00","og_image":[{"url":"https:\/\/nachoastorga.com\/blog\/wp-content\/uploads\/2026\/05\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png","type":"","width":"","height":""}],"author":"nachoastorga","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"nachoastorga","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/#article","isPartOf":{"@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/"},"author":{"name":"nachoastorga","@id":"https:\/\/nachoastorga.com\/blog\/#\/schema\/person\/9bafff8cf907157c6cdee83c682fbe09"},"headline":"El arte de limpiar antes de pintar","datePublished":"2026-05-09T18:33:17+00:00","dateModified":"2026-05-10T17:11:49+00:00","mainEntityOfPage":{"@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/"},"wordCount":263,"commentCount":0,"image":{"@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/#primaryimage"},"thumbnailUrl":"https:\/\/nachoastorga.com\/blog\/wp-content\/uploads\/2026\/05\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png","articleSection":["An\u00e1lisis de datos"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/","url":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/","name":"El arte de limpiar antes de pintar - Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos","isPartOf":{"@id":"https:\/\/nachoastorga.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/#primaryimage"},"image":{"@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/#primaryimage"},"thumbnailUrl":"https:\/\/nachoastorga.com\/blog\/wp-content\/uploads\/2026\/05\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png","datePublished":"2026-05-09T18:33:17+00:00","dateModified":"2026-05-10T17:11:49+00:00","author":{"@id":"https:\/\/nachoastorga.com\/blog\/#\/schema\/person\/9bafff8cf907157c6cdee83c682fbe09"},"breadcrumb":{"@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/#primaryimage","url":"https:\/\/nachoastorga.com\/blog\/wp-content\/uploads\/2026\/05\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png","contentUrl":"https:\/\/nachoastorga.com\/blog\/wp-content\/uploads\/2026\/05\/Captura-de-pantalla-2026-05-09-a-las-20.30.02-1.png","width":647,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/nachoastorga.com\/blog\/analisisdedatos\/el-arte-de-limpiar-antes-de-pintar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/nachoastorga.com\/blog\/"},{"@type":"ListItem","position":2,"name":"El arte de limpiar antes de pintar"}]},{"@type":"WebSite","@id":"https:\/\/nachoastorga.com\/blog\/#website","url":"https:\/\/nachoastorga.com\/blog\/","name":"Blog sobre un poco de Marketing y algo m\u00e1s de An\u00e1lisis de datos","description":"Nunca pienses que ya lo sabes todo","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nachoastorga.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/nachoastorga.com\/blog\/#\/schema\/person\/9bafff8cf907157c6cdee83c682fbe09","name":"nachoastorga","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/ca3495bbdfae29efa3d2d750322c4bebe230f75d93f37fcf2e72fdff1d805d13?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ca3495bbdfae29efa3d2d750322c4bebe230f75d93f37fcf2e72fdff1d805d13?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ca3495bbdfae29efa3d2d750322c4bebe230f75d93f37fcf2e72fdff1d805d13?s=96&d=mm&r=g","caption":"nachoastorga"},"sameAs":["https:\/\/www.linkedin.com\/in\/ignacio-astorga-ciruelos\/"],"url":"https:\/\/nachoastorga.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/posts\/79","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/comments?post=79"}],"version-history":[{"count":6,"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/posts\/79\/revisions"}],"predecessor-version":[{"id":91,"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/posts\/79\/revisions\/91"}],"wp:attachment":[{"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/media?parent=79"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/categories?post=79"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nachoastorga.com\/blog\/wp-json\/wp\/v2\/tags?post=79"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}