{"id":149591,"date":"2022-03-17T09:30:21","date_gmt":"2022-03-17T08:30:21","guid":{"rendered":"https:\/\/datascientest.com\/?p=149591"},"modified":"2024-11-18T14:28:31","modified_gmt":"2024-11-18T14:28:31","slug":"dax-power-bi","status":"publish","type":"post","link":"https:\/\/datascientest.com\/dax-power-bi","title":{"rendered":"DAX Power BI : tout sur le langage de programmation de requ\u00eates"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"149591\" class=\"elementor elementor-149591\" 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-cf3a1a1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cf3a1a1\" 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-b4aa7c2\" data-id=\"b4aa7c2\" 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-c1e62a9 elementor-widget elementor-widget-heading\" data-id=\"c1e62a9\" 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><p class=\"elementor-heading-title elementor-size-default\">La plateforme Power BI de Microsoft est d\u00e9di\u00e9e \u00e0 la Business Intelligence, l'analyse de donn\u00e9es et la Data Visualization. Cet outil logiciel permet de profiter d'analyses en temps r\u00e9el sous forme de visualisations.\nL'utilisation est tr\u00e8s intuitive, mais il est fr\u00e9quemment n\u00e9cessaire de cr\u00e9er des formules et des expressions pour analyser les donn\u00e9es. Pour cela, on utilise DAX.\nLe langage DAX ou Data Analysis Expressions permet de cr\u00e9er des formules et des expressions dans Power BI et diff\u00e9rents services d'analyse de donn\u00e9es comme Microsoft SQL Server ou Excel Power Pivot. Il offre une grande flexibilit\u00e9 pour les t\u00e2ches d'analyse de donn\u00e9es.<\/p>\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-d3a1d92 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d3a1d92\" 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-e71e02d\" data-id=\"e71e02d\" 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-ded3f1d elementor-widget elementor-widget-heading\" data-id=\"ded3f1d\" 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\">Qu'est-ce que Power BI ?<\/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-5751292 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5751292\" 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-1c9742f\" data-id=\"1c9742f\" 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-2998090 elementor-widget elementor-widget-text-editor\" data-id=\"2998090\" 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>Power BI est <strong>un outil de <a href=\"https:\/\/datascientest.com\/business-intelligence\">Business Intelligence<\/a> et une plateforme de Data Visualization<\/strong> propos\u00e9 par <strong><a href=\"https:\/\/www.microsoft.com\/fr-fr\">Microsoft<\/a><\/strong>. Il permet aux organisations d&rsquo;analyser les donn\u00e9es et de g\u00e9n\u00e9rer des rapports.<\/p><p>Un large ensemble d&rsquo;outils, d&rsquo;applications et de connecteurs accompagnent Power BI pour permettre de <strong>profiter d&rsquo;insights exploitables, de visuels immersifs et de rapports interactifs<\/strong>. Il s&rsquo;agit d&rsquo;<strong>une plateforme de Business Intelligence en self-service<\/strong>. Cela signifie qu&rsquo;il est tr\u00e8s facile d&rsquo;agr\u00e9ger, d&rsquo;analyser, de visualiser des donn\u00e9es et de produire des rapports de haute qualit\u00e9. Les donn\u00e9es peuvent \u00eatre extraites <strong>de multiples sources comme Oracle, SAP ou n&rsquo;importe quel Data Warehouse<\/strong>. Diff\u00e9rents types de donn\u00e9es sont pris en charge, du simple fichier<strong> Excel<\/strong> aux vastes volumes de Big Data.<\/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-edb1534 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"edb1534\" 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-39eb4ac\" data-id=\"39eb4ac\" 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-8a49838 elementor-widget elementor-widget-image\" data-id=\"8a49838\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"369\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/sources-donnees-dax-power-bi-1024x472.jpg\" class=\"attachment-large size-large wp-image-149597\" alt=\"sources-donn\u00e9es-dax-power-bi\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/sources-donnees-dax-power-bi-1024x472.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/sources-donnees-dax-power-bi-300x138.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/sources-donnees-dax-power-bi-768x354.jpg 768w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/sources-donnees-dax-power-bi.jpg 1520w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\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-184a4db elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"184a4db\" 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-d6c3b58\" data-id=\"d6c3b58\" 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-d504242 elementor-widget elementor-widget-text-editor\" data-id=\"d504242\" 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 nombreuses fonctionnalit\u00e9s permettent de cr\u00e9er des <strong>graphiques<\/strong>, des <strong>diagrammes<\/strong>, des <strong>tableaux de bord<\/strong> et des <strong>rapports <\/strong>pour analyser les donn\u00e9es et mesurer les indicateurs cl\u00e9s de performance. Il est possible d&rsquo;utiliser Power BI comme un logiciel <strong>en local avec Power BI Desktop<\/strong> ou <strong>comme un service Cloud avec Power BI Service<\/strong>. Des applications mobiles pour iOS et Android sont \u00e9galement disponibles. Avec les derni\u00e8res versions de Power BI, des fonctionnalit\u00e9s d&rsquo;intelligence artificielle permettent de d\u00e9ployer des techniques comme la reconnaissance d&rsquo;image ou l&rsquo;analyse de texte, de <strong>d\u00e9velopper des mod\u00e8les de Machine Learning<\/strong>, et d&rsquo;extraire facilement les insights \u00e0 partir des donn\u00e9es structur\u00e9es ou non structur\u00e9es.<\/p><p>Les principaux avantages de Power BI sont la simplicit\u00e9 de l&rsquo;int\u00e9gration gr\u00e2ce aux connecteurs de donn\u00e9es, <a style=\"font-weight: normal;\" href=\"https:\/\/datascientest.com\/lintelligence-artificielle-simmisce-petit-a-petit-dans-le-monde-de-ledition\">les fonctionnalit\u00e9s d&rsquo;intelligence artificielle<\/a>, les outils de partage de rapport, les tableaux de bord en temps r\u00e9el et <strong>les visualisations personnalisables<\/strong>.<\/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-21f669f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21f669f\" 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-e916ae4\" data-id=\"e916ae4\" 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-2f12eac elementor-widget elementor-widget-heading\" data-id=\"2f12eac\" 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\">Qu'est-ce que Power BI DAX ?<\/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-438e132 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"438e132\" 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-721d916\" data-id=\"721d916\" 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-c277388 elementor-widget elementor-widget-text-editor\" data-id=\"c277388\" 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>Le langage DAX (Data Analysis Expression) <strong>permet d&rsquo;effectuer des t\u00e2ches d&rsquo;analyse de donn\u00e9es sp\u00e9cifiques<\/strong> gr\u00e2ce \u00e0 des codes pr\u00e9d\u00e9finis. Il peut \u00eatre utilis\u00e9 sur Power BI, Microsoft SQL Server et Excel Power Pivot.<\/p><p>Au total, la DAX Library regroupe plus de 200 fonctions, op\u00e9rateurs et constantes pour apporter <strong>une grande flexibilit\u00e9 en mati\u00e8re d&rsquo;analyse de donn\u00e9es<\/strong>. De nouvelles fonctionnalit\u00e9s sont r\u00e9guli\u00e8rement ajout\u00e9es.<\/p><p>S&rsquo;il est plut\u00f4t facile de cr\u00e9er des rapports \u00e0 partir des donn\u00e9es avec Power BI, la t\u00e2che peut se compliquer pour les analyses complexes. C&rsquo;est la raison pour laquelle on utilise DAX.<\/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<div class=\"elementor-element elementor-element-9d279a0 e-con-full e-flex e-con\" data-id=\"9d279a0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-61e6bcf elementor-widget__width-initial elementor-widget elementor-widget-video\" data-id=\"61e6bcf\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=P1GZK0-fNXA&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-a1501d3 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"a1501d3\" 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-power-bi\">\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 au langage DAX<\/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>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-72d89ee elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"72d89ee\" 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-e97456b\" data-id=\"e97456b\" 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-2246c0e elementor-widget elementor-widget-heading\" data-id=\"2246c0e\" 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 apprendre \u00e0 utiliser DAX Power BI ?<\/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-9e900e7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9e900e7\" 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-cc17a06\" data-id=\"cc17a06\" 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-9637815 elementor-widget elementor-widget-text-editor\" data-id=\"9637815\" 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>L&rsquo;outil Power BI est utilis\u00e9 par les professionnels de la Data partout dans le monde pour analyser des donn\u00e9es en provenance de multiples sources et cr\u00e9er des rapports ou des tableaux de bord. <strong>Cet outil offre des fonctionnalit\u00e9s d&rsquo;importation, de transformation, d&rsquo;analyse et de visualisation de donn\u00e9es pour tout le processus de Business Intelligence<\/strong>.<\/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-13fcab4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"13fcab4\" 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-73fe27a\" data-id=\"73fe27a\" 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-37dc9dd elementor-widget elementor-widget-image\" data-id=\"37dc9dd\" 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=\"800\" height=\"388\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/dax-power-bi-analyse-1024x497.jpg\" class=\"attachment-large size-large wp-image-149598\" alt=\"dax-power-bi-analyse\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/dax-power-bi-analyse-1024x497.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/dax-power-bi-analyse-300x145.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/dax-power-bi-analyse-768x372.jpg 768w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/dax-power-bi-analyse.jpg 1520w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\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-67c26e3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"67c26e3\" 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-0478a63\" data-id=\"0478a63\" 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-21a41ed elementor-widget elementor-widget-text-editor\" data-id=\"21a41ed\" 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>La ma\u00eetrise de Power BI et du langage DAX est une comp\u00e9tence tr\u00e8s recherch\u00e9e en entreprise. Afin de d\u00e9couvrir la plateforme et d&rsquo;apprendre les formules DAX, vous pouvez vous tourner vers <strong>DataScientest<\/strong>.<span style=\"color: var( --e-global-color-primary ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); text-align: var(--text-align);\">Notre formation Power BI permet d&rsquo;apprendre \u00e0 utiliser le logiciel en seulement trois jours. \u00c0 la fin du parcours, <\/span><strong style=\"color: var( --e-global-color-primary ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; text-align: var(--text-align);\">vous passerez l&rsquo;examen DA-100 \/ PL-300 et obtenir la certification Data Analyst associ\u00e9 de Microsoft<\/strong><span style=\"color: var( --e-global-color-primary ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); text-align: var(--text-align);\">.<\/span><\/p>\n<p>Les diff\u00e9rents modules du programme couvrent <strong>l&rsquo;introduction g\u00e9n\u00e9rale \u00e0 Power BI, la transformation des donn\u00e9es avec Power Query, la mod\u00e9lisation des donn\u00e9es et le langage DAX<\/strong>, la visualisation de donn\u00e9es et la gestion des espaces de travail.<\/p>\n<p>\u00c0 l&rsquo;issue du cursus, vous ma\u00eetriserez l&rsquo;analyse de donn\u00e9es brutes, le tri et la modification des donn\u00e9es, la mod\u00e9lisation des donn\u00e9es transform\u00e9es et la cr\u00e9ation de tableaux de bord. Vous aurez toutes <strong>les comp\u00e9tences requises pour utiliser Power BI<\/strong> et r\u00e9ussir l&rsquo;examen DA-100 \/ PL-300.<span style=\"color: var( --e-global-color-primary ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); text-align: var(--text-align);\">Toutes nos formations s&rsquo;effectuent \u00e0 distance, et sont \u00e9ligibles au CPF pour le financement. N&rsquo;attendez plus et d\u00e9couvrez <\/span><strong style=\"color: var( --e-global-color-primary ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; text-align: var(--text-align);\">la formation Power BI de DataScientest<\/strong><span style=\"color: var( --e-global-color-primary ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); text-align: var(--text-align);\">.<\/span><\/p>\n<p>Vous savez tout sur Power BI DAX. Pour plus d&rsquo;informations, d\u00e9couvrez notre <a href=\"https:\/\/datascientest.com\/power-bi\">dossier complet sur Power BI <\/a>et <a style=\"font-weight: normal;\" href=\"https:\/\/datascientest.com\/tout-savoir-sur-microsoft-azure\">notre dossier sur le cloud Microsoft Azure<\/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-90a2aa5 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"90a2aa5\" 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-power-bi%20\">\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 notre formation Power BI<\/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-5596dd2 elementor-widget elementor-widget-html\" data-id=\"5596dd2\" 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'est-ce que Power BI ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Power BI est un outil de Business Intelligence et une plateforme de Data Visualization propos\u00e9 par Microsoft. Il permet aux organisations d'analyser les donn\u00e9es et de g\u00e9n\u00e9rer des rapports. Un large ensemble d'outils, d'applications et de connecteurs accompagnent Power BI pour permettre de profiter d'insights exploitables, de visuels immersifs et de rapports interactifs. Il s'agit d'une plateforme de Business Intelligence en self-service. Cela signifie qu'il est tr\u00e8s facile d'agr\u00e9ger, d'analyser, de visualiser des donn\u00e9es et de produire des rapports de haute qualit\u00e9. Les donn\u00e9es peuvent \u00eatre extraites de multiples sources comme Oracle, SAP ou n'importe quel Data Warehouse. Diff\u00e9rents types de donn\u00e9es sont pris en charge, du simple fichier Excel aux vastes volumes de Big Data.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est-ce que Power BI DAX ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Le langage DAX (Data Analysis Expression) permet d'effectuer des t\u00e2ches d'analyse de donn\u00e9es sp\u00e9cifiques gr\u00e2ce \u00e0 des codes pr\u00e9d\u00e9finis. Il peut \u00eatre utilis\u00e9 sur Power BI, Microsoft SQL Server et Excel Power Pivot. Au total, la DAX Library regroupe plus de 200 fonctions, op\u00e9rateurs et constantes pour apporter une grande flexibilit\u00e9 en mati\u00e8re d'analyse de donn\u00e9es. De nouvelles fonctionnalit\u00e9s sont r\u00e9guli\u00e8rement ajout\u00e9es. S'il est plut\u00f4t facile de cr\u00e9er des rapports \u00e0 partir des donn\u00e9es avec Power BI, la t\u00e2che peut se compliquer pour les analyses complexes. C'est la raison pour laquelle on utilise DAX.\"\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-563a412 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"563a412\" 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-9a81b72\" data-id=\"9a81b72\" 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\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>La plateforme Power BI de Microsoft est d\u00e9di\u00e9e \u00e0 la Business Intelligence, l&rsquo;analyse de donn\u00e9es et la Data Visualization. Cet outil logiciel permet de profiter d&rsquo;analyses en temps r\u00e9el sous forme de visualisations. L&rsquo;utilisation est tr\u00e8s intuitive, mais il est fr\u00e9quemment n\u00e9cessaire de cr\u00e9er des formules et des expressions pour analyser les donn\u00e9es. Pour cela, [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":149593,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"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>DAX Power BI : tout sur le langage de programmation de requ\u00eates<\/title>\n<meta name=\"description\" content=\"DAX Power BI est le langage de programmation utilis\u00e9 pour formuler des requ\u00eates sur les donn\u00e9es dans Power BI, la plateforme de Business Intelligence de Microsoft. D\u00e9couvrez tout ce que vous devez savoir sur ce langage et comment apprendre \u00e0 l&#039;utiliser.\" \/>\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\/dax-power-bi\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DAX Power BI : tout sur le langage de programmation de requ\u00eates\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/dax-power-bi\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-17T08:30:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-18T14:28:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/dax-power-bi.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1520\" \/>\n\t<meta property=\"og:image:height\" content=\"739\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/dax-power-bi\",\"url\":\"https:\/\/datascientest.com\/dax-power-bi\",\"name\":\"DAX Power BI : tout sur le langage de programmation de requ\u00eates\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-03-17T08:30:21+00:00\",\"dateModified\":\"2024-11-18T14:28:31+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"DAX Power BI est le langage de programmation utilis\u00e9 pour formuler des requ\u00eates sur les donn\u00e9es dans Power BI, la plateforme de Business Intelligence de Microsoft. D\u00e9couvrez tout ce que vous devez savoir sur ce langage et comment apprendre \u00e0 l'utiliser.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/dax-power-bi\"]}]},{\"@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":"DAX Power BI : tout sur le langage de programmation de requ\u00eates","description":"DAX Power BI est le langage de programmation utilis\u00e9 pour formuler des requ\u00eates sur les donn\u00e9es dans Power BI, la plateforme de Business Intelligence de Microsoft. D\u00e9couvrez tout ce que vous devez savoir sur ce langage et comment apprendre \u00e0 l'utiliser.","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\/dax-power-bi","og_locale":"fr_FR","og_type":"article","og_title":"DAX Power BI : tout sur le langage de programmation de requ\u00eates","og_url":"https:\/\/datascientest.com\/dax-power-bi","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-03-17T08:30:21+00:00","article_modified_time":"2024-11-18T14:28:31+00:00","og_image":[{"width":1520,"height":739,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/03\/dax-power-bi.jpg","type":"image\/jpeg"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/dax-power-bi","url":"https:\/\/datascientest.com\/dax-power-bi","name":"DAX Power BI : tout sur le langage de programmation de requ\u00eates","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-03-17T08:30:21+00:00","dateModified":"2024-11-18T14:28:31+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"DAX Power BI est le langage de programmation utilis\u00e9 pour formuler des requ\u00eates sur les donn\u00e9es dans Power BI, la plateforme de Business Intelligence de Microsoft. D\u00e9couvrez tout ce que vous devez savoir sur ce langage et comment apprendre \u00e0 l'utiliser.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/dax-power-bi"]}]},{"@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\/149591"}],"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=149591"}],"version-history":[{"count":1,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/149591\/revisions"}],"predecessor-version":[{"id":256896,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/149591\/revisions\/256896"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/149593"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=149591"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=149591"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=149591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}