{"id":14545,"date":"2026-01-09T16:19:10","date_gmt":"2026-01-09T15:19:10","guid":{"rendered":"https:\/\/www.leaplytics.de\/?page_id=14545"},"modified":"2026-01-09T16:25:49","modified_gmt":"2026-01-09T15:25:49","slug":"zaciname-vodopadova-varianta-power-bi","status":"publish","type":"page","link":"https:\/\/www.leaplytics.de\/cs\/zaciname-vodopadova-varianta-power-bi\/","title":{"rendered":"Za\u010d\u00edn\u00e1me - Vodop\u00e1d a odchylky"},"content":{"rendered":"<p><a href=\"#minimum-requirement\">Minim\u00e1ln\u00ed po\u017eadavky<\/a> | <a href=\"#license\">Licence<\/a> | <a href=\"#features\">Funkce<\/a> | <a href=\"#chart-modes\">Re\u017eimy grafu<\/a> | <a href=\"#troubleshooting\">\u0158e\u0161en\u00ed probl\u00e9m\u016f<\/a><\/p>\n\n<p>Finan\u010dn\u00ed t\u00fdmy nap\u0159\u00ed\u010d odv\u011btv\u00edmi pou\u017e\u00edvaj\u00ed vizu\u00e1ln\u00ed n\u00e1stroj LeapLytics Waterfall &amp; Variance k prezentaci rozpo\u010dtov\u00fdch odchylek, p\u0159\u00edjmov\u00fdch m\u016fstk\u016f, rozpis\u016f n\u00e1klad\u016f a anal\u00fdz P&amp;L p\u0159\u00edmo v prost\u0159ed\u00ed Power BI. Vizu\u00e1l je rychl\u00fd a vytvo\u0159en\u00fd pro profesion\u00e1ln\u00ed finan\u010dn\u00ed v\u00fdkaznictv\u00ed. D\u00edky funkc\u00edm, jako je p\u011bt re\u017eim\u016f grafu, automatick\u00fd v\u00fdpo\u010det odchylek, p\u0159eru\u0161en\u00ed m\u011b\u0159\u00edtka pro soust\u0159ed\u011bnou anal\u00fdzu, z\u00edskaj\u00ed u\u017eivatel\u00e9 okam\u017eitou jasnost o tom, co \u0159\u00edd\u00ed \u010d\u00edsla.<\/p>\n\n<p>Pokud m\u00e1te k dispozici sv\u00e1 finan\u010dn\u00ed data, m\u016f\u017eete pln\u011b nakonfigurovat a zprovoznit vizu\u00e1ln\u00ed n\u00e1stroj LeapLytics Waterfall &amp; Variance v. <strong>do 2 minut<\/strong>. Z\u00edsk\u00e1te funk\u010dn\u00ed vodop\u00e1dov\u00fd diagram v\u010detn\u011b kategori\u00ed, hodnot, ukazatel\u016f odchylek a form\u00e1tov\u00e1n\u00ed - p\u0159ipraven\u00fd pro prezentace na porad\u011b, v\u00fdkaznictv\u00ed pro veden\u00ed a anal\u00fdzu zainteresovan\u00fdch stran.<\/p>\n\n\n<h3 class=\"wp-block-heading\" id=\"minimum-requirement\">Minim\u00e1ln\u00ed po\u017eadavky<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>\u26a0\ufe0f D\u016fle\u017eit\u00e9:<\/strong> Va\u0161e data by m\u011bla m\u00edt tabulkovou strukturu, kde ka\u017ed\u00fd \u0159\u00e1dek p\u0159edstavuje kategorii a sloupce obsahuj\u00ed hodnoty.<\/p>\n<\/blockquote>\n\n\n<p>Vizu\u00e1ln\u00ed zobrazen\u00ed vy\u017eaduje pouze minim\u00e1ln\u00ed sadu pol\u00ed pro vytvo\u0159en\u00ed pln\u011b funk\u010dn\u00edho grafu. Ka\u017ed\u00fd datov\u00fd bod mus\u00ed obsahovat <strong>Kategorie<\/strong> (textov\u00e9 pole pro \u0161t\u00edtky, jako jsou m\u011bs\u00edce, produkty nebo n\u00e1kladov\u00e1 st\u0159ediska) a <strong>Hodnota<\/strong> (\u010d\u00edseln\u00e9 vyj\u00e1d\u0159en\u00ed skute\u010dn\u00fdch \u010d\u00e1stek). Pouze s t\u011bmito dv\u011bma poli se automaticky vykresl\u00ed profesion\u00e1ln\u00ed vodop\u00e1dov\u00fd nebo sloupcov\u00fd graf.<\/p>\n\n<p>Vizu\u00e1ln\u00ed zobrazen\u00ed interpretuje data automaticky na z\u00e1klad\u011b zvolen\u00e9ho re\u017eimu grafu. Na str\u00e1nce <strong>Sloupcov\u00fd graf<\/strong> se ka\u017ed\u00e1 kategorie zobraz\u00ed jako nez\u00e1visl\u00fd sloupec od nuly. V re\u017eimu <strong>Vodop\u00e1d<\/strong> Vizu\u00e1ln\u00ed zobrazen\u00ed vypo\u010d\u00edt\u00e1 pr\u016fb\u011b\u017en\u00e9 sou\u010dty a uk\u00e1\u017ee, jak se jednotliv\u00e9 hodnoty pod\u00edlej\u00ed na kone\u010dn\u00e9m v\u00fdsledku. <strong>\u0158\u00e1dek<\/strong>, <strong>Oblast<\/strong>a <strong>Lollipop<\/strong> poskytuj\u00ed alternativn\u00ed pohledy na stejn\u00e1 data.<\/p>\n\n\n<pre class=\"wp-block-code\"><code>\n  -- =====================================================\n  -- PO\u017dADOVAN\u00c1 POLE (minim\u00e1ln\u00ed pot\u0159ebn\u00e9 \u00fadaje)\n  -- =====================================================\n  \"January\" AS Category, -- Ozna\u010den\u00ed kategorie (text)\n  150000 AS Value, -- \u010c\u00edseln\u00e1 hodnota (m\u00edra)\n\n  -- ===== PODPOROVAN\u00c9 RE\u017dIMY GRAFU =====\n  -- Vizu\u00e1ln\u00ed zobrazen\u00ed nab\u00edz\u00ed p\u011bt re\u017eim\u016f grafu pro r\u016fzn\u00e9 perspektivy:\n  --\n  -- 1. Sloupcov\u00fd graf:     Nez\u00e1visl\u00e9 sloupce od nulov\u00e9 z\u00e1kladn\u00ed linie\n  -- 2. Vodop\u00e1d:     Pr\u016fb\u011b\u017en\u00e9 sou\u010dty zobrazuj\u00edc\u00ed kumulativn\u00ed tok\n  -- 3. \u010c\u00e1ra:          Propojen\u00e9 datov\u00e9 body zobrazuj\u00edc\u00ed trendy\n  -- 4. Plocha:          Vypln\u011bn\u00e1 oblast s barevn\u00fdm odli\u0161en\u00edm\n  -- 5. L\u00edz\u00e1tko:      Stonky s te\u010dkami pro \u010distou prezentaci\n  --\n  -- ===== POZN\u00c1MKY =====\n  -- -- Kategorie: - V\u00e1no\u010dn\u00ed strome\u010dek, - V\u00e1no\u010dn\u00ed strome\u010dek, - V\u00e1no\u010dn\u00ed strome\u010dek: Textov\u00e9 pole pro popisky (m\u011bs\u00edce, produkty, n\u00e1kladov\u00e1 st\u0159ediska).\n  -- - Hodnota: \u010c\u00edseln\u00e1 m\u00edra (v\u00fdnosy, n\u00e1klady, \u010d\u00e1stky odchylek).\n  -- - V\u0161echny re\u017eimy grafu pou\u017e\u00edvaj\u00ed stejn\u00e1 datov\u00e1 pole\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"license\">Licence<\/h3>\n\n\n<p>Zkop\u00edrujte sv\u016fj licen\u010dn\u00ed k\u00f3d a vlo\u017ete jej do pole Licence stisknut\u00edm kl\u00e1vesov\u00e9 zkratky CTRL+V. Pokud je\u0161t\u011b nem\u00e1te zku\u0161ebn\u00ed licenci, m\u016f\u017eete si ji vy\u017e\u00e1dat.\n<a href=\"https:\/\/www.leaplytics.de\/cs\/power-bi-waterfall-variance-vyzkouset-nyni\/\" style=\"text-decoration: underline;\">zde<\/a>.<\/p>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"features\">Funkce<\/h3>\n\n\n<p>Vizualizace LeapLytics Waterfall &amp; Variance poskytuje profesion\u00e1ln\u00ed finan\u010dn\u00ed vizualizaci s funkcemi, jako jsou nap\u0159. <strong>p\u011bt re\u017eim\u016f grafu<\/strong>, <strong>automatick\u00fd v\u00fdpo\u010det odchylky<\/strong>, <strong>p\u0159eru\u0161en\u00ed stupnice pro c\u00edlenou anal\u00fdzu<\/strong>, <strong>vodop\u00e1dov\u00e9 konektory<\/strong>, <strong>p\u0159izp\u016fsobiteln\u00e9 barvy<\/strong>a <strong>citliv\u00e9 datov\u00e9 \u0161t\u00edtky<\/strong>. Automaticky se p\u0159izp\u016fsobuje va\u0161im dat\u016fm, zobrazuje odpov\u00eddaj\u00edc\u00ed vizualizace a nab\u00edz\u00ed kompletn\u00ed mo\u017enosti stylov\u00e1n\u00ed - zaji\u0161\u0165uje p\u0159ehledn\u00e9 a profesion\u00e1ln\u00ed reporty p\u0159\u00edmo v Power BI.<\/p>\n\n<p>Pokud jsou va\u0161e data k dispozici, m\u016f\u017eete nastavit pln\u011b funk\u010dn\u00ed vodop\u00e1dov\u00fd graf - v\u010detn\u011b kategori\u00ed, hodnot, form\u00e1tov\u00e1n\u00ed a v\u00fdb\u011bru re\u017eimu grafu - v \u010d\u00e1sti <strong>2 minuty<\/strong>. Vizu\u00e1ln\u00ed podoba se okam\u017eit\u011b p\u0159izp\u016fsob\u00ed zadan\u00fdm pol\u00edm, co\u017e umo\u017e\u0148uje rychlou konfiguraci s minim\u00e1ln\u00edm \u00fasil\u00edm a poskytuje graf p\u0159ipraven\u00fd k pou\u017eit\u00ed pro finan\u010dn\u00ed t\u00fdmy, vedouc\u00ed pracovn\u00edky a z\u00fa\u010dastn\u011bn\u00e9 strany.<\/p>\n\n\n<h4 class=\"wp-block-heading\" id=\"chart-modes\">Re\u017eimy grafu<\/h4>\n\n\n<p>Vizu\u00e1ln\u00ed nab\u00eddka <strong>p\u011bt re\u017eim\u016f grafu<\/strong> mezi nimi\u017e lze p\u0159ep\u00ednat jedin\u00fdm kliknut\u00edm pomoc\u00ed rozbalovac\u00edho seznamu v z\u00e1hlav\u00ed. Ka\u017ed\u00fd re\u017eim poskytuje jin\u00fd pohled na va\u0161e data:<\/p>\n\n<ul>\n<li><strong>Sloupcov\u00fd graf:<\/strong> Klasick\u00e9 porovn\u00e1vac\u00ed zobrazen\u00ed s nez\u00e1visl\u00fdmi sloupci od nuly<\/li>\n<li><strong>Vodop\u00e1d:<\/strong> Mostn\u00ed graf zn\u00e1zor\u0148uj\u00edc\u00ed, jak hodnoty nar\u016fstaj\u00ed na celkovou hodnotu<\/li>\n<li><strong>Linka:<\/strong> Propojen\u00e9 datov\u00e9 body pro vizualizaci trend\u016f<\/li>\n<li><strong>Oblast:<\/strong> Vypln\u011bn\u00e1 oblast s automatick\u00fdm podbarven\u00edm odchylky (zelen\u00e1 nad z\u00e1kladn\u00ed lini\u00ed, \u010derven\u00e1 pod n\u00ed)<\/li>\n<li><strong>L\u00edz\u00e1tko:<\/strong> \u010cist\u00e1 prezentace se stopkami a te\u010dkami<\/li>\n<\/ul>\n\n<p>P\u0159ep\u00ednejte mezi re\u017eimy, abyste mohli vypr\u00e1v\u011bt r\u016fzn\u00e9 p\u0159\u00edb\u011bhy se stejn\u00fdmi daty - na porad\u011b p\u0159edstavenstva m\u016f\u017eete uk\u00e1zat most a pot\u00e9 p\u0159epnout do re\u017eimu \u0159\u00e1dk\u016f a diskutovat o trendech.<\/p>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">Vodop\u00e1dov\u00e9 konektory<\/h4>\n\n\n<p>Na adrese <strong>Vodop\u00e1d<\/strong> se na displeji automaticky zobraz\u00ed <strong>spojovac\u00ed veden\u00ed<\/strong> (naz\u00fdvan\u00e9 tak\u00e9 p\u0159eklenovac\u00ed \u010d\u00e1ry), kter\u00e9 ukazuj\u00ed, jak jednotliv\u00e9 hodnoty navazuj\u00ed na dal\u0161\u00ed. Tyto vodorovn\u00e9 \u010d\u00e1ry umo\u017e\u0148uj\u00ed okam\u017eit\u011b zjistit, jak pr\u016fb\u011b\u017en\u00fd sou\u010det p\u0159ech\u00e1z\u00ed z jedn\u00e9 kategorie do druh\u00e9, a pom\u00e1haj\u00ed tak z\u00fa\u010dastn\u011bn\u00fdm stran\u00e1m pochopit \"cestu\" od po\u010d\u00e1te\u010dn\u00ed hodnoty ke kone\u010dn\u00e9 hodnot\u011b. Spojnice lze zapnout nebo vypnout na panelu form\u00e1tov\u00e1n\u00ed.<\/p>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">P\u0159eru\u0161en\u00ed stupnice<\/h4>\n\n\n<p>Pokud je z\u00e1kladn\u00ed hodnota v milionech a odchylky v tis\u00edc\u00edch, rozd\u00edly jsou t\u00e9m\u011b\u0159 neviditeln\u00e9. Na <strong>P\u0159eru\u0161en\u00ed stupnice<\/strong> (dostupn\u00e1 v re\u017eimech Line a Area) komprimuje osu Y, aby se zam\u011b\u0159ila na to, co je d\u016fle\u017eit\u00e9 - skute\u010dn\u00fd rozsah dat, a ne na po\u010d\u00e1tek od nuly. Najet\u00edm na graf zobraz\u00edte indik\u00e1tor p\u0159eru\u0161en\u00ed m\u011b\u0159\u00edtka a kliknut\u00edm p\u0159ep\u00edn\u00e1te mezi pln\u00fdm m\u011b\u0159\u00edtkem a komprimovan\u00fdm zobrazen\u00edm. Vizu\u00e1ln\u00ed symbol klikat\u00e9 \u010d\u00e1ry ukazuje, kdy je m\u011b\u0159\u00edtko komprimovan\u00e9.<\/p>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">Indik\u00e1tor porovn\u00e1n\u00ed hodnot<\/h4>\n\n\n<p>Na str\u00e1nk\u00e1ch <strong>Indik\u00e1tor porovn\u00e1n\u00ed hodnot<\/strong> automaticky vypo\u010d\u00edt\u00e1 a zobraz\u00ed rozptyl mezi datov\u00fdmi body. \u0160ipka s barevn\u00fdm k\u00f3dov\u00e1n\u00edm (zelen\u00e1 pro kladn\u00e9 hodnoty, \u010derven\u00e1 pro z\u00e1porn\u00e9) ukazuje sm\u011br a velikost zm\u011bny. Nakonfigurujte ji tak, aby se zobrazovala:<\/p>\n\n<ul>\n<li><strong>Relativn\u00ed (%):<\/strong> Procentu\u00e1ln\u00ed zm\u011bna mezi hodnotami<\/li>\n<li><strong>Absolutn\u00ed:<\/strong> Skute\u010dn\u00fd \u010d\u00edseln\u00fd rozd\u00edl<\/li>\n<li><strong>Oboj\u00ed:<\/strong> Kombinovan\u00e9 zobrazen\u00ed s \u010d\u00e1stkou a procentem<\/li>\n<li><strong>\u017d\u00e1dn\u00e9:<\/strong> Pouze \u0161ipka bez \u0161t\u00edtku<\/li>\n<\/ul>\n\n<p>Zvolte si zp\u016fsoby porovn\u00e1n\u00ed, jako je Prvn\u00ed vs. Posledn\u00ed, P\u0159edchoz\u00ed vs. Posledn\u00ed nebo Nejni\u017e\u0161\u00ed vs. Nejvy\u0161\u0161\u00ed, abyste zv\u00fdraznili odchylku, kter\u00e1 je pro va\u0161i anal\u00fdzu nejd\u016fle\u017eit\u011bj\u0161\u00ed.<\/p>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">Barevn\u00e9 k\u00f3dov\u00e1n\u00ed<\/h4>\n\n\n<p>P\u0159izp\u016fsobte si barvy tak, aby odpov\u00eddaly va\u0161\u00ed firemn\u00ed zna\u010dce, nebo dodr\u017eujte standardy. Nakonfigurujte samostatn\u00e9 barvy pro:<\/p>\n\n<ul>\n<li><strong>Kladn\u00e9 hodnoty:<\/strong> Zv\u00fd\u0161en\u00ed, p\u0159\u00edzniv\u00e9 odchylky (v\u00fdchoz\u00ed: zelen\u00e1)<\/li>\n<li><strong>Z\u00e1porn\u00e9 hodnoty:<\/strong> Sn\u00ed\u017een\u00ed, nep\u0159\u00edzniv\u00e9 odchylky (v\u00fdchoz\u00ed: \u010derven\u00e1)<\/li>\n<li><strong>Celkov\u00fd po\u010det ty\u010d\u00ed:<\/strong> Po\u010d\u00e1te\u010dn\u00ed hodnoty a sou\u010dty (v\u00fdchoz\u00ed: \u0161ed\u00e1)<\/li>\n<\/ul>\n\n<p>V re\u017eimu sloupcov\u00e9ho grafu maj\u00ed v\u0161echny sloupce neutr\u00e1ln\u00ed barvu pro \u010dist\u00e9 srovn\u00e1n\u00ed. V re\u017eimu vodop\u00e1du jsou sloupce automaticky zbarveny podle toho, zda p\u0159edstavuj\u00ed n\u00e1r\u016fst nebo pokles.<\/p>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"troubleshooting\">\u0158e\u0161en\u00ed probl\u00e9m\u016f<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Data se nezobrazuj\u00ed<\/h4>\n\n\n\n<p><strong>Graf se zobraz\u00ed pr\u00e1zdn\u00fd nebo zobraz\u00ed vstupn\u00ed str\u00e1nku:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 Zkontrolujte, zda jsou v podokn\u011b dat namapov\u00e1na pole Kategorie i Hodnota.<\/li>\n\n\n\n<li>\u2705 Zkontrolujte, zda pole Kategorie obsahuje textov\u00e9 hodnoty (ne null).<\/li>\n\n\n\n<li>\u2705 Zajist\u011bte, aby pole Hodnota obsahovalo \u010d\u00edseln\u00e9 \u00fadaje (ne text).<\/li>\n\n\n\n<li>\u2705 Ov\u011b\u0159te, \u017ee v\u00e1\u0161 zdroj dat obsahuje alespo\u0148 jeden \u0159\u00e1dek platn\u00fdch dat.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Probl\u00e9my s re\u017eimem grafu<\/h4>\n\n\n\n<p><strong>Re\u017eim grafu se nep\u0159ep\u00edn\u00e1 nebo se zobrazuje nespr\u00e1vn\u011b:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 K p\u0159ep\u00edn\u00e1n\u00ed re\u017eim\u016f pou\u017eijte rozev\u00edrac\u00ed seznam ve vizu\u00e1ln\u00edm z\u00e1hlav\u00ed<\/li>\n\n\n\n<li>\u2705 Obnoven\u00ed vizu\u00e1lu, pokud se re\u017eim neaktualizuje okam\u017eit\u011b<\/li>\n\n\n\n<li>\u2705 Zkontrolujte, zda je nastaven\u00ed datov\u00fdch \u0161t\u00edtk\u016f vhodn\u00e9 pro zvolen\u00fd re\u017eim.<\/li>\n\n\n\n<li>\u2705 Ov\u011b\u0159te, zda je povoleno nastaven\u00ed konektoru pro vodop\u00e1dov\u00fd re\u017eim<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Nezobrazen\u00ed p\u0159eru\u0161en\u00ed stupnice<\/h4>\n\n\n\n<p><strong>Indik\u00e1tor p\u0159eru\u0161en\u00ed stupnice nen\u00ed viditeln\u00fd:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 P\u0159eru\u0161en\u00ed m\u011b\u0159\u00edtka je k dispozici pouze v re\u017eimech Line a Area.<\/li>\n\n\n\n<li>\u2705 Povolit \"P\u0159eru\u0161en\u00ed m\u011b\u0159\u00edtka\" v nastaven\u00ed osy na panelu form\u00e1tov\u00e1n\u00ed<\/li>\n\n\n\n<li>\u2705 Najet\u00edm na graf se na prav\u00e9m okraji zobraz\u00ed indik\u00e1tor p\u0159eru\u0161en\u00ed stupnice.<\/li>\n\n\n\n<li>\u2705 Kliknut\u00edm na indik\u00e1tor p\u0159epnete mezi pln\u00fdm a komprimovan\u00fdm zobrazen\u00edm.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Probl\u00e9my se zobrazen\u00edm \u0161t\u00edtk\u016f<\/h4>\n\n\n\n<p><strong>Nezobrazuj\u00ed se nebo se p\u0159ekr\u00fdvaj\u00ed popisky dat:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 Povolit \"Zobrazit \u0161t\u00edtky dat\" v nastaven\u00ed \u0161t\u00edtk\u016f dat<\/li>\n\n\n\n<li>\u2705 Vyzkou\u0161ejte r\u016fzn\u00e9 polohy \u0161t\u00edtk\u016f (Auto, Inside, Outside)<\/li>\n\n\n\n<li>\u2705 Zmen\u0161it velikost p\u00edsma, pokud se \u0161t\u00edtky p\u0159ekr\u00fdvaj\u00ed<\/li>\n\n\n\n<li>\u2705 \u0160t\u00edtky automaticky upravuj\u00ed form\u00e1t (K, M, B) na z\u00e1klad\u011b velikosti hodnoty<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Osv\u011bd\u010den\u00e9 postupy<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Kvalita dat<\/strong>: Zajist\u011bte, aby kategorie byly jedine\u010dn\u00e9 a hodnoty \u010d\u00edseln\u00e9; vyhn\u011bte se nulov\u00fdm hodnot\u00e1m.<\/li>\n\n\n\n<li><strong>Kategorie Objedn\u00e1vka<\/strong>: Se\u0159a\u010fte data v po\u0159ad\u00ed, v jak\u00e9m je chcete zobrazit (chronologicky pro \u010dasov\u00e9 \u0159ady, logicky pro rozd\u011blen\u00ed n\u00e1klad\u016f).<\/li>\n\n\n\n<li><strong>V\u00fdb\u011br re\u017eimu grafu<\/strong>: Pou\u017eijte vodop\u00e1d pro mosty, sloupcov\u00fd graf pro srovn\u00e1n\u00ed, \u010d\u00e1rov\u00fd\/plo\u0161n\u00fd graf pro trendy.<\/li>\n\n\n\n<li><strong>Konzistence barev<\/strong>: Pou\u017e\u00edvejte jednotn\u00e9 barvy pro v\u0161echny zpr\u00e1vy (zelen\u00e1 pro pozitivn\u00ed, \u010derven\u00e1 pro negativn\u00ed).<\/li>\n\n\n\n<li><strong>Pou\u017e\u00edv\u00e1n\u00ed p\u0159est\u00e1vek v m\u011b\u0159\u00edtku<\/strong>: Povolit pro re\u017eimy \u010c\u00e1ra\/Plocha, pokud v zobrazen\u00ed p\u0159eva\u017euje z\u00e1kladn\u00ed linie.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">P\u0159\u00edpady pou\u017eit\u00ed Reference<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>P\u0159\u00edpad pou\u017eit\u00ed<\/strong><\/th><th><strong>Doporu\u010den\u00fd re\u017eim<\/strong><\/th><th><strong>Kl\u00ed\u010dov\u00e9 vlastnosti<\/strong><\/th><th><strong>P\u0159\u00edklad dat<\/strong><\/th><\/tr><\/thead><tbody><tr><td><strong>P\u0159\u00edjmov\u00fd most<\/strong><\/td><td>Vodop\u00e1d<\/td><td>Konektory, Barevn\u00e9 k\u00f3dov\u00e1n\u00ed<\/td><td>P\u0159edchoz\u00ed rok \u2192 Cena \u2192 Objem \u2192 Mix \u2192 Aktu\u00e1ln\u00ed rok<\/td><\/tr><tr><td><strong>Rozd\u00edl v rozpo\u010dtu<\/strong><\/td><td>Sloupcov\u00fd graf<\/td><td>Indik\u00e1tor odchylky, \u0161t\u00edtky<\/td><td>Rozpo\u010det vs. skute\u010dnost podle odd\u011blen\u00ed<\/td><\/tr><tr><td><strong>M\u011bs\u00ed\u010dn\u00ed trend<\/strong><\/td><td>Linie \/ oblast<\/td><td>P\u0159eru\u0161en\u00ed m\u011b\u0159\u00edtka, trendov\u00e9 \u010d\u00e1ry<\/td><td>P\u0159\u00edjmy podle m\u011bs\u00edc\u016f (leden-prosinec)<\/td><\/tr><tr><td><strong>Rozd\u011blen\u00ed n\u00e1klad\u016f<\/strong><\/td><td>Vodop\u00e1d<\/td><td>Pr\u016fb\u011b\u017en\u00e9 sou\u010dty, Celkov\u00e9 sou\u010dty<\/td><td>Celkov\u00e9 n\u00e1klady \u2192 Komponenty \u2192 \u010cist\u00e9 n\u00e1klady<\/td><\/tr><tr><td><strong>Proch\u00e1zka P&amp;L<\/strong><\/td><td>Vodop\u00e1d<\/td><td>Konektory, Barevn\u00e9 k\u00f3dov\u00e1n\u00ed<\/td><td>Tr\u017eby \u2192 COGS \u2192 OpEx \u2192 EBIT<\/td><\/tr><tr><td><strong>Meziro\u010dn\u00ed srovn\u00e1n\u00ed<\/strong><\/td><td>Sloupcov\u00fd graf<\/td><td>\u0160ipka odchylky, \u0161t\u00edtky<\/td><td>Leto\u0161n\u00ed a lo\u0148sk\u00fd rok podle produktu<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">Podporovan\u00e9 zdroje dat<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong>Zdroj dat<\/strong><\/th><th><strong>Stav<\/strong><\/th><th><strong>Pozn\u00e1mky k integraci<\/strong><\/th><\/tr><\/thead><tbody><tr><td><strong>Excel\/CSV<\/strong><\/td><td>\u2705 Prim\u00e1rn\u00ed<\/td><td>P\u0159\u00edm\u00fd import do Power BI se sloupci Kategorie a Hodnota<\/td><\/tr><tr><td><strong>SQL Server<\/strong><\/td><td>\u2705 Prim\u00e1rn\u00ed<\/td><td>P\u0159\u00edm\u00e9 p\u0159ipojen\u00ed nebo re\u017eim importu<\/td><\/tr><tr><td><strong>SAP<\/strong><\/td><td>\u2705 Prim\u00e1rn\u00ed<\/td><td>SAP BW, SAP HANA prost\u0159ednictv\u00edm konektor\u016f Power BI<\/td><\/tr><tr><td><strong>Oracle<\/strong><\/td><td>\u2705 Prim\u00e1rn\u00ed<\/td><td>P\u0159\u00edm\u00e9 p\u0159ipojen\u00ed p\u0159es konektor Oracle<\/td><\/tr><tr><td><strong>Dynamics 365<\/strong><\/td><td>\u2705 Prim\u00e1rn\u00ed<\/td><td>Finan\u010dn\u00ed a provozn\u00ed data prost\u0159ednictv\u00edm slu\u017eby Dataverse<\/td><\/tr><tr><td><strong>SharePoint<\/strong><\/td><td>\u2705 Sekund\u00e1rn\u00ed<\/td><td>Soubory Excel nebo seznamy SharePoint<\/td><\/tr><tr><td><strong>Azure Synapse<\/strong><\/td><td>\u2705 Prim\u00e1rn\u00ed<\/td><td>P\u0159\u00edm\u00e9 napojen\u00ed na analytick\u00e1 data<\/td><\/tr><tr><td><strong>Datov\u00e9 toky<\/strong><\/td><td>\u2705 Prim\u00e1rn\u00ed<\/td><td>Datov\u00e9 toky Power BI pro p\u0159ipraven\u00e1 data<\/td><\/tr><\/tbody><\/table><\/figure>","protected":false},"excerpt":{"rendered":"<p>Minimum Requirements | License | Features | Chart Modes | Troubleshooting Finance teams across industries use the LeapLytics Waterfall &#038; Variance visual to present budget variances, revenue bridges, cost breakdowns, and P&#038;L analysis directly inside Power BI. The visual is fast and built for professional financial reporting. With features such as five chart modes, automatic &hellip; <\/p>","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-14545","page","type-page","status-publish","hentry","latest_post"],"_links":{"self":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages\/14545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/comments?post=14545"}],"version-history":[{"count":3,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages\/14545\/revisions"}],"predecessor-version":[{"id":14559,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages\/14545\/revisions\/14559"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/media?parent=14545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}