{"id":194196,"date":"2023-04-05T18:22:00","date_gmt":"2023-04-05T18:22:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=194196"},"modified":"2023-11-09T13:30:20","modified_gmt":"2023-11-09T13:30:20","slug":"vba-et-power-query-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/vba-et-power-query-tout-savoir","title":{"rendered":"VBA et Power Query : Comment \u00e7a fonctionne ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"194196\" class=\"elementor elementor-194196\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7898689 e-flex e-con-boxed e-con\" data-id=\"7898689\" 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-e4b8d84 elementor-widget elementor-widget-heading\" data-id=\"e4b8d84\" 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\">VBA et Power Query permettent d\u2019automatiser les t\u00e2ches de transformation de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir sur la cr\u00e9ation de macros !<\/h2>\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-9c26f18 e-flex e-con-boxed e-con\" data-id=\"9c26f18\" 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-5688cfb elementor-widget elementor-widget-text-editor\" data-id=\"5688cfb\" 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><span style=\"font-weight: 400;\">Afin <strong>d\u2019importer et de transformer les donn\u00e9es sur Excel et Power BI<\/strong>, on utilise couramment le moteur Power Query. Cet outil permet de manipuler les donn\u00e9es \u00e0 partir de sources externes.<\/span><\/p><p><span style=\"font-weight: 400;\">Toutefois, de nombreux utilisateurs ignorent qu\u2019il est possible d\u2019utiliser le <strong>langage de programmation VBA (Visual Basic for Applications)<\/strong> pour cr\u00e9er des macros d\u2019automatisation de transformation de donn\u00e9es.<\/span><\/p><p><span style=\"font-weight: 400;\">C\u2019est un excellent moyen de <strong>gagner en efficacit\u00e9<\/strong> sur les t\u00e2ches de manipulation de donn\u00e9es. D\u00e9couvrez \u00e0 pr\u00e9sent tout ce que vous devez savoir sur ce sujet !<\/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-9b6b37b e-flex e-con-boxed e-con\" data-id=\"9b6b37b\" 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-5ffb7ca elementor-widget elementor-widget-heading\" data-id=\"5ffb7ca\" 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\u2019est-ce que VBA ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e960e9 elementor-widget elementor-widget-text-editor\" data-id=\"8e960e9\" 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;\">Le langage de programmation VBA (Visual Basic for Applications) est directement <strong>int\u00e9gr\u00e9 aux outils de la suite Microsoft 365<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">Il permet de cr\u00e9er facilement des macros, afin d\u2019<strong>automatiser les t\u00e2ches les plus r\u00e9p\u00e9titives<\/strong> dans les logiciels comme Excel, Word, Access, PowerPoint et Outlook.<\/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-e8328ae elementor-widget elementor-widget-image\" data-id=\"e8328ae\" 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=\"771\" height=\"400\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/visual-basic-for-applications.png\" class=\"attachment-full size-full wp-image-194228\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/visual-basic-for-applications.png 771w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/visual-basic-for-applications-300x156.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/visual-basic-for-applications-768x398.png 768w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-82394d2 e-flex e-con-boxed e-con\" data-id=\"82394d2\" 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-2675419 elementor-widget elementor-widget-heading\" data-id=\"2675419\" 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\u2019est-ce que Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-05a8548 elementor-widget elementor-widget-text-editor\" data-id=\"05a8548\" 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;\">Int\u00e9gr\u00e9 \u00e0 Excel, Power BI et diff\u00e9rents outils de l\u2019\u00e9cosyst\u00e8me <strong>Microsoft Power Platform<\/strong>, Power Query permet l\u2019extraction, la transformation et le chargement (<a href=\"https:\/\/datascientest.com\/extract-transform-load-tout-savoir\">ETL<\/a>) de donn\u00e9es.<\/span><\/p><p><span style=\"font-weight: 400;\">On l\u2019utilise notamment pour charger, nettoyer et transformer les donn\u00e9es <strong>en provenance de<\/strong> <strong>diff\u00e9rentes sources<\/strong>. Il peut s\u2019agir de fichiers Excel, CSV, de bases de donn\u00e9es ou encore de services cloud et de pages web.<\/span><\/p><p><span style=\"font-weight: 400;\">Les op\u00e9rations de transformation de donn\u00e9es incluent <strong>le filtrage, le tri, le regroupement ou encore le fractionnement et le regroupement de colonnes<\/strong>. Il est \u00e9galement possible d\u2019ajouter des colonnes personnalis\u00e9es \u00e0 l\u2019aide des formules Power Query.<\/span><\/p><p><span style=\"font-weight: 400;\">Pour cr\u00e9er des relations entre les tableaux, on peut aussi les lier \u00e0 l\u2019aide de cl\u00e9s \u00e9trang\u00e8res. L\u2019outil permet aussi de <strong>cr\u00e9er des requ\u00eates dynamiques<\/strong> pour mettre \u00e0 jour les donn\u00e9es \u00e0 mesure qu\u2019elles sont ajout\u00e9es ou modifi\u00e9es dans la source externe.<\/span><\/p><p><span style=\"font-weight: 400;\">Le point fort de Power Query est son interface intuitive et simple d\u2019utilisation pour <strong>l\u2019importation et la transformation de donn\u00e9es<\/strong>. Toutefois, r\u00e9p\u00e9ter les m\u00eames t\u00e2ches de transformation inlassablement pour diff\u00e9rentes sources peut vite devenir fastidieux. Le langage VBA apporte une alternative.<\/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-bef97fa e-flex e-con-boxed e-con\" data-id=\"bef97fa\" 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-d49e2d9 elementor-widget elementor-widget-heading\" data-id=\"d49e2d9\" 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\">\u00c0 quoi sert VBA avec Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-beaa318 elementor-widget elementor-widget-text-editor\" data-id=\"beaa318\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">En utilisant VBA conjointement \u00e0 Power Query, il est possible d\u2019<strong>automatiser les t\u00e2ches de transformation de donn\u00e9es<\/strong> dans le but de gagner en efficacit\u00e9.<\/span><\/p><p><span style=\"font-weight: 400;\">La premi\u00e8re \u00e9tape est de cr\u00e9er une requ\u00eate Power Query, via l\u2019interface utilisateur d\u2019Excel ou l\u2019\u00e9diteur de Power BI. D\u00e8s que la requ\u00eate est cr\u00e9\u00e9e, elle peut \u00eatre enregistr\u00e9e sous forme de <strong>macro d\u2019automatisation<\/strong> qu\u2019il est possible de modifier librement. Voici plusieurs exemples de cas d\u2019usage.<\/span><\/p><p><span style=\"font-weight: 400;\">Tout d\u2019abord, il est possible d\u2019automatiser le processus d\u2019importation de donn\u00e9es \u00e0 partir de diff\u00e9rentes sources avec des <strong>macros VBA<\/strong>. On peut ensuite transformer les donn\u00e9es avec Power Query pour les rendre plus exploitables, et cr\u00e9er des visualisations avec Power BI.<\/span><\/p><p><span style=\"font-weight: 400;\">Pour les t\u00e2ches de nettoyage de donn\u00e9es, VBA permet par exemple d\u2019automatiser la suppression des lignes en double et les colonnes inutiles, de remplacer les valeurs manquantes, ou de convertir les donn\u00e9es en diff\u00e9rents formats.<\/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-3344363 elementor-widget elementor-widget-image\" data-id=\"3344363\" 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=\"899\" height=\"531\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/automatisation-taches.jpg\" class=\"attachment-full size-full wp-image-194232\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/automatisation-taches.jpg 899w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/automatisation-taches-300x177.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/automatisation-taches-768x454.jpg 768w\" sizes=\"(max-width: 899px) 100vw, 899px\" \/>\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-4167c2d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"4167c2d\" 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\">Apprendre \u00e0 utiliser VBA avec Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c14f6c7 elementor-widget elementor-widget-text-editor\" data-id=\"c14f6c7\" 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;\">Par ailleurs, VBA peut \u00eatre utilis\u00e9 pour <strong>combiner plusieurs sources de donn\u00e9es \u00e0 l\u2019aide de Power Query<\/strong>. Il peut notamment s\u2019agir de plusieurs feuilles Excel \u00e0 combiner en une seule requ\u00eate.<\/span><\/p><p><span style=\"font-weight: 400;\">De la m\u00eame mani\u00e8re, plusieurs donn\u00e9es provenant de diff\u00e9rentes sources externes peuvent \u00eatre combin\u00e9es. Ceci permet par exemple de <strong>combiner un fichier CSV avec une base de donn\u00e9es<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">Rien n\u2019emp\u00eache de cr\u00e9er une macro VBA pour <strong>cr\u00e9er des connexions Power Query pour plusieurs tableaux Excel<\/strong>. C\u2019est un gain de temps par rapport \u00e0 la cr\u00e9ation manuelle d\u2019une connexion pour chaque tableau \u00e0 combiner.<\/span><\/p><p><span style=\"font-weight: 400;\">Un autre exemple de cas d\u2019usage est l\u2019utilisation d\u2019une macro VBA pour <strong>cr\u00e9er un bouton de rafra\u00eechissement<\/strong>, permettant \u00e0 l\u2019utilisateur d\u2019automatiser les requ\u00eates directement sur Excel ou Power BI.<\/span><\/p><p><span style=\"font-weight: 400;\">En r\u00e8gle g\u00e9n\u00e9rale, toutes les t\u00e2ches de transformation r\u00e9p\u00e9titives peuvent \u00eatre automatis\u00e9es avec VBA. Son utilisation est donc tr\u00e8s pertinente pour des processus \u00e0 effectuer avec Power BI sur chaque nouvelle source de donn\u00e9es. Cependant, cette synergie pr\u00e9sente des limites.<\/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-f1cb93c e-flex e-con-boxed e-con\" data-id=\"f1cb93c\" 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-7064ecc elementor-widget elementor-widget-heading\" data-id=\"7064ecc\" 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\">Quelles sont les limites ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-800e966 elementor-widget elementor-widget-text-editor\" data-id=\"800e966\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Les macros VBA sont tr\u00e8s utiles, mais <strong>ne peuvent d\u00e9passer un certain seuil de complexit\u00e9<\/strong>. Une t\u00e2che de transformation de donn\u00e9es trop ardue requiert une macro compliqu\u00e9e qu\u2019il sera difficile de maintenir correctement.<\/span><\/p><p><span style=\"font-weight: 400;\">De m\u00eame, Power Query est un puissant outil de manipulation de donn\u00e9es, mais <strong>ne prend pas en charge certaines sources de donn\u00e9es<\/strong>. Il est \u00e9galement restreint en termes de transformation de donn\u00e9es.<\/span><\/p><p><span style=\"font-weight: 400;\">Sur des sources de donn\u00e9es comportant des relations complexes entre les tableaux, <strong>l\u2019automatisation des t\u00e2ches de transformation peut aussi \u00eatre difficile<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">En guise d\u2019alternative, il est possible d\u2019utiliser des outils de manipulation de donn\u00e9es plus avanc\u00e9s comme les langages <a href=\"https:\/\/datascientest.com\/python-tout-savoir\">Python<\/a>, <span style=\"text-decoration: underline;\"><strong>R<\/strong><\/span> ou <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">SQL<\/a> pour la cr\u00e9ation de scripts d\u2019automatisation.<\/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-6c73ab7 elementor-widget elementor-widget-image\" data-id=\"6c73ab7\" 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=\"640\" height=\"370\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/pexels-pixabay-270557.jpg\" class=\"attachment-full size-full wp-image-194233\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/pexels-pixabay-270557.jpg 640w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/pexels-pixabay-270557-300x173.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e9f75b5 e-flex e-con-boxed e-con\" data-id=\"e9f75b5\" 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-8e53867 elementor-widget elementor-widget-heading\" data-id=\"8e53867\" 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\">Conclusion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a5a2a2 elementor-widget elementor-widget-text-editor\" data-id=\"9a5a2a2\" 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;\">Le langage VBA est tr\u00e8s utile pour automatiser les t\u00e2ches de transformation de donn\u00e9es sur Power Query pour Excel et Power BI. C\u2019est <strong>un pr\u00e9cieux atout pour les processus les plus r\u00e9p\u00e9titifs<\/strong>, bien qu\u2019il pr\u00e9sente ses limites pour les manipulations complexes.<\/span><\/p><p><span style=\"font-weight: 400;\">Afin d\u2019apprendre \u00e0 manier Power Query, le langage VBA et les autres outils avanc\u00e9s d\u2019Excel ou Power BI, vous pouvez <strong>choisir DataScientest<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">Notre <strong>formation intensive \u00e0 Power BI<\/strong> se d\u00e9roule en <strong>38 heures r\u00e9parties sur 5 jours<\/strong>. Les 3 premiers jours sont d\u00e9di\u00e9s \u00e0 l\u2019initiation pour les d\u00e9butants, et les 2 jours suivants permettent de renforcer son expertise et s\u2019adresse aux initi\u00e9s.<\/span><\/p><p><span style=\"font-weight: 400;\">Il est possible d\u2019effectuer la totalit\u00e9 de parcours, ou de choisir l\u2019une des deux parties en fonction de vos besoins et de votre niveau de comp\u00e9tences.<\/span><\/p><p><span style=\"font-weight: 400;\">\u00c0 la fin du cursus, vous ma\u00eetriserez pleinement Power BI et serez en mesure de l\u2019utiliser pour <strong>collecter<\/strong>, <strong>transformer<\/strong>, <strong>analyser<\/strong> <strong>des donn\u00e9es et cr\u00e9er des tableaux de bord interactifs<\/strong>. Les langages <a href=\"https:\/\/datascientest.com\/dax-power-bi\">DAX<\/a>, M, VBA et le moteur Power Query n\u2019auront plus de secrets pour vous.<\/span><\/p><p><span style=\"font-weight: 400;\">Tous nos professeurs sont certifi\u00e9s <strong>Microsoft Trainer<\/strong>, et notre organisme a le statut de <strong>Microsoft Learning Partner<\/strong>. Ainsi, nous vous accompagnons jusqu\u2019\u00e0 l&rsquo;obtention de la <a href=\"https:\/\/datascientest.com\/pl-300-tout-savoir\">certification Microsoft PL-300<\/a> pour devenir Power BI Data Analyst Associate !<\/span><\/p><p><span style=\"font-weight: 400;\">Le programme se compl\u00e8te int\u00e9gralement \u00e0 distance via le web, et nous sommes \u00e9ligibles au <a href=\"https:\/\/datascientest.com\/cpf-definition-utlisation\">Compte Personnel de Formation<\/a> pour le financement. <strong>D\u00e9couvrez DataScientest !<\/strong><\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e30c71f elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e30c71f\" 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\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir les formations DataScientest<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-52c0fb7 elementor-widget elementor-widget-text-editor\" data-id=\"52c0fb7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Vous savez tout sur <strong>l\u2019alchimie entre VBA et Power Query<\/strong>. Pour plus d\u2019informations sur le m\u00eame sujet, d\u00e9couvrez <a href=\"https:\/\/datascientest.com\/power-bi\">notre dossier complet sur Power BI<\/a> et <a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\">notre dossier sur Power Query<\/a>.<\/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-0cbb91a e-flex e-con-boxed e-con\" data-id=\"0cbb91a\" 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-2e6ec00 elementor-widget elementor-widget-html\" data-id=\"2e6ec00\" 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\u2019est-ce que VBA ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Le langage de programmation VBA (Visual Basic for Applications) est directement int\u00e9gr\u00e9 aux outils de la suite Microsoft 365. Il permet de cr\u00e9er facilement des macros, afin d\u2019automatiser les t\u00e2ches les plus r\u00e9p\u00e9titives dans les logiciels comme Excel, Word, Access, PowerPoint et Outlook.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu\u2019est-ce que Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Int\u00e9gr\u00e9 \u00e0 Excel, Power BI et diff\u00e9rents outils de l\u2019\u00e9cosyst\u00e8me Microsoft Power Platform, Power Query permet l\u2019extraction, la transformation et le chargement (ETL) de donn\u00e9es. On l\u2019utilise notamment pour charger, nettoyer et transformer les donn\u00e9es en provenance de diff\u00e9rentes sources. Il peut s\u2019agir de fichiers Excel, CSV, de bases de donn\u00e9es ou encore de services cloud et de pages web.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00c0 quoi sert VBA avec Power Query ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"En utilisant VBA conjointement \u00e0 Power Query, il est possible d\u2019automatiser les t\u00e2ches de transformation de donn\u00e9es dans le but de gagner en efficacit\u00e9. La premi\u00e8re \u00e9tape est de cr\u00e9er une requ\u00eate Power Query, via l\u2019interface utilisateur d\u2019Excel ou l\u2019\u00e9diteur de Power BI. D\u00e8s que la requ\u00eate est cr\u00e9\u00e9e, elle peut \u00eatre enregistr\u00e9e sous forme de macro d\u2019automatisation qu\u2019il est possible de modifier librement. Voici plusieurs exemples de cas d\u2019usage.\"\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\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>VBA et Power Query permettent d\u2019automatiser les t\u00e2ches de transformation de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir sur la cr\u00e9ation de macros ! Afin d\u2019importer et de transformer les donn\u00e9es sur Excel et Power BI, on utilise couramment le moteur Power Query. Cet outil permet de manipuler les [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":194213,"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>VBA et Power Query : Comment \u00e7a fonctionne ? | DataScientest.com<\/title>\n<meta name=\"description\" content=\"VBA et Power Query permettent d\u2019automatiser les t\u00e2ches de transformation de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir sur la cr\u00e9ation de macros !\" \/>\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\/vba-et-power-query-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA et Power Query : Comment \u00e7a fonctionne ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/vba-et-power-query-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-05T18:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:30:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query-vba.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/vba-et-power-query-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/vba-et-power-query-tout-savoir\",\"name\":\"VBA et Power Query : Comment \u00e7a fonctionne ? | DataScientest.com\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-04-05T18:22:00+00:00\",\"dateModified\":\"2023-11-09T13:30:20+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"VBA et Power Query permettent d\u2019automatiser les t\u00e2ches de transformation de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir sur la cr\u00e9ation de macros !\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/vba-et-power-query-tout-savoir\"]}]},{\"@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":"VBA et Power Query : Comment \u00e7a fonctionne ? | DataScientest.com","description":"VBA et Power Query permettent d\u2019automatiser les t\u00e2ches de transformation de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir sur la cr\u00e9ation de macros !","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\/vba-et-power-query-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"VBA et Power Query : Comment \u00e7a fonctionne ?","og_url":"https:\/\/datascientest.com\/vba-et-power-query-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-04-05T18:22:00+00:00","article_modified_time":"2023-11-09T13:30:20+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/power-query-vba.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/vba-et-power-query-tout-savoir","url":"https:\/\/datascientest.com\/vba-et-power-query-tout-savoir","name":"VBA et Power Query : Comment \u00e7a fonctionne ? | DataScientest.com","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-04-05T18:22:00+00:00","dateModified":"2023-11-09T13:30:20+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"VBA et Power Query permettent d\u2019automatiser les t\u00e2ches de transformation de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir sur la cr\u00e9ation de macros !","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/vba-et-power-query-tout-savoir"]}]},{"@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\/194196"}],"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=194196"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/194196\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/194213"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=194196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=194196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=194196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}