{"id":61218,"date":"2025-10-07T10:45:23","date_gmt":"2025-10-07T10:45:23","guid":{"rendered":"https:\/\/www.apen.es\/?post_type=curso-formacion&#038;p=61218"},"modified":"2026-03-31T10:22:46","modified_gmt":"2026-03-31T10:22:46","slug":"power-query","status":"publish","type":"curso-formacion","link":"https:\/\/www.apen.es\/en\/curso-formacion\/power-query\/","title":{"rendered":"Power Query Level I"},"content":{"rendered":"<h2 class=\"wp-block-heading\"><strong>Who is it aimed at?<\/strong><\/h2>\n\n\n\n<p><br>The course of <em>Power BI <\/em>It is aimed at all professionals who need to analyze large amounts of data in real time to help in decision making, with the goal of improving processes based on the analysis of accurate information.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What will you learn?<\/strong><\/h2>\n\n\n\n<p>At the end of the training, participants will have a solid understanding of the fundamentals of Power BI and will be able to perform basic data analysis using DAX language calculations and visual calculations.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Share with other users.<\/li>\n\n\n\n<li>Design data structures from queries.<\/li>\n\n\n\n<li>Understanding and working with DAX.<\/li>\n\n\n\n<li>Create calculated fields.<\/li>\n\n\n\n<li>Create and use KPIs.<\/li>\n\n\n\n<li>Knowing and using different types of graphs.<\/li>\n\n\n\n<li>Customize views, filter and interrelate views.<\/li>\n\n\n\n<li>Understanding and working with reports and dashboards.<\/li>\n<\/ul>\n\n\n\n<p><\/p>","protected":false},"featured_media":62498,"parent":0,"menu_order":6,"template":"","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"modalidad":[953],"software":[979],"convocatoria":[966],"bonificable":[972],"class_list":["post-61218","curso-formacion","type-curso-formacion","status-publish","has-post-thumbnail","hentry","modalidad-curso","software-business-intelligence","convocatoria-abierta","bonificable-parcial"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Power Query nivel I - Apen Inform\u00e1tica<\/title>\n<meta name=\"description\" content=\"\u00bfA qui\u00e9n va dirigido? El curso de Power BI est\u00e1 dirigido a todos los profesionales que necesitan analizar gran cantidad de datos en tiempo real para la\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.apen.es\/en\/training-course\/power-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query nivel I - Apen Inform\u00e1tica\" \/>\n<meta property=\"og:description\" content=\"\u00bfA qui\u00e9n va dirigido? El curso de Power BI est\u00e1 dirigido a todos los profesionales que necesitan analizar gran cantidad de datos en tiempo real para la\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.apen.es\/en\/training-course\/power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Apen Inform\u00e1tica\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/apensolucions\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-31T10:22:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.apen.es\/wp-content\/uploads\/2025\/10\/imatges-cursos-microsoft.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"860\" \/>\n\t<meta property=\"og:image:height\" content=\"216\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/power-query\\\/\",\"url\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/power-query\\\/\",\"name\":\"Power Query nivel I - Apen Inform\u00e1tica\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/power-query\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/power-query\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/imatges-cursos-microsoft.jpg\",\"datePublished\":\"2025-10-07T10:45:23+00:00\",\"dateModified\":\"2026-03-31T10:22:46+00:00\",\"description\":\"\u00bfA qui\u00e9n va dirigido? El curso de Power BI est\u00e1 dirigido a todos los profesionales que necesitan analizar gran cantidad de datos en tiempo real para la\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/power-query\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/power-query\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/power-query\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/imatges-cursos-microsoft.jpg\",\"contentUrl\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/imatges-cursos-microsoft.jpg\",\"width\":860,\"height\":216},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/curso-formacion\\\/power-query\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/www.apen.es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Query nivel I\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/#website\",\"url\":\"https:\\\/\\\/www.apen.es\\\/\",\"name\":\"Apen Inform\u00e1tica\",\"description\":\"Mantenimiento Inform\u00e1tico , Software de Gesti\u00f3n, Soluciones de impresi\u00f3n\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.apen.es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/#organization\",\"name\":\"Apen: Soluciones inform\u00e1ticas\",\"url\":\"https:\\\/\\\/www.apen.es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apen.es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/logo-apenok-231x82-1.png\",\"contentUrl\":\"https:\\\/\\\/www.apen.es\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/logo-apenok-231x82-1.png\",\"width\":231,\"height\":82,\"caption\":\"Apen: Soluciones inform\u00e1ticas\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apen.es\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/apensolucions\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/ApenCentreInformatic\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1021771?trk=tyah&trkInfo=clickedVerticalcompanyclickedEntityId1021771idx2-1-2tarId1464195271196tasapenin\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power Query Level I - Apen Informatics","description":"Who is it for? The Power BI course is aimed at all professionals who need to analyze large amounts of data in real time for the","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:\/\/www.apen.es\/en\/training-course\/power-query\/","og_locale":"en_US","og_type":"article","og_title":"Power Query nivel I - Apen Inform\u00e1tica","og_description":"\u00bfA qui\u00e9n va dirigido? El curso de Power BI est\u00e1 dirigido a todos los profesionales que necesitan analizar gran cantidad de datos en tiempo real para la","og_url":"https:\/\/www.apen.es\/en\/training-course\/power-query\/","og_site_name":"Apen Inform\u00e1tica","article_publisher":"https:\/\/www.facebook.com\/apensolucions","article_modified_time":"2026-03-31T10:22:46+00:00","og_image":[{"width":860,"height":216,"url":"https:\/\/www.apen.es\/wp-content\/uploads\/2025\/10\/imatges-cursos-microsoft.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.apen.es\/curso-formacion\/power-query\/","url":"https:\/\/www.apen.es\/curso-formacion\/power-query\/","name":"Power Query Level I - Apen Informatics","isPartOf":{"@id":"https:\/\/www.apen.es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.apen.es\/curso-formacion\/power-query\/#primaryimage"},"image":{"@id":"https:\/\/www.apen.es\/curso-formacion\/power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.apen.es\/wp-content\/uploads\/2025\/10\/imatges-cursos-microsoft.jpg","datePublished":"2025-10-07T10:45:23+00:00","dateModified":"2026-03-31T10:22:46+00:00","description":"Who is it for? The Power BI course is aimed at all professionals who need to analyze large amounts of data in real time for the","breadcrumb":{"@id":"https:\/\/www.apen.es\/curso-formacion\/power-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.apen.es\/curso-formacion\/power-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apen.es\/curso-formacion\/power-query\/#primaryimage","url":"https:\/\/www.apen.es\/wp-content\/uploads\/2025\/10\/imatges-cursos-microsoft.jpg","contentUrl":"https:\/\/www.apen.es\/wp-content\/uploads\/2025\/10\/imatges-cursos-microsoft.jpg","width":860,"height":216},{"@type":"BreadcrumbList","@id":"https:\/\/www.apen.es\/curso-formacion\/power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.apen.es\/"},{"@type":"ListItem","position":2,"name":"Power Query nivel I"}]},{"@type":"WebSite","@id":"https:\/\/www.apen.es\/#website","url":"https:\/\/www.apen.es\/","name":"Apen Inform\u00e1tica","description":"IT Maintenance, Management Software, Printing Solutions","publisher":{"@id":"https:\/\/www.apen.es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.apen.es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.apen.es\/#organization","name":"Apen: IT Solutions","url":"https:\/\/www.apen.es\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apen.es\/#\/schema\/logo\/image\/","url":"https:\/\/www.apen.es\/wp-content\/uploads\/2022\/08\/logo-apenok-231x82-1.png","contentUrl":"https:\/\/www.apen.es\/wp-content\/uploads\/2022\/08\/logo-apenok-231x82-1.png","width":231,"height":82,"caption":"Apen: Soluciones inform\u00e1ticas"},"image":{"@id":"https:\/\/www.apen.es\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/apensolucions","https:\/\/www.youtube.com\/user\/ApenCentreInformatic","https:\/\/www.linkedin.com\/company\/1021771?trk=tyah&trkInfo=clickedVerticalcompanyclickedEntityId1021771idx2-1-2tarId1464195271196tasapenin"]}]}},"taxonomy_info":{"modalidad":[{"value":953,"label":"Curso"}],"software":[{"value":979,"label":"Business Intelligence"}],"convocatoria":[{"value":966,"label":"Abierta"}],"bonificable":[{"value":972,"label":"Parcial"}]},"featured_image_src_large":["https:\/\/www.apen.es\/wp-content\/uploads\/2025\/10\/imatges-cursos-microsoft.jpg",860,216,false],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/curso-formacion\/61218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/curso-formacion"}],"about":[{"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/types\/curso-formacion"}],"version-history":[{"count":5,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/curso-formacion\/61218\/revisions"}],"predecessor-version":[{"id":63325,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/curso-formacion\/61218\/revisions\/63325"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/media\/62498"}],"wp:attachment":[{"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/media?parent=61218"}],"wp:term":[{"taxonomy":"modalidad","embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/modalidad?post=61218"},{"taxonomy":"software","embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/software?post=61218"},{"taxonomy":"convocatoria","embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/convocatoria?post=61218"},{"taxonomy":"bonificable","embeddable":true,"href":"https:\/\/www.apen.es\/en\/wp-json\/wp\/v2\/bonificable?post=61218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}