{"id":40768,"date":"2021-02-03T15:52:43","date_gmt":"2021-02-03T14:52:43","guid":{"rendered":"https:\/\/datascientest.com\/?p=40768"},"modified":"2023-11-09T14:23:34","modified_gmt":"2023-11-09T14:23:34","slug":"data-warehouse","status":"publish","type":"post","link":"https:\/\/datascientest.com\/data-warehouse","title":{"rendered":"Data Warehouse : qu&rsquo;est-ce que c&rsquo;est et comment les utiliser ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"40768\" class=\"elementor elementor-40768\" 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-0ed04b3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0ed04b3\" 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-3132cf9\" data-id=\"3132cf9\" 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-24e4cab elementor-widget elementor-widget-heading\" data-id=\"24e4cab\" 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\">Un Data Warehouse permet de collecter des donn\u00e9es en provenance de sources diverses et de les analyser. D\u00e9couvrez tout ce que vous devez savoir sur cette technologie au coeur de la Data Science : d\u00e9finition, fonctionnement, histoire, cas d'usage, formations...<\/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-ea1e7f6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ea1e7f6\" 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-225f54d\" data-id=\"225f54d\" 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-fa92f0b elementor-widget elementor-widget-text-editor\" data-id=\"fa92f0b\" 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>Le<strong> terme de \u00ab\u00a0Data Warehousing\u00a0\u00bb<\/strong>\u00a0designe le processus consistant \u00e0 collecter et \u00e0 g\u00e9rer des donn\u00e9es en provenance de sources diverses, afin d&rsquo;en d\u00e9gager de pr\u00e9cieuses informations exploitables par l&rsquo;entreprise.<\/p><p>Un \u00ab\u00a0Data Warehouse\u00a0\u00bb (entrep\u00f4t de donn\u00e9es) est une plateforme utilis\u00e9e pour <strong>collecter et analyser des donn\u00e9es<\/strong> en provenance de multiples sources h\u00e9t\u00e9rog\u00e8nes. Elle occupe une place centrale au sein d&rsquo;un syst\u00e8me de <strong><a href=\"https:\/\/datascientest.com\/business-intelligence\">Business Intelligence<\/a><\/strong>.<\/p><p>Cette plateforme marie plusieurs technologies et composants permettant d&rsquo;exploiter la donn\u00e9e. Elle permet le stockage d&rsquo;un large volume de donn\u00e9es, mais aussi la requ\u00eate et l&rsquo;analyse. L&rsquo;objectif est de <strong>transformer les donn\u00e9es brutes<\/strong> en informations utiles, et de les rendre disponibles et accessibles aux utilisateurs.<\/p><p>Un Data Warehouse est g\u00e9n\u00e9ralement <strong>s\u00e9par\u00e9 de la base de donn\u00e9es <\/strong>op\u00e9rationnelle d&rsquo;une entreprise. Il permet aux utilisateurs de s&rsquo;appuyer sur les donn\u00e9es historiques et actuelles pour prendre de meilleures d\u00e9cisions.<\/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-382be85 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"382be85\" 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-894ea8a\" data-id=\"894ea8a\" 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-63efb86 elementor-widget elementor-widget-heading\" data-id=\"63efb86\" 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\">L'histoire des Data Warehouses<\/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-687b129 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"687b129\" 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-0153bfc\" data-id=\"0153bfc\" 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-689a776 elementor-widget elementor-widget-text-editor\" data-id=\"689a776\" 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>Au fil du temps, les ordinateurs sont devenus plus complexes. Le <strong>volume de donn\u00e9es<\/strong> \u00e0 disposition des entreprises a consid\u00e9rablement augment\u00e9. C&rsquo;est la raison pour laquelle les Data Warehouses sont devenus indispensables.<\/p><p>En 1970, pour la premi\u00e8re fois, Nielsen et IRI introduisent <strong>le concept de Data Marts dimensionnels<\/strong> pour les commerces de d\u00e9tail. En 1983, Teradata lance un syst\u00e8me de gestion de base de donn\u00e9es sp\u00e9cifiquement con\u00e7u pour l&rsquo;aide \u00e0 la d\u00e9cision.<\/p><p>Il faudra toutefois attendre la fin des ann\u00e9es 1980 pour assister \u00e0 l&rsquo;\u00e9mergence du <strong>premier Data Warehouse d&rsquo;entreprise<\/strong>, d\u00e9velopp\u00e9 par Paul Murphy et Barry Devlin d&rsquo;IBM.<\/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-bffaf1d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bffaf1d\" 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-79c93b0\" data-id=\"79c93b0\" 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-e11603c elementor-widget elementor-widget-video\" data-id=\"e11603c\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/AHR_7jFCMeY&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 class=\"elementor-element elementor-element-d174fab elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d174fab\" 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\/formation-data-engineer\">\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\">Apprendre \u00e0 utiliser la Data Warehouse<\/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-f98a4c7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f98a4c7\" 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-1052ecb\" data-id=\"1052ecb\" 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-bb642a6 elementor-widget elementor-widget-heading\" data-id=\"bb642a6\" 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\">Comment fonctionne une Data Warehouse ?<\/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-17b271f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"17b271f\" 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-2c8253c\" data-id=\"2c8253c\" 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-151e240 elementor-widget elementor-widget-text-editor\" data-id=\"151e240\" 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>Un Data Warehouse fonctionne <strong>\u00e0 la mani\u00e8re d&rsquo;un r\u00e9pertoire central<\/strong>. Les informations proviennent d&rsquo;une ou plusieurs sources de donn\u00e9es, telles qu&rsquo;un syst\u00e8me transactionnel ou d&rsquo;autres bases de donn\u00e9es relationnelles.<\/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-0a66d7c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0a66d7c\" 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-dc73f05\" data-id=\"dc73f05\" 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-358aae2 elementor-widget elementor-widget-text-editor\" data-id=\"358aae2\" 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>Les donn\u00e9es peuvent \u00eatre structur\u00e9es, semi-structur\u00e9es ou non structur\u00e9es. Une fois ing\u00e9r\u00e9es dans le Warehouse, elles sont trait\u00e9es et transform\u00e9es. Les utilisateurs peuvent ensuite y acc\u00e9der \u00e0 l&rsquo;aide d&rsquo;outils de Business Intelligence, de clients <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">SQL<\/a> ou de tableurs.<\/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-63c33e3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"63c33e3\" 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-5fc89b1\" data-id=\"5fc89b1\" 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-25bc579 elementor-widget elementor-widget-text-editor\" data-id=\"25bc579\" 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>En agr\u00e9geant les informations au m\u00eame emplacement, une entreprise peut <strong>profiter d&rsquo;une vue d&rsquo;ensemble<\/strong> sur sa client\u00e8le ou d&rsquo;autres \u00e9l\u00e9ments cruciaux. Le Warehousing permet de s&rsquo;assurer que toutes les informations soient pass\u00e9es en revue.<\/p><p>De plus, le Data Warehouse rend possible <strong><a href=\"https:\/\/datascientest.com\/data-mining-tout-savoir\" target=\"_blank\" rel=\"noopener\">le \u00ab\u00a0Data Mining\u00a0\u00bb (exploration de donn\u00e9es)<\/a>.<\/strong> Cette proc\u00e9dure consiste \u00e0 rechercher des tendances et des motifs dans les donn\u00e9es, et de s&rsquo;appuyer dessus pour augmenter les ventes et les revenus de l&rsquo;entreprise.<\/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-d2e948b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d2e948b\" 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-2d1e63f\" data-id=\"2d1e63f\" 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-b6be652 elementor-widget elementor-widget-video\" data-id=\"b6be652\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/FxQG65OhXAQ&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\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\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-2cbc8f5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2cbc8f5\" 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-ac29c73\" data-id=\"ac29c73\" 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-2d161b6 elementor-widget elementor-widget-heading\" data-id=\"2d161b6\" 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 diff\u00e9rents types de Data Warehouses<\/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-9a04f82 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9a04f82\" 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-959c2fe\" data-id=\"959c2fe\" 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-ebaf57c elementor-widget elementor-widget-text-editor\" data-id=\"ebaf57c\" 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>On distingue trois cat\u00e9gories principales de Data Warehouses. Tout d&rsquo;abord, <strong>les \u00ab\u00a0Data Warehouses d&rsquo;entreprise\u00a0\u00bb<\/strong>\u00a0(EDW) sont des entrep\u00f4ts de donn\u00e9es centralis\u00e9s permettant d&rsquo;assister les d\u00e9cisions de l&rsquo;entreprise.<\/p><p>Les donn\u00e9es sont organis\u00e9es et <strong>pr\u00e9sent\u00e9es de mani\u00e8re unifi\u00e9e<\/strong>. Les EDW permettent aussi de classifier les donn\u00e9es en fonction de leur sujet.<\/p><p>La seconde cat\u00e9gorie majeure de Data Warehouses est celle des <strong>Data Stores op\u00e9rationnels (ODS)<\/strong>. Les donn\u00e9es sont mises \u00e0 jour en temps r\u00e9el, ce qui s&rsquo;av\u00e8re tr\u00e8s utile pour les activit\u00e9s quotidiennes comme l&rsquo;enregistrement des rapports et enregistrements des employ\u00e9s.<\/p><p>Enfin, <strong>un Data Mart<\/strong> est une sous-cat\u00e9gorie de Data Warehouse. Elle est con\u00e7ue pour les entreprises des secteurs de la vente ou de la finance. Les donn\u00e9es peuvent \u00eatre collect\u00e9es directement depuis les diff\u00e9rentes sources.<\/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-8d36a06 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d36a06\" 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-70b7e79\" data-id=\"70b7e79\" 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-119a9cd elementor-widget elementor-widget-heading\" data-id=\"119a9cd\" 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 \u00e9tats d'un Data Warehouse<\/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-6577ae1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6577ae1\" 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-064bb9c\" data-id=\"064bb9c\" 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-904253f elementor-widget elementor-widget-text-editor\" data-id=\"904253f\" 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>Un Data Warehouse peut avoir diff\u00e9rents statuts. Lorsqu&rsquo;il est <strong>\u00ab\u00a0hors ligne\u00a0\u00bb<\/strong>, les donn\u00e9es sont copi\u00e9es depuis un syst\u00e8me op\u00e9rationnel vers un autre serveur. Le chargement, le traitement et le reporting des donn\u00e9es n&rsquo;impactent pas les performances de l&rsquo;OS.<\/p><p>Lorsqu&rsquo;elle est en ligne, en revanche, les donn\u00e9es sont r\u00e9guli\u00e8rement mises \u00e0 jour depuis la base de donn\u00e9es op\u00e9rationnelle. Dans le cas d&rsquo;un Data Warehouse <strong>en temps r\u00e9el<\/strong>, les donn\u00e9es sont mises \u00e0 jour chaque fois qu&rsquo;une transaction a lieu dans la <a href=\"https:\/\/datascientest.com\/bases-de-donnees-relationnelles\">base de donn\u00e9es relationnelle<\/a>. On peut citer comme exemple un syst\u00e8me de r\u00e9servation de train ou d&rsquo;avion.<\/p><p>Enfin, dans le cas d&rsquo;un <strong>Data Warehouse int\u00e9gr\u00e9<\/strong>, la mise \u00e0 jour des donn\u00e9es est continuelle. Les transactions g\u00e9n\u00e9r\u00e9es sont \u00e0 nouveau transf\u00e9r\u00e9es vers le syst\u00e8me d&rsquo;exploitation.<\/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-de23e4e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"de23e4e\" 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-4861d7e\" data-id=\"4861d7e\" 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-0827cef elementor-widget elementor-widget-heading\" data-id=\"0827cef\" 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 diff\u00e9rents composants d'une Data Warehouse<\/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-1e374b6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1e374b6\" 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-257fd89\" data-id=\"257fd89\" 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-3b23e97 elementor-widget elementor-widget-video\" data-id=\"3b23e97\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=zTs5zjSXnvs&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\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\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-46b9774 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"46b9774\" 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-09e2e5b\" data-id=\"09e2e5b\" 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-2cd1279 elementor-widget elementor-widget-text-editor\" data-id=\"2cd1279\" 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>Un Data Warehouse repose sur quatre composants principaux. Le<strong> \u00ab\u00a0load manager\u00a0\u00bb<\/strong>\u00a0permet toutes les op\u00e9rations d&rsquo;extraction et de chargement des donn\u00e9es vers l&rsquo;entrep\u00f4t. Il est aussi en charge de la transformation des donn\u00e9es.<\/p><p>Le <strong>Warehouse Manager<\/strong>, quant \u00e0 lui, effectue les op\u00e9rations li\u00e9es \u00e0 la gestion des donn\u00e9es au sein de l&rsquo;entrep\u00f4t. Il permet notamment d&rsquo;assurer la consistance des donn\u00e9es, la cr\u00e9ation d&rsquo;index et de visualisation, la transformation et la fusion de donn\u00e9es de plusieurs sources et l&rsquo;archivage.<\/p><p>Le <strong>gestionnaire de requ\u00eates<\/strong> effectue les op\u00e9rations li\u00e9es \u00e0 la gestion des requ\u00eates d&rsquo;utilisateurs en les aiguillant vers les tableaux appropri\u00e9s. Enfin, les outils d&rsquo;acc\u00e8s permettent aux utilisateurs finaux d&rsquo;interagir avec le Data Warehouse. Il peut s&rsquo;agir d&rsquo;outils de reporting, de requ\u00eate, de d\u00e9veloppement d&rsquo;application ou encore d&rsquo;exploration de donn\u00e9es.<\/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-6174c54 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6174c54\" 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-1cb908f\" data-id=\"1cb908f\" 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-4d7c7cf elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"4d7c7cf\" 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\/formation-data-engineer\">\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\">Devenir un expert des Data Warehouse<\/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-4d5ef48 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4d5ef48\" 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-881e991\" data-id=\"881e991\" 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-09486a5 elementor-widget elementor-widget-heading\" data-id=\"09486a5\" 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\">Qui utilise un Data Warehouse ?<\/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-7d7b10e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d7b10e\" 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-8c9713b\" data-id=\"8c9713b\" 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-77164b7 elementor-widget elementor-widget-text-editor\" data-id=\"77164b7\" 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>Les Data Warehouses sont utilis\u00e9s par toutes les entreprises ayant <strong>de vastes volumes de donn\u00e9es<\/strong> \u00e0 traiter, ou collectant des donn\u00e9es \u00e0 partir de multiples sources vari\u00e9es. Elles sont aussi utilis\u00e9es par les entreprises souhaitant acc\u00e9der plus facilement aux donn\u00e9es.<\/p><p>Pour toute entreprise d\u00e9sirant <strong>profiter d&rsquo;une aide \u00e0 la d\u00e9cision<\/strong>, les Data Warehouses peuvent se r\u00e9v\u00e9ler pertinents. C&rsquo;est \u00e9galement le cas pour les utilisateurs cherchant \u00e0 g\u00e9rer des rapports, des graphiques ou des diagrammes \u00e0 partir des donn\u00e9es.<\/p><p>Les Data Warehouses ont leur place <strong>dans tous les secteurs d&rsquo;activit\u00e9<\/strong>. Toutefois, elles sont utilis\u00e9es de fa\u00e7ons diff\u00e9rentes en fonction de l&rsquo;industrie.<\/p><p>Dans <a href=\"https:\/\/datascientest.com\/data-science-aeronautique-aviation\" target=\"_blank\" rel=\"noopener\">le domaine de l&rsquo;a\u00e9rien<\/a>, les compagnies a\u00e9riennes s&rsquo;en servent pour analyser la rentabilit\u00e9 des trajets, ou pour proposer des promotions personnalis\u00e9es. Les banques exploitent le Data Warehousing pour g\u00e9rer les ressources, effectuer des \u00e9tudes de march\u00e9, ou analyser les performances de leurs diff\u00e9rents produits.<\/p><p>Dans <a href=\"https:\/\/datascientest.com\/data-science-sante-medecine\" target=\"_blank\" rel=\"noopener\">le domaine de la sant\u00e9<\/a>, les Data Warehouses permettent de pr\u00e9dire les r\u00e9sultats d&rsquo;un traitement, de produire des rapports sur les patients ou encore de partager les donn\u00e9es avec les compagnies d&rsquo;assurance.<\/p><p>Le <strong>secteur public utilise cette technologie<\/strong> pour collecter des donn\u00e9es, ou pour analyser les rapports sur les taxes ou la politique de sant\u00e9. Dans le domaine des assurances, elle est utilis\u00e9e pour analyser les tendances du march\u00e9 ou le comportement des clients.<\/p><p>Les <strong>cha\u00eenes de magasins<\/strong> exploitent les Data Warehouses pour la distribution et le marketing, l&rsquo;inventaire, la logistique, pour comprendre les consommateurs et pour optimiser les prix ou lancer des campagnes de promotion personnalis\u00e9es.<\/p><p>Il en va de m\u00eame pour <strong>le secteur de la t\u00e9l\u00e9communication<\/strong> ou les d\u00e9cisions de vente et de distributions sont bas\u00e9es sur les donn\u00e9es, au m\u00eame titre que les campagnes promotionnelles. Enfin, dans le domaine du tourisme et de l&rsquo;h\u00f4tellerie, les campagnes publicitaires et promotionnelles peuvent \u00eatre bas\u00e9es sur les pr\u00e9f\u00e9rences et les habitudes des voyageurs.<\/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-01432d1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"01432d1\" 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-6ddd70c\" data-id=\"6ddd70c\" 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-ff03bfd elementor-widget elementor-widget-heading\" data-id=\"ff03bfd\" 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\">Avantages et inconv\u00e9nients des Data Warehouses<\/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-ad61882 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ad61882\" 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-3a76cc7\" data-id=\"3a76cc7\" 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-9e8276c elementor-widget elementor-widget-text-editor\" data-id=\"9e8276c\" 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>Les Data Warehouses pr\u00e9sentent des avantages et des inconv\u00e9nients. Elles sont tr\u00e8s utiles pour permettre aux entreprises<strong> d&rsquo;acc\u00e9der rapidement et facilement<\/strong> aux donn\u00e9es en provenance de multiples sources de mani\u00e8re centralis\u00e9e.<\/p><p>Gr\u00e2ce \u00e0 ces outils, il est possible d&rsquo;acc\u00e9der \u00e0 <strong>des informations coh\u00e9rentes et \u00e0 jour<\/strong> sur toutes les activit\u00e9s de l&rsquo;entreprise. Ils permettent aussi de g\u00e9n\u00e9rer des rapports et d&rsquo;effectuer des requ\u00eates pour interroger les donn\u00e9es.<\/p><p>De mani\u00e8re g\u00e9n\u00e9rale, un Data Warehouse permet de r\u00e9duire le temps n\u00e9cessaire pour l&rsquo;analyse de donn\u00e9es et la production de rapports et de faciliter ces t\u00e2ches. Enfin, gr\u00e2ce aux vastes volumes de donn\u00e9es historiques, les utilisateurs peuvent<strong> analyser les tendances sur diff\u00e9rentes p\u00e9riodes<\/strong> temporelles afin de r\u00e9aliser des pr\u00e9dictions pour le futur.<\/p><p>N\u00e9anmoins, les Data Warehouses ont aussi des inconv\u00e9nients. Tout d&rsquo;abord, il ne s&rsquo;agit pas d&rsquo;une solution id\u00e9ale <strong>pour les donn\u00e9es non structur\u00e9es<\/strong>.<\/p><p>En outre, la cr\u00e9ation et l&rsquo;impl\u00e9mentation d&rsquo;un entrep\u00f4t de donn\u00e9es prennent du temps et <strong>requi\u00e8rent souvent beaucoup de travail<\/strong>. Paradoxalement, un Warehouse peut rapidement devenir obsol\u00e8te.<\/p><p>Il est par ailleurs <strong>difficile d&rsquo;effectuer des changements<\/strong> dans les types de donn\u00e9es, les sch\u00e9mas de sources de donn\u00e9es, les index et les requ\u00eates. L&rsquo;utilisation d&rsquo;une telle plateforme peut se r\u00e9v\u00e9ler trop complexe pour l&rsquo;utilisateur moyen.<\/p><p>Ainsi, les organisations doivent d\u00e9ployer <strong>de nombreuses ressources<\/strong> pour former les employ\u00e9s et pour impl\u00e9menter le Warehouse. Il est donc important de peser les avantages et les inconv\u00e9nients avant de d\u00e9cider d&rsquo;utiliser ce type de solution.<\/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-af9117f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"af9117f\" 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-903abc7\" data-id=\"903abc7\" 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-bb3bd24 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"bb3bd24\" 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\/formation-data-engineer\">\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\u00e9marrer une formation de Data Engineer<\/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-c31f650 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c31f650\" 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-112dfac\" data-id=\"112dfac\" 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-ca6b48b elementor-widget elementor-widget-heading\" data-id=\"ca6b48b\" 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\">Comment se former pour apprendre \u00e0 utiliser un Data Warehouse ?<\/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-0a3cb05 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0a3cb05\" 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-bea0c2d\" data-id=\"bea0c2d\" 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-1ff2ed3 elementor-widget elementor-widget-text-editor\" data-id=\"1ff2ed3\" 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>Pour apprendre \u00e0 utiliser un Data Warehouse, vous pouvez vous tourner vers <strong>les formations Data Scientest<\/strong>. Vous pouvez d\u00e9couvrir comment ma\u00eetriser ces outils \u00e0 travers nos diff\u00e9rents programmes : Data Scientist, Data Analyst, Data Engineer&#8230;<\/p><p>La Data Warehouse est au c\u0153ur des m\u00e9tiers de la science des donn\u00e9es, et nos diff\u00e9rents cursus vous proposent donc d&rsquo;apprendre \u00e0 les manier. Vous pourrez par exemple d\u00e9couvrir <a href=\"https:\/\/datascientest.com\/snowflake\">Snowflake<\/a>, le Data Warehouse disponible sur le Cloud.<\/p><p>Nos formations adoptent une approche innovante de <a href=\"https:\/\/datascientest.com\/blended-learning\">Blended Learning<\/a>, hybride entre pr\u00e9sentiel et distanciel, et peuvent \u00eatre effectu\u00e9es en <strong>BootCamp intensif<\/strong> ou en <strong>Formation Continue<\/strong>. Elles permettent d&rsquo;obtenir un dipl\u00f4me certifi\u00e9 par l&rsquo;Universit\u00e9 de la Sorbonne.<\/p><p>Ces diff\u00e9rents cursus s&rsquo;adressent aux individus, ou aux entreprises souhaitant former leurs \u00e9quipes. N&rsquo;attendez plus et d\u00e9couvrez nos diff\u00e9rents programmes.<\/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-8b7f3d6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8b7f3d6\" 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-0bd7c49\" data-id=\"0bd7c49\" 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-39b72eb elementor-widget elementor-widget-video\" data-id=\"39b72eb\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=40jjIXVnzks&amp;t=4s&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\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\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-51e8216 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"51e8216\" 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-5de0659\" data-id=\"5de0659\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\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-10a221e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"10a221e\" 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-9b72fb0\" data-id=\"9b72fb0\" 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-99e29ca elementor-widget elementor-widget-text-editor\" data-id=\"99e29ca\" 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>Vous savez tout sur les Data Warehouses. D\u00e9couvrez tout ce que vous devez savoir sur <a href=\"https:\/\/datascientest.com\/base-de-donnees-definition\" target=\"_blank\" rel=\"noopener\">les bases de donn\u00e9es<\/a> en g\u00e9n\u00e9ral, et <a href=\"https:\/\/datascientest.com\/data-science-definition\" target=\"_blank\" rel=\"noopener\">notre dossier complet sur la Data Science<\/a>.<\/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-d465197 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d465197\" 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\/formation-ml-engineer\">\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 la formation Machine Learning Engineer<\/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-c05c35b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c05c35b\" 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-01848ea\" data-id=\"01848ea\" 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-14c2f32 elementor-widget elementor-widget-html\" data-id=\"14c2f32\" 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\": \"L'histoire des Data Warehouses\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Au fil du temps, les ordinateurs sont devenus plus complexes. Le volume de donn\u00e9es \u00e0 disposition des entreprises a consid\u00e9rablement augment\u00e9. C\u2019est la raison pour laquelle les Data Warehouses sont devenues indispensables.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment fonctionne une Data Warehouse ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Une Data Warehouse fonctionne \u00e0 la mani\u00e8re d\u2019un r\u00e9pertoire central. Les informations proviennent d\u2019une ou plusieurs sources de donn\u00e9es, telles qu\u2019un syst\u00e8me transactionnel ou d\u2019autres bases de donn\u00e9es relationnelles.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Les diff\u00e9rents types de Data Warehouses\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"On distingue trois cat\u00e9gories principales de Data Warehouses. Tout d\u2019abord, les \u201d Data Warehouses d\u2019entreprise \u201c (EDW) sont des entrep\u00f4ts de donn\u00e9es centralis\u00e9s permettant d\u2019assister les d\u00e9cisions de l\u2019entreprise.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qui utilise une Data Warehouse ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Les Data Warehouses sont utilis\u00e9es par toutes les entreprises ayant de vastes volumes de donn\u00e9es \u00e0 traiter, ou collectant des donn\u00e9es \u00e0 partir de multiples sources vari\u00e9es. Elles sont aussi utilis\u00e9es par les entreprises souhaitant acc\u00e9der plus facilement aux donn\u00e9es.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Avantages et inconv\u00e9nients des Data Warehouses\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Les Data Warehouses pr\u00e9sentent des avantages et des inconv\u00e9nients. Elles sont tr\u00e8s utiles pour permettre aux entreprises d\u2019acc\u00e9der rapidement et facilement aux donn\u00e9es en provenance de multiples sources de mani\u00e8re centralis\u00e9e.\"\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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Un Data Warehouse permet de collecter des donn\u00e9es en provenance de sources diverses et de les analyser. D\u00e9couvrez tout ce que vous devez savoir sur cette technologie au coeur de la Data Science : d\u00e9finition, fonctionnement, histoire, cas d&rsquo;usage, formations&#8230; Le terme de \u00ab\u00a0Data Warehousing\u00a0\u00bb&nbsp;designe le processus consistant \u00e0 collecter et \u00e0 g\u00e9rer des donn\u00e9es [&hellip;]<\/p>\n","protected":false},"author":79,"featured_media":185611,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2411],"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>Data Warehouse : qu&#039;est-ce que c&#039;est et comment les utiliser ?<\/title>\n<meta name=\"description\" content=\"Une Data Warehouse permet de stocker de larges volumes de donn\u00e9es, de les traiter et de les transformer. D\u00e9couvrez leur fonctionnement et leur utilisation.\" \/>\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\/data-warehouse\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Warehouse : qu&#039;est-ce que c&#039;est et comment les utiliser ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/data-warehouse\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-03T14:52:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T14:23:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/02\/Illu_BLOG_NEW_WareHouse.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dan Cohen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dan Cohen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/data-warehouse\",\"url\":\"https:\/\/datascientest.com\/data-warehouse\",\"name\":\"Data Warehouse : qu'est-ce que c'est et comment les utiliser ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2021-02-03T14:52:43+00:00\",\"dateModified\":\"2023-11-09T14:23:34+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/61997d589648bc1d367f632ba686e354\"},\"description\":\"Une Data Warehouse permet de stocker de larges volumes de donn\u00e9es, de les traiter et de les transformer. D\u00e9couvrez leur fonctionnement et leur utilisation.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/data-warehouse\"]}]},{\"@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\/61997d589648bc1d367f632ba686e354\",\"name\":\"Dan Cohen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/dancohen.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/dancohen.jpeg\",\"caption\":\"Dan Cohen\"},\"description\":\"Dan Cohen est actuellement Data Engineer chez DataScientest. Il poss\u00e8de une solide exp\u00e9rience dans le domaine de la data, ayant pr\u00e9c\u00e9demment occup\u00e9 des postes de Consultant en Data Science chez Meotec, Data Engineer chez Cetim, et Ing\u00e9nieur commercial chez Global D\u00e9co &amp; Food.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/dancohen1307\/\",\"Cloud & Data Engineering\"],\"url\":\"https:\/\/datascientest.com\/author\/dancohen\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Warehouse : qu'est-ce que c'est et comment les utiliser ?","description":"Une Data Warehouse permet de stocker de larges volumes de donn\u00e9es, de les traiter et de les transformer. D\u00e9couvrez leur fonctionnement et leur utilisation.","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\/data-warehouse","og_locale":"fr_FR","og_type":"article","og_title":"Data Warehouse : qu'est-ce que c'est et comment les utiliser ?","og_url":"https:\/\/datascientest.com\/data-warehouse","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2021-02-03T14:52:43+00:00","article_modified_time":"2023-11-09T14:23:34+00:00","og_image":[{"width":1024,"height":563,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/02\/Illu_BLOG_NEW_WareHouse.png","type":"image\/png"}],"author":"Dan Cohen","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Dan Cohen","Dur\u00e9e de lecture estim\u00e9e":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/data-warehouse","url":"https:\/\/datascientest.com\/data-warehouse","name":"Data Warehouse : qu'est-ce que c'est et comment les utiliser ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2021-02-03T14:52:43+00:00","dateModified":"2023-11-09T14:23:34+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/61997d589648bc1d367f632ba686e354"},"description":"Une Data Warehouse permet de stocker de larges volumes de donn\u00e9es, de les traiter et de les transformer. D\u00e9couvrez leur fonctionnement et leur utilisation.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/data-warehouse"]}]},{"@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\/61997d589648bc1d367f632ba686e354","name":"Dan Cohen","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/dancohen.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/dancohen.jpeg","caption":"Dan Cohen"},"description":"Dan Cohen est actuellement Data Engineer chez DataScientest. Il poss\u00e8de une solide exp\u00e9rience dans le domaine de la data, ayant pr\u00e9c\u00e9demment occup\u00e9 des postes de Consultant en Data Science chez Meotec, Data Engineer chez Cetim, et Ing\u00e9nieur commercial chez Global D\u00e9co &amp; Food.","sameAs":["https:\/\/www.linkedin.com\/in\/dancohen1307\/","Cloud & Data Engineering"],"url":"https:\/\/datascientest.com\/author\/dancohen"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/40768"}],"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\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=40768"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/40768\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/185611"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=40768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=40768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=40768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}