{"id":7085,"date":"2020-08-31T16:27:52","date_gmt":"2020-08-31T15:27:52","guid":{"rendered":"https:\/\/acadevor.com\/blog\/mini-curso-gratis-power-bi-tkp-copy\/"},"modified":"2021-05-07T05:57:17","modified_gmt":"2021-05-07T10:57:17","slug":"mini-curso-analisis-avanzados-en-excel","status":"publish","type":"post","link":"https:\/\/acadevor.com\/mini-curso-analisis-avanzados-en-excel\/","title":{"rendered":"Mini Curso An\u00e1lisis Avanzados en Excel"},"content":{"rendered":"\n<div class=\"wp-block-presto-player-reusable-edit\"><!--presto-player:video_id=11--><figure class=\"wp-block-video presto-block-video aligncenter 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\/454172460\" media-title=\"https:\/\/vimeo.com\/454172460\" css=\"\" class=\"presto-video-id-11 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=\"https:\/\/acadevor.com\/wp-content\/uploads\/2021\/05\/MiniCursoNHE_OG.png\" 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\/454172460?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 = 11;\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 = [{\"time\":\"0:00\",\"title\":\"Intro y qu\\u00e9 aprender\\u00e1s\"},{\"time\":\"1:24\",\"title\":\"Clase 1: Consolidando M\\u00faltiples Archivos con Power Query\"},{\"time\":\"13:02\",\"title\":\"Clase 2: Creaci\\u00f3n de un Reporte con Tablas y Gr\\u00e1ficos Din\\u00e1micos\"},{\"time\":\"24:40\",\"title\":\"Clase 3: Automatizando el Env\\u00edo del Reporte con una Macro\"},{\"time\":\"38:45\",\"title\":\"Clase 4: Trabajo Colaborativo con One Drive y Excel Online\"},{\"time\":\"48:01\",\"title\":\"Clase 5: Utilizando Modelos de Power Pivot en Power BI\"},{\"time\":\"58:34\",\"title\":\"Clase 6: Seguimiento de Objetivos de Ventas con Power Pivot y DAX\"}];\n                                                                player.overlays = [];\n                                                                player.tracks = [];\n                                                                player.branding = {\"logo\":\"\",\"color\":\"#3856f9\",\"logo_width\":45};\n                                                                player.blockAttributes = {\"id\":11,\"src\":\"https:\\\/\\\/vimeo.com\\\/454172460\",\"poster\":\"https:\\\/\\\/acadevor.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/MiniCursoNHE_OG.png\",\"preset\":5,\"chapters\":[{\"time\":\"0:00\",\"title\":\"Intro y qu\\u00e9 aprender\\u00e1s\"},{\"time\":\"1:24\",\"title\":\"Clase 1: Consolidando M\\u00faltiples Archivos con Power Query\"},{\"time\":\"13:02\",\"title\":\"Clase 2: Creaci\\u00f3n de un Reporte con Tablas y Gr\\u00e1ficos Din\\u00e1micos\"},{\"time\":\"24:40\",\"title\":\"Clase 3: Automatizando el Env\\u00edo del Reporte con una Macro\"},{\"time\":\"38:45\",\"title\":\"Clase 4: Trabajo Colaborativo con One Drive y Excel Online\"},{\"time\":\"48:01\",\"title\":\"Clase 5: Utilizando Modelos de Power Pivot en Power BI\"},{\"time\":\"58:34\",\"title\":\"Clase 6: Seguimiento de Objetivos de Ventas con Power Pivot y DAX\"}],\"video_id\":\"454172460\",\"align\":\"center\",\"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,\"overlays\":[],\"tracks\":[],\"title\":\"https:\\\/\\\/vimeo.com\\\/454172460\"};\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                <script type=\"application\/ld+json\">\n            {\"@context\":\"https:\\\/\\\/schema.org\",\"@type\":\"VideoObject\",\"name\":\"https:\\\/\\\/vimeo.com\\\/454172460\",\"thumbnailUrl\":\"https:\\\/\\\/acadevor.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/MiniCursoNHE_OG.png\",\"uploadDate\":\"2021-05-02T23:03:21-05:00\",\"contentUrl\":\"https:\\\/\\\/vimeo.com\\\/454172460\"}        <\/script>\n        <\/div>\n\n\n\n\n<p>En este mini curso aprender\u00e1s a combinar Power Query, Tablas Din\u00e1micas, Gr\u00e1ficos Din\u00e1micos, Power Pivot, funciones DAX, Macros, Excel Online y Power BI&nbsp;<strong>desarrollando&nbsp;un&nbsp;caso pr\u00e1ctico<\/strong>&nbsp;que&nbsp;consiste en&nbsp;crear los reportes para hacer seguimiento de los objetivos de una empresa.<\/p>\n\n\n\n<p>\ud83d\uddc2 Descarga los archivos de este curso&nbsp;<strong><a href=\"https:\/\/acadevor.com\/wp-content\/uploads\/2021\/05\/Mini-Curso-Analisis-Avanzados-en-Excel.zip\">haciendo click aqu\u00ed<\/a><\/strong>.<\/p>\n\n\n\n<p>Recursos mencionados en el video:<\/p>\n\n\n\n<ul><li><strong><a href=\"https:\/\/acadevor.com\/como-crear-una-cuenta-gratuita-en-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">C\u00f3mo crear una cuenta en Power BI<\/a><\/strong><\/li><\/ul>\n\n\n\n<p>Este mini curso es una introducci\u00f3n a todo el contenido que ense\u00f1amos en el <strong><a href=\"https:\/\/acadevor.com\/p\/curso-excel-nivel-3\/\">Curso de Business Intelligence en Excel con Power Pivot y Funciones DAX<\/a><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>En este mini curso aprender\u00e1s a combinar Power Query, Tablas Din\u00e1micas, Gr\u00e1ficos Din\u00e1micos, Power Pivot, funciones DAX, Macros, Excel Online y Power BI&nbsp;desarrollando&nbsp;un&nbsp;caso pr\u00e1ctico&nbsp;que&nbsp;consiste en&nbsp;crear&hellip;<\/p>\n","protected":false},"author":10,"featured_media":20450,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[29],"tags":[117],"acf":{"test-framer":"test-framer-valor"},"_links":{"self":[{"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/posts\/7085"}],"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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/comments?post=7085"}],"version-history":[{"count":0,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/posts\/7085\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/media\/20450"}],"wp:attachment":[{"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/media?parent=7085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/categories?post=7085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/acadevor.com\/wp-json\/wp\/v2\/tags?post=7085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}