{"id":2714,"date":"2022-03-29T13:49:53","date_gmt":"2022-03-29T11:49:53","guid":{"rendered":"https:\/\/edubeliso.eu\/sk\/?p=2714"},"modified":"2023-03-23T17:28:13","modified_gmt":"2023-03-23T16:28:13","slug":"co-je-to-power-bi","status":"publish","type":"post","link":"https:\/\/edubeliso.eu\/sk\/co-je-to-power-bi\/","title":{"rendered":"\u010co je to Power BI?"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Power BI \u00favod<\/h3>\n\n\n\n<p>Power BI je software, ktor\u00e9ho \u00faloha je prep\u00e1janie d\u00e1t z&nbsp;r\u00f4znych zdrojov a&nbsp;ich premena na vizu\u00e1lne a&nbsp;<em>interakt\u00edvne v\u00fdstupy<\/em>. Samotn\u00e1 skratka BI znamen\u00e1 <em>Business Intelligence<\/em> a&nbsp;teda podstatu tohto programu vn\u00edmame pr\u00e1ve v&nbsp;sprostredkovan\u00ed d\u00e1t publiku, \u010di u\u017e intern\u00e9mu alebo extern\u00e9mu. Power BI umo\u017e\u0148uje pripoji\u0165 sa k&nbsp;prakticky ak\u00e9muko\u013evek zdroju \u00fadajov a&nbsp;\u010derpa\u0165 z&nbsp;neho prostredn\u00edctvom doplnku <em>PowerQuery<\/em>. Fan\u00fa\u0161ikovia Excelu sa s&nbsp;t\u00fdmto pojmom u\u017e mohli v&nbsp;minulosti stretn\u00fa\u0165 lebo tento doplnok je s\u00fa\u010das\u0165ou aj pr\u00e1ve spom\u00ednan\u00e9ho Excelu. Prakticky m\u00f4\u017eeme tvrdi\u0165, \u017ee tieto v\u0161etky pojmy teda spolu \u00fazko s\u00favisia.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2022\/03\/Snimka2-1024x576.png\" alt=\"\" class=\"wp-image-2718\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2022\/03\/Snimka2-1024x576.png 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2022\/03\/Snimka2-300x169.png 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2022\/03\/Snimka2-768x432.png 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2022\/03\/Snimka2-610x343.png 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2022\/03\/Snimka2-600x338.png 600w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2022\/03\/Snimka2.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Pracovn\u00fd postup s Power BI<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Ako funguje PowerQuery?<\/h3>\n\n\n\n<p>Ak m\u00e1te Excel alebo program <em>Power BI Desktop<\/em> m\u00e1te automaticky k&nbsp;dispoz\u00edci\u00ed aj tento doplnok. PowerQuery prostredn\u00edctvom <em>dotazov<\/em> z\u00edskava d\u00e1ta z&nbsp;r\u00f4znych zdrojov. Najlep\u0161ie asi bude uvies\u0165 pr\u00edklady:<\/p>\n\n\n\n<p>Predstavme si situ\u00e1ciu, \u017ee va\u0161a pr\u00e1ca vy\u017eaduje denn\u00e9 prepo\u010d\u00edtavanie Eur na Dol\u00e1re. Vzh\u013eadom na povahu pr\u00e1ce musia by\u0165 kurzy v\u017edy aktu\u00e1lne ku d\u0148u, v&nbsp;ktorom pracujeme. Konven\u010dne by ste si ka\u017ed\u00e9 r\u00e1no stiahli do Excelu kurzov\u00fd l\u00edstok z&nbsp;NBS, ktor\u00fd by ste aktualizovali do svojich v\u00fdpo\u010dtov. PowerQuery dok\u00e1\u017ee zabezpe\u010di\u0165, \u017ee sa v\u017edy automaticky krok po kroku stiahne t\u00e1to tabu\u013eka zo zdroja, napr. aj zo str\u00e1nky NBS. Zdrojom inak m\u00f4\u017eu by\u0165 aj Excelov\u00e9 tabu\u013eky v&nbsp;cloude, SQL server, Access datab\u00e1za a&nbsp;r\u00f4zne in\u00e9. \u010co teda z\u00edskavam, resp. \u010do u\u0161etr\u00edm je \u010das, v ktor\u00fd ka\u017ed\u00fd de\u0148 opakovane s\u0165ahujem nov\u00fa tabu\u013eku.<\/p>\n\n\n\n<p>In\u00fd pr\u00edklad je situ\u00e1cia vo firme v&nbsp;ktorej pracuj\u00fa viacer\u00ed \u013eudia. Ka\u017ed\u00fd z&nbsp;nich dostal \u0161abl\u00f3nu Excelovej tabu\u013eky, ktor\u00fa m\u00e1 vyplni\u0165 pod\u013ea zadanej \u00falohy. Ka\u017ed\u00fd pracuj\u00faci vytvor\u00ed tabu\u013eku a&nbsp;nahr\u00e1 ju do spolo\u010dn\u00e9ho zdie\u013ean\u00e9ho prie\u010dinka. PowerQuery dok\u00e1\u017ee pomocou dotazov stiahnu\u0165 \u00fadaje zo v\u0161etk\u00fdch Excelov\u00fdch s\u00faborov prie\u010dinka a&nbsp;nahra\u0165 ich do jednej tabu\u013eky pomocou tzv. prip\u00e1jacieho dotazu. Tie\u017e zabezpe\u010d\u00ed automatiz\u00e1ciu v&nbsp;pr\u00edpade, \u017ee v&nbsp;bud\u00facnosti do toho ist\u00e9ho prie\u010dinka pribudne nov\u00fd s\u00fabor, automaticky bud\u00fa jeho \u00fadaje natiahnut\u00e9 do v\u00fdstupn\u00e9ho s\u00faboru.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u010co je to DAX?<\/h3>\n\n\n\n<p>Ke\u010f z\u00edskame d\u00e1ta je potrebn\u00e9 ich \u010dasto upravi\u0165 a pr\u00edpadne k nim prida\u0165 r\u00f4zne kalkul\u00e1cie. Na tieto kalkul\u00e1cie v programe Power BI pou\u017e\u00edvame jazyk <em>DAX<\/em>. Tento jazyk je podobn\u00fd jazyku MDX, resp. jazyku, ktor\u00fd pou\u017e\u00edva Excel. Excelov\u00ed veter\u00e1ni sa teda ve\u013emi r\u00fdchlo zorientuj\u00fa. Asi hlavn\u00fd rozdiel oproti jazyku MDX je ten, \u017ee v pr\u00edpade jazyka DAX pracujeme s cel\u00fdmi po\u013eami (st\u013apcami) namiesto buniek. A teda pr\u00e1ca m\u00f4\u017ee pripom\u00edna\u0165 pr\u00e1cu v programe Access.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00fdstup Power BI<\/h3>\n\n\n\n<p>Ke\u010f s\u00fa d\u00e1ta spracovan\u00e9 sme pripraven\u00ed vytv\u00e1ra\u0165 anal\u00fdzy a vizualiz\u00e1cie. Tie s\u00fa spracovan\u00e9 ako tzv. zostavy (reporty) a v pr\u00edpade ak ide o komplexnej\u0161ie v\u00fdstupy naz\u00fdvame ich tie\u017e panely (dashboardy) a m\u00f4\u017eu pripom\u00edna\u0165 aj PowerPointov\u00fa prezent\u00e1ciu svojou formou. Tieto v\u00fdstupy m\u00f4\u017eu obsahova\u0165 vizualiz\u00e1cie ako s\u00fa napr.:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>klasick\u00e9 grafy: Kol\u00e1\u010dov\u00e9, st\u013apcov\u00e9, \u010diarov\u00e9,<\/li>\n\n\n\n<li>tabu\u013eky: jednorozmern\u00e9, viacrozmern\u00e9 (matice),<\/li>\n\n\n\n<li>pokro\u010dil\u00e9 grafy: mapa, dekompozi\u010dn\u00fd strom, KPI grafy a in\u00e9,<\/li>\n\n\n\n<li>r\u00f4zne ovl\u00e1dacie tla\u010didl\u00e1: odkazy na web, odkazy na in\u00fa \u010das\u0165 prezent\u00e1cie,<\/li>\n\n\n\n<li>&#8222;statick\u00e9&#8220; vizu\u00e1lne prvky: \u0161\u00edpky, obr\u00e1zky a in\u00e9.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Uk\u00e1\u017eky pr\u00e1ce<\/h3>\n\n\n<div class=\"su-image-carousel  su-image-carousel-has-spacing su-image-carousel-has-outline su-image-carousel-adaptive su-image-carousel-slides-style-default su-image-carousel-controls-style-dark su-image-carousel-align-none\" style=\"\" data-flickity-options='{\"groupCells\":true,\"cellSelector\":\".su-image-carousel-item\",\"adaptiveHeight\":true,\"cellAlign\":\"left\",\"prevNextButtons\":true,\"pageDots\":true,\"autoPlay\":5000,\"imagesLoaded\":true,\"contain\":false,\"selectedAttraction\":0.025,\"friction\":0.28}' id=\"su_image_carousel_69ea30cdb96a1\"><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-01.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-01-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-01-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-01-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-01-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-01-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-01.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-02.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-02-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-02-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-02-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-02-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-02-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-02.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-03.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-03-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-03-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-03-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-03-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-03-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-03.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-04.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-04-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-04-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-04-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-04-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-04-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-04.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-05.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-05-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-05-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-05-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-05-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-05-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-05.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-06.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-06-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-06-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-06-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-06-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-06-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-06.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-07.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-07-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-07-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-07-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-07-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-07-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-07.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-08.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-08-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-08-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-08-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-08-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-08-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-08.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-09.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-09-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-09-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-09-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-09-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-09-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-09.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-10.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-10-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-10-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-10-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-10-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-10-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-10.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-12.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-12-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-12-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-12-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-12-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-12-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-12.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><div class=\"su-image-carousel-item\"><div class=\"su-image-carousel-item-content\"><a href=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-11.jpg\" target=\"_blank\" rel=\"noopener noreferrer\" data-caption=\"\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-11-1024x576.jpg\" class=\"\" alt=\"\" srcset=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-11-1024x576.jpg 1024w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-11-300x169.jpg 300w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-11-768x432.jpg 768w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-11-610x343.jpg 610w, https:\/\/edubeliso.eu\/wp-content\/uploads\/2023\/03\/Power-BI-ukazka-11.jpg 1280w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/div><\/div><\/div><script id=\"su_image_carousel_69ea30cdb96a1_script\">if(window.SUImageCarousel){setTimeout(function() {window.SUImageCarousel.initGallery(document.getElementById(\"su_image_carousel_69ea30cdb96a1\"))}, 0);}var su_image_carousel_69ea30cdb96a1_script=document.getElementById(\"su_image_carousel_69ea30cdb96a1_script\");if(su_image_carousel_69ea30cdb96a1_script){su_image_carousel_69ea30cdb96a1_script.parentNode.removeChild(su_image_carousel_69ea30cdb96a1_script);}<\/script>\n\n\n\n<h3 class=\"wp-block-heading\">Na \u010do sa hod\u00ed Power BI?<\/h3>\n\n\n\n<p>Program je vhodn\u00fd ak\u00e9muko\u013evek \u010dloveku, ktor\u00fd pracuje s d\u00e1tami a najm\u00e4 ich spracov\u00e1van\u00edm. V biznise s\u00fa to najm\u00e4 \u010dinnosti spojen\u00e9 napr\u00edklad aj s:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>spravovan\u00edm z\u00e1sob,<\/li>\n\n\n\n<li>identifikovan\u00edm n\u00e1kupn\u00fdch zvykov,<\/li>\n\n\n\n<li>optimaliz\u00e1ciou cien,<\/li>\n\n\n\n<li>vyhodnocovan\u00edm ziskov a tzv. KPI (k\u013e\u00fa\u010dov\u00e9 indik\u00e1tory v\u00fdkonu),<\/li>\n\n\n\n<li>vyhodnocovanie priemern\u00fdch tr\u017eieb v \u010dasov\u00fdch obdobiach,<\/li>\n\n\n\n<li>a r\u00f4zne in\u00e9.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Power BI a&nbsp;Excel<\/h3>\n\n\n\n<p>M\u00f4\u017eeme tvrdi\u0165, \u017ee ve\u013ea \u00faloh, ktor\u00e9 viete vyrie\u0161i\u0165 v&nbsp;Power BI Desktop dok\u00e1\u017eete vyrie\u0161i\u0165 aj v&nbsp;programe Excel. Najv\u00e4\u010d\u0161\u00ed rozdiel vn\u00edmame najm\u00e4 v&nbsp;pou\u017eite\u013enosti. Excel je tzv. tabu\u013ekov\u00fd procesor a&nbsp;teda t\u00fato pr\u00e1cu zvl\u00e1da najlep\u0161ie. Je vhodn\u00fd na tvorbu tabuliek a&nbsp;kalkul\u00e1cie v&nbsp;nich. Do ve\u013ekej miery zvl\u00e1da aj vizualizovanie av\u0161ak je to komplexnej\u0161ie ako napr\u00edklad v&nbsp;programe Power BI, ktor\u00fd je nato ur\u010den\u00fd. Power BI je teda ur\u010den\u00fd pr\u00e1ve na vizualiz\u00e1ciu. \u010casto sa v&nbsp;praxi pou\u017e\u00edva ako vstup do Power BI s\u00fabor spracovan\u00fd pr\u00e1ve v&nbsp;programe Excel.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Porovnanie<\/h4>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th><\/th><th><strong>Excel<\/strong><\/th><th>Power BI<\/th><\/tr><\/thead><tbody><tr><td>V\u00fdstup<\/td><td>V\u00fdstup v tabu\u013ekovej podobe.<\/td><td>V\u00fdstup v podobe vizu\u00e1lnych reportov a dashboardov, ktor\u00e9 s\u00fa interakt\u00edvne.<\/td><\/tr><tr><td>Vizualiz\u00e1cia<\/td><td>Vizualiz\u00e1cia je mo\u017en\u00e1, ale jej tvorba m\u00f4\u017ee by\u0165 n\u00e1ro\u010dnej\u0161ia.<\/td><td>Umo\u017e\u0148uje vytv\u00e1ranie r\u00f4znych grafick\u00fdch v\u00fdstupov. Optim\u00e1lne pre zobrazovanie KPI a tvorbu dashboardov.<\/td><\/tr><tr><td>Tvorba tabuliek<\/td><td>Umo\u017e\u0148uje jednoduch\u00fa tvorbu tabuliek od ich z\u00e1kladu.<\/td><td>Pracuje u\u017e s vytvoren\u00fdmi tabu\u013ekami.<\/td><\/tr><tr><td>Big Data<\/td><td>M\u00e1 relat\u00edvne limitovan\u00e9 mno\u017estvo d\u00e1t, ktor\u00e9 m\u00f4\u017ee spracova\u0165.<\/td><td>Umo\u017e\u0148uje spracovanie v\u00e4\u010d\u0161\u00edch s\u00faborov \u00fadajov.<\/td><\/tr><tr><td>Jazyk<\/td><td>Excel pou\u017e\u00edva tzv. jazyk MDX, to je ten klasick\u00fd jazyk, ktor\u00fdm tvor\u00edme funkcie.<\/td><td>Pou\u017e\u00edva tzv. jazyk DAX, ten sa podob\u00e1 na jazyk MDX av\u0161ak m\u00e1 aj rozdielne vlastnosti.<\/td><\/tr><tr><td>Pou\u017eite\u013enos\u0165<\/td><td>Z poh\u013eadu \u010dloveka, ktor\u00fd nikdy nepou\u017eil Excel, je Excel relat\u00edvne n\u00e1ro\u010dn\u00fd n\u00e1stroj.<\/td><td>Power BI m\u00e1 &#8222;user-friendly&#8220; prostredie, ktor\u00e9 sa \u010dlovek r\u00fdchlo nau\u010d\u00ed pou\u017e\u00edva\u0165.<\/td><\/tr><tr><td>Cena<\/td><td>S\u00fa\u010das\u0165 Office a teda cena je z\u00e1visl\u00e1 od ceny Office.<\/td><td>M\u00e1 aj verziu zadarmo a tie\u017e verziu Pro, ktor\u00e1 je spoplatnen\u00e1 mesa\u010dne.<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">Porovnanie Excel vs. Power BI<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Z\u00e1ver<\/h3>\n\n\n\n<p>Programy s\u00fa \u00fazko s\u00favisiace a najlep\u0161ie je ma\u0165 praktick\u00fd preh\u013ead vo v\u0161etk\u00fdch programoch. Power BI je ve\u013emi modern\u00fd a jeho postavenie na trhu sa upev\u0148uje. Nikto v\u0161ak nespochyb\u0148uje d\u00f4le\u017eit\u00fa \u00falohu Excelu, s ktor\u00fdm sa tieto dva programy dop\u013a\u0148aj\u00fa.<\/p>\n\n\n\n<p>Ak by ste sa rozhodli tento program \u0161tudova\u0165 \u010falej vieme v\u00e1m s t\u00fdm pom\u00f4c\u0165, nev\u00e1hajte n\u00e1s kontaktova\u0165.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power BI \u00favod Power BI je software, ktor\u00e9ho \u00faloha je prep\u00e1janie d\u00e1t z&nbsp;r\u00f4znych zdrojov a&nbsp;ich premena na vizu\u00e1lne a&nbsp;interakt\u00edvne v\u00fdstupy. &hellip; <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_glsr_average":0,"_glsr_ranking":0,"_glsr_reviews":0,"footnotes":""},"categories":[29],"tags":[],"class_list":["post-2714","post","type-post","status-publish","format-standard","hentry","category-practical-advices"],"jetpack_featured_media_url":"","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u010co je to Power BI? - EduBeliso<\/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:\/\/edubeliso.eu\/sk\/co-je-to-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u010co je to Power BI?\" \/>\n<meta property=\"og:description\" content=\"Power BI \u00favod Power BI je software, ktor\u00e9ho \u00faloha je prep\u00e1janie d\u00e1t z&nbsp;r\u00f4znych zdrojov a&nbsp;ich premena na vizu\u00e1lne a&nbsp;interakt\u00edvne v\u00fdstupy. &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/edubeliso.eu\/sk\/co-je-to-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"EduBeliso\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-29T11:49:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-23T16:28:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2022\/03\/Snimka2-1024x576.png\" \/>\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=\"4 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\":\"ImageObject\",\"@id\":\"https:\/\/edubeliso.eu\/sk\/co-je-to-power-bi\/#primaryimage\",\"inLanguage\":\"sk-SK\",\"url\":\"https:\/\/edubeliso.eu\/wp-content\/uploads\/2022\/03\/Snimka2.png\",\"width\":1280,\"height\":720},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/edubeliso.eu\/sk\/co-je-to-power-bi\/#webpage\",\"url\":\"https:\/\/edubeliso.eu\/sk\/co-je-to-power-bi\/\",\"name\":\"[:sk]\\u010co je to Power BI?[:] - EduBeliso\",\"isPartOf\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/co-je-to-power-bi\/#primaryimage\"},\"datePublished\":\"2022-03-29T11:49:53+00:00\",\"dateModified\":\"2023-03-23T16:28:13+00:00\",\"author\":{\"@id\":\"https:\/\/edubeliso.eu\/sk\/#\/schema\/person\/8a4b7acb54337777c632be0ff411507b\"},\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/edubeliso.eu\/sk\/co-je-to-power-bi\/\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/edubeliso.eu\/sk\/#\/schema\/person\/8a4b7acb54337777c632be0ff411507b\",\"name\":\"Peter Beli\\u010dka\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/edubeliso.eu\/sk\/#personlogo\",\"inLanguage\":\"sk-SK\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c9f218c64ad8771fd79a5eccbd0f7e947d49f4c58e8285649f151571d9f6f8c5?s=96&d=mm&r=g\",\"caption\":\"Peter Beli\\u010dka\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/posts\/2714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/types\/post"}],"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=2714"}],"version-history":[{"count":21,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/posts\/2714\/revisions"}],"predecessor-version":[{"id":2949,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/posts\/2714\/revisions\/2949"}],"wp:attachment":[{"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/media?parent=2714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/categories?post=2714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/edubeliso.eu\/sk\/wp-json\/wp\/v2\/tags?post=2714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}