{"id":596,"date":"2019-11-28T00:23:33","date_gmt":"2019-11-27T23:23:33","guid":{"rendered":"https:\/\/disruptivne.com\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/"},"modified":"2019-11-28T00:23:33","modified_gmt":"2019-11-27T23:23:33","slug":"osnova-kurzu-power-bi","status":"publish","type":"page","link":"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/","title":{"rendered":"Osnova kurzu Power BI"},"content":{"rendered":"<p>Osnova jednod\u0148ov\u00e9ho kurzu Power BI<\/p>\n<p>1. \u00davod do Power BI (Z\u00e1kladn\u00fd preh\u013ead o jednotliv\u00fdch \u010dastiach Power BI uk\u00e1zan\u00fd na pr\u00edklade.)<\/p>\n<ul>\n<li>Power BI Desktop<\/li>\n<li>Power BI Service<\/li>\n<li>Power BI Mobile<\/li>\n<li>Rozdiely medzi licenciami Free, Pro, Power BI Embeded a Power BI Premium<\/li>\n<\/ul>\n<p>2. Power Query<\/p>\n<ul>\n<li>\u00davod \u010do je Power Query a na \u010do sa pou\u017e\u00edva<\/li>\n<li>Na\u010d\u00edtavanie d\u00e1t z r\u00f4znych zdrojov<\/li>\n<li>Excel, CSV, datab\u00e1zy, MS Access, MS SQL, web, in\u00e9 slu\u017eby<\/li>\n<li>Integr\u00e1cia so Sharepoint<\/li>\n<li>ako skombinova\u0165 viacero d\u00e1tov\u00fdch zdrojov<\/li>\n<li>Uk\u00e1zanie naj\u010dastej\u0161\u00edch oper\u00e1ci\u00ed vyu\u017e\u00edvan\u00fdch v Power Query<\/li>\n<li>Prid\u00e1vanie, odoberanie st\u013apcov, premenovanie<\/li>\n<li>vytv\u00e1ranie a \u00faprava vlastn\u00fdch st\u013apcov<\/li>\n<li>vytv\u00e1ranie podmienen\u00fdch st\u013apcov<\/li>\n<li>Sp\u00e1janie viacer\u00fdch query cez Merge Queries (Oper\u00e1cia Join) a Append Queries<\/li>\n<li>\u00davod do M jazyka a roz\u0161\u00edren\u00e9ho editora<\/li>\n<li>Best Experience \u2013 Pr\u00edklady pou\u017e\u00edvania Power Query u mojich z\u00e1kazn\u00edkov<\/li>\n<\/ul>\n<p>3. Power BI desktop<\/p>\n<ul>\n<li>\u00davod o aplik\u00e1cii Power BI Desktop<\/li>\n<li>Uk\u00e1zanie z\u00e1kladn\u00fdch poh\u013eadov Report, Data, Relationships<\/li>\n<li>Vysvetlenie pou\u017e\u00edvania vz\u0165ahov (Relationships)<\/li>\n<li>Prepojenie r\u00f4znych d\u00e1tov\u00fdch zdrojov<\/li>\n<li>vz\u0165ahy 1:1, 1:n, n:n<\/li>\n<li>Obozn\u00e1menie sa s najviac pou\u017e\u00edvan\u00fdmi vizualiz\u00e1ciami Power BI<\/li>\n<li>Table &amp; Matrix table<\/li>\n<li>Slicer<\/li>\n<li> r\u00f4zne typy grafov<\/li>\n<li>Bar chart (klasick\u00fd st\u013apcov\u00fd graf)<\/li>\n<li>Line chart (Klasick\u00fd \u010diarov\u00fd graf)<\/li>\n<li>Waterfall chart<\/li>\n<li>Pie chart (Kol\u00e1\u010dov\u00fd graf)<\/li>\n<li>Scatter chart (Bodov\u00fd graf)<\/li>\n<li>kombinovanie r\u00f4znych druhov grafov<\/li>\n<li>Vyu\u017e\u00edvanie m\u00e1p<\/li>\n<li>Gauge, Card, KPI<\/li>\n<li>\u00davod do analytiky Power BI<\/li>\n<li>vysvetlenie Calculated column<\/li>\n<li>vysvetlenie Measures<\/li>\n<li>Najpou\u017e\u00edvanej\u0161ie funkcie jazyka DAX<\/li>\n<li>SUM, DIVIDE<\/li>\n<li>D\u00e1tumov\u00e9 funkcie<\/li>\n<li>Logick\u00e9 a s\u00fa\u010dtov\u00e9 funkcie<\/li>\n<li>funkcia Calculate podrobne<\/li>\n<li>Filter (Page, Report and visualization filter)<\/li>\n<li>Zozn\u00e1menie s hierarchiami<\/li>\n<li>Na \u010do ich pou\u017ei\u0165 a ako ich vytvori\u0165<\/li>\n<li>vytvorenie d\u00e1tumov\u00fdch a produktov\u00fdch hierarchi\u00ed<\/li>\n<li>oper\u00e1cie Drill up &amp; Drill down<\/li>\n<li>oper\u00e1cie Include &amp; Exclude<\/li>\n<li>Grafick\u00e1 a dizajnov\u00e1 \u00faprava reportu<\/li>\n<li>prejdenie celej \u010dasti Form\u00e1t<\/li>\n<li>vytvorenie podmienen\u00e9ho form\u00e1tovania pre tabu\u013eky a grafy<\/li>\n<li>Prisp\u00f4sobenie reportov pre mobil<\/li>\n<\/ul>\n<p>4. Ako premeni\u0165 \u010do najviac z kurzu do Praxe<\/p>\n<ul>\n<li>Rady a tipy oh\u013eadom vytvorenia prv\u00fdch \u017eiv\u00fdch reportov<\/li>\n<li>Tipy na bezplatn\u00e9 a kvalitn\u00e9 Power BI online kurzy<\/li>\n<li>Best Experience pr\u00edklady z mojej konzulta\u010dnej praxe z komer\u010dn\u00fdch projektov<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Osnova jednod\u0148ov\u00e9ho kurzu Power BI 1. \u00davod do Power BI [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":446,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Osnova kurzu Power BI - disruptivne.com<\/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:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Osnova kurzu Power BI - disruptivne.com\" \/>\n<meta property=\"og:description\" content=\"Osnova jednod\u0148ov\u00e9ho kurzu Power BI 1. \u00davod do Power BI [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"disruptivne.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Predpokladan\u00fd \u010das \u010d\u00edtania\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min\u00faty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/\",\"url\":\"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/\",\"name\":\"Osnova kurzu Power BI - disruptivne.com\",\"isPartOf\":{\"@id\":\"https:\/\/disruptivne.com\/sk\/#website\"},\"datePublished\":\"2019-11-27T23:23:33+00:00\",\"dateModified\":\"2019-11-27T23:23:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/#breadcrumb\"},\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/disruptivne.com\/sk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Na\u0161e rie\u0161enia\",\"item\":\"https:\/\/disruptivne.com\/sk\/our-solutions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"IT\",\"item\":\"https:\/\/disruptivne.com\/sk\/our-solutions\/it\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Power BI\",\"item\":\"https:\/\/disruptivne.com\/sk\/our-solutions\/it\/power-bi\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Osnova kurzu Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/disruptivne.com\/sk\/#website\",\"url\":\"https:\/\/disruptivne.com\/sk\/\",\"name\":\"disruptivne.com\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/disruptivne.com\/sk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"sk-SK\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Osnova kurzu Power BI - disruptivne.com","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:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/","og_locale":"sk_SK","og_type":"article","og_title":"Osnova kurzu Power BI - disruptivne.com","og_description":"Osnova jednod\u0148ov\u00e9ho kurzu Power BI 1. \u00davod do Power BI [&hellip;]","og_url":"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/","og_site_name":"disruptivne.com","twitter_card":"summary_large_image","twitter_misc":{"Predpokladan\u00fd \u010das \u010d\u00edtania":"2 min\u00faty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/","url":"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/","name":"Osnova kurzu Power BI - disruptivne.com","isPartOf":{"@id":"https:\/\/disruptivne.com\/sk\/#website"},"datePublished":"2019-11-27T23:23:33+00:00","dateModified":"2019-11-27T23:23:33+00:00","breadcrumb":{"@id":"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/#breadcrumb"},"inLanguage":"sk-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/disruptivne.com\/sk\/nase-riesenia\/it\/power-bi\/osnova-kurzu-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/disruptivne.com\/sk\/"},{"@type":"ListItem","position":2,"name":"Na\u0161e rie\u0161enia","item":"https:\/\/disruptivne.com\/sk\/our-solutions\/"},{"@type":"ListItem","position":3,"name":"IT","item":"https:\/\/disruptivne.com\/sk\/our-solutions\/it\/"},{"@type":"ListItem","position":4,"name":"Power BI","item":"https:\/\/disruptivne.com\/sk\/our-solutions\/it\/power-bi\/"},{"@type":"ListItem","position":5,"name":"Osnova kurzu Power BI"}]},{"@type":"WebSite","@id":"https:\/\/disruptivne.com\/sk\/#website","url":"https:\/\/disruptivne.com\/sk\/","name":"disruptivne.com","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/disruptivne.com\/sk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"sk-SK"}]}},"_links":{"self":[{"href":"https:\/\/disruptivne.com\/sk\/wp-json\/wp\/v2\/pages\/596"}],"collection":[{"href":"https:\/\/disruptivne.com\/sk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/disruptivne.com\/sk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/disruptivne.com\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/disruptivne.com\/sk\/wp-json\/wp\/v2\/comments?post=596"}],"version-history":[{"count":0,"href":"https:\/\/disruptivne.com\/sk\/wp-json\/wp\/v2\/pages\/596\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/disruptivne.com\/sk\/wp-json\/wp\/v2\/pages\/446"}],"wp:attachment":[{"href":"https:\/\/disruptivne.com\/sk\/wp-json\/wp\/v2\/media?parent=596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}