{"id":231108,"date":"2024-03-19T06:30:00","date_gmt":"2024-03-19T06:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=231108"},"modified":"2024-03-14T14:52:19","modified_gmt":"2024-03-14T14:52:19","slug":"multidimensional-expressions-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir","title":{"rendered":"MDX ou MultiDimensional eXpressionsMDX : Qu&rsquo;est-ce que c&rsquo;est ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"231108\" class=\"elementor elementor-231108\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7e95602 e-flex e-con-boxed e-con\" data-id=\"7e95602\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ee92871 elementor-widget elementor-widget-heading\" data-id=\"ee92871\" 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\">Dans des grandes entreprises g\u00e9rant des ensembles de donn\u00e9es complexes, l'analyse multidimensionnelle est souvent incontournable. L\u2019outil qui s\u2019impose alors est MDX\u2026 MDX est l\u2019abr\u00e9viation \"MultiDimensional eXpressions\", ou expressions multidimensionnelles. Il s\u2019agit d\u2019un langage de requ\u00eate intervenant sur une structure de donn\u00e9es complexes appel\u00e9es les cubes OLAP. Explications...<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-41dafdd e-flex e-con-boxed e-con\" data-id=\"41dafdd\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8fac19 elementor-widget elementor-widget-heading\" data-id=\"e8fac19\" 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\">Quelques concepts \u00e0 bien conna\u00eetre<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d90b027 elementor-widget elementor-widget-text-editor\" data-id=\"d90b027\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Pour bien comprendre ce qu\u2019est MDX, il importe de bien assimiler quelques concepts inh\u00e9rents aux <a href=\"https:\/\/datascientest.com\/sgbd-tout-savoir\">syst\u00e8mes de gestion de base de donn\u00e9es<\/a>.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c0b579 elementor-widget elementor-widget-heading\" data-id=\"8c0b579\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Multidimensional data \/ donn\u00e9es multidimensionnelles<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5838511 elementor-widget elementor-widget-text-editor\" data-id=\"5838511\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Les donn\u00e9es multidimensionnelles sont des donn\u00e9es <strong>organis\u00e9es de fa\u00e7on \u00e0 \u00eatre analysables selon plusieurs crit\u00e8res simultan\u00e9s<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">Avec <a href=\"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir\">SQL Server<\/a>, les informations sont pr\u00e9sentes dans des tables. En combinant plusieurs tables, il devient possible d\u2019<strong>obtenir une repr\u00e9sentation des donn\u00e9es multidimensionnelle<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">\u00ab\u00a0Multidimensional data\u00a0\u00bb signifie donc que les donn\u00e9es venant de plusieurs tables sont organis\u00e9es afin d\u2019\u00eatre analysables selon une vari\u00e9t\u00e9 de crit\u00e8res.<\/span><\/p><p><span style=\"font-weight: 400;\">La combinaison des donn\u00e9es venant des diverses tables forme ce que l\u2019on appelle un \u00ab\u00a0<strong>cube<\/strong>\u00ab\u00a0.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-980e65a elementor-widget elementor-widget-image\" data-id=\"980e65a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"875\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/donnees_multidimensionnelles.jpg\" class=\"attachment-full size-full wp-image-231122\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/donnees_multidimensionnelles.jpg 875w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/donnees_multidimensionnelles-300x171.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/donnees_multidimensionnelles-768x439.jpg 768w\" sizes=\"(max-width: 875px) 100vw, 875px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-43d3a5f elementor-widget elementor-widget-heading\" data-id=\"43d3a5f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">OLAP (online analytical processing)<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-913ec5f elementor-widget elementor-widget-text-editor\" data-id=\"913ec5f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/olap-tout-savoir-sur-cette-puissante-organisation-des-bases-de-donnees\">OLAP<\/a> est une technique d&rsquo;<a href=\"https:\/\/datascientest.com\/data-analysis-tout-savoir\">analyse de donn\u00e9es<\/a> con\u00e7ue pour des requ\u00eates d\u2019analyses multidimensionnelles ex\u00e9cutables en temps r\u00e9el. Il <strong>facilite l&rsquo;exploration de donn\u00e9es sous diff\u00e9rents points de vue et niveaux de d\u00e9tail<\/strong>. Par exemple, avec OLAP, il est ais\u00e9 de faire appara\u00eetre des ventes par ville, puis de les d\u00e9composer par mois, et enfin par produit.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc83d7c elementor-widget elementor-widget-heading\" data-id=\"cc83d7c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Cubes OLAP<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae8fe0c elementor-widget elementor-widget-text-editor\" data-id=\"ae8fe0c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Un cube OLAP est une <strong>repr\u00e9sentation des donn\u00e9es construit \u00e0 partir de plusieurs tables<\/strong>. La structure globale est assimil\u00e9e \u00e0 un cube dans lequel chaque ar\u00eate repr\u00e9sente une \u00ab\u00a0dimension\u00a0\u00bb des donn\u00e9es. Un cube OLAP organise ainsi les informations de sources diverses afin qu\u2019il soit possible d\u2019explorer plusieurs dimensions en m\u00eame temps. Par exemple, un cube synth\u00e9tisant plusieurs tables, pourrait aider \u00e0 analyser les donn\u00e9es par type de produit, par mois, par lieu.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a556d40 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"a556d40\" 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=\"\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Se former en data science<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c2e92b3 e-flex e-con-boxed e-con\" data-id=\"c2e92b3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f2fc8a6 elementor-widget elementor-widget-heading\" data-id=\"f2fc8a6\" 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\">Un langage pour analyser les cubes OLAP<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72954cf elementor-widget elementor-widget-text-editor\" data-id=\"72954cf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Le <strong>langage de requ\u00eate (query language) MDX<\/strong> sert \u00e0 interroger un cube OLAP, et donc\u00a0 \u00e0 analyser les donn\u00e9es multidimensionnelles d\u2019une telle structure.<\/span><\/p><p><span style=\"font-weight: 400;\">Pour certaines op\u00e9rations de base, <strong>la syntaxe de MDX est proche de<\/strong> <a href=\"https:\/\/datascientest.com\/formation-sql\">SQL<\/a>. Les deux langages sont toutefois diff\u00e9rents \u00e0 bien des \u00e9gards. Outre le fait que MDX intervient sur des donn\u00e9es multidimensionnelles, il est \u00e0 noter qu&rsquo;<strong>une requ\u00eate MDX, \u00e0 la diff\u00e9rence de SQL, ne modifie pas les donn\u00e9es<\/strong>. Ce langage op\u00e8re uniquement en lecture. Il est sp\u00e9cifiquement con\u00e7u pour l\u2019analyse et la prise de d\u00e9cision sur de vastes volumes d\u2019information.<\/span><\/p><p><span style=\"font-weight: 400;\">Par ailleurs, <strong>MDX facilite l&rsquo;interop\u00e9rabilit\u00e9<\/strong> en permettant d\u2019\u00e9crire des requ\u00eates complexes qui vont intervenir sur diff\u00e9rents syst\u00e8mes de gestion de bases de donn\u00e9es.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3b7e59f elementor-widget elementor-widget-image\" data-id=\"3b7e59f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"875\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/cubes_olap.jpg\" class=\"attachment-full size-full wp-image-231123\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/cubes_olap.jpg 875w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/cubes_olap-300x171.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/cubes_olap-768x439.jpg 768w\" sizes=\"(max-width: 875px) 100vw, 875px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4ff06b2 e-flex e-con-boxed e-con\" data-id=\"4ff06b2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5e567ef elementor-widget elementor-widget-heading\" data-id=\"5e567ef\" 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\">Quelques exemples d\u2019usage de MDX<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-155e872 elementor-widget elementor-widget-text-editor\" data-id=\"155e872\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Voici quelques exemples de ce que pourrait accomplir MDX sur un cube OLAP.<\/span><\/p><ul><li><span style=\"font-weight: 400;\">Analyser les <strong>taux de conversion<\/strong> durant les diverses \u00e9tapes d\u2019un tunnel de vente<\/span><\/li><li><span style=\"font-weight: 400;\">Analyser les <strong>motifs de pertes de clients<\/strong> en fonction de leur dur\u00e9e de vie et de leur comportement d\u2019achat<\/span><\/li><li><span style=\"font-weight: 400;\">Trouver le mois et la ville avec les <strong>ventes les plus faibles<\/strong><\/span><\/li><li><span style=\"font-weight: 400;\">Effectuer l\u2019analyse des <strong>co\u00fbts d\u2019acquisition de client par canal<\/strong> marketing<\/span><\/li><li><span style=\"font-weight: 400;\">Etc.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b01457c e-flex e-con-boxed e-con\" data-id=\"b01457c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9325594 elementor-widget elementor-widget-heading\" data-id=\"9325594\" 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\">Un outil pour le data scientist ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e2b16c1 elementor-widget elementor-widget-text-editor\" data-id=\"e2b16c1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Bien que MDX soit un langage de requ\u00eate <strong>puissant pour l&rsquo;analyse multidimensionnelle<\/strong>, on ne saurait dire qu\u2019il soit un outil essentiel pour le data scientist. Toutefois, ses capacit\u00e9s uniques d\u2019analyse seront <strong>extr\u00eamement profitables dans les environnements g\u00e9rant des cubes OLAP<\/strong>. A ce titre, il peut repr\u00e9senter un atout pour un <a href=\"https:\/\/datascientest.com\/salaire-data-scientist\">data scientist<\/a> qui postulerait pour une fonction dans une entreprise d\u2019envergure.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8710153 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"8710153\" 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=\"\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Apprendre la data science<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c10ed9 elementor-widget elementor-widget-html\" data-id=\"0c10ed9\" 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\": \"Qu\u2019est-ce que MDX ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"MDX est l\u2019abr\u00e9viation de MultiDimensional eXpressions ou expressions multidimensionnelles. Il s\u2019agit d\u2019un langage de requ\u00eate intervenant sur une structure de donn\u00e9es complexes appel\u00e9es les cubes OLAP. Les explications suivent...\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est-ce que le Multidimensional data ou donn\u00e9es multidimensionnelles ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Les donn\u00e9es multidimensionnelles sont des donn\u00e9es organis\u00e9es de fa\u00e7on \u00e0 \u00eatre analysables selon plusieurs crit\u00e8res simultan\u00e9s. Avec SQL Server, les informations sont pr\u00e9sentes dans des tables. En combinant plusieurs tables, il devient possible d\u2019obtenir une repr\u00e9sentation des donn\u00e9es multidimensionnelle.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est-ce qu'un cube OLAP ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Un cube OLAP est une repr\u00e9sentation des donn\u00e9es construit \u00e0 partir de plusieurs tables. La structure globale est assimil\u00e9e \u00e0 un cube dans lequel chaque ar\u00eate repr\u00e9sente une \"dimension\" des donn\u00e9es. Un cube OLAP organise ainsi les informations de sources diverses afin qu\u2019il soit possible d\u2019explorer plusieurs dimensions en m\u00eame temps.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00c0 quoi sert le langage MDX ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Le langage de requ\u00eate  (query language) MDX sert \u00e0 interroger un cube OLAP, et donc  \u00e0 analyser les donn\u00e9es multidimensionnelles d\u2019une telle structure.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Dans des grandes entreprises g\u00e9rant des ensembles de donn\u00e9es complexes, l&rsquo;analyse multidimensionnelle est souvent incontournable. L\u2019outil qui s\u2019impose alors est MDX\u2026 MDX est l\u2019abr\u00e9viation \u00ab\u00a0MultiDimensional eXpressions\u00a0\u00bb, ou expressions multidimensionnelles. Il s\u2019agit d\u2019un langage de requ\u00eate intervenant sur une structure de donn\u00e9es complexes appel\u00e9es les cubes OLAP. Explications&#8230; Quelques concepts \u00e0 bien conna\u00eetre Pour bien comprendre [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":231110,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MDX ou MultiDimensional eXpressionsMDX : Qu&#039;est-ce que c&#039;est ?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MDX ou MultiDimensional eXpressionsMDX : Qu&#039;est-ce que c&#039;est ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-19T06:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-14T14:52:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/multidimensional_expressions_datascientest.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"686\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir\",\"name\":\"MDX ou MultiDimensional eXpressionsMDX : Qu'est-ce que c'est ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2024-03-19T06:30:00+00:00\",\"dateModified\":\"2024-03-14T14:52:19+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MDX ou MultiDimensional eXpressionsMDX : Qu'est-ce que c'est ?","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\/multidimensional-expressions-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"MDX ou MultiDimensional eXpressionsMDX : Qu'est-ce que c'est ?","og_url":"https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2024-03-19T06:30:00+00:00","article_modified_time":"2024-03-14T14:52:19+00:00","og_image":[{"width":1200,"height":686,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/02\/multidimensional_expressions_datascientest.jpg","type":"image\/jpeg"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir","url":"https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir","name":"MDX ou MultiDimensional eXpressionsMDX : Qu'est-ce que c'est ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2024-03-19T06:30:00+00:00","dateModified":"2024-03-14T14:52:19+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/multidimensional-expressions-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/231108"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=231108"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/231108\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/231110"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=231108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=231108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=231108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}