{"id":1452,"date":"2012-01-20T03:36:56","date_gmt":"2012-01-20T01:36:56","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=1452"},"modified":"2012-01-20T03:38:59","modified_gmt":"2012-01-20T01:38:59","slug":"avec-powerpivot-linformatique-decisionnelle-sinvite-sur-excel","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=1452","title":{"rendered":"Avec PowerPivot, l\u2019informatique d\u00e9cisionnelle s\u2019invite sur Excel"},"content":{"rendered":"<p style=\"text-align: justify;\">Au fil des versions, Excel s\u2019enrichit de fonctionnalit\u00e9s nouvelles et s\u2019affranchit de ses limites originelles. Excel 2007 a ainsi permis de briser la barre des 65 mille lignes dans un m\u00eame tableau (portant cette limite \u00e0 un million). Excel 2007 est\u00a0en mesure de g\u00e9rer des tableaux comprenant plusieurs centaines de milliers de lignes, se rapprochant, de par ses capacit\u00e9s de traitement, des SGBDR, avec toutefois l&#8217;avantage d&#8217;\u00eatre accessible aux non-sp\u00e9cialistes.<\/p>\n<p style=\"text-align: justify;\">PowerPivot simplifie l\u2019acc\u00e8s aux donn\u00e9es externes en ajoutant \u00e0 Excel 2010 des fonctionnalit\u00e9s de gestion de bases de donn\u00e9es. Il est maintenant possible de lier des tables de donn\u00e9es entre elles \u00e0 l\u2019aide de jointures. PowerPivot s\u2019appuie sur le moteur SQL Vertipaq ce qui \u00e9tend \u00e0 plusieurs millions le nombre d\u2019enregistrements par table de donn\u00e9es tout en conservant des temps de traitement proches de l\u2019instantan\u00e9. Les sources de donn\u00e9es interrogeables sont vari\u00e9es : bases de donn\u00e9es SQL, tableaux Excel, fichiers ASCII\u2026 La fonction RECHERCHEV prend un s\u00e9rieux coup de vieux.<\/p>\n<p style=\"text-align: justify;\">Fonctionnalit\u00e9s offertes par\u00a0PowerPivot :<\/p>\n<ul>\n<li>\n<div style=\"text-align: justify;\">Import de donn\u00e9es (avec filtres),<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">D\u00e9finition des relations inter-tables (clefs primaires et \u00e9trang\u00e8res),<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">Cr\u00e9ation de tableaux crois\u00e9s dynamiques,<\/div>\n<\/li>\n<li>\n<div style=\"text-align: justify;\">Int\u00e9gration du langage DAX (Data Analysis eXpression) : ce langage ajoute des fonctions de champs calcul\u00e9s, d\u2019agr\u00e9gation, de gestion des dates et de filtrage \u00e0 Excel 2010.<\/div>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">PowerPivot peut parfaitement s\u2019int\u00e9grer dans le syst\u00e8me d\u2019informatique d\u00e9cisionnelle de la PME : l\u00e9ger, ais\u00e9 \u00e0 prendre en main, il interroge en temps r\u00e9el une (ou plusieurs) base de donn\u00e9es de l\u2019entreprise sans difficult\u00e9 et restitue l\u2019information retrait\u00e9e sous forme de tableaux de bord personnalis\u00e9s.<\/p>\n<p style=\"text-align: justify;\">PowerPivot se pr\u00e9sente sous la forme d\u2019un add-in. Une fois install\u00e9 sur le poste, PowerPivot s\u2019int\u00e8gre dans le ruban d\u2019Excel (PowerPivot n\u00e9cessite Excel 2010 au minimum ; pour t\u00e9l\u00e9charger gratuitement PowerPivot : <a href=\"http:\/\/www.microsoft.com\/downloads\/fr-fr\/details.aspx?FamilyId=e081c894-e4ab-42df-8c87-4b99c1f3c49b&amp;displaylang=fr\">http:\/\/www.microsoft.com\/downloads\/fr-fr\/details.aspx?FamilyId=e081c894-e4ab-42df-8c87-4b99c1f3c49b&amp;displaylang=fr<\/a>). La version actuelle de PowerPivot n\u2019est pas pilotable par le biais du VBA (il n\u2019est donc pas possible pour le moment d\u2019automatiser des t\u00e2ches li\u00e9es \u00e0 PowerPivot).<\/p>\n<p style=\"text-align: justify;\">Pour plus d\u2019info sur PowerPivot : <a href=\"http:\/\/www.cellenza.com\/publications\/powerpivot-vers-une-bi-en-self-service\/\">http:\/\/www.cellenza.com\/publications\/powerpivot-vers-une-bi-en-self-service\/<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Avec%20PowerPivot%2C%20l%E2%80%99informatique%20d%C3%A9cisionnelle%20s%E2%80%99invite%20sur%20Excel\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Au fil des versions, Excel s\u2019enrichit de fonctionnalit\u00e9s nouvelles et s\u2019affranchit de ses limites originelles. Excel 2007 a ainsi permis de briser la barre des 65 mille lignes dans un m\u00eame tableau (portant cette limite \u00e0 un million). Excel 2007 est\u00a0en mesure de g\u00e9rer des tableaux comprenant plusieurs centaines de milliers de lignes, se rapprochant, &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=1452\" class=\"more-link\">Continue reading &lsquo;Avec PowerPivot, l\u2019informatique d\u00e9cisionnelle s\u2019invite sur Excel&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Avec%20PowerPivot%2C%20l%E2%80%99informatique%20d%C3%A9cisionnelle%20s%E2%80%99invite%20sur%20Excel\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[7,24],"tags":[377,61,414,378,692,690,689,691,1633,52,294,164,593,687,686,685,683,680,688,57,682,684,1643,68,375,182,681],"class_list":["post-1452","post","type-post","status-publish","format-standard","hentry","category-breves","category-systeme-dinformation","tag-agregation-de-donnees","tag-base-de-donnees","tag-bi","tag-business-intelligence","tag-champ-calcule","tag-clef-etrangere","tag-clef-primaire","tag-clef-secondaire","tag-excel","tag-exploitation-des-donnees","tag-filtres","tag-informatique-decisionnelle","tag-intelligence-daffaires","tag-jointure","tag-langage-dax","tag-moteur-sql","tag-ole-db","tag-powerpivot","tag-recherchev","tag-requete-sql","tag-sgbdr","tag-source-de-donnees","tag-sql","tag-tableau-croise-dynamique","tag-tableau-de-bord","tag-tcd","tag-vertipaq-analysis-services"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1452"}],"version-history":[{"count":0,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1452\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}