{"id":2894,"date":"2023-03-23T16:02:07","date_gmt":"2023-03-23T15:02:07","guid":{"rendered":"https:\/\/edubeliso.eu\/sk\/?page_id=2894"},"modified":"2023-03-23T16:46:22","modified_gmt":"2023-03-23T15:46:22","slug":"power-query","status":"publish","type":"page","link":"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-query\/","title":{"rendered":"Power Query"},"content":{"rendered":"\n<p>Power Query je s\u00fa\u010das\u0165ou bal\u00edka n\u00e1strojov Microsoft Excel, ktor\u00fd umo\u017e\u0148uje \u013eu\u010fom vytv\u00e1ra\u0165, upravova\u0165 a analyzova\u0165 d\u00e1ta z r\u00f4znych zdrojov. Power Query umo\u017e\u0148uje pou\u017e\u00edvate\u013eom importova\u0165 d\u00e1ta z r\u00f4znych zdrojov, vr\u00e1tane datab\u00e1z, s\u00faborov CSV, Excelov\u00fdch tabuliek, webov\u00fdch str\u00e1nok a mnoh\u00fdch \u010fal\u0161\u00edch.<\/p>\n\n\n\n<p>Power Query tie\u017e poskytuje funkcie na \u010distenie, transformovanie a modelovanie d\u00e1t, ktor\u00e9 umo\u017e\u0148uj\u00fa pou\u017e\u00edvate\u013eom z\u00edskava\u0165 u\u017eito\u010dn\u00e9 inform\u00e1cie z ve\u013ek\u00e9ho mno\u017estva d\u00e1t. Napr\u00edklad m\u00f4\u017eu sa odstr\u00e1ni\u0165 duplik\u00e1ty, premenova\u0165 st\u013apce, zmeni\u0165 poradie st\u013apcov, odstr\u00e1ni\u0165 riadky s ch\u00fdbaj\u00facimi d\u00e1tami a \u010fal\u0161ie.<\/p>\n\n\n\n<p>Power Query sa tie\u017e integruje s \u010fal\u0161\u00edmi n\u00e1strojmi v r\u00e1mci bal\u00edka Microsoft Excel, ako je napr\u00edklad Power Pivot, ktor\u00fd umo\u017e\u0148uje pou\u017e\u00edvate\u013eom vytv\u00e1ra\u0165 zlo\u017eit\u00e9 modely d\u00e1t a&nbsp;tie\u017e je integrovan\u00fd v&nbsp;programe Power BI, ktor\u00fd sl\u00fa\u017ei najm\u00e4 na vizualiz\u00e1ciu d\u00e1t. Power Query tie\u017e poskytuje funkcie na aktualiz\u00e1ciu d\u00e1t, ktor\u00e9 umo\u017e\u0148uj\u00fa pou\u017e\u00edvate\u013eom aktualizova\u0165 svoje anal\u00fdzy d\u00e1t pomocou najnov\u0161\u00edch inform\u00e1ci\u00ed. Pr\u00e1ca v&nbsp;tomto programe do zna\u010dnej miery pripom\u00edna aj pr\u00e1cu v&nbsp;programe Access.<\/p>\n\n\n\n<p>\u0160kolenie Power Query trv\u00e1 jeden de\u0148, respekt\u00edve 5 hod\u00edn a&nbsp;je vhodn\u00e9 pre u\u017e\u00edvate\u013eov, ktor\u00ed nemaj\u00fa predo\u0161l\u00e9 sk\u00fasenosti s&nbsp;Power Query. Pred absolvovan\u00edm \u0161kolenia je nevyhnutn\u00e9 dosahova\u0165 znalosti Excelu aspo\u0148 na \u00farovni Excel level 3 \u2013 stredne pokro\u010dil\u00fd. Ak\u00e9ko\u013evek sk\u00fasenosti s&nbsp;datab\u00e1zami s\u00fa pr\u00ednosn\u00e9.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Osnovy<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u00davod<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Uvedenie do problematiky<\/li>\n\n\n\n<li>Predstavenie programu Power Query v&nbsp;programe Excel<\/li>\n\n\n\n<li>Porovnanie Power Query v&nbsp;programe Excel a&nbsp;Power BI<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Z\u00edskanie d\u00e1t<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vysvetlenie \u010do je to Dotaz (Query)<\/li>\n\n\n\n<li>Z\u00edskavanie d\u00e1t z&nbsp;r\u00f4znych zdrojov (Excel, CSV, Access datab\u00e1za, webov\u00e1 str\u00e1nka)<\/li>\n\n\n\n<li>Aktualiz\u00e1cia z\u00edskan\u00fdch d\u00e1t<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u010cistenie d\u00e1t<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0160tatistika st\u013apca a&nbsp;vlastnosti st\u013apca<\/li>\n\n\n\n<li>Vysvetlenie d\u00e1tov\u00fdch typov (text, \u010d\u00edslo, d\u00e1tum, true\/false a&nbsp;pod.)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Z\u00e1kladn\u00e1 transform\u00e1cia d\u00e1t<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vysvetlenie krokov v&nbsp;r\u00e1mci dotazov<\/li>\n\n\n\n<li>Prid\u00e1vanie a&nbsp;odstra\u0148ovanie st\u013apcov<\/li>\n\n\n\n<li>Odstra\u0148ovanie riadkov<\/li>\n\n\n\n<li>Nastavenie hlavi\u010dky tabu\u013eky (men\u00e1 st\u013apcov, posunutie prv\u00e9ho riadku do hlavi\u010dky)<\/li>\n\n\n\n<li>Filtrovanie<\/li>\n\n\n\n<li>Zru\u0161enie kontingen\u010dnosti st\u013apcov, vytvorenie \u201ekontingen\u010dnej\u201c tabu\u013eky<\/li>\n\n\n\n<li>Vyplnenie d\u00e1t<\/li>\n\n\n\n<li>Z\u00e1kladn\u00e9 matematick\u00e9 oper\u00e1cie<\/li>\n\n\n\n<li>Podmienen\u00fd st\u013apec (obdoba IF funkcie)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Pokro\u010dil\u00e1 transform\u00e1cia d\u00e1t<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Uvedenie do editora jazyka Power Query M<\/li>\n\n\n\n<li>Identifik\u00e1cia a&nbsp;vytvorenie vhodn\u00e9ho kl\u00fa\u010da pre vz\u0165ahy<\/li>\n\n\n\n<li>Kombina\u010dn\u00e9 dotazy \u2013 pripojenie (spojenie rovnak\u00fdch tabuliek do jednej \u2013 APPEND)<\/li>\n\n\n\n<li>Kombina\u010dn\u00e9 dotazy \u2013 zl\u00fa\u010denie (obdoba VLOOKUP z&nbsp;Excelu \u2013 MERGE)<\/li>\n\n\n\n<li>Duplikovanie dotazov\/vytvorenie odkazu<\/li>\n\n\n\n<li>Nahr\u00e1dzanie hodn\u00f4t a&nbsp;ch\u00fdb (odstra\u0148ovanie nekonzistentn\u00fdch z\u00e1pisov)<\/li>\n\n\n\n<li>Rozdelenie st\u013apca na viac st\u013apcov pomocou rozde\u013eova\u010dov alebo po\u010dtu znakov<\/li>\n\n\n\n<li>Extrahovanie textu<\/li>\n\n\n\n<li>Pr\u00e1ca s&nbsp;d\u00e1tumom<\/li>\n\n\n\n<li>Transform\u00e1cia nevhodne form\u00e1tovan\u00e9ho d\u00e1tumu<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Na\u010d\u00edtanie \u00fadajov<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Na\u010d\u00edtanie \u00fadajov do tabu\u013eky\/kontingen\u010dnej tabu\u013eky<\/li>\n\n\n\n<li>Na\u010d\u00edtanie \u00fadajov ako pripojenie<\/li>\n\n\n\n<li>Odstra\u0148ovanie dotazov<\/li>\n\n\n\n<li>Ulo\u017eenie pr\u00e1ce<\/li>\n<\/ul>\n\n\n<div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-chevron roz-pole-kurz no-dis su-spoiler-closed\" data-anchor=\"ukazka-tvorby\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Uk\u00e1\u017eka tvorby na \u0161kolen\u00ed<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\nBla, bla, bla<br \/>\n<\/div><\/div>\n\n\n\n<span id=\"course-info\"><\/span>\n\n\n<div class=\"su-tabs su-tabs-style-default su-tabs-mobile-stack tab-info text-blok\" data-active=\"1\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-tabs-nav\"><span class=\"\" data-anchor=\"informacie-o-skoleni\" data-url=\"\" data-target=\"self\" tabindex=\"0\" role=\"button\"><strong>Inform\u00e1cie o \u0161kolen\u00ed<\/strong><\/span><span class=\"\" data-anchor=\"vstupne-vedomosti\" data-url=\"#course-info\" data-target=\"self\" tabindex=\"0\" role=\"button\"><strong>Podporovan\u00e9 verzie programu<\/strong><\/span><span class=\"\" data-anchor=\"preberane-funkcie\" data-url=\"#course-info\" data-target=\"self\" tabindex=\"0\" role=\"button\"><strong>Odpor\u00fa\u010dan\u00e9 kurzy<\/strong><\/span><span class=\"\" data-anchor=\"vseobecne-informacie\" data-url=\"#course-info\" data-target=\"self\" tabindex=\"0\" role=\"button\"><strong>V\u0161eobecn\u00e9 inform\u00e1cie<\/strong><\/span><\/div><div class=\"su-tabs-panes\"><div class=\"su-tabs-pane su-u-clearfix su-u-trim\" data-title=\"&lt;strong&gt;Inform\u00e1cie o \u0161kolen\u00ed&lt;\/strong&gt;\">\n<strong>Cena:<\/strong> 80,00 \u20ac<br \/>\n<strong>D\u013a\u017eka trvania kurzu:<\/strong> 1 de\u0148<br \/>\n<strong>Celkov\u00fd po\u010det hod\u00edn:<\/strong> 5 hod\u00edn<br \/>\n<strong>Odpor\u00fa\u010dan\u00e9 minim\u00e1lne vstupn\u00e9 vedomosti:<\/strong> Z\u00e1kladn\u00e9 ovl\u00e1danie po\u010d\u00edta\u010da, pr\u00e1ca s prie\u010dinkami a s\u00fabormi. Tento kurz <strong>nie je vhodn\u00fd pre za\u010diato\u010dn\u00edkov<\/strong>, na absolvovanie kurzu odpor\u00fa\u010dame disponova\u0165 minim\u00e1lne sk\u00fasenos\u0165ami na \u00farovni absolvovania kurzu Excel level 3 &#8211; stredne porko\u010dil\u00fd. Pokia\u013e ich nem\u00e1te, odpor\u00fa\u010dame za\u010da\u0165 kme\u0148ov\u00fdmi kurzami Excel level 1 a\u017e Excel level 3.<br \/>\n<\/div>\n<div class=\"su-tabs-pane su-u-clearfix su-u-trim\" data-title=\"&lt;strong&gt;Podporovan\u00e9 verzie programu&lt;\/strong&gt;\">\nPower Query bude prezentovan\u00e9 na verzii Microsoft 365. Tento kurz je mo\u017en\u00e9 absolvova\u0165 s verziou Microsoft 365, Office 2021, Office 2019, Office 2016. V pr\u00edpade, \u017ee nem\u00e1te jednu z uveden\u00fdch verzi\u00ed, kontaktujte n\u00e1s.<br \/>\n<a href=\"https:\/\/edubeliso.eu\/sk\/difference-betwen-microsoft-365-and-office-2019\/\" target=\"_blank\" rel=\"noopener noreferrer\">Rozdiel medzi Microsoft 365 a Office 2019<\/a><br \/>\n<\/div>\n<div class=\"su-tabs-pane su-u-clearfix su-u-trim\" data-title=\"&lt;strong&gt;Odpor\u00fa\u010dan\u00e9 kurzy&lt;\/strong&gt;\">\n<strong>Pred kurzom:<\/strong><br \/>\nExcel level 3 &#8211; stredne pokro\u010dil\u00fd<br \/>\n<strong>Po kurze:<\/strong><br \/>\nPower BI &#8211; u\u017e\u00edvate\u013e<br \/>\n<\/div>\n<div class=\"su-tabs-pane su-u-clearfix su-u-trim\" data-title=\"&lt;strong&gt;V\u0161eobecn\u00e9 inform\u00e1cie&lt;\/strong&gt;\">\n<div data-post-id='2426' class='insert-page insert-page-2426 '>\n<p>Pred samotn\u00fdm kurzom odpor\u00fa\u010dame prezrie\u0165 nasleduj\u00face \u010dl\u00e1nky:<br><a href=\"https:\/\/edubeliso.eu\/sk\/how-does-an-online-course-look-like\/\" target=\"_blank\" aria-label=\"undefined (otv\u00e1ra sa na novej karte)\" rel=\"noreferrer noopener\">Ako vyzer\u00e1 online kurz?<\/a><br><a href=\"https:\/\/edubeliso.eu\/sk\/how-to-join-an-online-course\/\" target=\"_blank\" aria-label=\"undefined (otv\u00e1ra sa na novej karte)\" rel=\"noreferrer noopener\">Ako sa pripoji\u0165 na online kurz?<\/a><\/p>\n<\/div>\n<\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Power Query je s\u00fa\u010das\u0165ou bal\u00edka n\u00e1strojov Microsoft Excel, ktor\u00fd umo\u017e\u0148uje \u013eu\u010fom vytv\u00e1ra\u0165, upravova\u0165 a analyzova\u0165 d\u00e1ta z r\u00f4znych zdrojov. Power &hellip; <\/p>\n","protected":false},"author":2,"featured_media":0,"parent":397,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_glsr_average":0,"_glsr_ranking":0,"_glsr_reviews":0,"footnotes":""},"class_list":["post-2894","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>EduBeliso - Power Query<\/title>\n<meta name=\"description\" content=\"Kurz Excel 365 poskytuje preh\u013ead nov\u00fdch funkci\u00ed a n\u00e1strojov pridan\u00fdch v posledn\u00fdch verzi\u00e1ch programu Excel. R\u00f4zne nov\u00e9 funkcie, ako je aj napr\u00edklad XLOOKUP.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-query\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query\" \/>\n<meta property=\"og:description\" content=\"Kurz Excel 365 poskytuje preh\u013ead nov\u00fdch funkci\u00ed a n\u00e1strojov pridan\u00fdch v posledn\u00fdch verzi\u00e1ch programu Excel. R\u00f4zne nov\u00e9 funkcie, ako je aj napr\u00edklad XLOOKUP.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"EduBeliso\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-23T15:46:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2020\/08\/Excel-365-2020_08_09.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Autor:\">\n\t<meta name=\"twitter:data1\" content=\"Peter Beli\u010dka\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"3 min\u00faty\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\",\"url\":\"https:\/\/edubeliso.eu\/sk\/\",\"name\":\"EduBeliso\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/edubeliso.eu\/sk\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"sk-SK\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-query\/#webpage\",\"url\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-query\/\",\"name\":\"EduBeliso - Kurz [:sk]Power Query[:]\",\"isPartOf\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\"},\"datePublished\":\"2023-03-23T15:02:07+00:00\",\"dateModified\":\"2023-03-23T15:46:22+00:00\",\"description\":\"Kurz Excel 365 poskytuje preh\\u013ead nov\\u00fdch funkci\\u00ed a n\\u00e1strojov pridan\\u00fdch v posledn\\u00fdch verzi\\u00e1ch programu Excel. R\\u00f4zne nov\\u00e9 funkcie, ako je aj napr\\u00edklad XLOOKUP.\",\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-query\/\"]}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/2894","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/comments?post=2894"}],"version-history":[{"count":7,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/2894\/revisions"}],"predecessor-version":[{"id":2903,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/2894\/revisions\/2903"}],"up":[{"embeddable":true,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/397"}],"wp:attachment":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/media?parent=2894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}