{"id":221214,"date":"2022-02-19T15:32:17","date_gmt":"2022-02-19T14:32:17","guid":{"rendered":"https:\/\/blog.lewagon.com\/non-classifiee\/data-warehouse\/"},"modified":"2023-07-10T17:33:04","modified_gmt":"2023-07-10T15:33:04","slug":"data-warehouse","status":"publish","type":"post","link":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/","title":{"rendered":"Data Warehouse : ce que vous devez absolument savoir"},"content":{"rendered":"","protected":false},"excerpt":{"rendered":"<p>Le data warehouse est un incontournable de la data d&rsquo;analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.<\/p>\n","protected":false},"author":1,"featured_media":221215,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[142],"type_de_post":[],"post-format":[],"class_list":["post-221214","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-skills","tag-data-fr"],"acf":[],"acfml_non_translatable_locations":null,"_wp_attached_file":null,"_wp_attachment_metadata":null,"wpml_media_processed":null,"_elementor_inline_svg":null,"_elementor_source_image_hash":null,"_wp_attachment_image_alt":null,"_msc":null,"_elementor_is_screenshot":null,"_wp_attachment_context":null,"_oembed_4f1dc266c1e5b199d2e3668569863d35":null,"_wp_attachment_backup_sizes":null,"description_courte_du_cours":null,"_description_courte_du_cours":null,"sujets":null,"_sujets":null,"niveau":null,"_niveau":null,"duree":null,"_duree":null,"lien_externe_du_cours":null,"_lien_externe_du_cours":null,"_g_feedback_shortcode_8e54bebc0966bf7f9290fee5ef5e57c8a8c597c6":null,"_g_feedback_shortcode_atts_8e54bebc0966bf7f9290fee5ef5e57c8a8c597c6":null,"elementor_font_files":null,"elementor_font_face":null,"_elementor_location":null,"_elementor_priority":null,"_elementor_code":null,"_elementor_extra_options":null,"date_de_levent":null,"_date_de_levent":null,"heure_de_debut_de_levent":null,"_heure_de_debut_de_levent":null,"heure_de_fin_de_levent":null,"_heure_de_fin_de_levent":null,"time_zone":null,"_time_zone":null,"description_de_levent":null,"_description_de_levent":null,"format_du_cours":null,"_format_du_cours":null,"pre-requis":null,"_pre-requis":null,"langue_de_levent":null,"_langue_de_levent":null,"lien_externe_de_levent":null,"_lien_externe_de_levent":null,"_yoast_wpseo_primary_tag_events":null,"lieu_de_levent":null,"_lieu_de_levent":null,"_menu_item_type":null,"_menu_item_menu_item_parent":null,"_menu_item_object_id":null,"_menu_item_object":null,"_menu_item_target":null,"_menu_item_classes":null,"_menu_item_xfn":null,"_menu_item_url":null,"_omapi_type":null,"_omapi_ids":null,"_omapi_enabled":null,"_yoast_wpseo_content_score":null,"_pll_strings_translations":null,"_yoast_wpseo_primary_post_tag":"","_yoast_wpseo_primary_type_de_post":"","_yoast_wpseo_primary_post-format":"","_oembed_e607e81f61090d85eabdabc743a27470":null,"_oembed_196c62ccee9fda191cd6fa5f568ddc05":null,"_oembed_6b5f28c0de48cbf3a2ad766be5eb3b30":null,"_oembed_082c4292f4cd0dedc40ae746a899501c":null,"om_disable_all_campaigns":"","wpil_sync_report3":"1","_yoast_wpseo_focuskw":null,"_yoast_wpseo_linkdex":null,"_yoast_wpseo_opengraph-title":"Data Warehouse : ce que vous devez absolument savoir","_yoast_wpseo_opengraph-description":"Le data warehouse est un incontournable de la data d'analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.","_yoast_wpseo_twitter-title":"Data Warehouse : ce que vous devez absolument savoir","_yoast_wpseo_twitter-description":"Le data warehouse est un incontournable de la data d'analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.","wpil_links_inbound_internal_count":"0","wpil_links_inbound_internal_count_data":[],"wpil_links_outbound_internal_count":"0","wpil_links_outbound_internal_count_data":[],"wpil_links_outbound_external_count":"1","wpil_links_outbound_external_count_data":[{"__PHP_Incomplete_Class_Name":"Wpil_Model_Link","link_id":0,"url":"https:\/\/www.lewagon.com\/fr\/data-analytics-course","host":"lewagon.com","internal":false,"post":null,"anchor":"formation Data Analyst.","added_by_plugin":false,"location":"content"}],"wpil_sync_report2_time":"2023-08-11T09:31:39+00:00","gnpub_modified_count":null,"_encloseme":"1","_jetpack_memberships_contains_paid_content":null,"_oembed_df252bc3f21e94e550790f0a26013d33":null,"_oembed_7c25793225e5877909b9566a95c01f07":null,"_oembed_time_7c25793225e5877909b9566a95c01f07":null,"_oembed_c035311b2d37111892bc6336ad75c1a7":null,"_oembed_time_c035311b2d37111892bc6336ad75c1a7":null,"_yoast_wpseo_focuskw_text_input":"","_yoast_wpseo_opengraph-image":"https:\/\/blog.lewagon.com\/wp-content\/uploads\/2023\/03\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg","_yoast_wpseo_twitter-image":"https:\/\/blog.lewagon.com\/wp-content\/uploads\/2023\/03\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg","_bnitk_mfd_meta-robots-noindex":null,"_yoast_wpseo_meta-robots-noindex":null,"_bnitk_mfd_meta-robots-nofollow":null,"_yoast_wpseo_meta-robots-nofollow":null,"_oembed_9b38dff8e9475b390d223d1a13735d6e":null,"_oembed_09b03dce1da57707d8b400d6ead6cfea":null,"_oembed_time_09b03dce1da57707d8b400d6ead6cfea":null,"_oembed_761875ecd5d7c814e779a8a1669e3078":null,"_oembed_time_761875ecd5d7c814e779a8a1669e3078":null,"_oembed_60128998417fdcbaac97a635f5785efd":null,"_oembed_time_60128998417fdcbaac97a635f5785efd":null,"_oembed_bbc2c908fc7e611d82dce88119dc4350":null,"_oembed_time_bbc2c908fc7e611d82dce88119dc4350":null,"_oembed_5ada75a4373349f7b136423290505b3a":null,"_oembed_time_5ada75a4373349f7b136423290505b3a":null,"_oembed_086373a651e90a4eb1279fa1f945472c":null,"_oembed_time_086373a651e90a4eb1279fa1f945472c":null,"_wpml_post_translation_editor_native":null,"_oembed_5e24c29ce369f6b80c9eeec04f14665b":null,"_oembed_time_5e24c29ce369f6b80c9eeec04f14665b":null,"_oembed_8c3e7085f10b7c0fc5520e72277d797b":null,"_oembed_time_8c3e7085f10b7c0fc5520e72277d797b":null,"_oembed_1489782c3c8ef26605b6876b88f7bdda":null,"_oembed_time_1489782c3c8ef26605b6876b88f7bdda":null,"_oembed_0a3d659fc8de333aa903ab0b56018d23":null,"_oembed_time_0a3d659fc8de333aa903ab0b56018d23":null,"_oembed_d1585e059963c7dbe1909a198f64637b":null,"_oembed_da273c5e4d4993b38963204fa3018b68":null,"_oembed_time_da273c5e4d4993b38963204fa3018b68":null,"_oembed_a5e2c70342e4f17e48253b0a60b76258":null,"_oembed_time_a5e2c70342e4f17e48253b0a60b76258":null,"_oembed_83c8f84c43191797360817ecdc633650":null,"_oembed_time_83c8f84c43191797360817ecdc633650":null,"_oembed_e105b3463a1e23321ff3d1a9daf4ce77":null,"_oembed_1692f2329443bc1b18fc320e0d77cb4e":null,"_yoast_wpseo_schema_article_type":null,"_oembed_02bf1d274545a46fdad44828db802e9b":null,"_oembed_483efee027379bb1099137e135e60619":null,"_oembed_time_483efee027379bb1099137e135e60619":null,"_oembed_d9e3a2e55472c308a6d4f95f9859d57c":null,"_oembed_time_d9e3a2e55472c308a6d4f95f9859d57c":null,"_oembed_14a773041d4083fdc540105ccc635e1f":null,"_oembed_time_14a773041d4083fdc540105ccc635e1f":null,"_oembed_fd2c0295b311b878f43def139f693291":null,"_oembed_time_fd2c0295b311b878f43def139f693291":null,"_oembed_9e88339a75e081aa4aa002ac43b5917e":null,"_oembed_time_9e88339a75e081aa4aa002ac43b5917e":null,"_oembed_e58b2264fd34411178c5aead6e76fc0e":null,"_oembed_time_e58b2264fd34411178c5aead6e76fc0e":null,"_oembed_bddf29494cd341c273d2f25802785f3a":null,"_oembed_time_bddf29494cd341c273d2f25802785f3a":null,"_oembed_9fdc7ffbd7d1c456cb57323136bcf86d":null,"_oembed_time_9fdc7ffbd7d1c456cb57323136bcf86d":null,"_oembed_6882adf1f7ba34c40d8abda49c078862":null,"_oembed_time_6882adf1f7ba34c40d8abda49c078862":null,"_oembed_42ae0b6a999f98ed81c86edf9b80d360":null,"_oembed_time_42ae0b6a999f98ed81c86edf9b80d360":null,"_oembed_f4dcff6ba8f84f09cade790420ba4d80":null,"_oembed_time_f4dcff6ba8f84f09cade790420ba4d80":null,"_oembed_25071af9d5ecd73a9356fe5704bba4d8":null,"_oembed_time_25071af9d5ecd73a9356fe5704bba4d8":null,"_oembed_a86728f5efc0ca0642006bbb96f843cc":null,"_oembed_time_a86728f5efc0ca0642006bbb96f843cc":null,"_oembed_d7b5055b785ef8a0cf22c87d024bf2a4":null,"_oembed_time_d7b5055b785ef8a0cf22c87d024bf2a4":null,"_oembed_6a73e101cae7c3452b00a72cf0fc9b22":null,"_oembed_time_6a73e101cae7c3452b00a72cf0fc9b22":null,"_oembed_0aef478f0830cc2e857b9a150a7f763a":null,"_oembed_time_0aef478f0830cc2e857b9a150a7f763a":null,"_oembed_d1a3bdcdf10e4859560b01d910ad1120":null,"_oembed_time_d1a3bdcdf10e4859560b01d910ad1120":null,"_oembed_05ef2af36a31586761b7311d393d1df4":null,"_oembed_time_05ef2af36a31586761b7311d393d1df4":null,"_oembed_ed00fe1690bb2e86f1eb06acfe8a13e7":null,"_oembed_time_ed00fe1690bb2e86f1eb06acfe8a13e7":null,"_oembed_59ffcbf71f633752ca4f26b3b4a544c9":null,"_oembed_time_59ffcbf71f633752ca4f26b3b4a544c9":null,"_oembed_a7b688611478922544f14672fda18461":null,"_oembed_time_a7b688611478922544f14672fda18461":null,"_oembed_266f9a151e3a09eeee918af2d28fd24f":null,"_oembed_time_266f9a151e3a09eeee918af2d28fd24f":null,"_oembed_9f52726dd229470e47d40ff0c8aeb5f8":null,"_oembed_time_9f52726dd229470e47d40ff0c8aeb5f8":null,"_oembed_5547f713058fed19783e0533ce393a31":null,"_oembed_time_5547f713058fed19783e0533ce393a31":null,"_oembed_68ff8dd20e77e109ad084c2252ca040d":null,"_oembed_time_68ff8dd20e77e109ad084c2252ca040d":null,"_oembed_819f09a569080db91bf5dadda0a30d9f":null,"_oembed_time_819f09a569080db91bf5dadda0a30d9f":null,"_oembed_4fc081fbdf0afd05a624ba852a63e133":null,"_oembed_time_4fc081fbdf0afd05a624ba852a63e133":null,"_oembed_d66baf1301b99db8b19a0924319cf03e":null,"_oembed_time_d66baf1301b99db8b19a0924319cf03e":null,"_oembed_14a5f80e3eef4903e482b0ef3799659e":null,"_oembed_time_14a5f80e3eef4903e482b0ef3799659e":null,"_oembed_c24c715adb3853482526a794a5f3c3bb":null,"_oembed_time_c24c715adb3853482526a794a5f3c3bb":null,"_oembed_9c493e098be2852715cc990b6e6243f3":null,"_oembed_time_9c493e098be2852715cc990b6e6243f3":null,"_oembed_b60b7e3028d326711916099f54e986fa":null,"_oembed_time_b60b7e3028d326711916099f54e986fa":null,"_oembed_5283e19fcec44e632de8d436d46ec2f7":null,"_oembed_time_5283e19fcec44e632de8d436d46ec2f7":null,"_oembed_057692cb4479cf5c77363896a28db44f":null,"_oembed_time_057692cb4479cf5c77363896a28db44f":null,"_oembed_e8cb0f41d141fe5eb9d69fc32a98cd72":null,"_oembed_time_e8cb0f41d141fe5eb9d69fc32a98cd72":null,"_oembed_75dcbca80ec1829a77578390fae8fa56":null,"_oembed_time_75dcbca80ec1829a77578390fae8fa56":null,"_oembed_e49318dfeabd5f16d7967e2fcc746fbd":null,"_oembed_time_e49318dfeabd5f16d7967e2fcc746fbd":null,"_oembed_76116b03fe5a013341210d278021184b":null,"_oembed_time_76116b03fe5a013341210d278021184b":null,"_oembed_6c81e1c9b634b5066fb37aaccfd71053":null,"_oembed_time_6c81e1c9b634b5066fb37aaccfd71053":null,"_oembed_abbc1aa97e554f334c2ce25f0d883702":null,"_oembed_time_abbc1aa97e554f334c2ce25f0d883702":null,"_oembed_ba421363b36dd97c087665d5025396cf":null,"_oembed_time_ba421363b36dd97c087665d5025396cf":null,"_oembed_a98f236eb48eb9cd4ede7f319e9cfbc7":null,"_oembed_time_a98f236eb48eb9cd4ede7f319e9cfbc7":null,"_oembed_d61fec7d73397687995fec8d7bd9852f":null,"_oembed_time_d61fec7d73397687995fec8d7bd9852f":null,"_oembed_2e9e46a0176fe90e49cc5fff32ac6912":null,"_oembed_time_2e9e46a0176fe90e49cc5fff32ac6912":null,"_oembed_8a304f49b3aa1c3eec8d0b0577e05e3d":null,"_oembed_time_8a304f49b3aa1c3eec8d0b0577e05e3d":null,"_oembed_ad30824ca1e37cffdad2dbce46c4998a":null,"_oembed_time_ad30824ca1e37cffdad2dbce46c4998a":null,"_oembed_6c3dacc8273d4877c65378c1f324c9cc":null,"_oembed_time_6c3dacc8273d4877c65378c1f324c9cc":null,"_oembed_1d0e7d3c6d826ca1e56a24218abba6f2":null,"_oembed_time_1d0e7d3c6d826ca1e56a24218abba6f2":null,"_oembed_50929cd1300f7cdee57e6e5451afb186":null,"_oembed_time_50929cd1300f7cdee57e6e5451afb186":null,"_oembed_72dc139d079681a2c3d759a86af48ccc":null,"_oembed_time_72dc139d079681a2c3d759a86af48ccc":null,"_oembed_d359fdb1fa5da9e62dd3505937f46fb6":null,"_oembed_time_d359fdb1fa5da9e62dd3505937f46fb6":null,"_oembed_589d6065ccac39334963be5bd8656631":null,"_oembed_time_589d6065ccac39334963be5bd8656631":null,"_oembed_715be02b6ebadc1be6dd638a57d01eb7":null,"_oembed_time_715be02b6ebadc1be6dd638a57d01eb7":null,"_oembed_f5139a9df267d3aa532f5b56409c90b0":null,"_oembed_time_f5139a9df267d3aa532f5b56409c90b0":null,"_oembed_3d9a26be229b27005ca74596fb62cc08":null,"_oembed_time_3d9a26be229b27005ca74596fb62cc08":null,"_oembed_a7d6f0ce79de685fc6f7f4d447e15468":null,"_oembed_time_a7d6f0ce79de685fc6f7f4d447e15468":null,"_oembed_20849479e832b5312335e3086c5f972b":null,"_oembed_time_20849479e832b5312335e3086c5f972b":null,"_oembed_2be4d392f66846deb7624c1bf3bc293e":null,"_oembed_time_2be4d392f66846deb7624c1bf3bc293e":null,"_oembed_9bcf546ec292041d23df28a719840688":null,"_oembed_time_9bcf546ec292041d23df28a719840688":null,"_oembed_0858ffd7404bcd7d82896f942481fe63":null,"_oembed_time_0858ffd7404bcd7d82896f942481fe63":null,"_oembed_4a2dd0ecf082a7c7d82731c06a644799":null,"_oembed_time_4a2dd0ecf082a7c7d82731c06a644799":null,"_oembed_8a1e46bc730cb21c1085d157ae6fa8b6":null,"_oembed_time_8a1e46bc730cb21c1085d157ae6fa8b6":null,"_oembed_cae7deb931d75f809e459e912e71429a":null,"_oembed_time_cae7deb931d75f809e459e912e71429a":null,"_oembed_6fcb4f8ab72abccda75674f71a946f97":null,"_oembed_time_6fcb4f8ab72abccda75674f71a946f97":null,"_oembed_7f0bfd584f844117a64fe73d83b43245":null,"_oembed_time_7f0bfd584f844117a64fe73d83b43245":null,"_oembed_d0aea105cffdf6e004979cf1e4f51e96":null,"_oembed_time_d0aea105cffdf6e004979cf1e4f51e96":null,"_oembed_e53b85b8766b3dc91338f6c1b95a2541":null,"_oembed_time_e53b85b8766b3dc91338f6c1b95a2541":null,"_oembed_48832be87b763046d232c1f2b5ac5fb3":null,"_oembed_time_48832be87b763046d232c1f2b5ac5fb3":null,"_oembed_32a9a34fcf91c466be9a08e1dba3c84e":null,"_oembed_time_32a9a34fcf91c466be9a08e1dba3c84e":null,"_oembed_fb50b2dc07acfa2418f00cdc2ad4c4c2":null,"_oembed_time_fb50b2dc07acfa2418f00cdc2ad4c4c2":null,"_oembed_3089e1d62f944a73b38c996e49abd2fc":null,"_oembed_time_3089e1d62f944a73b38c996e49abd2fc":null,"_oembed_1ecc99e75cf5d001c8da4f4d600703a8":null,"_oembed_time_1ecc99e75cf5d001c8da4f4d600703a8":null,"_oembed_b9c03ca24b382c17966861d251dc3b8d":null,"_oembed_time_b9c03ca24b382c17966861d251dc3b8d":null,"_wp_trash_meta_status":null,"_wp_trash_meta_time":null,"_wp_desired_post_slug":null,"_oembed_031755ba22f2b639d88c78254a99ff39":null,"_oembed_time_031755ba22f2b639d88c78254a99ff39":null,"description_de_la_ressource":null,"_description_de_la_ressource":null,"titre_du_fichier":null,"_titre_du_fichier":null,"_edit_last":"2","_edit_lock":"1689003067:2","_wp_old_slug":null,"_top_nav_excluded":null,"_cms_nav_minihome":null,"inline_featured_image":null,"_yoast_wpseo_estimated-reading-time-minutes":"0","_yoast_wpseo_wordproof_timestamp":"","_wpml_media_duplicate":"1","_thumbnail_id":"221215","_wpml_media_featured":"1","_wpml_word_count":"{\"total\":950,\"to_translate\":{\"en\":950,\"de\":950,\"ja\":950,\"pt-br\":950,\"es\":950}}","_last_translation_edit_mode":null,"_last_editor_used_jetpack":"classic-editor","_elementor_edit_mode":null,"_elementor_template_type":null,"_wp_page_template":"default","_elementor_page_settings":null,"_elementor_data":null,"_elementor_page_assets":[],"_elementor_version":null,"_elementor_pro_version":null,"_elementor_elements_default_values":null,"_elementor_css":null,"_elementor_source":null,"_elementor_conditions":null,"_wpml_location_migration_done":null,"_elementor_controls_usage":null,"_elementor_screenshot_failed":null,"_elementor_screenshot":null,"_elementor_popup_display_settings":null,"_yoast_wpseo_primary_category":"","_wp_old_date":null,"_elementor_template_widget_type":null,"_icl_lang_duplicate_of":null,"_yoast_wpseo_metadesc":"Le data warehouse est un incontournable de la data d'analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.","_yoast_wpseo_title":"Data Warehouse : ce que vous devez absolument savoir","contenu_de_larticle":"Avez-vous d\u00e9j\u00e0 entendu parler de <em>data warehouse<\/em> ?\r\n\r\nOn aurait pu tout aussi bien utiliser le mot \"entrep\u00f4t de donn\u00e9es\", nous direz-vous.\r\n\r\nMais parfois, notre chauvinisme en prend un coup : en France ou ailleurs, les pros de la data parlent bien de d<em>ata warehouse<\/em>.\r\n\r\n\u200d\r\n<h2>Qu'est-ce qu'un <em>data warehouse<\/em> ?<\/h2>\r\n<strong>Un <em>data warehouse<\/em> est un syst\u00e8me qui r\u00e9colte et stocke toutes les donn\u00e9es dont dispose l'entreprise<\/strong>. Ces donn\u00e9es sont r\u00e9cup\u00e9r\u00e9es \u00e0 travers une multitude de sources diff\u00e9rentes, \u00e0 des fins de reporting ou d'analyse. Gr\u00e2ce \u00e0 des requ\u00eates SQL complexes, l'entreprise cr\u00e9e ainsi des rapports qu'elle utilise pour prendre des d\u00e9cisions sur son activit\u00e9.\r\n\r\nPar exemple, chez Shapr, les \u00e9quipes utilisent un <em>data warehouse<\/em> pour cr\u00e9er des audiences similaires \u00e0 partir des utilisateurs les plus actifs sur l'application afin de g\u00e9n\u00e9rer de nouveaux leads.\r\n\r\nConcr\u00e8tement, les donn\u00e9es arrivent brutes dans le <em>data warehouse<\/em>, qui se charge de les ing\u00e9rer, les transformer, les traiter et les rendre accessible \u00e0 la prise de d\u00e9cision.\r\n\r\n\u00c0 l'origine, les <em>data warehouse<\/em> \u00e9taient h\u00e9berg\u00e9s sur les serveurs des entreprises. Aujourd'hui, la plupart des data engineers choisissent des solutions cloud.\r\n\r\nSi ces derni\u00e8res ont contribu\u00e9 \u00e0 rendre le stockage de la donn\u00e9e plus accessible, elles requi\u00e8rent encore des connaissances et des comp\u00e9tences techniques tr\u00e8s pointues.\r\n\r\nOn distingue donc souvent les data engineers, qui r\u00e9coltent et transforment les donn\u00e9es, et les data analysts, qui les analysent.\r\n\r\n\u200d\r\n<h2>D'o\u00f9 viennent les donn\u00e9es ?<\/h2>\r\nL\u2019entreprise dispose de plusieurs sources de donn\u00e9es - aussi appel\u00e9es <em>data sources<\/em> :\r\n<ul>\r\n \t<li>les bases de donn\u00e9es, comme votre produit, un ERP, un CRM, etc.<\/li>\r\n \t<li>les outils SaaS, comme les outils d'emailing, d'analytics, de comptabilit\u00e9, etc.<\/li>\r\n \t<li>les feuilles de calcul, mises \u00e0 jour manuellement ou automatiquement.<\/li>\r\n \t<li>les API externes, qui incluent l'open data.<\/li>\r\n<\/ul>\r\n\u200d\r\n<h2>Quelle est la diff\u00e9rence entre un <em>data warehouse<\/em> et une base de donn\u00e9es classique ?<\/h2>\r\nUne base de donn\u00e9es classique, que l'on qualifie d'op\u00e9rationnelle, stocke uniquement les donn\u00e9es n\u00e9cessaires pour faire fonctionner le produit. Sur ces donn\u00e9es, vous pouvez appliquez une quantit\u00e9 massive de requ\u00eates simples. Mais pour croiser les donn\u00e9es de deux bases de donn\u00e9es transactionnelles gr\u00e2ce \u00e0 des requ\u00eates plus complexes, il vous faut un <em>data warehouse<\/em>.\r\n\r\nAlors que les donn\u00e9es des <em>data warehouse<\/em> suivent un mod\u00e8le \"append only\", c'est-\u00e0-dire qu'on y int\u00e8gre des donn\u00e9es dat\u00e9es sans modifier les donn\u00e9es existantes, les donn\u00e9es d'une base transactionnelle sont sans cesse \u00e9cras\u00e9es pour \u00eatre mises \u00e0 jour par les applications m\u00e9tiers et refl\u00e8tent seulement la valeur en cours.\r\n\r\nDans un <em>data warehous<\/em>e, on retrouve g\u00e9n\u00e9ralement 3 niveaux de couches data - aussi appel\u00e9es <em>data layers<\/em> :\r\n<ul>\r\n \t<li>la couche <em>raw data<\/em> : les donn\u00e9es brutes des data sources<\/li>\r\n \t<li>la couche <em>staging<\/em> : les donn\u00e9es qui sont format\u00e9es par des r\u00e8gles m\u00e9tiers<\/li>\r\n \t<li>la couche <em>data mart<\/em> : les donn\u00e9es agr\u00e9g\u00e9es et transform\u00e9es pour les \u00e9quipes m\u00e9tiers. Par exemple, les \u00e9quipes marketing vont pouvoir analyser le nombre de prospects par canaux ainsi que leur co\u00fbt d'acquisition, plut\u00f4t que d'avoir les donn\u00e9es brutes de chaque canal ind\u00e9pendamment.<\/li>\r\n<\/ul>\r\nDans une base de donn\u00e9es op\u00e9rationnelle, les donn\u00e9es ne sont pas stock\u00e9es dans une optique d'analyse, mais pour faire fonctionner le produit. Elles sont optimis\u00e9es pour minimiser le temps de r\u00e9ponse aux requ\u00eates qu'utilise le produit. Vous ne retrouverez pas cette logique de couche de donn\u00e9es et vous aurez encore moins une table par m\u00e9tier avec les donn\u00e9es essentielles pour piloter l'activit\u00e9 m\u00e9tier.\r\n\r\n\u200d\r\n<h2>Pourquoi vous devez en avoir un ?<\/h2>\r\nAvant toute chose, il est important de pr\u00e9ciser que toute entreprise ne doit pas \u00e0 tout prix se munir d'un <em>data warehouse<\/em>. Tout d\u00e9pend du volume de donn\u00e9es que vous traitez et des comp\u00e9tences que vous avez en interne.\r\n\r\nValidez donc votre potentiel sur ces deux sujets avant de passer \u00e0 l'acte ;)\r\n\r\nLe <em>data warehouse<\/em> est un vrai atout pour prendre de meilleures d\u00e9cisions. Il permet de :\r\n<ul>\r\n \t<li>s'assurer de l'homog\u00e9n\u00e9it\u00e9 de la donn\u00e9e : si les donn\u00e9es sont stock\u00e9es sous diff\u00e9rents formats dans les bases de donn\u00e9es source, elles sont format\u00e9es en arrivant dans le <em>data warehouse<\/em>. Les analystes peuvent ainsi facilement les utiliser pour des analyses crois\u00e9es.<\/li>\r\n \t<li>mener des analyses dans le temps : les donn\u00e9es n'\u00e9tant pas \u00e9cras\u00e9es par les anciennes, vous pouvez cr\u00e9er des tableaux de bord historiques.<\/li>\r\n \t<li>acc\u00e9der facilement \u00e0 la data sans impacter les op\u00e9rations : les bases de donn\u00e9es analytiques, dont le <em>data warehouse<\/em>, sont distincts des outils op\u00e9rationnels pour ne pas ralentir l'exp\u00e9rience client \u00e0 cause des analyses.<\/li>\r\n<\/ul>\r\nConcr\u00e8tement, vous pourrez par exemple :\r\n<ul>\r\n \t<li>calculer la <em>customer lifetime value<\/em> de vos clients par canal d'acquisition<\/li>\r\n \t<li>mener des analyses en cohorte pour \u00e9tudier l'utilisation du support par vos clients en fonction de leur fid\u00e9lit\u00e9<\/li>\r\n \t<li>r\u00e9aliser des pr\u00e9dictions tr\u00e8s pr\u00e9cises de vos ventes sur la prochaine ann\u00e9e<\/li>\r\n<\/ul>\r\nAlors, on vous a mis l'eau \u00e0 la bouche ? On aborde justement ce sujet en large et en travers lors de notre prochaine session de <a href=\"https:\/\/www.lewagon.com\/fr\/data-analytics-course\">formation Data Analyst.<\/a>","_contenu_de_larticle":"field_6412588b55814","titre_de_la_banniere":"","_titre_de_la_banniere":"field_6422eb732c237","paragraphe_de_la_banniere":"","_paragraphe_de_la_banniere":"field_6422ed834a968","intitule_du_bouton_de_la_banniere":"","_intitule_du_bouton_de_la_banniere":"field_6422ed934a969","lien_du_bouton_de_la_banniere":"","_lien_du_bouton_de_la_banniere":"field_6422eda54a96a","yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Data Warehouse : ce que vous devez absolument savoir<\/title>\n<meta name=\"description\" content=\"Le data warehouse est un incontournable de la data d&#039;analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.lewagon.com\/fr\/skills\/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 : ce que vous devez absolument savoir\" \/>\n<meta property=\"og:description\" content=\"Le data warehouse est un incontournable de la data d&#039;analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Le Wagon\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-19T14:32:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-10T15:33:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.lewagon.com\/wp-content\/uploads\/2023\/03\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg\" \/>\n<meta name=\"author\" content=\"MickaelT\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Data Warehouse : ce que vous devez absolument savoir\" \/>\n<meta name=\"twitter:description\" content=\"Le data warehouse est un incontournable de la data d&#039;analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/blog.lewagon.com\/wp-content\/uploads\/2023\/03\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"MickaelT\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/\"},\"author\":{\"name\":\"MickaelT\",\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/#\\\/schema\\\/person\\\/8b4567040d8a3520451362bb71ea09e6\"},\"headline\":\"Data Warehouse : ce que vous devez absolument savoir\",\"datePublished\":\"2022-02-19T14:32:17+00:00\",\"dateModified\":\"2023-07-10T15:33:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/\"},\"wordCount\":8,\"publisher\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/blog.lewagon.com\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg?fit=2426%2C1728&ssl=1\",\"keywords\":[\"Data\"],\"articleSection\":[\"Skills\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/\",\"url\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/\",\"name\":\"Data Warehouse : ce que vous devez absolument savoir\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/blog.lewagon.com\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg?fit=2426%2C1728&ssl=1\",\"datePublished\":\"2022-02-19T14:32:17+00:00\",\"dateModified\":\"2023-07-10T15:33:04+00:00\",\"description\":\"Le data warehouse est un incontournable de la data d'analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/blog.lewagon.com\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg?fit=2426%2C1728&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/blog.lewagon.com\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg?fit=2426%2C1728&ssl=1\",\"width\":2426,\"height\":1728},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/skills\\\/data-warehouse\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Skills\",\"item\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/.\\\/skills\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Warehouse : ce que vous devez absolument savoir\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/\",\"name\":\"Le Wagon\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/#organization\",\"name\":\"Le Wagon\",\"url\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/blog.lewagon.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/logo.svg\",\"contentUrl\":\"https:\\\/\\\/blog.lewagon.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/logo.svg\",\"width\":172,\"height\":44,\"caption\":\"Le Wagon\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/#\\\/schema\\\/person\\\/8b4567040d8a3520451362bb71ea09e6\",\"name\":\"MickaelT\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/627722b9f4aaa9f24735f9b8656525ab01111fb2c94de91dc70c9c1bffb90e7b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/627722b9f4aaa9f24735f9b8656525ab01111fb2c94de91dc70c9c1bffb90e7b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/627722b9f4aaa9f24735f9b8656525ab01111fb2c94de91dc70c9c1bffb90e7b?s=96&d=mm&r=g\",\"caption\":\"MickaelT\"},\"sameAs\":[\"http:\\\/\\\/blog.lewagon.com\"],\"url\":\"https:\\\/\\\/blog.lewagon.com\\\/fr\\\/author\\\/mickaelt\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Warehouse : ce que vous devez absolument savoir","description":"Le data warehouse est un incontournable de la data d'analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.","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:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/","og_locale":"fr_FR","og_type":"article","og_title":"Data Warehouse : ce que vous devez absolument savoir","og_description":"Le data warehouse est un incontournable de la data d'analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.","og_url":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/","og_site_name":"Blog Le Wagon","article_published_time":"2022-02-19T14:32:17+00:00","article_modified_time":"2023-07-10T15:33:04+00:00","og_image":[{"url":"https:\/\/blog.lewagon.com\/wp-content\/uploads\/2023\/03\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg","type":"","width":"","height":""}],"author":"MickaelT","twitter_card":"summary_large_image","twitter_title":"Data Warehouse : ce que vous devez absolument savoir","twitter_description":"Le data warehouse est un incontournable de la data d'analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.","twitter_image":"https:\/\/blog.lewagon.com\/wp-content\/uploads\/2023\/03\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg","twitter_misc":{"\u00c9crit par":"MickaelT"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/#article","isPartOf":{"@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/"},"author":{"name":"MickaelT","@id":"https:\/\/blog.lewagon.com\/fr\/#\/schema\/person\/8b4567040d8a3520451362bb71ea09e6"},"headline":"Data Warehouse : ce que vous devez absolument savoir","datePublished":"2022-02-19T14:32:17+00:00","dateModified":"2023-07-10T15:33:04+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/"},"wordCount":8,"publisher":{"@id":"https:\/\/blog.lewagon.com\/fr\/#organization"},"image":{"@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/blog.lewagon.com\/wp-content\/uploads\/2023\/04\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg?fit=2426%2C1728&ssl=1","keywords":["Data"],"articleSection":["Skills"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/","url":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/","name":"Data Warehouse : ce que vous devez absolument savoir","isPartOf":{"@id":"https:\/\/blog.lewagon.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/blog.lewagon.com\/wp-content\/uploads\/2023\/04\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg?fit=2426%2C1728&ssl=1","datePublished":"2022-02-19T14:32:17+00:00","dateModified":"2023-07-10T15:33:04+00:00","description":"Le data warehouse est un incontournable de la data d'analyse. Pourquoi ? \u00c0 quoi \u00e7a sert ? On vous dit tout dans cet article.","breadcrumb":{"@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/#primaryimage","url":"https:\/\/i0.wp.com\/blog.lewagon.com\/wp-content\/uploads\/2023\/04\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg?fit=2426%2C1728&ssl=1","contentUrl":"https:\/\/i0.wp.com\/blog.lewagon.com\/wp-content\/uploads\/2023\/04\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg?fit=2426%2C1728&ssl=1","width":2426,"height":1728},{"@type":"BreadcrumbList","@id":"https:\/\/blog.lewagon.com\/fr\/skills\/data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.lewagon.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Skills","item":"https:\/\/blog.lewagon.com\/fr\/.\/skills\/"},{"@type":"ListItem","position":3,"name":"Data Warehouse : ce que vous devez absolument savoir"}]},{"@type":"WebSite","@id":"https:\/\/blog.lewagon.com\/fr\/#website","url":"https:\/\/blog.lewagon.com\/fr\/","name":"Le Wagon","description":"","publisher":{"@id":"https:\/\/blog.lewagon.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.lewagon.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.lewagon.com\/fr\/#organization","name":"Le Wagon","url":"https:\/\/blog.lewagon.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.lewagon.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.lewagon.com\/wp-content\/uploads\/2023\/02\/logo.svg","contentUrl":"https:\/\/blog.lewagon.com\/wp-content\/uploads\/2023\/02\/logo.svg","width":172,"height":44,"caption":"Le Wagon"},"image":{"@id":"https:\/\/blog.lewagon.com\/fr\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/blog.lewagon.com\/fr\/#\/schema\/person\/8b4567040d8a3520451362bb71ea09e6","name":"MickaelT","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/627722b9f4aaa9f24735f9b8656525ab01111fb2c94de91dc70c9c1bffb90e7b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/627722b9f4aaa9f24735f9b8656525ab01111fb2c94de91dc70c9c1bffb90e7b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/627722b9f4aaa9f24735f9b8656525ab01111fb2c94de91dc70c9c1bffb90e7b?s=96&d=mm&r=g","caption":"MickaelT"},"sameAs":["http:\/\/blog.lewagon.com"],"url":"https:\/\/blog.lewagon.com\/fr\/author\/mickaelt\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/blog.lewagon.com\/wp-content\/uploads\/2023\/04\/617a9df2e6bc9cc5780daea5_data-warehouse.jpg?fit=2426%2C1728&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/posts\/221214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/comments?post=221214"}],"version-history":[{"count":2,"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/posts\/221214\/revisions"}],"predecessor-version":[{"id":223912,"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/posts\/221214\/revisions\/223912"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/media\/221215"}],"wp:attachment":[{"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/media?parent=221214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/categories?post=221214"},{"taxonomy":"type_de_post","embeddable":true,"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/type_de_post?post=221214"},{"taxonomy":"post-format","embeddable":true,"href":"https:\/\/blog.lewagon.com\/fr\/wp-json\/wp\/v2\/post-format?post=221214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}