{"id":24243,"date":"2025-01-31T01:15:33","date_gmt":"2025-01-31T01:15:33","guid":{"rendered":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/"},"modified":"2025-06-16T12:08:29","modified_gmt":"2025-06-16T12:08:29","slug":"analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi","status":"publish","type":"product","link":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/","title":{"rendered":"AN\u00c1LISIS DE DATOS CON EXCEL: POWER QUERY, POWER PIVOT Y POWER BI"},"content":{"rendered":"<p>1. REALIZACI\u00d3N DE TABLAS<\/p>\n<p>  2. AN\u00c1LISIS Y REALIZACI\u00d3N DE TABLAS Y GR\u00c1FICOS DIN\u00c1MICOS<br \/>\n  2.1 Crear una tabla din\u00e1mica para analizar datos<br \/>\n  -2.2 Dar formato a una tabla din\u00e1mica<br \/>\n  2.3 Crear gr\u00e1ficos din\u00e1micos para presentar de forma gr\u00e1fica los datos de una tabla din\u00e1mica<\/p>\n<p>  3. APRENDIZAJE DEL USO DE POWER QUERY. OBTENCI\u00d3N Y TRANSFORMACI\u00d3N DE DATOS<br \/>\n  3.1 Conectar diferentes fuentes de datos<br \/>\n  3.2 Transformar datos<br \/>\n  3.3 Combinar datos de diferentes or\u00edgenes<br \/>\n  3.4 Cargar la consulta de Excel<\/p>\n<p>  4. APRENDIZAJE DEL USO DE POWER PIVOT. MODELADO DE DATOS Y AN\u00c1LISIS<br \/>\n  4.1 Crear relaciones entre tablas<br \/>\n  4.2 Utilizar el lenguaje DAX para crear expresiones de an\u00e1lisis de datos<br \/>\n  4.3 Crear indicadores clave de rendimiento (KPI)<br \/>\n  4.4 Crear perspectivas para la navegaci\u00f3n por conjuntos de datos<br \/>\n  4.5 Organizar campos de jerarqu\u00edas<\/p>\n<p>  5. APRENDIZAJE DEL USO DE POWER BI<br \/>\n  5.1 Creaci\u00f3n de informes y paneles interactivos<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Importar datos de diferentes fuentes de datos externas (ficheros CSV, Excel, Access, \u2026) para explorarlos y visualizarlos en tablas din\u00e1micas, gr\u00e1ficos din\u00e1micos y Power BI.<\/p>\n","protected":false},"featured_media":24101,"template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":""},"product_brand":[],"product_cat":[48],"product_tag":[],"class_list":["post-24243","product","type-product","status-publish","has-post-thumbnail","product_cat-informatica-y-comunicaciones","first","instock","virtual","taxable","purchasable","product-type-simple"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>AN\u00c1LISIS DE DATOS CON EXCEL: POWER QUERY, POWER PIVOT Y POWER BI -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AN\u00c1LISIS DE DATOS CON EXCEL: POWER QUERY, POWER PIVOT Y POWER BI -\" \/>\n<meta property=\"og:description\" content=\"Importar datos de diferentes fuentes de datos externas (ficheros CSV, Excel, Access, \u2026) para explorarlos y visualizarlos en tablas din\u00e1micas, gr\u00e1ficos din\u00e1micos y Power BI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Formaliser\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-16T12:08:29+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\\\/\",\"url\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\\\/\",\"name\":\"AN\u00c1LISIS DE DATOS CON EXCEL: POWER QUERY, POWER PIVOT Y POWER BI -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/INFORMATICA.png\",\"datePublished\":\"2025-01-31T01:15:33+00:00\",\"dateModified\":\"2025-06-16T12:08:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/INFORMATICA.png\",\"contentUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/INFORMATICA.png\",\"width\":587,\"height\":506},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/abexis.es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cursos\",\"item\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/cursos-online-profesionales-y-subvencionados\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"AN\u00c1LISIS DE DATOS CON EXCEL: POWER QUERY, POWER PIVOT Y POWER BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#website\",\"url\":\"https:\\\/\\\/abexis.es\\\/\",\"name\":\"Formaliser\",\"description\":\"Formaci\u00f3n\",\"publisher\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/abexis.es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#organization\",\"name\":\"Formaliser\",\"url\":\"https:\\\/\\\/abexis.es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/cropped-LOGO-web.png\",\"contentUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/cropped-LOGO-web.png\",\"width\":1000,\"height\":295,\"caption\":\"Formaliser\"},\"image\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AN\u00c1LISIS DE DATOS CON EXCEL: POWER QUERY, POWER PIVOT Y POWER BI -","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:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/","og_locale":"es_ES","og_type":"article","og_title":"AN\u00c1LISIS DE DATOS CON EXCEL: POWER QUERY, POWER PIVOT Y POWER BI -","og_description":"Importar datos de diferentes fuentes de datos externas (ficheros CSV, Excel, Access, \u2026) para explorarlos y visualizarlos en tablas din\u00e1micas, gr\u00e1ficos din\u00e1micos y Power BI.","og_url":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/","og_site_name":"Formaliser","article_modified_time":"2025-06-16T12:08:29+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/","url":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/","name":"AN\u00c1LISIS DE DATOS CON EXCEL: POWER QUERY, POWER PIVOT Y POWER BI -","isPartOf":{"@id":"https:\/\/abexis.es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/INFORMATICA.png","datePublished":"2025-01-31T01:15:33+00:00","dateModified":"2025-06-16T12:08:29+00:00","breadcrumb":{"@id":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/#primaryimage","url":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/INFORMATICA.png","contentUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/INFORMATICA.png","width":587,"height":506},{"@type":"BreadcrumbList","@id":"https:\/\/abexis.es\/index.php\/product\/analisis-de-datos-con-excel-power-query-power-pivot-y-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/abexis.es\/"},{"@type":"ListItem","position":2,"name":"Cursos","item":"https:\/\/abexis.es\/index.php\/cursos-online-profesionales-y-subvencionados\/"},{"@type":"ListItem","position":3,"name":"AN\u00c1LISIS DE DATOS CON EXCEL: POWER QUERY, POWER PIVOT Y POWER BI"}]},{"@type":"WebSite","@id":"https:\/\/abexis.es\/#website","url":"https:\/\/abexis.es\/","name":"Formaliser","description":"Formaci\u00f3n","publisher":{"@id":"https:\/\/abexis.es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/abexis.es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/abexis.es\/#organization","name":"Formaliser","url":"https:\/\/abexis.es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abexis.es\/#\/schema\/logo\/image\/","url":"https:\/\/abexis.es\/wp-content\/uploads\/2024\/12\/cropped-LOGO-web.png","contentUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2024\/12\/cropped-LOGO-web.png","width":1000,"height":295,"caption":"Formaliser"},"image":{"@id":"https:\/\/abexis.es\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product\/24243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/media\/24101"}],"wp:attachment":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/media?parent=24243"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_brand?post=24243"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_cat?post=24243"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_tag?post=24243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}