{"id":58844,"date":"2021-09-28T09:31:34","date_gmt":"2021-09-28T07:31:34","guid":{"rendered":"https:\/\/blog.euncet.com\/?p=58844"},"modified":"2023-03-07T10:15:30","modified_gmt":"2023-03-07T09:15:30","slug":"que-son-processos-etl","status":"publish","type":"post","link":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/","title":{"rendered":"Qu\u00e8 s\u00f3n els processos ETL (extreure, transformar i carregar)?"},"content":{"rendered":"<p>Les organitzacions sempre han\u00a0hagut de gestionar informaci\u00f3 per poder prendre decisions que gui\u00efn el rumb de l&#8217;empresa. Els temps actuals s&#8217;estan\u00a0caracteritzant, m\u00e9s que mai, pel gran poder que t\u00e9 una bona gesti\u00f3 i interpretaci\u00f3 de les dades.<\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u00cdNDEX DE CONTINGUTS<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #222222;color:#222222\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #222222;color:#222222\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#Processos_ETL\" >Processos ETL\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#Com_desenvolupar_els_processos_ETL_a_les_empreses\" >Com desenvolupar els processos ETL a les empreses?\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#Fase_dExtraccio_Extract\" >Fase d&#8217;Extracci\u00f3 (Extract)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#Fase_de_Transformacio_Transform\" >Fase de Transformaci\u00f3 (Transform)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#Carrega_Load\" >C\u00e0rrega (Load)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#Tipus_deines_ETL_Quines_son_les_mes_usades\" >Tipus d&#8217;eines\u00a0 ETL: Quines s\u00f3n les m\u00e9s usades?\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#Software_ETL_de_pago\" >Software ETL de pago<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#Software_Open_Source\" >Software Open Source<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#La_importancia_del_Big_Data_a_les_empreses\" >La import\u00e0ncia del Big Data a les empreses\u00a0 \u00a0\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n\n<p><span data-contrast=\"auto\">En el seg\u00fcent article, veurem en qu\u00e8 consisteixen els processos ETL i les eines que existeixen per poder gestionar-lo, aix\u00ed com el gran repte i oportunitat que presenta l&#8217;aplicaci\u00f3 de la Big Data.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-50959 aligncenter\" src=\"https:\/\/blog.euncet.com\/wp-content\/uploads\/2021\/09\/Procesos-ETL.png\" alt=\"Procesos-ETL\" width=\"750\" height=\"300\" srcset=\"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Procesos-ETL.png 750w, https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Procesos-ETL-300x120.png 300w, https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Procesos-ETL-80x32.png 80w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Processos_ETL\"><\/span><span class=\"TextRun SCXW260998714 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW260998714 BCX0\" data-ccp-parastyle=\"heading 2\">Processos ETL<\/span><\/span><span class=\"EOP SCXW260998714 BCX0\" data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:360,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span data-contrast=\"auto\">Per poder entendre el potencial i beneficis que pot reportar la implementaci\u00f3 d&#8217;un bon proc\u00e9s ETL cal entendre qu\u00e8 \u00e9s exactament aquest concepte.\u00a0\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<p>\u00c9s l&#8217;acr\u00f2nim d&#8217;ETL Extract, Transform Load, o com seria en espanyol: extreure, transformar i carregar.\u00a0Aquestes tres fases formen part d&#8217;aquest proc\u00e9s o m\u00e8tode amb el qual es vetlla per una gesti\u00f3 eficient de les dades i informacions corporatives generades per diferents fonts per a la seva posterior an\u00e0lisi i\u00a0interpretaci\u00f3 (business intelligence).<\/p>\n<p>En els processos ETL s&#8217;extreuen\u00a0dades de m\u00faltiples fonts o sistemes d&#8217;origen per transformar-los i adaptar-los a les necessitats de cada organitzaci\u00f3 per convertir-les en informaci\u00f3 que ajudi en la presa de decisions directives.\u00a0Sense un bon tractament, les dades no tenen valor.<\/p>\n<p>Aquest m\u00e8tode va n\u00e9ixer als 70 amb la necessitat de les empreses per emmagatzemar diferents tipus d&#8217;informaci\u00f3\u00a0 utilitzades en m\u00faltiples bases de dades.\u00a0Tot i que aleshores es tractava d&#8217;un proc\u00e9s manual, els processos ETL van servir per integrar totes aquestes dades en un \u00fanic magatzem virtual destinat a l&#8217;anal\u00edtica: Data Warehouse, creat a\u00a0 principis dels 90.<\/p>\n<p>El sistema ETL es caracteritza per gestionar grans quantitats de dades repartides, emmagatzemades i generades per diferents departaments dins d&#8217;una mateixa organitzaci\u00f3. Un dels\u00a0principals reptes que afronten aquests processos \u00e9s extreure les dades i consolidar aquesta informaci\u00f3.<\/p>\n<p>Perqu\u00e8 aquests processos siguin eficients i \u00fatils per a qualsevol empresa \u00e9s important que es realitzin en intervals regulars perqu\u00e8 tota la data emmagatzemada estigui sempre actualitzada i tractada.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-50962 aligncenter\" src=\"https:\/\/blog.euncet.com\/wp-content\/uploads\/2021\/09\/Como-desarrollar-los-procesos-ETL-en-las-empresas.png\" alt=\"C\u00f3mo-desarrollar-los-procesos-ETL-en-las-empresas\" width=\"750\" height=\"300\" srcset=\"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Como-desarrollar-los-procesos-ETL-en-las-empresas.png 750w, https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Como-desarrollar-los-procesos-ETL-en-las-empresas-300x120.png 300w, https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Como-desarrollar-los-procesos-ETL-en-las-empresas-80x32.png 80w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Com_desenvolupar_els_processos_ETL_a_les_empreses\"><\/span><span class=\"TextRun SCXW244870326 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW244870326 BCX0\" data-ccp-parastyle=\"heading 2\">Com desenvolupar el<\/span><span class=\"NormalTextRun SCXW244870326 BCX0\" data-ccp-parastyle=\"heading 2\">s processos <\/span><span class=\"NormalTextRun SCXW244870326 BCX0\" data-ccp-parastyle=\"heading 2\">ETL a les empreses?<\/span><\/span><span class=\"EOP SCXW244870326 BCX0\" data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:360,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span class=\"TextRun SCXW51833049 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW51833049 BCX0\">Tal com hem comentat abans, els processos ETL se centren en tres accions: extreure, transformar i carregar. Amb aquest m\u00e8tode\u00a0les empreses examinen i organitzen les seves dades per atendre millor els seus clients i consumidors.<\/span><\/span><span class=\"EOP SCXW51833049 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<h3><span class=\"ez-toc-section\" id=\"Fase_dExtraccio_Extract\"><\/span><span style=\"font-weight: 400;\">Fase d&#8217;Extracci\u00f3 (Extract)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ol>\n<p><span class=\"TextRun SCXW144118284 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW144118284 BCX0\">\u00c9s la primera fase del proc\u00e9s ETL i s&#8217;hi extreuen les dades en brut de fonts i\u00a0sistemes\u00a0<\/span><\/span><span class=\"TextRun SCXW144118284 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW144118284 BCX0\"> d&#8217;origen<\/span><\/span><span class=\"TextRun SCXW144118284 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW144118284 BCX0\"> molt variats: bases de dades relacionals, XML, fitxers no estructurats, RDBMS en forma de taula&#8230;<\/span><\/span><span class=\"EOP SCXW144118284 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<h3><span class=\"ez-toc-section\" id=\"Fase_de_Transformacio_Transform\"><\/span><span style=\"font-weight: 400;\">Fase de Transformaci\u00f3 (Transform)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ol>\n<p><span class=\"TextRun SCXW159747877 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW159747877 BCX0\">Aquesta etapa del proc\u00e9s ETL \u00e9s la m\u00e9s delicada. S&#8217;hi analitzen i modifiquen les dades en brut per transformar-les en un format \u00fatil o f\u00e0cil d&#8217;entendre. El protocol haur\u00e0 d&#8217;incloure directrius declaratives, independents i clares. \u00c9s a dir, una s\u00e8rie de normes i reglaments que garanteixin la qualitat i accessibilitat de les dades.<\/span><\/span><span class=\"EOP SCXW159747877 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\">\n<h3><span class=\"ez-toc-section\" id=\"Carrega_Load\"><\/span><span style=\"font-weight: 400;\">C\u00e0rrega (Load)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ol>\n<p><span class=\"TextRun SCXW96051436 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW96051436 BCX0\">La fase de c\u00e0rrega \u00e9s l&#8217;\u00faltima dins del proc\u00e9s ETL. En ella, es carreguen les dades, pr\u00e8viament tractades i convertits en un format consistent i homogeni, a un sistema de destinaci\u00f3, generalment el Data <\/span><span class=\"NormalTextRun SCXW96051436 BCX0\">Warehouse<\/span><span class=\"NormalTextRun SCXW96051436 BCX0\">.\u00a0Existeixen dues vies per carregar-les: la c\u00e0rrega completa o acumulaci\u00f3 simple, quan totes les dades es carreguen al magatzem alhora; i la c\u00e0rrega incremental o <\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW96051436 BCX0\">rolling<\/span><span class=\"NormalTextRun SCXW96051436 BCX0\">, quan aquest proc\u00e9s es\u00a0realitza a trav\u00e9s de lots.<\/span><\/span><span class=\"EOP SCXW96051436 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-50965 aligncenter\" src=\"https:\/\/blog.euncet.com\/wp-content\/uploads\/2021\/09\/Tipos-de-herramientas-ETL.png\" alt=\"Tipos-de-herramientas-ETL\" width=\"750\" height=\"300\" srcset=\"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Tipos-de-herramientas-ETL.png 750w, https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Tipos-de-herramientas-ETL-300x120.png 300w, https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Tipos-de-herramientas-ETL-80x32.png 80w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tipus_deines_ETL_Quines_son_les_mes_usades\"><\/span><span class=\"TextRun SCXW56051785 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW56051785 BCX0\" data-ccp-parastyle=\"heading 2\">Tipus d&#8217;eines\u00a0 ETL: Quines s\u00f3n les m\u00e9s usades?<\/span><\/span><span class=\"EOP SCXW56051785 BCX0\" data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:360,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span data-contrast=\"auto\">Els processos ETL poden reviure&#8217;s de forma manual o automatitzada amb l&#8217;ajuda d&#8217;eines\u00a0i aplicacions que poden ser Enterprise Software ETL (de pagament) o Open Source ETL (de codi obert).\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">En molts casos, les organitzacions es mostren reticents a l&#8217;hora de destinar el seu pressupost a les eines ETL. A l&#8217;hora de contractar un d&#8217;aquests serveis \u00e9s important tenir en compte la naturalesa de les dades, \u00e9s a dir, contemplar la capacitat de transformaci\u00f3 de dades que l&#8217; eina ofereix i\u00a0comparar-ho amb les necessitats empresarials existents.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Tamb\u00e9 s&#8217;haur\u00e0 de tenir en compte la gesti\u00f3 de la p\u00e8rdua o indisponibilitat de les dades durant la seva extracci\u00f3, aix\u00ed com els possibles costos afegits en el futur per l\u2019augment del volum de dades.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-58846 aligncenter\" src=\"https:\/\/blog.euncet.com\/wp-content\/uploads\/2023\/03\/1-Ciber-H-1.gif\" alt=\"\" width=\"750\" height=\"265\" \/>\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Software_ETL_de_pago\"><\/span><span style=\"font-weight: 400;\">Software ETL de pago<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li data-leveltext=\"\u25cf\" data-font=\"Calibri\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\u25cf&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><a href=\"http:\/\/www.informatica.com\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">Inform\u00e0tica<\/span><span data-contrast=\"none\"> PowerCenter<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/a><\/li>\n<li data-leveltext=\"\u25cf\" data-font=\"Calibri\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\u25cf&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><a href=\"https:\/\/www.ibm.com\/es-es\/products\/infosphere-datastage\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">IBM <\/span><span data-contrast=\"none\">Infosphere<\/span><span data-contrast=\"none\"> DataStage<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/a><\/li>\n<li data-leveltext=\"\u25cf\" data-font=\"Calibri\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\u25cf&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><a href=\"http:\/\/www.oracle.com\/technology\/products\/warehouse\/index.html\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">Constructor<\/span> <span data-contrast=\"none\">de magatzems<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/a><\/li>\n<li data-leveltext=\"\u25cf\" data-font=\"Calibri\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\u25cf&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><a href=\"http:\/\/msdn.microsoft.com\/es-es\/library\/ms141026.aspx\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">Microsoft<\/span><span data-contrast=\"none\"> SQL Server Integration Services -SSIS-<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/a><\/li>\n<li data-leveltext=\"\u25cf\" data-font=\"Calibri\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\u25cf&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><a href=\"http:\/\/www.dataflux.com\/home.aspx?lang=es-es\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">SAS <\/span><span data-contrast=\"none\">Dataflux<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/a><\/li>\n<li data-leveltext=\"\u25cf\" data-font=\"Calibri\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\u25cf&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><a href=\"https:\/\/help.sap.com\/viewer\/ec68e48b18a44a49abb12b8ee8ae306f\/10.0.33\/en-US\/f9c2e4c06faf1014878bae8cb0e91070.html\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">Gestor de dades SAP<\/span><\/a><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Software_Open_Source\"><\/span><span style=\"font-weight: 400;\">Software Open Source<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"http:\/\/www.talend.com\/\"><span style=\"font-weight: 400;\">Talend Open Studio<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"http:\/\/www.jitterbit.com\/Product\/how-it-works\"><span style=\"font-weight: 400;\">Jitterbit<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"http:\/\/kettle.pentaho.com\/\"><span style=\"font-weight: 400;\">Pentaho Data Integration -anterior Kettle<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/hadoop.apache.org\/\"><span style=\"font-weight: 400;\">Hadoop<\/span><\/a><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-50968 aligncenter\" src=\"https:\/\/blog.euncet.com\/wp-content\/uploads\/2021\/09\/La-importancia-del-big-data-en-las-empresas.png\" alt=\"La-importancia-del-big-data-en-las-empresas\" width=\"750\" height=\"300\" srcset=\"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/La-importancia-del-big-data-en-las-empresas.png 750w, https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/La-importancia-del-big-data-en-las-empresas-300x120.png 300w, https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/La-importancia-del-big-data-en-las-empresas-80x32.png 80w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"La_importancia_del_Big_Data_a_les_empreses\"><\/span><span style=\"font-weight: 400;\"><span class=\"TextRun SCXW202808750 BCX0\" lang=\"CA\" xml:lang=\"CA\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW202808750 BCX0\" data-ccp-parastyle=\"heading 2\">La import\u00e0ncia del Big Data a les empreses<\/span><\/span><span class=\"EOP SCXW202808750 BCX0\" data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:360,&quot;335559739&quot;:120,&quot;335559740&quot;:276}\">\u00a0<\/span> \u00a0\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span data-contrast=\"none\">El Big Data o macrodades consisteix en l&#8217;an\u00e0lisi massiva de dades.\u00a0Aplicar-ho als negocis (Business Intelligence) ajuda els directius a interpretar la informaci\u00f3 corporativa per poder prendre millors decisions i moviments empresarials estrat\u00e8gics.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:40,&quot;335559740&quot;:276}\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:40,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">Entre els principals beneficis que reporta aplicar el Big Data en els negocis destaca:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:40,&quot;335559740&quot;:276}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Efici\u00e8ncia i estalvi de temps.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Identificaci\u00f3 i resoluci\u00f3 de problemes.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">\u00a0Ajut en la gesti\u00f3 d&#8217;equips. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Permet l&#8217;an\u00e0lisi predictiva.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Millora de la presa de decisions.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Major efici\u00e8ncia i optimitzaci\u00f3 de costos.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Segmentaci\u00f3 dels clients.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Major accessibilitat a la informaci\u00f3 empresarial.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Major avantatge competitiu.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Millor reputaci\u00f3 online.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><i><span data-contrast=\"none\">Feedback <\/span><\/i><span data-contrast=\"none\">en temps real.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"none\">Machine learning o aprenentatge autom\u00e0tic.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:40,&quot;335559740&quot;:276}\">\u00a0<\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Les organitzacions sempre han\u00a0hagut de gestionar informaci\u00f3 per poder prendre decisions que gui\u00efn el rumb de l&#8217;empresa. Els temps actuals s&#8217;estan\u00a0caracteritzant, m\u00e9s que mai, pel gran poder que t\u00e9 una bona gesti\u00f3 i interpretaci\u00f3 de les dades. En el seg\u00fcent article, veurem en qu\u00e8 consisteixen els processos ETL i les eines que existeixen per poder [&hellip;]<\/p>\n","protected":false},"author":28,"featured_media":50957,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[452],"tags":[],"class_list":["post-58844","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-innovacio-i-tecnologia"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Els processos ETL: qu\u00e8 s\u00f3n i com aplicar-los a les empreses?<\/title>\n<meta name=\"description\" content=\"Descobreix com funcionen els processos ETL i quins beneficis ens aporten per a la presa de decisions. S\u00f3n aplicables per a totes les empreses?\" \/>\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.euncet.com\/blog\/ca\/que-son-processos-etl\/\" \/>\n<meta property=\"og:locale\" content=\"ca_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Els processos ETL: qu\u00e8 s\u00f3n i com aplicar-los a les empreses?\" \/>\n<meta property=\"og:description\" content=\"Descobreix com funcionen els processos ETL i quins beneficis ens aporten per a la presa de decisions. S\u00f3n aplicables per a totes les empreses?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/\" \/>\n<meta property=\"og:site_name\" content=\"Euncet Business School\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/euncet\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-28T07:31:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-07T09:15:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Que-son-los-procesos-ETL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"560\" \/>\n\t<meta property=\"og:image:height\" content=\"416\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"euncet\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@euncet\" \/>\n<meta name=\"twitter:site\" content=\"@euncet\" \/>\n<meta name=\"twitter:label1\" content=\"Escrit per\" \/>\n\t<meta name=\"twitter:data1\" content=\"euncet\" \/>\n\t<meta name=\"twitter:label2\" content=\"Temps estimat de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minuts\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/\"},\"author\":{\"name\":\"euncet\",\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/#\\\/schema\\\/person\\\/8253e592273eb1f7a48788902ca03268\"},\"headline\":\"Qu\u00e8 s\u00f3n els processos ETL (extreure, transformar i carregar)?\",\"datePublished\":\"2021-09-28T07:31:34+00:00\",\"dateModified\":\"2023-03-07T09:15:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/\"},\"wordCount\":883,\"image\":{\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/Que-son-los-procesos-ETL.png\",\"articleSection\":[\"Innovaci\u00f3 i Tecnologia\"],\"inLanguage\":\"ca\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/\",\"url\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/\",\"name\":\"Els processos ETL: qu\u00e8 s\u00f3n i com aplicar-los a les empreses?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/Que-son-los-procesos-ETL.png\",\"datePublished\":\"2021-09-28T07:31:34+00:00\",\"dateModified\":\"2023-03-07T09:15:30+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/#\\\/schema\\\/person\\\/8253e592273eb1f7a48788902ca03268\"},\"description\":\"Descobreix com funcionen els processos ETL i quins beneficis ens aporten per a la presa de decisions. S\u00f3n aplicables per a totes les empreses?\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/#breadcrumb\"},\"inLanguage\":\"ca\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ca\",\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/Que-son-los-procesos-ETL.png\",\"contentUrl\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/Que-son-los-procesos-ETL.png\",\"width\":560,\"height\":416,\"caption\":\"Qu\u00e9-son-los-procesos-ETL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/que-son-processos-etl\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Qu\u00e8 s\u00f3n els processos ETL (extreure, transformar i carregar)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/#website\",\"url\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/\",\"name\":\"Euncet Business School\",\"description\":\"Escuela de negocios\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ca\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/#\\\/schema\\\/person\\\/8253e592273eb1f7a48788902ca03268\",\"name\":\"euncet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ca\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ee2ce5f049e82b74bcc6b8db4c5e9c717e35544f3cde91d14a3daa9827fe21f0?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ee2ce5f049e82b74bcc6b8db4c5e9c717e35544f3cde91d14a3daa9827fe21f0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ee2ce5f049e82b74bcc6b8db4c5e9c717e35544f3cde91d14a3daa9827fe21f0?s=96&d=mm&r=g\",\"caption\":\"euncet\"},\"url\":\"https:\\\/\\\/www.euncet.com\\\/blog\\\/ca\\\/author\\\/euncet\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Els processos ETL: qu\u00e8 s\u00f3n i com aplicar-los a les empreses?","description":"Descobreix com funcionen els processos ETL i quins beneficis ens aporten per a la presa de decisions. S\u00f3n aplicables per a totes les empreses?","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.euncet.com\/blog\/ca\/que-son-processos-etl\/","og_locale":"ca_ES","og_type":"article","og_title":"Els processos ETL: qu\u00e8 s\u00f3n i com aplicar-los a les empreses?","og_description":"Descobreix com funcionen els processos ETL i quins beneficis ens aporten per a la presa de decisions. S\u00f3n aplicables per a totes les empreses?","og_url":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/","og_site_name":"Euncet Business School","article_publisher":"https:\/\/www.facebook.com\/euncet","article_published_time":"2021-09-28T07:31:34+00:00","article_modified_time":"2023-03-07T09:15:30+00:00","og_image":[{"width":560,"height":416,"url":"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Que-son-los-procesos-ETL.png","type":"image\/png"}],"author":"euncet","twitter_card":"summary_large_image","twitter_creator":"@euncet","twitter_site":"@euncet","twitter_misc":{"Escrit per":"euncet","Temps estimat de lectura":"4 minuts"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#article","isPartOf":{"@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/"},"author":{"name":"euncet","@id":"https:\/\/www.euncet.com\/blog\/ca\/#\/schema\/person\/8253e592273eb1f7a48788902ca03268"},"headline":"Qu\u00e8 s\u00f3n els processos ETL (extreure, transformar i carregar)?","datePublished":"2021-09-28T07:31:34+00:00","dateModified":"2023-03-07T09:15:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/"},"wordCount":883,"image":{"@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#primaryimage"},"thumbnailUrl":"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Que-son-los-procesos-ETL.png","articleSection":["Innovaci\u00f3 i Tecnologia"],"inLanguage":"ca"},{"@type":"WebPage","@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/","url":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/","name":"Els processos ETL: qu\u00e8 s\u00f3n i com aplicar-los a les empreses?","isPartOf":{"@id":"https:\/\/www.euncet.com\/blog\/ca\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#primaryimage"},"image":{"@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#primaryimage"},"thumbnailUrl":"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Que-son-los-procesos-ETL.png","datePublished":"2021-09-28T07:31:34+00:00","dateModified":"2023-03-07T09:15:30+00:00","author":{"@id":"https:\/\/www.euncet.com\/blog\/ca\/#\/schema\/person\/8253e592273eb1f7a48788902ca03268"},"description":"Descobreix com funcionen els processos ETL i quins beneficis ens aporten per a la presa de decisions. S\u00f3n aplicables per a totes les empreses?","breadcrumb":{"@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#breadcrumb"},"inLanguage":"ca","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/"]}]},{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#primaryimage","url":"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Que-son-los-procesos-ETL.png","contentUrl":"https:\/\/www.euncet.com\/blog\/wp-content\/uploads\/2021\/09\/Que-son-los-procesos-ETL.png","width":560,"height":416,"caption":"Qu\u00e9-son-los-procesos-ETL"},{"@type":"BreadcrumbList","@id":"https:\/\/www.euncet.com\/blog\/ca\/que-son-processos-etl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.euncet.com\/blog\/ca\/"},{"@type":"ListItem","position":2,"name":"Qu\u00e8 s\u00f3n els processos ETL (extreure, transformar i carregar)?"}]},{"@type":"WebSite","@id":"https:\/\/www.euncet.com\/blog\/ca\/#website","url":"https:\/\/www.euncet.com\/blog\/ca\/","name":"Euncet Business School","description":"Escuela de negocios","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.euncet.com\/blog\/ca\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ca"},{"@type":"Person","@id":"https:\/\/www.euncet.com\/blog\/ca\/#\/schema\/person\/8253e592273eb1f7a48788902ca03268","name":"euncet","image":{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/secure.gravatar.com\/avatar\/ee2ce5f049e82b74bcc6b8db4c5e9c717e35544f3cde91d14a3daa9827fe21f0?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ee2ce5f049e82b74bcc6b8db4c5e9c717e35544f3cde91d14a3daa9827fe21f0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ee2ce5f049e82b74bcc6b8db4c5e9c717e35544f3cde91d14a3daa9827fe21f0?s=96&d=mm&r=g","caption":"euncet"},"url":"https:\/\/www.euncet.com\/blog\/ca\/author\/euncet\/"}]}},"_links":{"self":[{"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/posts\/58844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/comments?post=58844"}],"version-history":[{"count":0,"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/posts\/58844\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/media\/50957"}],"wp:attachment":[{"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/media?parent=58844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/categories?post=58844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.euncet.com\/blog\/ca\/wp-json\/wp\/v2\/tags?post=58844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}