{"id":77266,"date":"2023-02-08T15:37:19","date_gmt":"2023-02-08T20:37:19","guid":{"rendered":"https:\/\/acadevor.com\/simulacion-reunion-power-bi-copy\/"},"modified":"2023-02-09T00:22:38","modified_gmt":"2023-02-09T05:22:38","slug":"master-class-power-query","status":"publish","type":"post","link":"https:\/\/acadevor.com\/master-class-power-query\/","title":{"rendered":"Master Class: C\u00f3mo Automatizar la Preparaci\u00f3n de tus Datos en Excel con Power Query"},"content":{"rendered":"<!--presto-player:video_id=18--><figure class=\"wp-block-video presto-block-video  presto-provider-vimeo\" style=\"--plyr-color-main: var(--presto-player-highlight-color, #3856f9); --plyr-captions-background: #000000; --presto-player-logo-width: 45px; \">\n    <presto-player  id=\"presto-player-1\" src=\"https:\/\/vimeo.com\/797230771\" media-title=\"https:\/\/vimeo.com\/797230771\" css=\"\" class=\"presto-video-id-18 presto-preset-id-5 skin-stacked caption-style-default\" skin=\"stacked\" icon-url=\"https:\/\/acadevor.com\/wp-content\/plugins\/presto-player\/img\/sprite.svg\" preload=\"\" poster=\"\" playsinline  >\n        \n\n    <div class=\"presto-iframe-fallback-container\">\n        <iframe style=\"width: 100%\" title=\"Vimeo Video\" class=\"presto-fallback-iframe\" id=\"presto-iframe-fallback-1\" data-src=\"https:\/\/player.vimeo.com\/video\/797230771?loop=false&amp;byline=false&amp;portrait=false&amp;title=false&amp;speed=true&amp;transparent=0&amp;gesture=media\" allowfullscreen allowtransparency allow=\"autoplay\"><\/iframe>\n    <\/div>\n    <\/presto-player>\n<\/figure>        <script>\n            var player = document.querySelector('presto-player#presto-player-1');\n            player.video_id = 18;\n                                                player.preset = {\"id\":5,\"name\":\"Acadevor Preset\",\"slug\":\"acadevor-preset\",\"icon\":\"\",\"skin\":\"stacked\",\"play-large\":true,\"rewind\":true,\"play\":true,\"fast-forward\":true,\"progress\":true,\"current-time\":true,\"mute\":true,\"volume\":true,\"speed\":true,\"pip\":true,\"fullscreen\":true,\"auto_hide\":true,\"save_player_position\":true,\"sticky_scroll\":true,\"hide_youtube\":true,\"lazy_load_youtube\":true,\"hide_logo\":true,\"border_radius\":0,\"caption_style\":\"default\",\"caption_background\":\"#000000\",\"is_locked\":false,\"created_by\":36471,\"created_at\":\"2021-03-23 11:20:13\",\"updated_at\":\"2023-07-27 10:27:33\",\"deleted_at\":\"\",\"reset_on_end\":false,\"email_collection\":{\"enabled\":false,\"behavior\":\"pause\",\"percentage\":0,\"allow_skip\":false,\"provider\":\"\",\"provider_list\":\"\",\"provider_tag\":\"\",\"border_radius\":0,\"headline\":\"\",\"bottom_text\":\"\",\"button_text\":\"\",\"button_color\":null,\"button_text_color\":null},\"action_bar\":{\"enabled\":false,\"percentage_start\":0,\"text\":\"\",\"background_color\":\"\",\"button_type\":\"none\",\"button_count\":false,\"button_text\":\"\",\"button_radius\":0,\"button_color\":\"\",\"button_text_color\":\"\",\"button_link\":{\"id\":\"\",\"url\":\"\",\"type\":\"\",\"opensInNewTab\":false}},\"captions_enabled\":false,\"sticky_scroll_position\":\"\",\"cta\":{\"enabled\":false,\"percentage\":100,\"show_rewatch\":true,\"show_skip\":true,\"headline\":\"\",\"bottom_text\":\"\",\"show_button\":true,\"button_text\":\"\",\"button_color\":\"\",\"button_text_color\":\"\",\"background_opacity\":0,\"button_link\":{\"id\":\"\",\"url\":\"\",\"type\":\"\",\"opensInNewTab\":false},\"button_radius\":0},\"captions\":false,\"play_video_viewport\":false,\"watermark\":{\"enabled\":false,\"text\":\"\",\"backgroundColor\":\"\",\"color\":\"\",\"opacity\":0,\"position\":\"\"},\"on_video_end\":\"\",\"search\":{\"enabled\":false,\"minMatchCharLength\":1,\"threshold\":0.3,\"placeholder\":\"Search\"},\"show_time_elapsed\":false};\n                                                                player.chapters = [];\n                                                                player.overlays = [];\n                                                                player.tracks = [];\n                                                                player.branding = {\"logo\":\"\",\"color\":\"#3856f9\",\"logo_width\":45};\n                                                                player.blockAttributes = {\"id\":18,\"src\":\"https:\\\/\\\/vimeo.com\\\/797230771\",\"preset\":5,\"video_id\":\"797230771\",\"visibility\":\"public\",\"color\":\"#00b3ff\",\"mutedPreview\":{\"enabled\":false,\"captions\":false},\"mutedOverlay\":{\"enabled\":false,\"src\":\"\",\"width\":200,\"focalPoint\":{\"x\":0.5,\"y\":0.5}},\"mutedOverlayType\":\"text\",\"mutedOverlayText\":\"Click to play\",\"mutedOverlayImageWidth\":200,\"playsInline\":true,\"chapters\":[],\"overlays\":[],\"tracks\":[],\"title\":\"https:\\\/\\\/vimeo.com\\\/797230771\"};\n                                                                                            player.skin = \"stacked\";\n                                                                player.analytics = true;\n                                                                player.automations = true;\n                                                                player.provider = \"vimeo\";\n                                                                                                                                                                                player.youtube = {\"noCookie\":false,\"channelId\":\"\",\"show_count\":false};\n                                    <\/script>\n        \n\n\n<p><\/p>\n\n\n\n<p><strong>\u00bfQu\u00e9 ver\u00e1s en la clase?<\/strong><\/p>\n\n\n\n<p>Miguel prepar\u00f3 5 casos pr\u00e1cticos para mostrarte todo el potencial de Power Query:<\/p>\n\n\n\n<p>\u2705<strong> Caso Pr\u00e1ctico 1<\/strong>: C\u00f3mo enriquecer una tabla con datos de otras tablas.<\/p>\n\n\n\n<p>\u2705 <strong>Caso Pr\u00e1ctico 2<\/strong>: C\u00f3mo reemplazar BUSCARV para siempre gracias a la herramienta &#8220;Combinar consultas&#8221;.<\/p>\n\n\n\n<p>\u2705 <strong>Caso Pr\u00e1ctico 3<\/strong>: C\u00f3mo limpiar un extracto bancario con Power Query y las ventajas frente a hacerlo con Macros.<\/p>\n\n\n\n<p>\u2705 <strong>Caso pr\u00e1ctico 4<\/strong>: C\u00f3mo preparar tablas normalizadas que sean analizables con Tablas Din\u00e1micas.<\/p>\n\n\n\n<p>\u2705 <strong>Caso pr\u00e1ctico 5<\/strong>: C\u00f3mo consolidar varios archivos que se encuentran en una carpeta.<\/p>\n\n\n\n<p>Adem\u00e1s hacia el final de la clase Miguel te cuenta la diferencia entre usar Macros y usar Power Query.<\/p>\n\n\n\n<p>El objetivo del <strong><a href=\"https:\/\/acadevor.com\/cursos\/power-query-excel\/?coupon=xl2feb23\">Curso de Preparaci\u00f3n de Datos en Excel con Power Query<\/a>  <\/strong>es que ahorres mucho tiempo en tu trabajo diario aprendiendo esta herramienta que te ayudar\u00e1 a importar, limpiar y consolidar tus<strong> <\/strong>datos de forma automatizada. \ud83d\udc49 <a href=\"https:\/\/acadevor.com\/cursos\/power-query-excel\/?coupon=xl2feb23\"><strong>m\u00e1s info del curso<\/strong><\/a>.<\/p>\n\n\n\n<p>Este curso est\u00e1 incluido en nuestra<strong> <a href=\"https:\/\/acadevor.com\/registro\/pro\/\">membres\u00eda<\/a><\/strong> (que incluye acceso total a todos nuestros cursos, soporte personalizado de expertos en menos de 48 hs h\u00e1biles, una comunidad para ampliar tu red, plantillas y workshops en vivo).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfQu\u00e9 ver\u00e1s en la clase? Miguel prepar\u00f3 5 casos pr\u00e1cticos para mostrarte todo el potencial de Power Query: \u2705 Caso Pr\u00e1ctico 1: C\u00f3mo enriquecer una&hellip;<\/p>\n","protected":false},"author":25,"featured_media":77276,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[266],"tags":[],"acf":{"test-framer":"test-framer-valor"},"_links":{"self":[{"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/posts\/77266"}],"collection":[{"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/comments?post=77266"}],"version-history":[{"count":0,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/posts\/77266\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/media\/77276"}],"wp:attachment":[{"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/media?parent=77266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/categories?post=77266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/tags?post=77266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}