{"id":146540,"date":"2022-03-21T15:21:02","date_gmt":"2022-03-21T14:21:02","guid":{"rendered":"https:\/\/datascientest.com\/?p=146540"},"modified":"2023-11-09T13:32:05","modified_gmt":"2023-11-09T13:32:05","slug":"power-pivot","status":"publish","type":"post","link":"https:\/\/datascientest.com\/power-pivot","title":{"rendered":"Power Pivot : le composant Big Data de Microsoft Power BI"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"146540\" class=\"elementor elementor-146540\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-543753b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"543753b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7e5321c\" data-id=\"7e5321c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b9033ba elementor-widget elementor-widget-heading\" data-id=\"b9033ba\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">La Business Intelligence est de plus en plus utilis\u00e9e en entreprise. Parmi les logiciels les plus populaires, on peut citer la plateforme Power BI de Microsoft.\nCette plateforme offre une solution compl\u00e8te d'informatique d\u00e9cisionnelle gr\u00e2ce \u00e0 une large vari\u00e9t\u00e9 d'outils et de fonctionnalit\u00e9s. L'un des principaux composants de Power BI est Power Pivot.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-204eda4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"204eda4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-20d4044\" data-id=\"20d4044\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ebcfda0 elementor-widget elementor-widget-heading\" data-id=\"ebcfda0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Qu'est-ce que Power Pivot ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d8f17e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d8f17e6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0f5ad49\" data-id=\"0f5ad49\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1c0994e elementor-widget elementor-widget-text-editor\" data-id=\"1c0994e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><strong>Power Pivot fait partie du stack logiciel de Business Intelligence de Microsoft<\/strong>, notamment pour l&rsquo;analyse de donn\u00e9es <strong>Big Data<\/strong>. Selon Microsoft, cet outil offre de nombreuses fonctionnalit\u00e9s.<\/p><p>Il permet d&rsquo;importer des millions de colonnes de donn\u00e9es <strong>en provenance <\/strong><strong>de <\/strong><strong>multiples sources au sein d&rsquo;un workbook<\/strong> <strong>Excel<\/strong> <strong>unique<\/strong>, de cr\u00e9er des relations entre des donn\u00e9es h\u00e9t\u00e9rog\u00e8nes, de cr\u00e9er des mesures et des colonnes calcul\u00e9es \u00e0 l&rsquo;aide de formules.<\/p><p>En outre, la solution permet de <strong>cr\u00e9er des PivotTables et des PivotCharts<\/strong>, et d&rsquo;analyser les donn\u00e9es pour prendre des d\u00e9cisions pour l&rsquo;entreprise sans avoir besoin de l&rsquo;assistance d&rsquo;une \u00e9quipe informatique.<\/p><p>\u00c0 l&rsquo;origine, Power Pivot fut introduit comme une extension <strong>pour Excel 2010 et Excel 2013<\/strong>. Il est d\u00e9sormais nativement int\u00e9gr\u00e9 \u00e0 l&rsquo;application. On manipule Power Pivot avec <strong>le langage DAX (Data Analysis Expressions)<\/strong>.<\/p><p>Cet outil fut cr\u00e9\u00e9 <strong>pour r\u00e9pondre \u00e0 une forte demande en mati\u00e8re d&rsquo;outils Big Data<\/strong> au sein des entreprises. Pour cause, les pr\u00e9c\u00e9dentes g\u00e9n\u00e9rations d&rsquo;Excel \u00e9taient trop restreintes \u00e0 cause de leur limite de lignes et leur vitesse de traitement.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2044ea0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2044ea0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-14b52b8\" data-id=\"14b52b8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-66e40ab elementor-widget elementor-widget-heading\" data-id=\"66e40ab\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Power Pivot vs Excel<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cbf74cf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cbf74cf\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-13fa1d1\" data-id=\"13fa1d1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-099491f elementor-widget elementor-widget-text-editor\" data-id=\"099491f\" 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>Avant Power BI, Power Pivot \u00e9tait d\u00e9j\u00e0 pr\u00e9sent dans Excel depuis 2009. Jusqu&rsquo;\u00e0 Excel 2016, les utilisateurs devaient <strong>t\u00e9l\u00e9charger Power Pivot s\u00e9par\u00e9ment.<\/strong> D\u00e9sormais, l&rsquo;add-in est d\u00e9j\u00e0 inclus.<\/p><p>Cet outil apporte plusieurs b\u00e9n\u00e9fices \u00e0 Excel. Il permet tout d&rsquo;abord d&rsquo;importer et de manipuler <strong>des centaines de millions de lignes de donn\u00e9es<\/strong>, tandis qu&rsquo;Excel \u00e9tait limit\u00e9 \u00e0 environ un million de lignes.<\/p><p>En outre, Power Pivot offre la libert\u00e9 d&rsquo;importer des donn\u00e9es en provenance de sources multiples dans un workbook source unique. <strong>Ces donn\u00e9es peuvent ensuite \u00eatre manipul\u00e9es, analys\u00e9es et interpr\u00e9t\u00e9es sans ralentir les performances de la machine<\/strong>. Enfin, PivotCharts et Power BI permettent de visualiser les donn\u00e9es.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5a5b092 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5a5b092\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8311999\" data-id=\"8311999\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-64313fe elementor-widget elementor-widget-image\" data-id=\"64313fe\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"316\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/02\/excel-power-pivot-1024x404.jpg\" class=\"attachment-large size-large wp-image-146549\" alt=\"excel-power-pivot\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/02\/excel-power-pivot-1024x404.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/02\/excel-power-pivot-300x118.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/02\/excel-power-pivot-768x303.jpg 768w, https:\/\/datascientest.com\/wp-content\/uploads\/2022\/02\/excel-power-pivot.jpg 1520w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-04fb764 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"04fb764\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-98f6b0b\" data-id=\"98f6b0b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ce267b7 elementor-widget elementor-widget-heading\" data-id=\"ce267b7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Power Pivot et Power BI<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-93e7e54 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"93e7e54\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-06a6558\" data-id=\"06a6558\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-10dc9fb elementor-widget elementor-widget-text-editor\" data-id=\"10dc9fb\" 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>Power Pivot fait partie de la plateforme de Business Intelligence Power BI, <strong>au m\u00eame titre que<\/strong> <a href=\"https:\/\/datascientest.com\/booster-sa-productivite-grace-a-powerquery\">Power Query<\/a>. Toutefois, il n&rsquo;est pas imp\u00e9ratif d&rsquo;utiliser ces deux outils ind\u00e9pendants.<\/p><p>Le r\u00f4le de Power Query est de pr\u00e9parer de larges ensembles de donn\u00e9es pour l&rsquo;analyse, tandis que Power Pivot est utilis\u00e9 <strong>pour les mod\u00e8les plus complexes et n\u00e9cessitant des capacit\u00e9s de calcul sup\u00e9rieures \u00e0 Excel<\/strong>.<\/p><p>Les deux outils peuvent \u00eatre utilis\u00e9s ind\u00e9pendamment, mais sont aussi compl\u00e9mentaires. M\u00eame si Power Pivot inclut <strong>des fonctionnalit\u00e9s d&rsquo;import et de formatage de donn\u00e9es<\/strong>, il est pr\u00e9f\u00e9rable d&rsquo;effectuer ces t\u00e2ches de pr\u00e9paration avec Power Query.<\/p><p>Une fois les donn\u00e9es pr\u00e9par\u00e9es, elles peuvent \u00eatre charg\u00e9es vers le mod\u00e8le et Power Pivot peut commencer <strong>\u00e0 \u00e9tablir des relations et \u00e0 cr\u00e9er des mesures \u00e0 l&rsquo;aide du langage DAX<\/strong>.<\/p><p>De son c\u00f4t\u00e9, Power BI inclut davantage d&rsquo;options de connexion que Power Query sur Excel. Il offre aussi <strong>des fonctionnalit\u00e9s de visualisation<\/strong>, et permet de publier et de partager les rapports sur Power BI Service.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f43e61b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f43e61b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-02eb063\" data-id=\"02eb063\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fba4a5c elementor-widget elementor-widget-heading\" data-id=\"fba4a5c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment apprendre \u00e0 utiliser Power Pivot ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9023287 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9023287\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4d21221\" data-id=\"4d21221\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0c2c0b5 elementor-widget elementor-widget-text-editor\" data-id=\"0c2c0b5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Pour apprendre \u00e0 utiliser Power Pivot et plus g\u00e9n\u00e9ralement Power BI, vous pouvez choisir <strong>DataScientest<\/strong>. Notre <strong>formation intensive Power BI<\/strong> vous permet de ma\u00eetriser la plateforme de Business Intelligence de Microsoft en seulement trois jours.<\/p><p>\u00c0 l&rsquo;issue du parcours, vous serez un expert de Power BI capable <strong>de trier, d&rsquo;organiser et d&rsquo;analyser les donn\u00e9es brutes, de mod\u00e9liser les donn\u00e9es transform\u00e9es et de cr\u00e9er un tableau de bord<\/strong> avec plusieurs axes d&rsquo;analyse.<\/p><p>Le cursus se d\u00e9compose en plusieurs modules \u00e0 travers lesquels vous apprendrez <strong>les fondamentaux de la Business Intelligence<\/strong>, les bases de Power BI, la transformation des donn\u00e9es avec Power Query, la mod\u00e9lisation des donn\u00e9es et le langage DAX, la Data Visualisation et la gestion des espaces de travail.<\/p><p>Notre approche Blended Learning combine <strong>50% de coaching personnalis\u00e9<\/strong> sur notre plateforme en ligne et <strong>50% de Masterclass<\/strong>. La formation s&rsquo;effectue en ligne \u00e0 100%.<\/p><p>\u00c0 la fin du programme, et apr\u00e8s un examen blanc, vous pourrez <a href=\"https:\/\/datascientest.com\/pl-300-tout-savoir\">passer l&rsquo;examen PL-300 (anciennement DA-100)<\/a> pour obtenir la certification Microsoft de Data Analyst associ\u00e9. Cette certification permettra de d\u00e9montrer vos comp\u00e9tences et votre expertise sur Power BI aupr\u00e8s des employeurs.<\/p><p>Pour le financement, toutes nos formations sont \u00e9ligibles au <strong>Compte Personnel de Formation<\/strong>. N&rsquo;attendez plus, et d\u00e9couvrez la formation DataScientest Power BI !<\/p><p>Vous savez tout sur Power Pivot. D\u00e9couvrez notre dossier complet sur la Business Intelligence, et <strong>notre dossier complet sur Power BI<\/strong>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7d551dc elementor-widget elementor-widget-html\" data-id=\"7d551dc\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est-ce que Power Pivot ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Power Pivot fait partie du stack logiciel de Business Intelligence de Microsoft, notamment pour l'analyse de donn\u00e9es Big Data. Selon Microsoft, cet outil offre de nombreuses fonctionnalit\u00e9s. Il permet d'importer des millions de colonnes de donn\u00e9es en provenance de multiples sources au sein d'un workbook Excel unique, de cr\u00e9er des relations entre des donn\u00e9es h\u00e9t\u00e9rog\u00e8nes, de cr\u00e9er des mesures et des colonnes calcul\u00e9es \u00e0 l'aide de formules.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment apprendre \u00e0 utiliser Power Pivot ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Pour apprendre \u00e0 utiliser Power Pivot et plus g\u00e9n\u00e9ralement Power BI, vous pouvez choisir DataScientest. Notre formation intensive Power BI vous permet de ma\u00eetriser la plateforme de Business Intelligence de Microsoft en seulement trois jours. \u00c0 l'issue du parcours, vous serez un expert de Power BI capable de trier, d'organiser et d'analyser les donn\u00e9es brutes, de mod\u00e9liser les donn\u00e9es transform\u00e9es et de cr\u00e9er un tableau de bord avec plusieurs axes d'analyse.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est ce que Power Pivot et Power BI ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Power Pivot fait partie de la plateforme de Business Intelligence Power BI, au m\u00eame titre que Power Query. Toutefois, il n'est pas imp\u00e9ratif d'utiliser ces deux outils ind\u00e9pendants. Le r\u00f4le de Power Query est de pr\u00e9parer de larges ensembles de donn\u00e9es pour l'analyse, tandis que Power Pivot est utilis\u00e9 pour les mod\u00e8les plus complexes et n\u00e9cessitant des capacit\u00e9s de calcul sup\u00e9rieures \u00e0 Excel.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Quelle est la diff\u00e9rence entre Power Pivot et Excel ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Avant Power BI, Power Pivot \u00e9tait d\u00e9j\u00e0 pr\u00e9sent dans Excel depuis 2009. Jusqu'\u00e0 Excel 2016, les utilisateurs devaient t\u00e9l\u00e9charger Power Pivot s\u00e9par\u00e9ment. D\u00e9sormais, l'add-in est d\u00e9j\u00e0 inclus. Cet outil apporte plusieurs b\u00e9n\u00e9fices \u00e0 Excel. Il permet tout d'abord d'importer et de manipuler des centaines de millions de lignes de donn\u00e9es, tandis qu'Excel \u00e9tait limit\u00e9 \u00e0 environ un million de lignes. En outre, Power Pivot offre la libert\u00e9 d'importer des donn\u00e9es en provenance de sources multiples dans un workbook source unique. Ces donn\u00e9es peuvent ensuite \u00eatre manipul\u00e9es, analys\u00e9es et interpr\u00e9t\u00e9es sans ralentir les performances de la machine. Enfin, PivotCharts et Power BI permettent de visualiser les donn\u00e9es.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e22b9f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e22b9f0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-12bb114\" data-id=\"12bb114\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-648f0da elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"648f0da\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-power-bi\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">En savoir plus sur notre formation Power BI<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>La Business Intelligence est de plus en plus utilis\u00e9e en entreprise. Parmi les logiciels les plus populaires, on peut citer la plateforme Power BI de Microsoft. Cette plateforme offre une solution compl\u00e8te d&rsquo;informatique d\u00e9cisionnelle gr\u00e2ce \u00e0 une large vari\u00e9t\u00e9 d&rsquo;outils et de fonctionnalit\u00e9s. L&rsquo;un des principaux composants de Power BI est Power Pivot. Qu&rsquo;est-ce que [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":42382,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power Pivot : le composant Big Data de Microsoft Power BI<\/title>\n<meta name=\"description\" content=\"Power Pivot est l&#039;un des principaux composants de la plateforme de Business Intelligence Power BI de Microsoft, notamment pour l&#039;analyse de donn\u00e9es Big Data.\" \/>\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\/power-pivot\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Pivot : le composant Big Data de Microsoft Power BI\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/power-pivot\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-21T14:21:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:32:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/01\/illu_powerBI_blog-76.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1405\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/power-pivot\",\"url\":\"https:\/\/datascientest.com\/power-pivot\",\"name\":\"Power Pivot : le composant Big Data de Microsoft Power BI\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-03-21T14:21:02+00:00\",\"dateModified\":\"2023-11-09T13:32:05+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Power Pivot est l'un des principaux composants de la plateforme de Business Intelligence Power BI de Microsoft, notamment pour l'analyse de donn\u00e9es Big Data.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/power-pivot\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Pivot : le composant Big Data de Microsoft Power BI","description":"Power Pivot est l'un des principaux composants de la plateforme de Business Intelligence Power BI de Microsoft, notamment pour l'analyse de donn\u00e9es Big Data.","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\/power-pivot","og_locale":"fr_FR","og_type":"article","og_title":"Power Pivot : le composant Big Data de Microsoft Power BI","og_url":"https:\/\/datascientest.com\/power-pivot","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-03-21T14:21:02+00:00","article_modified_time":"2023-11-09T13:32:05+00:00","og_image":[{"width":2560,"height":1405,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/01\/illu_powerBI_blog-76.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/power-pivot","url":"https:\/\/datascientest.com\/power-pivot","name":"Power Pivot : le composant Big Data de Microsoft Power BI","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-03-21T14:21:02+00:00","dateModified":"2023-11-09T13:32:05+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Power Pivot est l'un des principaux composants de la plateforme de Business Intelligence Power BI de Microsoft, notamment pour l'analyse de donn\u00e9es Big Data.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/power-pivot"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/146540"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=146540"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/146540\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/42382"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=146540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=146540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=146540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}