{"id":2970,"date":"2023-05-01T12:10:00","date_gmt":"2023-05-01T10:10:00","guid":{"rendered":"https:\/\/edubeliso.eu\/sk\/?page_id=2970"},"modified":"2023-05-01T12:35:29","modified_gmt":"2023-05-01T10:35:29","slug":"power-pivot","status":"publish","type":"page","link":"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-pivot\/","title":{"rendered":"Power Pivot"},"content":{"rendered":"\n<p>\u0160kolenie je vo\u013en\u00fdm pokra\u010dovan\u00edm \u0161kolenia Excel &#8211; kontingen\u010dn\u00e9 tabu\u013eky.<\/p>\n\n\n\n<p>Power Pivot je doplnok pre program Microsoft Excel, ktor\u00fd umo\u017e\u0148uje u\u017e\u00edvate\u013eom analyzova\u0165 a manipulova\u0165 s ve\u013ek\u00fdm mno\u017estvom d\u00e1t vo ve\u013emi kr\u00e1tkom \u010dase. Tento program je ur\u010den\u00fd pre u\u017e\u00edvate\u013eov, ktor\u00ed sa zaoberaj\u00fa Business Intelligence a analytick\u00fdmi \u00falohami, kde je potrebn\u00e9 pracova\u0165 s obrovsk\u00fdmi mno\u017estvami d\u00e1t.<\/p>\n\n\n\n<p>Power Pivot poskytuje \u0161peci\u00e1lne n\u00e1stroje na prepojenie r\u00f4znych zdrojov d\u00e1t, vytvorenie komplexn\u00fdch vz\u0165ahov medzi nimi a tvorbu pokro\u010dil\u00fdch v\u00fdpo\u010dtov. U\u017e\u00edvatelia m\u00f4\u017eu vyu\u017e\u00edva\u0165 funkcie ako sumariz\u00e1cia d\u00e1t, filtrovanie, zoskupovanie, triedenie a kontingen\u010dn\u00e9 tabu\u013eky na r\u00fdchlej\u0161ie a efekt\u00edvnej\u0161ie spracovanie d\u00e1t. Power Pivot tie\u017e umo\u017e\u0148uje vytv\u00e1ranie pokro\u010dil\u00fdch grafick\u00fdch vizualiz\u00e1ci\u00ed, ktor\u00e9 umo\u017e\u0148uj\u00fa lep\u0161iu prezent\u00e1ciu a porozumenie d\u00e1tam.<\/p>\n\n\n\n<p>V\u00fdhody Power Pivot zah\u0155\u0148aj\u00fa mo\u017enos\u0165 r\u00fdchlej a efekt\u00edvnej pr\u00e1ce s obrovsk\u00fdmi mno\u017estvami d\u00e1t, jednoduch\u00e9 a intuit\u00edvne pou\u017e\u00edvate\u013esk\u00e9 rozhranie, vytv\u00e1ranie pokro\u010dil\u00fdch anal\u00fdz a vizualiz\u00e1ci\u00ed a mo\u017enos\u0165 pripojenia sa k r\u00f4znym zdrojom d\u00e1t vr\u00e1tane SQL datab\u00e1z, textov\u00fdch s\u00faborov, CSV s\u00faborov a \u010fal\u0161\u00edch.<\/p>\n\n\n\n<p>Power Pivot je u\u017eito\u010dn\u00fd pre r\u00f4zne oblasti, ako s\u00fa financie, marketing, predaj, logistika, v\u00fdroba a mnoho \u010fal\u0161\u00edch. Pom\u00e1ha u\u017e\u00edvate\u013eom z\u00edska\u0165 lep\u0161ie porozumenie svojich d\u00e1t, zlep\u0161i\u0165 procesy a robi\u0165 lep\u0161ie rozhodnutia na z\u00e1klade z\u00edskan\u00fdch poznatkov a anal\u00fdz.<\/p>\n\n\n\n<p>Na absolvovanie \u0161kolenia odpor\u00fa\u010dame disponova\u0165 znalos\u0165ami na \u00farovni absolvovania Excel level 3 &#8211; stredne pokro\u010dil\u00fd a Excel &#8211; kontingen\u010dn\u00e9 tabu\u013eky.<\/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>Z\u00edskanie doplnku Power Pivot pre Excel<\/li>\n\n\n\n<li>Spustenie a&nbsp;predstavenie doplnku Power Pivot<\/li>\n\n\n\n<li>Vysvetlenie pracovn\u00e9ho postupu a&nbsp;s\u00favislos\u0165 s&nbsp;Power Query<\/li>\n\n\n\n<li>S\u00favislos\u0165 s&nbsp;programom Power BI (Business Intelligence)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Importovanie d\u00e1t<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Importovanie \u00fadajov do d\u00e1tov\u00e9ho modelu zo s\u00faboru Excel<\/li>\n\n\n\n<li>Uk\u00e1\u017eka importu z&nbsp;in\u00fdch zdrojov<\/li>\n\n\n\n<li>Aktualiz\u00e1cia d\u00e1t (obnovovanie d\u00e1t)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Pr\u00edprava na analyzovanie<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vysvetlenie pojmu rela\u010dn\u00fd vz\u0165ah a&nbsp;uk\u00e1\u017eka r\u00f4znych<\/li>\n\n\n\n<li>Zobrazenie diagramu vz\u0165ahov a&nbsp;jeho vysvetlenie<\/li>\n\n\n\n<li>Tvorba rela\u010dn\u00fdch vz\u0165ahov<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Analyzovanie d\u00e1t<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vysvetlenie pojmu \u201ejazyk DAX\u201c<\/li>\n\n\n\n<li>Preh\u013ead vo funkci\u00e1ch DAX<\/li>\n\n\n\n<li>Vytv\u00e1ranie st\u013apcov \u2013 vypo\u010d\u00edtan\u00e9 st\u013apce<\/li>\n\n\n\n<li>Z\u00e1kladn\u00e9 matematick\u00e9 oper\u00e1cie (s\u00fa\u010det, rozdiel, s\u00fa\u010din, delenie)<\/li>\n\n\n\n<li>Pou\u017eitie funkcie RELATED na \u201esp\u00e1janie tabuliek\u201c<\/li>\n\n\n\n<li>Vytv\u00e1ranie mierok<\/li>\n\n\n\n<li>Z\u00e1kladn\u00e9 agrega\u010dn\u00e9 funkcie (SUM, AVERAGE, COUNT, MIN, MAX)<\/li>\n\n\n\n<li>Funkcia CALCULATE<\/li>\n\n\n\n<li>Funkcia FILTER<\/li>\n\n\n\n<li>Vytvorenie a&nbsp;v\u00fdznam d\u00e1tumovej tabu\u013eky<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Vizualizovanie d\u00e1t<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Zobrazenie d\u00e1t v&nbsp;kontinge\u010dnej tabu\u013eke<\/li>\n\n\n\n<li>Vizualiz\u00e1cia pomocou kontinge\u010dn\u00fdch grafov<\/li>\n\n\n\n<li>KPI (K\u013e\u00fa\u010dov\u00e9 ukazovatele v\u00fdkonu) \u2013 sledovanie v\u00fdkonnosti<\/li>\n<\/ul>\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 pokro\u010dil\u00fd a tie\u017e je nutn\u00e9 ovl\u00e1da\u0165 kontingen\u010dn\u00e9 tabu\u013eky. 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 Pivot 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 \/>\nExcel &#8211; kontinge\u010dn\u00e9 tabu\u013eky<br \/>\n<strong>Po kurze:<\/strong><br \/>\nExcel &#8211; grafy<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>\u0160kolenie je vo\u013en\u00fdm pokra\u010dovan\u00edm \u0161kolenia Excel &#8211; kontingen\u010dn\u00e9 tabu\u013eky. Power Pivot je doplnok pre program Microsoft Excel, ktor\u00fd umo\u017e\u0148uje u\u017e\u00edvate\u013eom &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-2970","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 Pivot<\/title>\n<meta name=\"description\" content=\"T\u00e1to str\u00e1nka pon\u00faka \u0161kolenia pre Excel - Power Pivot, ktor\u00e9 s\u00fa zameran\u00e9 na zlep\u0161enie schopnost\u00ed u\u017e\u00edvate\u013eov v oblasti business intelligence a analytick\u00fdch \u00faloh.\" \/>\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-pivot\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Pivot\" \/>\n<meta property=\"og:description\" content=\"T\u00e1to str\u00e1nka pon\u00faka \u0161kolenia pre Excel - Power Pivot, ktor\u00e9 s\u00fa zameran\u00e9 na zlep\u0161enie schopnost\u00ed u\u017e\u00edvate\u013eov v oblasti business intelligence a analytick\u00fdch \u00faloh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-pivot\/\" \/>\n<meta property=\"og:site_name\" content=\"EduBeliso\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-01T10:35:29+00:00\" \/>\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-pivot\/#webpage\",\"url\":\"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-pivot\/\",\"name\":\"EduBeliso - Kurz [:sk]Power Pivot[:]\",\"isPartOf\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\"},\"datePublished\":\"2023-05-01T10:10:00+00:00\",\"dateModified\":\"2023-05-01T10:35:29+00:00\",\"description\":\"T\\u00e1to str\\u00e1nka pon\\u00faka \\u0161kolenia pre Excel - Power Pivot, ktor\\u00e9 s\\u00fa zameran\\u00e9 na zlep\\u0161enie schopnost\\u00ed u\\u017e\\u00edvate\\u013eov v oblasti business intelligence a analytick\\u00fdch \\u00faloh.\",\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubeliso.eu\/sk\/office\/excel\/power-pivot\/\"]}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/2970","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=2970"}],"version-history":[{"count":2,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/2970\/revisions"}],"predecessor-version":[{"id":2972,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/pages\/2970\/revisions\/2972"}],"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=2970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}