{"id":171358,"date":"2023-09-28T11:08:59","date_gmt":"2023-09-28T10:08:59","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=171358"},"modified":"2023-10-30T20:20:16","modified_gmt":"2023-10-30T19:20:16","slug":"excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi","title":{"rendered":"Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"171358\" class=\"elementor elementor-171358\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1f49308e e-flex e-con-boxed e-con\" data-id=\"1f49308e\" 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-754e0349 elementor-widget elementor-widget-text-editor\" data-id=\"754e0349\" 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>Do you want to leverage data with Power BI, especially from your Excel files? Check out our tutorial on how to transform pivot tables into actionable datasets.<\/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-5669d2aa elementor-widget elementor-widget-heading\" data-id=\"5669d2aa\" 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\">Summary<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-43a82f27 elementor-widget elementor-widget-text-editor\" data-id=\"43a82f27\" 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>\n    <li><a href=\"#A\">Acquisition of an Excel File<\/a>\n        <ul>\n            <li><a href=\"#B\">1. Loading a New Data Source<\/a><\/li>\n            <li><a href=\"#C\">2. Transformations with Power Query<\/a><\/li>\n        <\/ul>\n    <\/li>\n    <li><a href=\"#D\">Creating Visuals in Power BI Desktop<\/a>\n        <ul>\n            <li><a href=\"#E\">1. The Title<\/a><\/li>\n            <li><a href=\"#F\">2. Slicers<\/a>\n                <ul>\n                    <li><a href=\"#G\">Methodology<\/a><\/li>\n                    <li><a href=\"#H\">Business Intelligence Point<\/a><\/li>\n                <\/ul>\n            <\/li>\n            <li><a href=\"#I\">3. The Matrix<\/a>\n                <ul>\n                    <li><a href=\"#J\">Methodology<\/a><\/li>\n                    <li><a href=\"#K\">Business Intelligence Point<\/a><\/li>\n                <\/ul>\n            <\/li>\n            <li><a href=\"#L\">4. Clustered Histograms<\/a>\n                <ul>\n                    <li><a href=\"#M\">Methodology<\/a><\/li>\n                <\/ul>\n            <\/li>\n            <li><a href=\"#N\">5. Line Charts<\/a>\n                <ul>\n                    <li><a href=\"#O\">Methodology<\/a><\/li>\n                <\/ul>\n            <\/li>\n        <\/ul>\n    <\/li>\n    <li><a href=\"#P\">Interactions Between Visuals<\/a><\/li>\n    <li><a href=\"#Q\">Conclusion<\/a><\/li>\n<\/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-17485e81 e-flex e-con-boxed e-con\" data-id=\"17485e81\" 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-219cef65 elementor-widget elementor-widget-text-editor\" data-id=\"219cef65\" 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>When you want to <a href=\"https:\/\/datascientest.com\/en\/power-bi-microsofts-business-intelligence-solution\">work with data in Power BI<\/a>, you have various options for your data sources. Among them is the ability to work with your Excel files, making it easier to automate and exploit the data within them.<\/p><p>However, often the format of your data in the spreadsheet is not suitable for <a href=\"https:\/\/datascientest.com\/en\/excel-vs-power-bi-what-are-the-differences\">direct use in Power BI<\/a>. Indeed, Microsoft&#8217;s Business Intelligence software only accepts data stored in the form of tables. This terminology refers to data organized in the form of tables, where columns represent categories of information (phone number, date, time, text, integer\/decimal numbers, etc.), and rows represent data records or entries.<\/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-70416006 e-flex e-con-boxed e-con\" data-id=\"70416006\" 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-5652e9ae elementor-widget elementor-widget-text-editor\" data-id=\"5652e9ae\" 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-7a08916f elementor-widget elementor-widget-html\" data-id=\"7a08916f\" 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\">\n  <table>\n    <tbody>\n      <tr>\n        <td class=\"has-text-align-center\" data-align=\"center\"><strong><em>Name<\/em><\/strong><\/td>\n        <td class=\"has-text-align-center\" data-align=\"center\"><strong><em>First Name<\/em><\/strong><\/td>\n        <td class=\"has-text-align-center\" data-align=\"center\"><strong><em>Age<\/em><\/strong><\/td>\n        <td class=\"has-text-align-center\" data-align=\"center\"><strong><em>Profession<\/em><\/strong><\/td>\n      <\/tr>\n      <tr>\n        <td class=\"has-text-align-center\" data-align=\"center\"><em>MOREAUX<\/em><\/td>\n        <td class=\"has-text-align-center\" data-align=\"center\"><em>Antonin<\/em><\/td>\n        <td class=\"has-text-align-center\" data-align=\"center\"><em>27<\/em><\/td>\n        <td class=\"has-text-align-center\" data-align=\"center\"><em>Developer, Writer, Trainer<\/em><\/td>\n      <\/tr>\n      <tr>\n        <td class=\"has-text-align-center\" data-align=\"center\"><em>FELLOUS<\/em><\/td>\n        <td class=\"has-text-align-center\" data-align=\"center\"><em>Aur\u00e9lia<\/em><\/td>\n        <td class=\"has-text-align-center\" data-align=\"center\">-<\/td>\n        <td class=\"has-text-align-center\" data-align=\"center\"><em>Head of Marketing<\/em><\/td>\n      <\/tr>\n    <\/tbody>\n  <\/table>\n<\/figure>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6527ca19 elementor-widget elementor-widget-text-editor\" data-id=\"6527ca19\" 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>However, this data organization method is not always the most visual. Many Excel users prefer to organize their tables in their own way. As soon as this data needs to be used to create dashboards, it quickly becomes challenging to utilize these resources.<\/p><p>For example:<\/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-45324e6e elementor-widget elementor-widget-image\" data-id=\"45324e6e\" 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\/en\/files\/2023\/09\/tableau-croise-powerbi.png\" class=\"attachment-large size-large wp-image-171361\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi.png 550w, https:\/\/datascientest.com\/en\/files\/2023\/09\/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-1c3156a8 elementor-widget elementor-widget-text-editor\" data-id=\"1c3156a8\" 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;\">In this article, we will detail the acquisition and transformation of an Excel file in the form of a &#8220;pivot table&#8221; before using its data to create a complete dashboard.<\/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-29910ee e-flex e-con-boxed e-con\" data-id=\"29910ee\" 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-271485b2 elementor-widget elementor-widget-heading\" data-id=\"271485b2\" 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 of an Excel file<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-503e9798 elementor-widget elementor-widget-text-editor\" data-id=\"503e9798\" 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;\">As mentioned above, Power BI accepts various data sources, including the spreadsheet software from the same creator: Microsoft Excel. In this section, we will see how to load an Excel file into 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-1da64940 elementor-widget elementor-widget-heading\" data-id=\"1da64940\" 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. Loading a new data source<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-81a05e1 elementor-widget elementor-widget-text-editor\" data-id=\"81a05e1\" 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>In the &#8220;Home&#8221; tab, you will find the following tools:<\/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-4a85c44d elementor-widget elementor-widget-image\" data-id=\"4a85c44d\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"311\" height=\"81\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi1.png\" class=\"attachment-large size-large wp-image-171362\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi1.png 311w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi1-300x78.png 300w\" sizes=\"(max-width: 311px) 100vw, 311px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-2e07425c elementor-widget elementor-widget-text-editor\" data-id=\"2e07425c\" 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>Click on &#8220;Excel Workbook,&#8221; and your file explorer will open. From there, you can select the file you want to use.<\/p><p>Once you&#8217;ve done that, a new contextual menu will appear:<\/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-3cacc3cd elementor-widget elementor-widget-image\" data-id=\"3cacc3cd\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"503\" height=\"400\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi2.png\" class=\"attachment-large size-large wp-image-171363\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi2.png 503w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi2-300x239.png 300w\" sizes=\"(max-width: 503px) 100vw, 503px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-26f4f40 elementor-widget elementor-widget-text-editor\" data-id=\"26f4f40\" 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>This menu allows you to select the item you want to interact with. With Excel, Power BI recognizes sheets as well as tables declared in Excel. You can differentiate these elements through the associated logos:<\/p><p>&#8211; Sheets:<\/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-2901f136 elementor-widget elementor-widget-image\" data-id=\"2901f136\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"25\" height=\"22\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi3.png\" class=\"attachment-large size-large wp-image-171364\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-52901a33 elementor-widget elementor-widget-text-editor\" data-id=\"52901a33\" 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; paintings :<\/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-378d1f81 elementor-widget elementor-widget-image\" data-id=\"378d1f81\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"26\" height=\"22\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi4.png\" class=\"attachment-large size-large wp-image-171365\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-6713698a elementor-widget elementor-widget-text-editor\" data-id=\"6713698a\" 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>Bear in mind that if you select a sheet, Power BI will load all the data present, not just the selected table.<\/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-79bc9039 elementor-widget elementor-widget-text-editor\" data-id=\"79bc9039\" 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>Once you&#8217;ve selected the desired item, you have two options:<\/p><p>1. Load the data <a href=\"https:\/\/datascientest.com\/en\/power-bi-desktop-download-and-installation-guide\">directly into Power BI Desktop<\/a> and start creating visuals.<br \/>2. Transform your data using Microsoft&#8217;s data transformation engine, Power Query.<\/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-74e6eab elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"74e6eab\" 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\" 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-73a1604c elementor-widget elementor-widget-heading\" data-id=\"73a1604c\" 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 with Power Query<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f36f0cd elementor-widget elementor-widget-text-editor\" data-id=\"3f36f0cd\" 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>In this article, we will explore this second option through an example of a pivot table created in Excel. Pivot tables are widely used because they allow for quick and easy reading of data, with entries arranged in rows and columns.<\/p><p>In the example below, we have a table that stores data about modes of transportation in major French cities over time.<\/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-6548dc3b elementor-widget elementor-widget-image\" data-id=\"6548dc3b\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"698\" height=\"94\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi5.png\" class=\"attachment-large size-large wp-image-171366\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi5.png 698w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi5-300x40.png 300w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-5376f6a8 elementor-widget elementor-widget-text-editor\" data-id=\"5376f6a8\" 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>In this type of table, users can read the data with multiple entries:<\/p><p>&#8211; The first column entry for city names.<br \/>&#8211; The second column entry for modes of transportation.<br \/>&#8211; The third row entry for the years in question.<\/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-6a97b23 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"6a97b23\" 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\" 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-2e0ee8f8 elementor-widget elementor-widget-text-editor\" data-id=\"2e0ee8f8\" 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>But Power BI cannot utilize data presented in this way. To make this table format usable, several transformations need to be performed using Power Query.<\/p><p>Indeed, Power BI loads the data in the following format:<\/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-71327bf6 elementor-widget elementor-widget-image\" data-id=\"71327bf6\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"753\" height=\"174\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi6.png\" class=\"attachment-large size-large wp-image-171367\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi6.png 753w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi6-300x69.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-150f4408 elementor-widget elementor-widget-text-editor\" data-id=\"150f4408\" 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>This data format is not suitable and must be adapted using the following list of transformations:<\/p><p>First, you need to unpivot the table once using the &#8220;Transpose&#8221; tool.<\/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-b715e6 elementor-widget elementor-widget-image\" data-id=\"b715e6\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"753\" height=\"355\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi7.png\" class=\"attachment-large size-large wp-image-171368\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi7.png 753w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi7-300x141.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-d1de4d1 elementor-widget elementor-widget-text-editor\" data-id=\"d1de4d1\" 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>then, use the &#8220;Fill Down&#8221; command.<\/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-7da64587 elementor-widget elementor-widget-image\" data-id=\"7da64587\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"753\" height=\"421\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi8.png\" class=\"attachment-large size-large wp-image-171369\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi8.png 753w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi8-300x168.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-84815b elementor-widget elementor-widget-text-editor\" data-id=\"84815b\" 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\">to use the first row of the table as headers, we use the &#8220;Use First Row As Headers&#8221; tool.<\/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-5b3cb146 elementor-widget elementor-widget-image\" data-id=\"5b3cb146\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"753\" height=\"405\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi9.png\" class=\"attachment-large size-large wp-image-171370\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi9.png 753w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi9-300x161.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-4090b42a elementor-widget elementor-widget-text-editor\" data-id=\"4090b42a\" 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>we rename our columns to make them easier to work with.<\/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-489925eb elementor-widget elementor-widget-image\" data-id=\"489925eb\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"753\" height=\"404\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi10.png\" class=\"attachment-large size-large wp-image-171371\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi10.png 753w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi10-300x161.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-4dbd970 elementor-widget elementor-widget-text-editor\" data-id=\"4dbd970\" 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>we once again remove the pivot table by selecting the correctly formatted columns (City and Mode) and using the &#8220;Unpivot Other Columns&#8221; tool.<\/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-2a2c0d75 elementor-widget elementor-widget-image\" data-id=\"2a2c0d75\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"753\" height=\"481\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi11.png\" class=\"attachment-large size-large wp-image-171372\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi11.png 753w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi11-300x192.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-25815e35 elementor-widget elementor-widget-text-editor\" data-id=\"25815e35\" 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\">we then detect the data type by selecting the entire table and using the &#8220;Detect data type&#8221; tool. This enables us to detect numerical data, and thus perform mathematical operations on this data.<\/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-4090e8c6 elementor-widget elementor-widget-image\" data-id=\"4090e8c6\" 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\/en\/files\/2023\/09\/tableau-croise-powerbi12.png\" class=\"attachment-large size-large wp-image-171373\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi12.png 753w, https:\/\/datascientest.com\/en\/files\/2023\/09\/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-706a007 elementor-widget elementor-widget-text-editor\" data-id=\"706a007\" 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;\">The data is now ready to be used in Power BI Desktop. We can then use the &#8220;Close &amp; Apply&#8221; command:<\/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-73f4626f elementor-widget elementor-widget-image\" data-id=\"73f4626f\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"97\" height=\"134\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi13.png\" class=\"attachment-large size-large wp-image-171374\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-3925318b elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"3925318b\" 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\" 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-5a1eab1c elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"5a1eab1c\" 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\/en\/power-bi-training\">\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\">Power BI Training<\/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-71d2e4a0 e-flex e-con-boxed e-con\" data-id=\"71d2e4a0\" 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-37b5cc2a elementor-widget elementor-widget-heading\" data-id=\"37b5cc2a\" 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\">Creating visuals in Power BI Desktop<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4cea285b elementor-widget elementor-widget-text-editor\" data-id=\"4cea285b\" 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;\">In Power BI Desktop, you have the ability to create visuals very easily. In this section, we will detail the process of creating the visuals for the dashboard presented below.<\/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-3b79f248 elementor-widget elementor-widget-image\" data-id=\"3b79f248\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"337\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi14.png\" class=\"attachment-large size-large wp-image-171375\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi14.png 602w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi14-300x168.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-9a173f3 elementor-widget elementor-widget-heading\" data-id=\"9a173f3\" 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. The title<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fe839bd elementor-widget elementor-widget-text-editor\" data-id=\"3fe839bd\" 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>To optimize the user experience, every dashboard should include a simple, unambiguous title that relates to the developed visuals. The title should allow users to immediately understand the context of the dashboard.<\/p><p>In terms of methodology, I use the &#8220;Text Box&#8221; tool in the &#8220;Insert&#8221; tab. I then format it as needed for the users.<\/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-333f9e09 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"333f9e09\" 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\" 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-236b4e6a elementor-widget elementor-widget-heading\" data-id=\"236b4e6a\" 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. Segments\n\n<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77915f22 elementor-widget elementor-widget-text-editor\" data-id=\"77915f22\" 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>In Power BI, segments are tools that enable you to filter the data you display, according to different criteria:<\/p><p>textual (city or country names, product group, team name, etc.) ;<br \/>numerical and chronological (between, after, before, etc.).<\/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-75beb4c8 e-flex e-con-boxed e-con\" data-id=\"75beb4c8\" 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-27ba75cc e-con-full e-flex e-con\" data-id=\"27ba75cc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-686b24f6 elementor-widget elementor-widget-image\" data-id=\"686b24f6\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"290\" height=\"283\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi15.png\" class=\"attachment-large size-large wp-image-171376\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-6a40328b e-con-full e-flex e-con\" data-id=\"6a40328b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3bb66160 elementor-widget elementor-widget-image\" data-id=\"3bb66160\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"293\" height=\"264\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi16.png\" class=\"attachment-large size-large wp-image-171377\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-3d6c0caf e-flex e-con-boxed e-con\" data-id=\"3d6c0caf\" 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-4bf4f826 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"4bf4f826\" 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\" 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-3fae1e54 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"3fae1e54\" 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\" 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-1dbd6fbe elementor-widget elementor-widget-heading\" data-id=\"1dbd6fbe\" 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\">- Methodology<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5d71c68 elementor-widget elementor-widget-text-editor\" data-id=\"5d71c68\" 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>To create a segment, click on the visual &#8220;Segment&#8221;.<\/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-411f8379 elementor-widget elementor-widget-image\" data-id=\"411f8379\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"58\" height=\"53\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi17.png\" class=\"attachment-large size-large wp-image-171378\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-1c4f8756 elementor-widget elementor-widget-text-editor\" data-id=\"1c4f8756\" 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;\">Choose the city:<br \/><\/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-7482068e elementor-widget elementor-widget-image\" data-id=\"7482068e\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"225\" height=\"89\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi18.png\" class=\"attachment-large size-large wp-image-171379\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-1691f706 elementor-widget elementor-widget-text-editor\" data-id=\"1691f706\" 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>You can then customize the shape and functionality of the segment as you wish, thanks to the <strong>&#8220;Visual format&#8221;<\/strong> pane:<\/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-6634fd62 e-flex e-con-boxed e-con\" data-id=\"6634fd62\" 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-20f8dbad e-con-full e-flex e-con\" data-id=\"20f8dbad\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2182249b elementor-widget elementor-widget-image\" data-id=\"2182249b\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"328\" height=\"337\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi19.png\" class=\"attachment-large size-large wp-image-171380\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi19.png 328w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi19-292x300.png 292w\" sizes=\"(max-width: 328px) 100vw, 328px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-60f1bc6e e-con-full e-flex e-con\" data-id=\"60f1bc6e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5548d945 elementor-widget elementor-widget-image\" data-id=\"5548d945\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"331\" height=\"444\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi20.png\" class=\"attachment-large size-large wp-image-171381\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi20.png 331w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi20-224x300.png 224w\" sizes=\"(max-width: 331px) 100vw, 331px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-2e7f2d63 e-flex e-con-boxed e-con\" data-id=\"2e7f2d63\" 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-3baeae59 elementor-widget elementor-widget-heading\" data-id=\"3baeae59\" 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\">- Business Intelligence<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-52c06811 elementor-widget elementor-widget-text-editor\" data-id=\"52c06811\" 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;\">In Business Intelligence, the notion of filtering refers to the action of a field or table on a set of data or measures.<\/span><span style=\"font-weight: 400;\"><br \/><\/span><span style=\"font-weight: 400;\"><br \/><\/span><span style=\"font-weight: 400;\">In Power BI, if you use a segment to filter your data, the field applied to it will need to be chosen carefully. A field can filter:<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">data from the table to which it belongs;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">the data of the table(s) located on the <strong>&#8220;several&#8221;<\/strong> side of a <strong>&#8220;one-to-many&#8221;<\/strong> relationship (the filter field is on the <strong>&#8220;one&#8221;<\/strong> side of the <strong>&#8220;one-to-many&#8221;<\/strong><\/span><\/li><\/ul> relationship).\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-560cda4e elementor-widget elementor-widget-image\" data-id=\"560cda4e\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"276\" height=\"200\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi21.png\" class=\"attachment-large size-large wp-image-171382\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-575d4b16 elementor-widget elementor-widget-text-editor\" data-id=\"575d4b16\" 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>In the example below, fields in the <strong>Product<\/strong> table can filter the <strong>Sales<\/strong> table combined.<\/p><p>Thus, the cities segment can filter cities displayed on other visuals.<\/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-1c377822 elementor-widget elementor-widget-heading\" data-id=\"1c377822\" 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. The matrix<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6b5d2e0f elementor-widget elementor-widget-text-editor\" data-id=\"6b5d2e0f\" 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-435b63e7 elementor-widget elementor-widget-image\" data-id=\"435b63e7\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"753\" height=\"158\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi22.png\" class=\"attachment-large size-large wp-image-171383\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi22.png 753w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi22-300x63.png 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-173d2f0f elementor-widget elementor-widget-heading\" data-id=\"173d2f0f\" 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\">- Methodology<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-73a22864 elementor-widget elementor-widget-text-editor\" data-id=\"73a22864\" 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;\">To create your matrix, click on the &#8220;matrix&#8221; visual<\/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-7970ac75 elementor-widget elementor-widget-image\" data-id=\"7970ac75\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"49\" height=\"37\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi23.png\" class=\"attachment-large size-large wp-image-171384\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-345eaa3d elementor-widget elementor-widget-text-editor\" data-id=\"345eaa3d\" 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;\">then drag and drop the various fields as follows:<\/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-3f22e123 elementor-widget elementor-widget-image\" data-id=\"3f22e123\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"328\" height=\"440\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi24.png\" class=\"attachment-large size-large wp-image-171385\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi24.png 328w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi24-224x300.png 224w\" sizes=\"(max-width: 328px) 100vw, 328px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-221dacdc elementor-widget elementor-widget-text-editor\" data-id=\"221dacdc\" 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;\">You can then move up the hierarchy you&#8217;ve created: each year includes data for several cities.<\/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-2b606826 elementor-widget elementor-widget-image\" data-id=\"2b606826\" 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\/en\/files\/2023\/09\/tableau-croise-powerbi25.png\" class=\"attachment-large size-large wp-image-171386\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi25.png 501w, https:\/\/datascientest.com\/en\/files\/2023\/09\/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-3c0d3afd elementor-widget elementor-widget-image\" data-id=\"3c0d3afd\" 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\/en\/files\/2023\/09\/tableau-croise-powerbi26.png\" class=\"attachment-large size-large wp-image-171387\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi26.png 753w, https:\/\/datascientest.com\/en\/files\/2023\/09\/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-62962ee elementor-widget elementor-widget-text-editor\" data-id=\"62962ee\" 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;\">using the tools at the top right of the display<\/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-4f2dd726 elementor-widget elementor-widget-image\" data-id=\"4f2dd726\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"224\" height=\"45\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi27.png\" class=\"attachment-large size-large wp-image-171388\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-2558346f elementor-widget elementor-widget-text-editor\" data-id=\"2558346f\" 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;\">In the &#8220;Design your visual&#8221; area, you&#8217;ll have access to a wide range of customization options for your visual.<\/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-33bc41db e-flex e-con-boxed e-con\" data-id=\"33bc41db\" 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-126a408f e-con-full e-flex e-con\" data-id=\"126a408f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dc2af37 elementor-widget elementor-widget-image\" data-id=\"dc2af37\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"174\" height=\"486\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi28.png\" class=\"attachment-large size-large wp-image-171389\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi28.png 174w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi28-107x300.png 107w\" sizes=\"(max-width: 174px) 100vw, 174px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-6a683288 e-con-full e-flex e-con\" data-id=\"6a683288\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2baa9091 elementor-widget elementor-widget-image\" data-id=\"2baa9091\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"189\" height=\"259\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi29.png\" class=\"attachment-large size-large wp-image-171390\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-4c75b23 e-flex e-con-boxed e-con\" data-id=\"4c75b23\" 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-2a5082a8 elementor-widget elementor-widget-heading\" data-id=\"2a5082a8\" 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\">- Business Intelligence<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-560b2625 elementor-widget elementor-widget-text-editor\" data-id=\"560b2625\" 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><a href=\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\">Power BI&#8217;s matrix visuals<\/a> are reminiscent of Excel&#8217;s pivot table tool. Indeed, they are functionally oriented in the same way: grouping data by category, and aggregating them according to the desired calculation.<\/p><p>The major difference lies in what you can decide to represent in the matrix. In Excel, you can aggregate your data according to the classic calculation modes:<\/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-5ca085e9 elementor-widget elementor-widget-image\" data-id=\"5ca085e9\" 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\/en\/files\/2023\/09\/tableau-croise-powerbi30.png\" class=\"attachment-large size-large wp-image-171391\" 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-7860b287 elementor-widget elementor-widget-text-editor\" data-id=\"7860b287\" 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>But in Power BI, you can represent your measurements in a matrix. As a result, the calculation possibilities are infinite, and no longer limited to conventional mathematical operations.<br \/><br \/><\/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-34c20586 elementor-widget elementor-widget-heading\" data-id=\"34c20586\" 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. Grouped histograms<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-453d045 elementor-widget elementor-widget-text-editor\" data-id=\"453d045\" 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>Histograms are one of the great classics of visual data representation. Who hasn&#8217;t represented a quantity organized by class on a histogram?<\/p><p>In our example, we represent the total for each mode of transport, classified by city. This visualization enables us to compare different values quickly and visually.<\/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-4aa3dad2 elementor-widget elementor-widget-image\" data-id=\"4aa3dad2\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"392\" height=\"149\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi31.png\" class=\"attachment-large size-large wp-image-171392\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi31.png 392w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi31-300x114.png 300w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-2d402bf9 elementor-widget elementor-widget-heading\" data-id=\"2d402bf9\" 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\">- Methodology<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5fa231e0 elementor-widget elementor-widget-text-editor\" data-id=\"5fa231e0\" 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;\">To create your grouped histogram visual, click on its 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-645fecc2 elementor-widget elementor-widget-image\" data-id=\"645fecc2\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"30\" height=\"30\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi32.png\" class=\"attachment-large size-large wp-image-171393\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-4076a4d4 elementor-widget elementor-widget-text-editor\" data-id=\"4076a4d4\" 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;\">then fill in the various fields as follows:<\/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-32eb5209 elementor-widget elementor-widget-image\" data-id=\"32eb5209\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"211\" height=\"201\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi33.png\" class=\"attachment-large size-large wp-image-171394\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-502682b3 elementor-widget elementor-widget-text-editor\" data-id=\"502682b3\" 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;\">You can then customize the various visual options as you wish in the &#8220;Shape your visual&#8221; section:<\/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-21876f63 e-flex e-con-boxed e-con\" data-id=\"21876f63\" 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-46938b68 e-con-full e-flex e-con\" data-id=\"46938b68\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2f4b01b7 elementor-widget elementor-widget-image\" data-id=\"2f4b01b7\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"156\" height=\"301\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi34.png\" class=\"attachment-large size-large wp-image-171395\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-38b51c66 e-con-full e-flex e-con\" data-id=\"38b51c66\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-59d926df elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"59d926df\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"190\" height=\"230\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi35.png\" class=\"attachment-large size-large wp-image-171396\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-580bf150 e-flex e-con-boxed e-con\" data-id=\"580bf150\" 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-304fc7fa elementor-widget elementor-widget-heading\" data-id=\"304fc7fa\" 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. Curve graphics<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-69ea9a8a elementor-widget elementor-widget-text-editor\" data-id=\"69ea9a8a\" 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;\">Like histograms, curve graphs are among the most widely used graphs. And for good reason: they&#8217;re the best way of representing the evolution of a quantity as a function of time.<\/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-53e7a410 elementor-widget elementor-widget-image\" data-id=\"53e7a410\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"246\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi36.png\" class=\"attachment-large size-large wp-image-171397\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi36.png 602w, https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi36-300x123.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-4eeaad0d elementor-widget elementor-widget-text-editor\" data-id=\"4eeaad0d\" 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;\">In our example, we show the evolution of the total for each mode of transport (all cities combined) as a function of time. This graph allows us to visualize the temporal evolution of our quantity, and thus to analyze the behavior of the population studied.<\/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-39bbb6e5 elementor-widget elementor-widget-heading\" data-id=\"39bbb6e5\" 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\">- Methodology<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ebc7c6 elementor-widget elementor-widget-text-editor\" data-id=\"2ebc7c6\" 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;\">To create your curve graph, select its symbol<\/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-67b2c1d5 elementor-widget elementor-widget-image\" data-id=\"67b2c1d5\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"26\" height=\"25\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi37.png\" class=\"attachment-large size-large wp-image-171398\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-23123e82 elementor-widget elementor-widget-text-editor\" data-id=\"23123e82\" 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;\">then fill in the fields as follows:<\/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-688843e8 elementor-widget elementor-widget-image\" data-id=\"688843e8\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"178\" height=\"192\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi38.png\" class=\"attachment-large size-large wp-image-171399\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-6f22cfec elementor-widget elementor-widget-text-editor\" data-id=\"6f22cfec\" 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;\">You can then customize the various visual options as you wish in the &#8220;Shape your visual&#8221; section:<\/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-279cbf2e e-flex e-con-boxed e-con\" data-id=\"279cbf2e\" 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-2c69d74c e-con-full e-flex e-con\" data-id=\"2c69d74c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-490fcd5a elementor-widget elementor-widget-image\" data-id=\"490fcd5a\" 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\/en\/files\/2023\/09\/tableau-croise-powerbi39.png\" class=\"attachment-large size-large wp-image-171400\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi39.png 159w, https:\/\/datascientest.com\/en\/files\/2023\/09\/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-7a276b4d e-con-full e-flex e-con\" data-id=\"7a276b4d\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2a3f28f5 elementor-widget elementor-widget-image\" data-id=\"2a3f28f5\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"187\" height=\"228\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi40.png\" class=\"attachment-large size-large wp-image-171401\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-59d1a7a5 e-flex e-con-boxed e-con\" data-id=\"59d1a7a5\" 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-51551170 elementor-widget elementor-widget-heading\" data-id=\"51551170\" 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\">Interaction between visuals<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a174af8 elementor-widget elementor-widget-text-editor\" data-id=\"4a174af8\" 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>The great <a href=\"https:\/\/datascientest.com\/en\/tutorial-power-bi-learn-how-to-use-the-bi-tool-by-microsoft\">strength of Power BI<\/a> is undoubtedly the interactivity between dashboard visuals. Indeed, clicking on a graphical element will act as a filter on the selected data. This is particularly useful when you want to delve deeper into your data, and isolate certain characteristics.<\/p><p>To modify this feature, and decorrelate visuals from one another, select the element on which you wish to act.<\/p><p>Then go to the &#8220;Format&#8221; ribbon, &#8220;Modify interactions&#8221;, and click on the item below to disconnect the desired visual.<\/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-538ff052 elementor-widget elementor-widget-image\" data-id=\"538ff052\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"27\" height=\"27\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi41.png\" class=\"attachment-large size-large wp-image-171402\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-27b03faa elementor-widget elementor-widget-text-editor\" data-id=\"27b03faa\" 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 the item below to reconstruct the link between the elements.<\/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-2d0154a9 elementor-widget elementor-widget-image\" data-id=\"2d0154a9\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"31\" height=\"25\" src=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/tableau-croise-powerbi42.png\" class=\"attachment-large size-large wp-image-171403\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-693ebf83 e-flex e-con-boxed e-con\" data-id=\"693ebf83\" 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-44b7cdca elementor-widget elementor-widget-heading\" data-id=\"44b7cdca\" 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-6658ff47 elementor-widget elementor-widget-text-editor\" data-id=\"6658ff47\" 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>Acquiring, transforming and representing data has never been easier than with Power BI. Microsoft&#8217;s Power BI software is versatile, intuitive and allows you to go a long way in analyzing your data.<\/p><p>In this article, we focus on one of the most common transformations: the de-ivisioning of a pivot table. These are commonplace in Excel spreadsheets, thanks to the readability they provide.<\/p><p>Once transformed and tabulated, the data can be used to create visuals and an entire dashboard. Power BI lets you interact with all the visual elements of your report.<\/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-10e026d9 elementor-widget elementor-widget-text-editor\" data-id=\"10e026d9\" 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>If you&#8217;d like to deepen your knowledge of Power BI and obtain certification, we invite you to take the DataScientest training course or read these related articles\ud83d\udca1: <\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;DAX Power BI: all about the query programming language&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\" target=\"_blank\" rel=\"noopener\">DAX Power BI: all about the query programming language<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Direct Query: All you need to know about this data query method&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\" target=\"_blank\" rel=\"noopener\">Power BI Direct Query: All you need to know about this data query method<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Desktop download and installation guide I DataScientest&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-desktop-download-and-installation-guide\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-desktop-download-and-installation-guide\" target=\"_blank\" rel=\"noopener\">Power BI Desktop download and installation guide I DataScientest<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Time Intelligence: Everything you need to know about these DAX functions&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\" target=\"_blank\" rel=\"noopener\">Power BI Time Intelligence: Everything you need to know about these DAX functions<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Report Builder: What is it? How do I use it?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-report-builder-what-is-it-how-do-i-use-it\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-report-builder-what-is-it-how-do-i-use-it\" target=\"_blank\" rel=\"noopener\">Power BI Report Builder: What is it? How do I use it?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Incremental Update&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/incremental-update-power-bi-all-you-need-to-know\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/incremental-update-power-bi-all-you-need-to-know\" target=\"_blank\" rel=\"noopener\">Incremental Update<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21669464 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"21669464\" 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\/en\/power-bi-training\">\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\">Power BI Training<\/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>Do you want to leverage data with Power BI, especially from your Excel files? Check out our tutorial on how to transform pivot tables into actionable datasets. Summary Acquisition of an Excel File 1. Loading a New Data Source 2. Transformations with Power Query Creating Visuals in Power BI Desktop 1. The Title 2. Slicers [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":171360,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420],"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 to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI?<\/title>\n<meta name=\"description\" content=\"By following these steps, you can effectively transform your pivot table from Excel to Power BI into a dataset that is ready for analysis\" \/>\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\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI?\" \/>\n<meta property=\"og:description\" content=\"Do you want to leverage data with Power BI, especially from your Excel files? Check out our tutorial on how to transform pivot tables into actionable\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-28T10:08:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T19:20:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/09\/excel-vs-power-bi-1.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"404\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI?\",\"datePublished\":\"2023-09-28T10:08:59+00:00\",\"dateModified\":\"2023-10-30T19:20:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\"},\"wordCount\":1761,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\",\"url\":\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\",\"name\":\"Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-09-28T10:08:59+00:00\",\"dateModified\":\"2023-10-30T19:20:16+00:00\",\"description\":\"By following these steps, you can effectively transform your pivot table from Excel to Power BI into a dataset that is ready for analysis\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI?","description":"By following these steps, you can effectively transform your pivot table from Excel to Power BI into a dataset that is ready for analysis","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\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi","og_locale":"en_GB","og_type":"article","og_title":"Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI?","og_description":"Do you want to leverage data with Power BI, especially from your Excel files? Check out our tutorial on how to transform pivot tables into actionable","og_url":"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-09-28T10:08:59+00:00","article_modified_time":"2023-10-30T19:20:16+00:00","og_image":[{"width":1024,"height":404,"url":"https:\/\/datascientest.com\/en\/files\/2023\/09\/excel-vs-power-bi-1.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI?","datePublished":"2023-09-28T10:08:59+00:00","dateModified":"2023-10-30T19:20:16+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi"},"wordCount":1761,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi","url":"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi","name":"Excel to Power BI: how to transform a pivot table in Excel into a dataset that can be used by Power BI?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-09-28T10:08:59+00:00","dateModified":"2023-10-30T19:20:16+00:00","description":"By following these steps, you can effectively transform your pivot table from Excel to Power BI into a dataset that is ready for analysis","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/171358"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=171358"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/171358\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/171360"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=171358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=171358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=171358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}