{"id":172195,"date":"2022-08-24T14:46:35","date_gmt":"2022-08-24T14:46:35","guid":{"rendered":"https:\/\/datascientest.com\/?p=172195"},"modified":"2023-11-09T13:31:26","modified_gmt":"2023-11-09T13:31:26","slug":"transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi","status":"publish","type":"post","link":"https:\/\/datascientest.com\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi","title":{"rendered":"Excel vers Power BI : comment transformer un tableau crois\u00e9 sur Excel en jeux de donn\u00e9es exploitable par Power BI ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"172195\" class=\"elementor elementor-172195\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3a118a9 e-flex e-con-boxed e-con\" data-id=\"3a118a9\" 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-766a3c1 elementor-widget elementor-widget-text-editor\" data-id=\"766a3c1\" 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<h2>Vous souhaitez exploiter des donn\u00e9es avec Power BI, notamment vos fichiers Excel ? D\u00e9couvrez notre tutoriel pour transformer des tableaux crois\u00e9s en jeux de donn\u00e9es exploitables.<\/h2>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-78b67a8 elementor-widget elementor-widget-heading\" data-id=\"78b67a8\" 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><h3 class=\"elementor-heading-title elementor-size-default\">Sommaire<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-577e25e elementor-widget elementor-widget-text-editor\" data-id=\"577e25e\" 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<ul><li><a href=\"#A\">Acquisition d\u2019un fichier Excel<\/a><ul><li><a href=\"#B\">1. Chargement d\u2019une nouvelle source de donn\u00e9e<\/a><\/li><li><a href=\"#C\">2. Transformations avec Power Query<\/a><\/li><\/ul><\/li><li><a href=\"#D\">Cr\u00e9ation des visuels dans Power BI Desktop <\/a><ul><li><a href=\"#E\">1. Le titre<\/a><\/li><li><a href=\"#F\">2. Les segments<\/a><ul><li><a href=\"#G\">M\u00e9thodologie<\/a><\/li><li><a href=\"#H\">Point Business Intelligence<\/a><\/li><\/ul><\/li><li><a href=\"#I\">3. La matrice<\/a><ul><li><a href=\"#J\">M\u00e9thodologie<\/a><\/li><li><a href=\"#K\">Point Business Intelligence<\/a><\/li><\/ul><\/li><li><a href=\"#L\">4. Les histogrammes group\u00e9s<\/a><ul><li><a href=\"#M\">M\u00e9thodologie<\/a><\/li><\/ul><\/li><li><a href=\"#N\">5. Les graphiques en courbes<\/a><ul><li><a href=\"#O\">M\u00e9thodologie<\/a><\/li><\/ul><\/li><\/ul><\/li><li><a href=\"#P\">Interactions entre visuels<\/a><\/li><li><a href=\"#Q\">Conclusion<\/a><\/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-a9e0c7a e-flex e-con-boxed e-con\" data-id=\"a9e0c7a\" 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-771baee elementor-widget elementor-widget-text-editor\" data-id=\"771baee\" 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>Lorsque vous souhaitez <strong><a href=\"https:\/\/datascientest.com\/power-bi\">exploiter des donn\u00e9es avec Power BI<\/a><\/strong>, vous avez \u00e0 votre disposition de nombreux choix pour vos sources de donn\u00e9es. Parmi eux, la possibilit\u00e9 de travailler \u00e0 partir de vos <strong>fichiers Excel<\/strong>, et ainsi faciliter et automatiser l\u2019exploitation des donn\u00e9es contenues dans ceux-ci.<\/p><p>Mais bien souvent, la forme de vos donn\u00e9es dans le tableur ne convient pas \u00e0 une <strong>exploitation directe avec Power BI<\/strong>. En effet, le logiciel de <a href=\"https:\/\/datascientest.com\/business-intelligence\">Business Intelligence<\/a> de Microsoft n\u2019accepte que des donn\u00e9es stock\u00e9es sous forme de tables. Cette terminologie d\u00e9signe des <strong>donn\u00e9es organis\u00e9es sous forme de tableaux<\/strong>, o\u00f9 les colonnes sont les cat\u00e9gories d\u2019informations (num\u00e9ro de t\u00e9l\u00e9phone, date, heure, texte, nombre entier \/ d\u00e9cimal, etc.), et les lignes sont les enregistrements ou entr\u00e9es de donn\u00e9es.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0c2b235 e-flex e-con-boxed e-con\" data-id=\"0c2b235\" 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-9673615 elementor-widget elementor-widget-text-editor\" data-id=\"9673615\" 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=\"text-decoration: underline;\">Ex<\/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-3175906 elementor-widget elementor-widget-html\" data-id=\"3175906\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<figure class=\"wp-block-table is-style-regular\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong><em>Nom<\/em><\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong><em>Pr\u00e9nom<\/em><\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong><em>\u00c2ge<\/em><\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong><em>M\u00e9tier<\/em><\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><em>MOREAUX<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\"><em>Antonin<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\"><em>27<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\"><em>D\u00e9veloppeur, r\u00e9dacteur, formateur<\/em><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><em>FELLOUS<\/em><\/td><td class=\"has-text-align-center\" data-align=\"center\">Aur\u00e9lia<\/td><td class=\"has-text-align-center\" data-align=\"center\">-<\/td><td class=\"has-text-align-center\" data-align=\"center\"><em>Head of marketing<\/em><\/td><\/tr><\/tbody><\/table><\/figure>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-94aa7be elementor-widget elementor-widget-text-editor\" data-id=\"94aa7be\" 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>Or, ce mode d\u2019organisation des donn\u00e9es n\u2019est pas toujours le plus visuel. De nombreux utilisateurs d\u2019Excel pr\u00e9f\u00e8rent organiser leurs tableaux \u00e0 leur fa\u00e7on. D\u00e8s lors que ces donn\u00e9es doivent \u00eatre utilis\u00e9es pour cr\u00e9er des <strong>tableaux de bord<\/strong>, il devient rapidement complexe d\u2019exploiter ces ressources.<\/p><p><span style=\"text-decoration: underline;\">Ex<\/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-b91ec84 elementor-widget elementor-widget-image\" data-id=\"b91ec84\" 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=\"550\" height=\"255\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi.png\" class=\"attachment-large size-large wp-image-172211\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi.png 550w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi-300x139.png 300w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/>\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-e7b1a63 elementor-widget elementor-widget-text-editor\" data-id=\"e7b1a63\" 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;\">Dans cet article, nous allons d\u00e9tailler l\u2019acquisition et la transformation d\u2019un <strong>fichier Excel<\/strong> de la forme \u00ab\u00a0tableau crois\u00e9\u00a0\u00bb, avant d\u2019utiliser ses donn\u00e9es pour cr\u00e9er un tableau de bord complet.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3ee0446 e-flex e-con-boxed e-con\" data-id=\"3ee0446\" 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-9c168eb elementor-widget elementor-widget-heading\" data-id=\"9c168eb\" data-element_type=\"widget\" id=\"A\" 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\">Acquisition d\u2019un fichier Excel<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-287e571 elementor-widget elementor-widget-text-editor\" data-id=\"287e571\" 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;\">Comme \u00e9voqu\u00e9 ci-dessus, Power BI accepte de nombreuses <strong>sources de donn\u00e9es<\/strong>, dont le logiciel tableur du m\u00eame cr\u00e9ateur : <a href=\"https:\/\/datascientest.com\/formation-excel\">Microsoft Excel<\/a>. Dans cette partie, nous allons visualiser comment charger un fichier Excel dans Power BI.<\/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-d4d2982 elementor-widget elementor-widget-heading\" data-id=\"d4d2982\" data-element_type=\"widget\" id=\"B\" 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-default\">1. Chargement d\u2019une nouvelle source de donn\u00e9e<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45c0abc elementor-widget elementor-widget-text-editor\" data-id=\"45c0abc\" 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>Dans le ruban <strong>\u00ab\u00a0Accueil\u00a0\u00bb<\/strong>, vous retrouverez les outils suivants :<\/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-a8d865e elementor-widget elementor-widget-image\" data-id=\"a8d865e\" 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=\"311\" height=\"81\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi1.png\" class=\"attachment-large size-large wp-image-172215\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi1.png 311w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi1-300x78.png 300w\" sizes=\"(max-width: 311px) 100vw, 311px\" \/>\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-1c79b12 elementor-widget elementor-widget-text-editor\" data-id=\"1c79b12\" 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>Cliquez sur <strong>\u00ab\u00a0Classeur Excel\u00a0\u00bb<\/strong>, et vous verrez s\u2019ouvrir votre explorateur de fichiers. Vous pourrez ainsi s\u00e9lectionner le fichier que vous souhaitez utiliser.<\/p><p>Une fois cette action men\u00e9e, un nouveau menu contextuel appara\u00eetra :<\/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-77551dc elementor-widget elementor-widget-image\" data-id=\"77551dc\" 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=\"503\" height=\"400\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi2.png\" class=\"attachment-large size-large wp-image-172216\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi2.png 503w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi2-300x239.png 300w\" sizes=\"(max-width: 503px) 100vw, 503px\" \/>\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-b0f9d18 elementor-widget elementor-widget-text-editor\" data-id=\"b0f9d18\" 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;\">Ce menu vous permet de s\u00e9lectionner l\u2019\u00e9l\u00e9ment sur lequel vous pourrez interagir. Avec Excel, Power BI reconna\u00eet les <strong>feuilles<\/strong>, ainsi que les <strong>tableaux<\/strong> d\u00e9clar\u00e9s dans Excel. Vous pourrez diff\u00e9rencier ces \u00e9l\u00e9ments gr\u00e2ces aux logos qui leurs sont associ\u00e9s :<\/span><\/p><p><span style=\"font-weight: 400;\">&#8211; les feuilles :<\/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-cf9c9ba elementor-widget elementor-widget-image\" data-id=\"cf9c9ba\" 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=\"25\" height=\"22\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi3.png\" class=\"attachment-large size-large wp-image-172222\" alt=\"\" \/>\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-941ff2a elementor-widget elementor-widget-text-editor\" data-id=\"941ff2a\" 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;\">&#8211; les tableaux : <\/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-d9eb57b elementor-widget elementor-widget-image\" data-id=\"d9eb57b\" 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=\"26\" height=\"22\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi4.png\" class=\"attachment-large size-large wp-image-172229\" alt=\"\" \/>\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-2b48819 elementor-widget elementor-widget-text-editor\" data-id=\"2b48819\" 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>Gardez \u00e0 l\u2019esprit que si vous s\u00e9lectionnez une feuille, Power BI chargera l\u2019int\u00e9gralit\u00e9 des donn\u00e9es pr\u00e9sentes, et non uniquement le tableau choisi.<\/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-fe95e06 elementor-widget elementor-widget-text-editor\" data-id=\"fe95e06\" 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>Une fois l\u2019\u00e9l\u00e9ment souhait\u00e9 s\u00e9lectionn\u00e9, Vous avez deux possibilit\u00e9s :<\/p><ul><li>charger les donn\u00e9es directement dans <a href=\"https:\/\/datascientest.com\/telechargement-et-installation-power-bi-desktop\">Power BI Desktop<\/a>, et commencer \u00e0 cr\u00e9er des <strong>visuels<\/strong> avec ;<\/li><li>transformer vos donn\u00e9es avec le <strong>moteur de transformation de donn\u00e9es<\/strong> de Microsoft : Power Query.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9919579 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"9919579\" 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><iframe title=\"Acquisition d&#039;un fichier Excel\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/F2D2iBS0m3Y?feature=oembed&enablejsapi=1&origin=https:\/\/datascientest.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/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-319891b elementor-widget elementor-widget-heading\" data-id=\"319891b\" data-element_type=\"widget\" id=\"C\" 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-default\">2. Transformations avec Power Query<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6883ca6 elementor-widget elementor-widget-text-editor\" data-id=\"6883ca6\" 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>Dans cet article, nous aborderons cette deuxi\u00e8me option, au travers d\u2019un exemple de <strong>tableau crois\u00e9<\/strong> cr\u00e9\u00e9 dans Excel. Ce type de tableau est tr\u00e8s r\u00e9pandu, et pour cause : il permet une lecture rapide et ais\u00e9e du tableau, gr\u00e2ce \u00e0 des entr\u00e9es de lectures en lignes et en colonne.<\/p><p>Dans l\u2019exemple ci-dessous, nous retrouvons un tableau qui stocke des donn\u00e9es sur les modes de transports dans de grandes villes fran\u00e7aises au cours du temps.<\/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-f3de455 elementor-widget elementor-widget-image\" data-id=\"f3de455\" 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=\"698\" height=\"94\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi5.png\" class=\"attachment-large size-large wp-image-172237\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi5.png 698w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi5-300x40.png 300w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/>\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-1a48a65 elementor-widget elementor-widget-text-editor\" data-id=\"1a48a65\" 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>Dans ce type de tableaux, les utilisateurs peuvent lire les donn\u00e9es par plusieurs entr\u00e9es :<\/p><ul><li>une premi\u00e8re entr\u00e9e en colonne pour les noms des villes ;<\/li><li>une deuxi\u00e8me entr\u00e9e en colonne pour les noms des modes de transports ;<\/li><li>une troisi\u00e8me entr\u00e9e en ligne pour les ann\u00e9es concern\u00e9es.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85c72a5 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"85c72a5\" 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><iframe title=\"Fichier Excel crois\u00e9\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/-NObnKxCF2Q?feature=oembed&enablejsapi=1&origin=https:\/\/datascientest.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/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-c9673b9 elementor-widget elementor-widget-text-editor\" data-id=\"c9673b9\" 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>Mais Power BI n\u2019est pas capable d\u2019exploiter des donn\u00e9es pr\u00e9sent\u00e9es comme cela. Pour rendre ce format de <strong>tableau exploitable<\/strong>, il est n\u00e9cessaire d\u2019effectuer plusieurs transformations avec <a href=\"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery\">Power Query<\/a>.<\/p><p>En effet, Power BI charge les donn\u00e9es sous la forme suivante :<\/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-bad6cb0 elementor-widget elementor-widget-image\" data-id=\"bad6cb0\" 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=\"753\" height=\"174\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi6.png\" class=\"attachment-large size-large wp-image-172247\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi6.png 753w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi6-300x69.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\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-71a592d elementor-widget elementor-widget-text-editor\" data-id=\"71a592d\" 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>Ce format de donn\u00e9es ne convient pas, et doit donc \u00eatre adapt\u00e9, gr\u00e2ce \u00e0 la liste de transformations suivante :<\/p><ul><li>tout d\u2019abord, il faut d\u00e9croiser le tableau une premi\u00e8re fois gr\u00e2ce \u00e0 l\u2019outil <strong>\u00ab\u00a0Transposer\u00a0\u00bb<\/strong><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cbfacc0 elementor-widget elementor-widget-image\" data-id=\"cbfacc0\" 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=\"753\" height=\"355\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi7.png\" class=\"attachment-large size-large wp-image-172251\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi7.png 753w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi7-300x141.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\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-cc6ceaf elementor-widget elementor-widget-text-editor\" data-id=\"cc6ceaf\" 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<ul><li>puis, utiliser la commande <strong>\u00ab\u00a0remplir vers le bas\u00a0\u00bb<\/strong><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8f755b3 elementor-widget elementor-widget-image\" data-id=\"8f755b3\" 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=\"753\" height=\"421\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi8.png\" class=\"attachment-large size-large wp-image-172252\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi8.png 753w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi8-300x168.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\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-8f1890f elementor-widget elementor-widget-text-editor\" data-id=\"8f1890f\" 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<ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">pour utiliser la premi\u00e8re ligne du tableau comme en-t\u00eate, nous utilisons l\u2019outil <strong>\u00ab\u00a0En-t\u00eates promus\u00a0\u00bb<\/strong><\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-11efa48 elementor-widget elementor-widget-image\" data-id=\"11efa48\" 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=\"753\" height=\"405\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi9.png\" class=\"attachment-large size-large wp-image-172256\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi9.png 753w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi9-300x161.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\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-e5992b3 elementor-widget elementor-widget-text-editor\" data-id=\"e5992b3\" 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<ul><li><span style=\"font-weight: 400;\">nous renommons nos colonnes pour faciliter leur manipulation<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35fb978 elementor-widget elementor-widget-image\" data-id=\"35fb978\" 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=\"753\" height=\"404\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi10.png\" class=\"attachment-large size-large wp-image-172257\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi10.png 753w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi10-300x161.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\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-e9b3867 elementor-widget elementor-widget-text-editor\" data-id=\"e9b3867\" 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<ul><li><span style=\"font-weight: 400;\">nous supprimons ensuite une nouvelle fois\u00a0 le tableau crois\u00e9 en s\u00e9lectionnant les colonnes correctement mises en forme (Ville et Mode), et en utilisant l\u2019outil <strong>\u00ab\u00a0d\u00e9pivoter les autres colonnes\u00a0\u00bb<\/strong>.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-603af4d elementor-widget elementor-widget-image\" data-id=\"603af4d\" 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=\"753\" height=\"481\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi11.png\" class=\"attachment-large size-large wp-image-172262\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi11.png 753w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi11-300x192.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\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-1ff2429 elementor-widget elementor-widget-text-editor\" data-id=\"1ff2429\" 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<ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">nous d\u00e9tectons ensuite le type de donn\u00e9es en s\u00e9lectionnant tout le tableau et en utilisant l\u2019outil <strong>\u00ab\u00a0D\u00e9tecter le type de donn\u00e9es\u00a0\u00bb<\/strong>. Cela nous permet de d\u00e9tecter les donn\u00e9es de type num\u00e9rique, et ainsi de <strong>r\u00e9aliser des op\u00e9rations math\u00e9matiques sur ces donn\u00e9es<\/strong>.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-61bb4a2 elementor-widget elementor-widget-image\" data-id=\"61bb4a2\" 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=\"753\" height=\"194\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi12.png\" class=\"attachment-large size-large wp-image-172268\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi12.png 753w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi12-300x77.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\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-044472b elementor-widget elementor-widget-text-editor\" data-id=\"044472b\" 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 sont maintenant pr\u00eates \u00e0 \u00eatre utilis\u00e9es dans Power BI Desktop. Nous pouvons alors utiliser la commande <strong>\u00ab\u00a0Fermer et appliquer\u00a0\u00bb<\/strong> :<\/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-1321459 elementor-widget elementor-widget-image\" data-id=\"1321459\" 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=\"97\" height=\"134\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi13.png\" class=\"attachment-large size-large wp-image-172270\" alt=\"\" \/>\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-eb5b01a elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"eb5b01a\" 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><iframe title=\"D\u00e9pivotage d&#039;une table\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/9EedIgWHRac?feature=oembed&enablejsapi=1&origin=https:\/\/datascientest.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/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-ffee8dc elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ffee8dc\" 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\">En savoir plus sur la 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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5d40bf1 e-flex e-con-boxed e-con\" data-id=\"5d40bf1\" 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-cac22dd elementor-widget elementor-widget-heading\" data-id=\"cac22dd\" data-element_type=\"widget\" id=\"D\" 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\">Cr\u00e9ation des visuels dans Power BI Desktop<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-23c7d50 elementor-widget elementor-widget-text-editor\" data-id=\"23c7d50\" 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;\">Dans Power BI Desktop, vous profitez de la possibilit\u00e9 de cr\u00e9er des visuels tr\u00e8s simplement. Dans cette partie, nous allons d\u00e9tailler le processus de cr\u00e9ation des visuels du dashboard pr\u00e9sent\u00e9 ci-dessous.<\/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-2075ea1 elementor-widget elementor-widget-image\" data-id=\"2075ea1\" 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=\"602\" height=\"337\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi14.png\" class=\"attachment-large size-large wp-image-172301\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi14.png 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi14-300x168.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-c210a8f elementor-widget elementor-widget-heading\" data-id=\"c210a8f\" data-element_type=\"widget\" id=\"E\" 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-default\">1. Le titre<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-87e4363 elementor-widget elementor-widget-text-editor\" data-id=\"87e4363\" 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;\">Pour optimiser l\u2019exp\u00e9rience utilisateur, tout dashboard doit comporter un titre simple, sans \u00e9quivoque, et en rapport avec les visuels d\u00e9velopp\u00e9s. Le titre doit permettre aux utilisateurs de se projeter directement dans le contexte du dashboard.<\/span><span style=\"font-weight: 400;\"><br \/><\/span><span style=\"font-weight: 400;\"><br \/><\/span><span style=\"font-weight: 400;\">En termes de m\u00e9thodologie, j\u2019utilise l\u2019outil <strong>\u00ab\u00a0Zone de texte\u00a0\u00bb<\/strong> dans le ruban <strong>\u00ab\u00a0Ins\u00e9rer\u00a0\u00bb<\/strong>. Je mets ensuite en forme selon les besoins des utilisateurs.<\/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-58e0f3a elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"58e0f3a\" 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><iframe title=\"Ins\u00e9rer un titre   une zone de texte\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/i3CVmNUV9O0?feature=oembed&enablejsapi=1&origin=https:\/\/datascientest.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/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-3d9d231 elementor-widget elementor-widget-heading\" data-id=\"3d9d231\" data-element_type=\"widget\" id=\"F\" 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-default\">2. Les segments<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e8cc258 elementor-widget elementor-widget-text-editor\" data-id=\"e8cc258\" 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>Dans Power BI, les segments sont des outils qui vous permettent de <strong>filtrer les donn\u00e9es<\/strong> que vous affichez, selon diff\u00e9rents crit\u00e8res :<\/p><ul><li>textuels (noms de villes ou de pays, groupe de produit, nom d\u2019une \u00e9quipe, etc.) ;<\/li><li>num\u00e9riques et chronologiques (entre, apr\u00e8s, avant, etc.).<\/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-7830f5f e-flex e-con-boxed e-con\" data-id=\"7830f5f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-e4ab82e e-con-full e-flex e-con\" data-id=\"e4ab82e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9af3e00 elementor-widget elementor-widget-image\" data-id=\"9af3e00\" 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=\"290\" height=\"283\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi15.png\" class=\"attachment-large size-large wp-image-172311\" alt=\"\" \/>\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>\n\t\t<div class=\"elementor-element elementor-element-78972dc e-con-full e-flex e-con\" data-id=\"78972dc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c790bee elementor-widget elementor-widget-image\" data-id=\"c790bee\" 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=\"293\" height=\"264\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi16.png\" class=\"attachment-large size-large wp-image-172316\" alt=\"\" \/>\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>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d52ba94 e-flex e-con-boxed e-con\" data-id=\"d52ba94\" 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-f6f3106 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"f6f3106\" 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><iframe title=\"Cr\u00e9er un segment textuel\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/39_dOY7MLqA?feature=oembed&enablejsapi=1&origin=https:\/\/datascientest.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/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-1a35103 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"1a35103\" 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><iframe title=\"Cr\u00e9er un segment num\u00e9rique\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/eAMrARFr9bY?feature=oembed&enablejsapi=1&origin=https:\/\/datascientest.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/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-8e3cb9a elementor-widget elementor-widget-heading\" data-id=\"8e3cb9a\" data-element_type=\"widget\" id=\"G\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">- M\u00e9thodologie<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-921c1c6 elementor-widget elementor-widget-text-editor\" data-id=\"921c1c6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Pour cr\u00e9er un segment, cliquez sur le visuel <strong>\u00ab\u00a0Segment\u00a0\u00bb<\/strong><\/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-df07dbc elementor-widget elementor-widget-image\" data-id=\"df07dbc\" 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=\"58\" height=\"53\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi17.png\" class=\"attachment-large size-large wp-image-172329\" alt=\"\" \/>\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-90431f2 elementor-widget elementor-widget-text-editor\" data-id=\"90431f2\" 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;\">et glissez le champ [Ville] dans la zone <strong>\u00ab\u00a0Champ\u00a0\u00bb<\/strong> du volet <strong>\u00ab\u00a0Visualisation\u00a0\u00bb<\/strong><\/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-22e1662 elementor-widget elementor-widget-image\" data-id=\"22e1662\" 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=\"225\" height=\"89\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi18.png\" class=\"attachment-large size-large wp-image-172333\" alt=\"\" \/>\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-acc4d81 elementor-widget elementor-widget-text-editor\" data-id=\"acc4d81\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Vous pourrez ensuite personnaliser \u00e0 votre guise la forme et les fonctionnalit\u00e9s du segment, gr\u00e2ce au volet <strong>\u00ab\u00a0Format visuel\u00a0\u00bb<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4c235ee e-flex e-con-boxed e-con\" data-id=\"4c235ee\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-2046c98 e-con-full e-flex e-con\" data-id=\"2046c98\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0141f81 elementor-widget elementor-widget-image\" data-id=\"0141f81\" 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=\"328\" height=\"337\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi19.png\" class=\"attachment-large size-large wp-image-172340\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi19.png 328w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi19-292x300.png 292w\" sizes=\"(max-width: 328px) 100vw, 328px\" \/>\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>\n\t\t<div class=\"elementor-element elementor-element-27227e9 e-con-full e-flex e-con\" data-id=\"27227e9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e21558b elementor-widget elementor-widget-image\" data-id=\"e21558b\" 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=\"331\" height=\"444\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi20.png\" class=\"attachment-large size-large wp-image-172341\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi20.png 331w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi20-224x300.png 224w\" sizes=\"(max-width: 331px) 100vw, 331px\" \/>\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>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-485b175 e-flex e-con-boxed e-con\" data-id=\"485b175\" 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-eadc747 elementor-widget elementor-widget-heading\" data-id=\"eadc747\" data-element_type=\"widget\" id=\"H\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">- Point Business Intelligence<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-05a8156 elementor-widget elementor-widget-text-editor\" data-id=\"05a8156\" 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;\">En Business Intelligence, la notion de filtrage d\u00e9signe l\u2019action d\u2019un champ ou d\u2019une table sur un ensemble de donn\u00e9es ou de mesures.<\/span><span style=\"font-weight: 400;\"><br \/><\/span><span style=\"font-weight: 400;\"><br \/><\/span><span style=\"font-weight: 400;\">Dans Power BI, si vous utilisez un segment pour filtrer vos donn\u00e9es, le champ appliqu\u00e9 \u00e0 celui-ci sera \u00e0 choisir avec soin. En effet, un champ peut filtrer :<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">les donn\u00e9es de la table \u00e0 laquelle il appartient ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">les donn\u00e9es de la \/ des table(s) situ\u00e9s du c\u00f4t\u00e9 <strong>\u00ab\u00a0plusieurs\u00a0\u00bb<\/strong> d\u2019une relation <strong>\u00ab\u00a0un \u00e0 plusieurs\u00a0\u00bb<\/strong> (le champ filtrant est du c\u00f4t\u00e9 <strong>\u00ab\u00a0un\u00a0\u00bb<\/strong> de la relation <strong>\u00ab\u00a0un \u00e0 plusieurs\u00a0\u00bb<\/strong><\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d38c76a elementor-widget elementor-widget-image\" data-id=\"d38c76a\" 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=\"276\" height=\"200\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi21.png\" class=\"attachment-large size-large wp-image-172345\" alt=\"\" \/>\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-2486680 elementor-widget elementor-widget-text-editor\" data-id=\"2486680\" 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>Dans l\u2019exemple ci-dessous, les champs de la table <strong>Produit<\/strong> peuvent filtrer la table <strong>Vente<\/strong> combin\u00e9es.<\/p><p>Ainsi, le segment des villes permet de filtrer les villes affich\u00e9es sur les autres visuels.<\/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-1651518 elementor-widget elementor-widget-heading\" data-id=\"1651518\" data-element_type=\"widget\" id=\"I\" 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-default\">3. La matrice<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-874dc18 elementor-widget elementor-widget-text-editor\" data-id=\"874dc18\" 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;\">Dans Power BI, le visuel matrice permet de repr\u00e9senter des donn\u00e9es en fonction de cat\u00e9gories communes, en lignes et en colonne. Dans notre exemple, les ann\u00e9es sont r\u00e9sum\u00e9es en en-t\u00eates de cat\u00e9gorie de colonnes, d\u00e9clin\u00e9es ensuite entre les diff\u00e9rentes villes. En ligne, nous retrouvons les diff\u00e9rents modes de transport.<\/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-8414a09 elementor-widget elementor-widget-image\" data-id=\"8414a09\" 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=\"753\" height=\"158\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi22.png\" class=\"attachment-large size-large wp-image-172349\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi22.png 753w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi22-300x63.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\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-a6efce7 elementor-widget elementor-widget-heading\" data-id=\"a6efce7\" data-element_type=\"widget\" id=\"J\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">- M\u00e9thodologie<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc4a217 elementor-widget elementor-widget-text-editor\" data-id=\"dc4a217\" 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;\">Pour cr\u00e9er votre matrice, cliquez sur le visuel <strong>\u00ab\u00a0matrice\u00a0\u00bb<\/strong><\/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-7e6b090 elementor-widget elementor-widget-image\" data-id=\"7e6b090\" 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=\"49\" height=\"37\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi23.png\" class=\"attachment-large size-large wp-image-172353\" alt=\"\" \/>\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-3645409 elementor-widget elementor-widget-text-editor\" data-id=\"3645409\" 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;\">puis glissez les diff\u00e9rents champs comme suit :<\/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-9d183d3 elementor-widget elementor-widget-image\" data-id=\"9d183d3\" 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=\"328\" height=\"440\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi24.png\" class=\"attachment-large size-large wp-image-172357\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi24.png 328w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi24-224x300.png 224w\" sizes=\"(max-width: 328px) 100vw, 328px\" \/>\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-94c8de1 elementor-widget elementor-widget-text-editor\" data-id=\"94c8de1\" 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;\">Vous pourrez ensuite \u00e9voluer dans les diff\u00e9rents niveaux de la hi\u00e9rarchie cr\u00e9\u00e9e : chaque ann\u00e9e comporte des donn\u00e9es pour plusieurs villes.<\/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-9662d70 elementor-widget elementor-widget-image\" data-id=\"9662d70\" 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=\"501\" height=\"184\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi25.png\" class=\"attachment-large size-large wp-image-172358\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi25.png 501w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi25-300x110.png 300w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/>\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-2df6c6a elementor-widget elementor-widget-image\" data-id=\"2df6c6a\" 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=\"753\" height=\"144\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi26.png\" class=\"attachment-large size-large wp-image-172359\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi26.png 753w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi26-300x57.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\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-21ce4d7 elementor-widget elementor-widget-text-editor\" data-id=\"21ce4d7\" 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;\">gr\u00e2ce aux outils situ\u00e9s sur la partie sup\u00e9rieur droite du visuel<\/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-3df775d elementor-widget elementor-widget-image\" data-id=\"3df775d\" 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=\"224\" height=\"45\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi27.png\" class=\"attachment-large size-large wp-image-172363\" alt=\"\" \/>\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-c55d486 elementor-widget elementor-widget-text-editor\" data-id=\"c55d486\" 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;\">Dans la zone <strong>\u00ab\u00a0Mettre en forme votre visuel\u00a0\u00bb<\/strong>, vous aurez acc\u00e8s \u00e0 de nombreuses options de personnalisation pour votre visuel.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d76ae92 e-flex e-con-boxed e-con\" data-id=\"d76ae92\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-0c9c243 e-con-full e-flex e-con\" data-id=\"0c9c243\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d0e4275 elementor-widget elementor-widget-image\" data-id=\"d0e4275\" 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=\"174\" height=\"486\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi28.png\" class=\"attachment-large size-large wp-image-172364\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi28.png 174w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi28-107x300.png 107w\" sizes=\"(max-width: 174px) 100vw, 174px\" \/>\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>\n\t\t<div class=\"elementor-element elementor-element-778ec15 e-con-full e-flex e-con\" data-id=\"778ec15\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c329bb2 elementor-widget elementor-widget-image\" data-id=\"c329bb2\" 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=\"189\" height=\"259\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi29.png\" class=\"attachment-large size-large wp-image-172365\" alt=\"\" \/>\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>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e544c38 e-flex e-con-boxed e-con\" data-id=\"e544c38\" 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-04050fc elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"04050fc\" 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><iframe title=\"Cr\u00e9er une matrice\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/AuLc38mwt4Y?feature=oembed&enablejsapi=1&origin=https:\/\/datascientest.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/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-fb4aecf elementor-widget elementor-widget-heading\" data-id=\"fb4aecf\" data-element_type=\"widget\" id=\"K\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">- Point Business Intelligence<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4d24351 elementor-widget elementor-widget-text-editor\" data-id=\"4d24351\" 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 visuels matrices de Power BI ne sont pas sans rappeler l\u2019outil tableau crois\u00e9 dynamique d\u2019Excel. Ils sont en effet fonctionnellement orient\u00e9s de la m\u00eame fa\u00e7on : regrouper des donn\u00e9es par cat\u00e9gories, et les agr\u00e9ger selon le calcul souhait\u00e9.<\/span><\/p><p><span style=\"font-weight: 400;\">La diff\u00e9rence majeure r\u00e9side dans ce que l\u2019on peut d\u00e9cider de repr\u00e9senter dans la <strong>matrice<\/strong>. Dans Excel, vous pouvez en effet agr\u00e9ger vos donn\u00e9es selon les modes de calcul classiques :\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-b594f4a elementor-widget elementor-widget-image\" data-id=\"b594f4a\" 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=\"82\" height=\"151\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi30.png\" class=\"attachment-large size-large wp-image-172369\" alt=\"\" \/>\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-dcc1fe0 elementor-widget elementor-widget-text-editor\" data-id=\"dcc1fe0\" 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;\">Mais dans Power BI, vous pouvez repr\u00e9senter <\/span><span style=\"font-weight: 400;\">vos mesures<\/span><span style=\"font-weight: 400;\"> dans une matrice. D\u00e8s lors, les possibilit\u00e9s de calculs sont infinies, et non plus limit\u00e9es aux op\u00e9rations math\u00e9matiques classiques.<\/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-b38a9a4 elementor-widget elementor-widget-heading\" data-id=\"b38a9a4\" data-element_type=\"widget\" id=\"L\" 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-default\">4. Les histogrammes group\u00e9s<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-63c1607 elementor-widget elementor-widget-text-editor\" data-id=\"63c1607\" 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;\">Parmi les grands classiques des repr\u00e9sentations visuelles des donn\u00e9es, les histogrammes tiennent une place importante. Qui n\u2019a jamais repr\u00e9sent\u00e9 une quantit\u00e9 organis\u00e9e par classe sur un histogramme ?<\/span><\/p><p><span style=\"font-weight: 400;\">Dans notre exemple, nous repr\u00e9sentons le total de chaque mode de transport, class\u00e9 par ville. Cette <a href=\"https:\/\/datascientest.com\/avec-la-data-visualisation-donnez-du-sens-a-vos-donnees\">visualisation<\/a> nous permet de comparer les diff\u00e9rentes valeurs rapidement et visuellement.<\/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-5301445 elementor-widget elementor-widget-image\" data-id=\"5301445\" 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=\"392\" height=\"149\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi31.png\" class=\"attachment-large size-large wp-image-172373\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi31.png 392w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi31-300x114.png 300w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/>\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-60fbbcb elementor-widget elementor-widget-heading\" data-id=\"60fbbcb\" data-element_type=\"widget\" id=\"M\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">- M\u00e9thodologie<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0594bbd elementor-widget elementor-widget-text-editor\" data-id=\"0594bbd\" 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;\">Pour cr\u00e9er votre visuel histogramme group\u00e9, cliquez sur son logo<\/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-d5bd3b6 elementor-widget elementor-widget-image\" data-id=\"d5bd3b6\" 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=\"30\" height=\"30\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi32.png\" class=\"attachment-large size-large wp-image-172374\" alt=\"\" \/>\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-9e0fd27 elementor-widget elementor-widget-text-editor\" data-id=\"9e0fd27\" 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;\">puis alimentez les diff\u00e9rents champs comme suit :<\/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-650d097 elementor-widget elementor-widget-image\" data-id=\"650d097\" 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=\"211\" height=\"201\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi33.png\" class=\"attachment-large size-large wp-image-172378\" alt=\"\" \/>\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-09b48fb elementor-widget elementor-widget-text-editor\" data-id=\"09b48fb\" 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;\">Vous pourrez ensuite personnaliser \u00e0 souhait les diff\u00e9rentes options visuelles gr\u00e2ce au volet <strong>\u00ab\u00a0Mettre en forme votre visuel\u00a0\u00bb<\/strong> :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-711c2fd e-flex e-con-boxed e-con\" data-id=\"711c2fd\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-eee4632 e-con-full e-flex e-con\" data-id=\"eee4632\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bb01ce7 elementor-widget elementor-widget-image\" data-id=\"bb01ce7\" 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=\"156\" height=\"301\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi34.png\" class=\"attachment-large size-large wp-image-172382\" alt=\"\" \/>\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>\n\t\t<div class=\"elementor-element elementor-element-5584db9 e-con-full e-flex e-con\" data-id=\"5584db9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6aa7e44 elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"6aa7e44\" 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=\"190\" height=\"230\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi35.png\" class=\"attachment-large size-large wp-image-172386\" alt=\"\" \/>\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>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-714275e e-flex e-con-boxed e-con\" data-id=\"714275e\" 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-2bd671d elementor-widget elementor-widget-heading\" data-id=\"2bd671d\" data-element_type=\"widget\" id=\"N\" 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-default\">5. Les graphiques en courbes<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-53c0887 elementor-widget elementor-widget-text-editor\" data-id=\"53c0887\" 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;\">De la m\u00eame fa\u00e7on que pour les histogrammes, les graphiques en courbe font partie des graphiques les plus utilis\u00e9s. Et pour cause, ils sont la meilleure fa\u00e7on de repr\u00e9senter l\u2019\u00e9volution d\u2019une quantit\u00e9 en fonction du temps. <\/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-0fcbfdc elementor-widget elementor-widget-image\" data-id=\"0fcbfdc\" 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=\"602\" height=\"246\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi36.png\" class=\"attachment-large size-large wp-image-172390\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi36.png 602w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi36-300x123.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\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-dd67cec elementor-widget elementor-widget-text-editor\" data-id=\"dd67cec\" 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;\">Dans notre exemple, nous repr\u00e9sentons l\u2019\u00e9volution du total de chaque mode de transport (toutes villes confondues) en fonction du temps. Ce graphique nous permet ainsi de visualiser l\u2019\u00e9volution temporelle de notre quantit\u00e9, et ainsi d\u2019analyser le comportement de la population \u00e9tudi\u00e9e.<\/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-86e43c3 elementor-widget elementor-widget-heading\" data-id=\"86e43c3\" data-element_type=\"widget\" id=\"O\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">- M\u00e9thodologie<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a5a1479 elementor-widget elementor-widget-text-editor\" data-id=\"a5a1479\" 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;\">Afin de cr\u00e9er votre graphique en courbe, s\u00e9lectionnez son symbole<\/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-05c9a8c elementor-widget elementor-widget-image\" data-id=\"05c9a8c\" 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=\"26\" height=\"25\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi37.png\" class=\"attachment-large size-large wp-image-172395\" alt=\"\" \/>\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-030e4bb elementor-widget elementor-widget-text-editor\" data-id=\"030e4bb\" 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;\">puis alimentez les champs comme suit :<\/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-ad84447 elementor-widget elementor-widget-image\" data-id=\"ad84447\" 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=\"178\" height=\"192\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi38.png\" class=\"attachment-large size-large wp-image-172400\" alt=\"\" \/>\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-e1a08f5 elementor-widget elementor-widget-text-editor\" data-id=\"e1a08f5\" 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;\">Vous pourrez ensuite personnaliser \u00e0 souhait les diff\u00e9rentes options visuelles gr\u00e2ce au volet <strong>\u00ab\u00a0Mettre en forme votre visuel\u00a0\u00bb<\/strong> :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f3142d7 e-flex e-con-boxed e-con\" data-id=\"f3142d7\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3027604 e-con-full e-flex e-con\" data-id=\"3027604\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a1606bc elementor-widget elementor-widget-image\" data-id=\"a1606bc\" 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=\"159\" height=\"383\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi39.png\" class=\"attachment-large size-large wp-image-172404\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi39.png 159w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi39-125x300.png 125w\" sizes=\"(max-width: 159px) 100vw, 159px\" \/>\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>\n\t\t<div class=\"elementor-element elementor-element-9817aeb e-con-full e-flex e-con\" data-id=\"9817aeb\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d9949eb elementor-widget elementor-widget-image\" data-id=\"d9949eb\" 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=\"187\" height=\"228\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi40.png\" class=\"attachment-large size-large wp-image-172411\" alt=\"\" \/>\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>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0cd8d1a e-flex e-con-boxed e-con\" data-id=\"0cd8d1a\" 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-bfe4bd9 elementor-widget elementor-widget-heading\" data-id=\"bfe4bd9\" data-element_type=\"widget\" id=\"P\" 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\">Interactions entre visuels<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc245bb elementor-widget elementor-widget-text-editor\" data-id=\"cc245bb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">La grande force de Power BI est sans doute l\u2019<strong>interactivit\u00e9 entre les visuels des tableaux de bord<\/strong>. En effet, cliquer sur un \u00e9l\u00e9ment graphique agira comme un filtre sur les donn\u00e9es s\u00e9lectionn\u00e9es. Cela devient int\u00e9ressant lorsque vous souhaitez plonger en profondeur dans vos donn\u00e9es, et isoler certaines de leurs caract\u00e9ristiques.<\/span><\/p><p><span style=\"font-weight: 400;\">Pour modifier cette fonctionnalit\u00e9, et d\u00e9corr\u00e9ler des visuels entre eux, s\u00e9lectionnez l\u2019\u00e9l\u00e9ment sur lequel vous souhaitez agir. <\/span><\/p><p><span style=\"font-weight: 400;\">Puis, rendez-vous dans le ruban <strong>\u00ab\u00a0Format\u00a0\u00bb<\/strong>, <strong>\u00ab\u00a0Modifier les interactions\u00a0\u00bb<\/strong>, et cliquez sur l&rsquo;item ci-dessous \u00a0pour d\u00e9connecter le visuel souhait\u00e9<\/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-1a73779 elementor-widget elementor-widget-image\" data-id=\"1a73779\" 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=\"27\" height=\"27\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi41.png\" class=\"attachment-large size-large wp-image-172415\" alt=\"\" \/>\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-a4e0eff elementor-widget elementor-widget-text-editor\" data-id=\"a4e0eff\" 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;\">ou l&rsquo;item ci-dessous pour <\/span><span style=\"font-weight: 400;\">reconstruire le lien entre les \u00e9l\u00e9ments.<\/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-9e3a80b elementor-widget elementor-widget-image\" data-id=\"9e3a80b\" 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=\"31\" height=\"25\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/tableau-croise-powerbi42.png\" class=\"attachment-large size-large wp-image-172416\" alt=\"\" \/>\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-e76a77c e-flex e-con-boxed e-con\" data-id=\"e76a77c\" 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-7827f95 elementor-widget elementor-widget-heading\" data-id=\"7827f95\" data-element_type=\"widget\" id=\"Q\" 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\">Conclusion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-568b21f elementor-widget elementor-widget-text-editor\" data-id=\"568b21f\" 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;\">Acqu\u00e9rir ses donn\u00e9es, les transformer puis les repr\u00e9senter n\u2019a jamais \u00e9t\u00e9 aussi simple qu\u2019avec Power BI. Le logiciel de Microsoft peut se targuer d\u2019\u00eatre \u00e0 la fois <strong>polyvalent<\/strong>, <strong>intuitif<\/strong>, et permet d\u2019aller tr\u00e8s loin dans l\u2019analyse de ses donn\u00e9es.<\/span><\/p><p><span style=\"font-weight: 400;\">Cet article nous permet de mettre l\u2019accent sur une des transformations les plus communes : le <strong>d\u00e9pivotage d\u2019un tableau crois\u00e9<\/strong>. Ces derniers sont en effet monnaie courante avec le tableur Excel, de par la lisibilit\u00e9 qu\u2019ils apportent.<\/span><\/p><p><span style=\"font-weight: 400;\">Une fois transform\u00e9es et mises sous forme de tables, les donn\u00e9es peuvent ainsi \u00eatre exploit\u00e9es pour cr\u00e9er des visuels, et tout un <a href=\"https:\/\/datascientest.com\/comment-creer-un-tableau-de-bord-dans-power-bi\">tableau de bord<\/a>. Power BI vous permet alors d\u2019interagir avec l\u2019ensemble des \u00e9l\u00e9ments visuels de votre rapport. <\/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-41b2de5 elementor-widget elementor-widget-text-editor\" data-id=\"41b2de5\" 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>Si vous d\u00e9sirez approfondir votre ma\u00eetrise de Power BI et obtenir une <a href=\"https:\/\/datascientest.com\/certification-power-bi\">certification<\/a>, nous vous invitons \u00e0 suivre la formation <strong>DataScientest<\/strong>.<\/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-e09609d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e09609d\" 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\">D\u00e9couvrir la 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\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>Vous souhaitez exploiter des donn\u00e9es avec Power BI, notamment vos fichiers Excel ? D\u00e9couvrez notre tutoriel pour transformer des tableaux crois\u00e9s en jeux de donn\u00e9es exploitables. Sommaire Acquisition d\u2019un fichier Excel 1. Chargement d\u2019une nouvelle source de donn\u00e9e 2. Transformations avec Power Query Cr\u00e9ation des visuels dans Power BI Desktop 1. Le titre 2. Les [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":175230,"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>Excel vers Power BI : comment transformer un tableau crois\u00e9 sur Excel en jeux de donn\u00e9es exploitable par Power BI ?<\/title>\n<meta name=\"description\" content=\"Vous souhaitez exploiter des donn\u00e9es avec Power BI, notamment vos fichiers Excel ? D\u00e9couvrez notre tutoriel pour transformer des tableaux crois\u00e9s en jeux de donn\u00e9es exploitables.\" \/>\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\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel vers Power BI : comment transformer un tableau crois\u00e9 sur Excel en jeux de donn\u00e9es exploitable par Power BI ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-24T14:46:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:31:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/integrer-un-excel-dans-power-bi-.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1025\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi\",\"url\":\"https:\/\/datascientest.com\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi\",\"name\":\"Excel vers Power BI : comment transformer un tableau crois\u00e9 sur Excel en jeux de donn\u00e9es exploitable par Power BI ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-08-24T14:46:35+00:00\",\"dateModified\":\"2023-11-09T13:31:26+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Vous souhaitez exploiter des donn\u00e9es avec Power BI, notamment vos fichiers Excel ? D\u00e9couvrez notre tutoriel pour transformer des tableaux crois\u00e9s en jeux de donn\u00e9es exploitables.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-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\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel vers Power BI : comment transformer un tableau crois\u00e9 sur Excel en jeux de donn\u00e9es exploitable par Power BI ?","description":"Vous souhaitez exploiter des donn\u00e9es avec Power BI, notamment vos fichiers Excel ? D\u00e9couvrez notre tutoriel pour transformer des tableaux crois\u00e9s en jeux de donn\u00e9es exploitables.","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\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi","og_locale":"fr_FR","og_type":"article","og_title":"Excel vers Power BI : comment transformer un tableau crois\u00e9 sur Excel en jeux de donn\u00e9es exploitable par Power BI ?","og_url":"https:\/\/datascientest.com\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-08-24T14:46:35+00:00","article_modified_time":"2023-11-09T13:31:26+00:00","og_image":[{"width":1025,"height":563,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/08\/integrer-un-excel-dans-power-bi-.jpg","type":"image\/jpeg"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi","url":"https:\/\/datascientest.com\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-power-bi","name":"Excel vers Power BI : comment transformer un tableau crois\u00e9 sur Excel en jeux de donn\u00e9es exploitable par Power BI ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-08-24T14:46:35+00:00","dateModified":"2023-11-09T13:31:26+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Vous souhaitez exploiter des donn\u00e9es avec Power BI, notamment vos fichiers Excel ? D\u00e9couvrez notre tutoriel pour transformer des tableaux crois\u00e9s en jeux de donn\u00e9es exploitables.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/transformer-un-tableau-croise-sur-excel-en-jeux-de-donnees-exploitable-par-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\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/172195"}],"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\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=172195"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/172195\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/175230"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=172195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=172195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=172195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}