{"id":124626,"date":"2021-11-18T15:21:16","date_gmt":"2021-11-18T14:21:16","guid":{"rendered":"https:\/\/datascientest.com\/?p=124626"},"modified":"2023-11-13T11:26:23","modified_gmt":"2023-11-13T11:26:23","slug":"extract-transform-load-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/extract-transform-load-tout-savoir","title":{"rendered":"ETL ou \u00ab\u00a0Extract Transform Load : D\u00e9finition et utilisation"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"124626\" class=\"elementor elementor-124626\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2a2679cb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2a2679cb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5ad38ae0\" data-id=\"5ad38ae0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c3cbfed elementor-widget elementor-widget-heading\" data-id=\"c3cbfed\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Avec l'av\u00e8nement du Big Data, les entreprises collectent de plus en plus de donn\u00e9es. Depuis plusieurs ann\u00e9es, la d\u00e9mocratisation des logiciels ETL leur permettent d\u2019extraire, de transformer et de charger ces donn\u00e9es dans leur entrep\u00f4ts de donn\u00e9es pour mieux les analyser. Voyons ensemble le fonctionnement de ces logiciels et les diff\u00e9rents acteurs pr\u00e9sents sur le march\u00e9.\u00a0<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9a63cce elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9a63cce\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1585ffd\" data-id=\"1585ffd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-71fd7cc e-flex e-con-boxed e-con\" data-id=\"71fd7cc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-50d249b e-con-full e-flex e-con\" data-id=\"50d249b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-08362c5 e-con-full e-flex e-con\" data-id=\"08362c5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d154e51 elementor-widget elementor-widget-video\" data-id=\"d154e51\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/L83Nnii4y28?si=hPU9KS4zKKBITnf5&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-video .elementor-widget-container{overflow:hidden;transform:translateZ(0)}.elementor-widget-video .elementor-wrapper{aspect-ratio:var(--video-aspect-ratio)}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{height:100%;width:100%;display:flex;border:none;background-color:#000}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-wrapper{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .elementor-open-inline .elementor-custom-embed-image-overlay{position:absolute;top:0;right:0;bottom:0;left:0;background-size:cover;background-position:50%}.elementor-widget-video .elementor-custom-embed-image-overlay{cursor:pointer;text-align:center}.elementor-widget-video .elementor-custom-embed-image-overlay:hover .elementor-custom-embed-play i{opacity:1}.elementor-widget-video .elementor-custom-embed-image-overlay img{display:block;width:100%;aspect-ratio:var(--video-aspect-ratio);-o-object-fit:cover;object-fit:cover;-o-object-position:center center;object-position:center center}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-custom-embed-image-overlay{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-custom-embed-image-overlay img{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .e-hosted-video .elementor-video{-o-object-fit:cover;object-fit:cover}.e-con-inner>.elementor-widget-video,.e-con>.elementor-widget-video{width:var(--container-widget-width);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6f98bd9 e-con-full e-flex e-con\" data-id=\"6f98bd9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-723da25 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"723da25\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bb24bb3\" data-id=\"bb24bb3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8ef50c8 elementor-widget elementor-widget-text-editor\" data-id=\"8ef50c8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Les processus ETL ont fait leur apparition dans les ann\u00e9es 1970. A cette \u00e9poque, les entreprises ont commenc\u00e9 \u00e0 collecter des donn\u00e9es en provenance de diff\u00e9rentes sources. Les logiciels ETL sont n\u00e9s <strong>pour r\u00e9pondre au besoin d\u2019int\u00e9grer ces donn\u00e9es diverses.\u00a0<\/strong><\/span><\/p><p><span style=\"font-weight: 400;\">Derri\u00e8re cet acronyme se cachent trois \u00e9tapes essentielles \u00e0 la gestion de donn\u00e9es et la<a href=\"https:\/\/datascientest.com\/business-intelligence\"> business intelligence<\/a>: Extract-Transform-Load soit l\u2019extraction des donn\u00e9es de l\u2019entreprise, leur transformation et leur chargement sur des data warehouse. A la fin du processus, le logiciel ETL doit avoir \u00e9t\u00e9 en mesure de <strong>produire des donn\u00e9es propres, faciles d&rsquo;acc\u00e8s<\/strong> et qui peuvent \u00eatre exploit\u00e9es efficacement par l&rsquo;analytique, la Business Intelligence et les diff\u00e9rents m\u00e9tiers de l\u2019entreprise.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-516b5cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"516b5cc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ec8d20c\" data-id=\"ec8d20c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f30deab elementor-widget elementor-widget-heading\" data-id=\"f30deab\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Premi\u00e8re \u00e9tape, l\u2019extraction de donn\u00e9es \n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cd9f8fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cd9f8fc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0166d23\" data-id=\"0166d23\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7555f17 elementor-widget elementor-widget-text-editor\" data-id=\"7555f17\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">La premi\u00e8re \u00e9tape du processus ETL consiste \u00e0 <strong>extraire des donn\u00e9es brutes qui ont \u00e9t\u00e9 collect\u00e9es par l\u2019entreprise<\/strong> et peuvent provenir de diff\u00e9rentes sources de donn\u00e9es: des bases de donn\u00e9es existantes, des journaux de bords concernant l\u2019activit\u00e9 de l\u2019entreprise, des bases de donn\u00e9es non structur\u00e9es relatives aux comportements, performances et anomalies des applications ou d\u2019autres op\u00e9rations diverses. L&rsquo;extraction des donn\u00e9es permet de consolider, traiter et affiner les donn\u00e9es, puis de les stocker dans un emplacement centralis\u00e9 avant de les transformer.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9e2a98f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e2a98f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a539321\" data-id=\"a539321\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f52338d elementor-widget elementor-widget-heading\" data-id=\"f52338d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Deuxi\u00e8me \u00e9tape: la transformation des donn\u00e9es\n\n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d5f21c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d5f21c2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-43e885d\" data-id=\"43e885d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5b1c2df elementor-widget elementor-widget-text-editor\" data-id=\"5b1c2df\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Une fois les donn\u00e9es extraites, la deuxi\u00e8me \u00e9tape consiste \u00e0 les affiner. Pendant cette phase de transformation, l<strong>es donn\u00e9es sont tri\u00e9es, structur\u00e9es et nettoy\u00e9es<\/strong>: les donn\u00e9es en double sont supprim\u00e9es, les valeurs manquantes sont supprim\u00e9es, et l\u2019ensemble des donn\u00e9es sont v\u00e9rifi\u00e9es afin d\u2019obtenir des donn\u00e9es coh\u00e9rentes, exploitables et fiables.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5e20d8c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e20d8c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1c75f1b\" data-id=\"1c75f1b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ce38beb elementor-widget elementor-widget-heading\" data-id=\"ce38beb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"><h3 data-elementor-setting-key=\"title\" data-pen-placeholder=\"\u00c9crivez ici...\" style=\"font-family: var( --e-global-typography-primary-font-family ), Sans-serif; font-weight: var( --e-global-typography-primary-font-weight ); color: rgb(0, 0, 0); outline-style: initial; outline-width: 0px;\"><span style=\"color: var( --e-global-color-primary ); font-family: var( --e-global-typography-primary-font-family ), Sans-serif; font-weight: var( --e-global-typography-primary-font-weight );\">Troisi\u00e8me \u00e9tape: le chargement des donn\u00e9es<\/span><\/h3><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b5ae2a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b5ae2a3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-022f05c\" data-id=\"022f05c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5ce85a9 elementor-widget elementor-widget-text-editor\" data-id=\"5ce85a9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Le chargement des donn\u00e9es, mat\u00e9rialis\u00e9 par l\u2019expression anglaise \u2018Load\u2019 dans le processus Extract Transform Load, consiste tout simplement \u00e0 <strong>acheminer les donn\u00e9es tri\u00e9es et nettoy\u00e9es vers un nouvel espace de stockage<\/strong>, le<a href=\"https:\/\/datascientest.com\/data-warehouse-2\"> data warehouse<\/a>, o\u00f9 elles seront accessibles et analysables par l\u2019ensemble des services de l\u2019entreprise. En g\u00e9n\u00e9ral, les data warehouses supportent deux modes pour le chargement des donn\u00e9es : chargement complet et chargement incr\u00e9mentiel. Ce dernier mode ne prendra en compte que les donn\u00e9es qui sont diff\u00e9rentes de celles d\u00e9j\u00e0 pr\u00e9sentes sur l\u2019espace de stockage.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8cfcc42 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8cfcc42\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c1eb833\" data-id=\"c1eb833\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-37b6389 elementor-widget elementor-widget-image\" data-id=\"37b6389\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"469\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/11\/shutterstock_1896452143-2.jpg\" class=\"attachment-large size-large wp-image-124682\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/11\/shutterstock_1896452143-2.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2021\/11\/shutterstock_1896452143-2-300x176.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2021\/11\/shutterstock_1896452143-2-768x450.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f0bc85 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0f0bc85\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">En savoir plus sur nos formations<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-918a03c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"918a03c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e914753\" data-id=\"e914753\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-56c57da elementor-widget elementor-widget-heading\" data-id=\"56c57da\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Les b\u00e9n\u00e9fices d\u2019un logiciel ETL \n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d2e4988 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d2e4988\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-238e7da\" data-id=\"238e7da\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b6e29c5 elementor-widget elementor-widget-text-editor\" data-id=\"b6e29c5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Toutes les \u00e9tapes d\u2019un processus ETL sont bien s\u00fbr r\u00e9alisables manuellement, mais l<strong>es marges d\u2019erreur sont particuli\u00e8rement importantes<\/strong>. A l\u2019heure du Big Data, les entreprises collectent toujours plus de donn\u00e9es et pour de nombreuses entreprises, un traitement manuel n\u00e9cessiterait la mobilisation de nombreux salari\u00e9s. Un processus automatique permet\u00a0 un meilleur contr\u00f4le des donn\u00e9es, une meilleure agilit\u00e9 gr\u00e2ce \u00e0 la centralisation du processus ETL au sein d\u2019un seul logiciel, un meilleur partage avec les diff\u00e9rents services de l\u2019entreprise, et une plus grande pr\u00e9cision.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d70af88 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d70af88\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-243d302\" data-id=\"243d302\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-234e06e elementor-widget elementor-widget-heading\" data-id=\"234e06e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Quels sont les acteurs principaux sur le march\u00e9 des ETL? \n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f721ea5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f721ea5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c75e254\" data-id=\"c75e254\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ee4168f elementor-widget elementor-widget-text-editor\" data-id=\"ee4168f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Il existe diff\u00e9rentes solutions propri\u00e9taires et open source sur le march\u00e9 des logiciels ETL. Parmis les plus connues, on peut nommer BIRT, Cloudera, Pentaho et Talend<\/span><\/p>\n<p><b>Birt<\/b><span style=\"font-weight: 400;\">, de l\u2019anglais Business Intelligence Reporting Tools, propose de cr\u00e9er des data visualisations, des tableaux de bord, que vous pouvez directement ins\u00e9rer sur vos plateformes web et dans vos rapports clients. C\u2019est une solution open source ce qui vous permettra de r\u00e9utiliser son code pour ins\u00e9rer ses modules dans de nombreuses autres applications.\u00a0<\/span><\/p>\n<p><b>Cloudera<\/b><span style=\"font-weight: 400;\">, est une deuxi\u00e8me solution ETL, elle propose une analyse multi-fonctionnelle sur une plate-forme unifi\u00e9e qui \u00e9limine les silos et permet une analyse plus efficace de la donn\u00e9e.\u00a0 Dans son processus de partage de donn\u00e9es, Cloudera met l\u2019accent sur la s\u00e9curit\u00e9, la gouvernance des donn\u00e9es et la production de m\u00e9tadonn\u00e9es coh\u00e9rentes. <\/span><span style=\"font-weight: 400;\">Flexible, elle permet le d\u00e9ploiement de donn\u00e9es sur un cloud public, un multi-cloud et directement sur site<\/span><\/p>\n<p><b>Pentaho<\/b><span style=\"font-weight: 400;\"> \u00e9tait auparavant connu sous le nom de Kettle, c\u2019est \u00e9galement un logiciel Open Source qui permet la conception ainsi que l\u2019ex\u00e9cution des op\u00e9rations de manipulation et de transformation de donn\u00e9es tr\u00e8s complexes. Pentaho existe en version gratuite, mais la version payante qui vous apportera beaucoup plus de fonctionnalit\u00e9s.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Enfin, le fran\u00e7ais<\/span><b> Talend <\/b><span style=\"font-weight: 400;\">fait \u00e9galement partie des acteurs majeurs du march\u00e9. Il est l\u2019\u00e9diteur d\u2019une suite de logiciels Open Source existante depuis 2005. Son logiciel ETL est connu sous le nom de Talend Open Studio for Data Integration (TOS).<\/span> <span style=\"font-weight: 400;\">Ce logiciel permet de cr\u00e9er des flux\u00a0 de mani\u00e8re intuitive \u00e0 l\u2019aide d\u2019une interface graphique. Cette solution d\u2019int\u00e9gration est particuli\u00e8rement appr\u00e9ci\u00e9e pour sa simplicit\u00e9 d\u2019utilisation, sa souplesse et son \u00e9volution. <\/span><span style=\"font-weight: 400;\">Talend propose \u00e0 travers sa suite de logiciels divers outils permettant de r\u00e9colter, qualifier, traiter, centraliser et restituer vos donn\u00e9es.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-685a13f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"685a13f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5b1c4e1\" data-id=\"5b1c4e1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c434d62 elementor-widget elementor-widget-text-editor\" data-id=\"c434d62\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Il existe donc de multiples solutions pour extraire, transformer et charger vos donn\u00e9es. Les logiciels ETL, qu\u2019ils soient gratuits ou payants sont en g\u00e9n\u00e9ral faits pour <strong>faciliter et s\u00e9curiser la gestion de vos donn\u00e9es et leur analyse<\/strong>. Etant donn\u00e9 l\u2019\u00e9volution de la collecte de donn\u00e9es des entreprises, il y a fort \u00e0 parier que le march\u00e9 des ETL continuera \u00e0 se d\u00e9velopper et que leurs fonctionnalit\u00e9s seront de plus en plus qualitatives.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-995f92f elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"995f92f\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir nos formations en Data Science<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"elementor-element elementor-element-624ab47 e-flex e-con-boxed e-con\" data-id=\"624ab47\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-896ac3d elementor-widget elementor-widget-html\" data-id=\"896ac3d\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Premi\u00e8re \u00e9tape, l\u2019extraction de donn\u00e9es  \",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La premi\u00e8re \u00e9tape du processus ETL consiste \u00e0 extraire des donn\u00e9es brutes qui ont \u00e9t\u00e9 collect\u00e9es par l\u2019entreprise et peuvent provenir de diff\u00e9rentes sources de donn\u00e9es: des bases de donn\u00e9es existantes, des journaux de bords concernant l\u2019activit\u00e9 de l\u2019entreprise, des bases de donn\u00e9es non structur\u00e9es relatives aux comportements, performances et anomalies des applications ou d\u2019autres op\u00e9rations diverses. L'extraction des donn\u00e9es permet de consolider, traiter et affiner les donn\u00e9es, puis de les stocker dans un emplacement centralis\u00e9 avant de les transformer.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Deuxi\u00e8me \u00e9tape: la transformation des donn\u00e9es  \",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Une fois les donn\u00e9es extraites, la deuxi\u00e8me \u00e9tape consiste \u00e0 les affiner. Pendant cette phase de transformation, les donn\u00e9es sont tri\u00e9es, structur\u00e9es et nettoy\u00e9es: les donn\u00e9es en double sont supprim\u00e9es, les valeurs manquantes sont supprim\u00e9es, et l\u2019ensemble des donn\u00e9es sont v\u00e9rifi\u00e9es afin d\u2019obtenir des donn\u00e9es coh\u00e9rentes, exploitables et fiables.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Troisi\u00e8me \u00e9tape: le chargement des donn\u00e9es\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Le chargement des donn\u00e9es, mat\u00e9rialis\u00e9 par l\u2019expression anglaise \u2018Load\u2019 dans le processus Extract Transform Load, consiste tout simplement \u00e0 acheminer les donn\u00e9es tri\u00e9es et nettoy\u00e9es vers un nouvel espace de stockage, le data warehouse, o\u00f9 elles seront accessibles et analysables par l\u2019ensemble des services de l\u2019entreprise. En g\u00e9n\u00e9ral, les data warehouses supportent deux modes pour le chargement des donn\u00e9es : chargement complet et chargement incr\u00e9mentiel. Ce dernier mode ne prendra en compte que les donn\u00e9es qui sont diff\u00e9rentes de celles d\u00e9j\u00e0 pr\u00e9sentes sur l\u2019espace de stockage.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Quels sont les acteurs principaux sur le march\u00e9 des ETL?  \",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Il existe diff\u00e9rentes solutions propri\u00e9taires et open source sur le march\u00e9 des logiciels ETL. Parmis les plus connues, on peut nommer BIRT, Cloudera, Pentaho et Talend. Birt, de l\u2019anglais Business Intelligence Reporting Tools, propose de cr\u00e9er des data visualisations, des tableaux de bord, que vous pouvez directement ins\u00e9rer sur vos plateformes web et dans vos rapports clients. C\u2019est une solution open source ce qui vous permettra de r\u00e9utiliser son code pour ins\u00e9rer ses modules dans de nombreuses autres applications.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Avec l&rsquo;av\u00e8nement du Big Data, les entreprises collectent de plus en plus de donn\u00e9es. Depuis plusieurs ann\u00e9es, la d\u00e9mocratisation des logiciels ETL leur permettent d\u2019extraire, de transformer et de charger ces donn\u00e9es dans leur entrep\u00f4ts de donn\u00e9es pour mieux les analyser. Voyons ensemble le fonctionnement de ces logiciels et les diff\u00e9rents acteurs pr\u00e9sents sur le [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":124659,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ETL ou &quot;Extract Transform Load : D\u00e9finition et utilisation<\/title>\n<meta name=\"description\" content=\"ETL est la contraction de &quot;Extract Transform Load&quot;. Voyons ensemble comment fonctionne cette technologie.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/extract-transform-load-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ETL ou &quot;Extract Transform Load : D\u00e9finition et utilisation\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/extract-transform-load-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-18T14:21:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-13T11:26:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/11\/shutterstock_1081970570-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1520\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/extract-transform-load-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/extract-transform-load-tout-savoir\",\"name\":\"ETL ou \\\"Extract Transform Load : D\u00e9finition et utilisation\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2021-11-18T14:21:16+00:00\",\"dateModified\":\"2023-11-13T11:26:23+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"ETL est la contraction de \\\"Extract Transform Load\\\". Voyons ensemble comment fonctionne cette technologie.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/extract-transform-load-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ETL ou \"Extract Transform Load : D\u00e9finition et utilisation","description":"ETL est la contraction de \"Extract Transform Load\". Voyons ensemble comment fonctionne cette technologie.","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:\/\/datascientest.com\/extract-transform-load-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"ETL ou \"Extract Transform Load : D\u00e9finition et utilisation","og_url":"https:\/\/datascientest.com\/extract-transform-load-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2021-11-18T14:21:16+00:00","article_modified_time":"2023-11-13T11:26:23+00:00","og_image":[{"width":1520,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/11\/shutterstock_1081970570-1.jpg","type":"image\/jpeg"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/extract-transform-load-tout-savoir","url":"https:\/\/datascientest.com\/extract-transform-load-tout-savoir","name":"ETL ou \"Extract Transform Load : D\u00e9finition et utilisation","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2021-11-18T14:21:16+00:00","dateModified":"2023-11-13T11:26:23+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"ETL est la contraction de \"Extract Transform Load\". Voyons ensemble comment fonctionne cette technologie.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/extract-transform-load-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/124626"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=124626"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/124626\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/124659"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=124626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=124626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=124626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}