{"id":14529,"date":"2026-01-07T21:00:48","date_gmt":"2026-01-07T20:00:48","guid":{"rendered":"https:\/\/www.leaplytics.de\/?page_id=14529"},"modified":"2026-01-07T21:00:49","modified_gmt":"2026-01-07T20:00:49","slug":"odchylka-vodopadu","status":"publish","type":"page","link":"https:\/\/www.leaplytics.de\/sk\/odchylka-vodopadu\/","title":{"rendered":"Vodop\u00e1d a odch\u00fdlka"},"content":{"rendered":"

Jedin\u00fd vodop\u00e1dov\u00fd graf vytvoren\u00fd pre finan\u010dn\u00e9 t\u00edmy, ktor\u00e9 potrebuj\u00fa vysvetli\u0165 \"pre\u010do\" v Power BI<\/h3>\n\n\n\n

Ak prezentujete anal\u00fdzu odch\u00fdlok v Power BI a zainteresovan\u00e9 strany sa neust\u00e1le p\u00fdtaj\u00fa \"ale \u010do sa zmenilo?\"... ak manu\u00e1lne vytv\u00e1rate preklenovacie grafy v Exceli, preto\u017ee nat\u00edvne grafy Power BI nedok\u00e1\u017eu zobrazi\u0165 rozpis... ak v\u00e1\u0161 finan\u010dn\u00fd riadite\u013e chce vidie\u0165 pl\u00e1n vs. skuto\u010dnos\u0165 s jasn\u00fdmi ukazovate\u013emi odch\u00fdlok a vy to nedok\u00e1\u017eete poskytn\u00fa\u0165...<\/p>\n\n\n\n

Nie ste sami.<\/strong><\/p>\n\n\n\n

Toto je to, \u010do je in\u00e9: Toto nie je \u010fal\u0161\u00ed z\u00e1kladn\u00fd vizu\u00e1l vodop\u00e1du. Ide o kompletn\u00fd syst\u00e9m anal\u00fdzy odch\u00fdlok s piatimi re\u017eimami grafu (st\u013apcov\u00fd, vodop\u00e1dov\u00fd, \u010diarov\u00fd, plo\u0161n\u00fd, l\u00edzatko), automatick\u00fdmi v\u00fdpo\u010dtami odch\u00fdlok so \u0161\u00edpkami odch\u00fdlok, porovnan\u00edm pl\u00e1n vs. skuto\u010dnos\u0165 vs. odhad a funkciou preru\u0161enia mierky, ktor\u00e1 v\u00e1m umo\u017en\u00ed zamera\u0165 sa na to, \u010do je d\u00f4le\u017eit\u00e9 - nie na z\u00e1kladn\u00fa l\u00edniu.<\/p>\n\n\n\n

<\/div>\n\n\n\n

Skuto\u010dn\u00e9 finan\u010dn\u00e9 t\u00edmy. Skuto\u010dn\u00e9 v\u00fdsledky.<\/h3>\n\n\n\n

\"Na\u0161ej rade mesa\u010dne predklad\u00e1me anal\u00fdzu odch\u00fdlok. Pred touto vizu\u00e1lnou aplik\u00e1ciou sme exportovali do Excelu, ru\u010dne vytv\u00e1rali preklenovacie grafy a kop\u00edrovali ich do PowerPointu. Teraz? Most\u00edky pr\u00edjmov, rozpisy n\u00e1kladov a prech\u00e1dzky mar\u017eami zobrazujeme priamo v Power BI. V\u010faka \u0161\u00edpkam odch\u00fdlok je okam\u017eite jasn\u00e9, \u010do ovplyv\u0148uje v\u00fdkonnos\u0165. Na\u0161e zasadnutia spr\u00e1vnej rady s\u00fa kone\u010dne produkt\u00edvne.\"<\/em><\/p>\n\n\n\n

- Riadite\u013e FP&A, v\u00fdrobn\u00e1 spolo\u010dnos\u0165<\/strong><\/p>\n\n\n\n

<\/div>\n\n\n\n

Tu je to, \u010do dostanete (\u010do nem\u00f4\u017eete dosta\u0165 nikde inde)<\/h3>\n\n\n\n

5 re\u017eimov grafu, jeden vizu\u00e1lny<\/strong>
St\u013apcov\u00fd graf. Vodop\u00e1d. L\u00ednia. Plocha. Lollipop. Prep\u00ednajte medzi nimi jedn\u00fdm kliknut\u00edm. Rovnak\u00e9 \u00fadaje, r\u00f4zne perspekt\u00edvy. Zobrazte most\u00edk, potom trend - bez toho, aby ste museli \u010doko\u013evek prestavova\u0165.<\/p>\n\n\n\n

\u0160\u00edpky odch\u00fdlok, ktor\u00e9 rozpr\u00e1vaj\u00fa pr\u00edbeh<\/strong>
Automatick\u00fd v\u00fdpo\u010det odch\u00fdlky medzi \u013eubovo\u013en\u00fdmi dvoma hodnotami. \u0160\u00edpky hore\/dole s farebn\u00fdm ozna\u010den\u00edm. Zobrazenie absol\u00fatnej a relat\u00edvnej (percentu\u00e1lnej) odch\u00fdlky. Va\u0161i ved\u00faci pracovn\u00edci kone\u010dne pochopia, \u010do riadi \u010d\u00edsla.<\/p>\n\n\n\n

Rozdelenie stupnice pre cielen\u00fa anal\u00fdzu<\/strong>
Ke\u010f je va\u0161a z\u00e1kladn\u00e1 hodnota 10 mili\u00f3nov a odch\u00fdlky s\u00fa 50 tis\u00edc, st\u013apce sa stan\u00fa nevidite\u013en\u00fdmi. Na\u0161a funkcia prelomenia mierky stla\u010d\u00ed os Y, aby sa zobrazilo len to, \u010do je d\u00f4le\u017eit\u00e9. Kliknut\u00edm prepnete. Pozrite si skuto\u010dn\u00e9 rozdiely.<\/p>\n\n\n\n

Porovnanie pl\u00e1nu a skuto\u010dnosti a odhadu<\/strong>
Tri zabudovan\u00e9 re\u017eimy porovn\u00e1vania. Zobrazenie odch\u00fdlok medzi pl\u00e1nom a skuto\u010dnos\u0165ou. Sledovanie odhadov v porovnan\u00ed s v\u00fdsledkami. Ukazovatele odch\u00fdlok upozor\u0148uj\u00fa na to, \u010do je vpredu a \u010do pozadu.<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n

Presne to, \u010do sme potrebovali<\/p>\n\"Pre\u0161li sme z konkuren\u010dn\u00e9ho vizu\u00e1lu, ktor\u00fd nedok\u00e1zal spr\u00e1vne zobrazi\u0165 z\u00e1porn\u00e9 odch\u00fdlky. Tento vizu\u00e1l spr\u00e1vne spracov\u00e1va kladn\u00e9 a z\u00e1porn\u00e9 hodnoty, zobrazuje priebe\u017en\u00e9 s\u00fa\u010dty v re\u017eime vodop\u00e1du a v\u010faka spojovac\u00edm \u010diaram je tok kri\u0161t\u00e1\u013eovo jasn\u00fd. Vrelo odpor\u00fa\u010dam.\"

Recenzia aplik\u00e1cie Microsoft AppSource<\/strong> \"\"<\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n

Skuto\u010dn\u00e1 cena za to, \u017ee to nem\u00e1te<\/h3>\n\n\n\n

Pre finan\u010dn\u00e9 t\u00edmy:<\/strong><\/p>\n\n\n\n

    \n
  • Str\u00e1vite viac ako 4 hodiny mesa\u010dne ru\u010dn\u00fdm vytv\u00e1ran\u00edm preklenovac\u00edch grafov v programe Excel<\/li>\n\n\n\n
  • Ved\u00faci pracovn\u00edci nerozumej\u00fa va\u0161im spr\u00e1vam o odch\u00fdlkach, preto\u017ee s\u00fa to len tabu\u013eky \u010d\u00edsel<\/li>\n\n\n\n
  • Porovnanie pl\u00e1nu a skuto\u010dnosti si vy\u017eaduje viacero vizu\u00e1lov, ktor\u00e9 nie s\u00fa spr\u00e1vne synchronizovan\u00e9<\/li>\n\n\n\n
  • Mal\u00e9 odch\u00fdlky nie s\u00fa vidite\u013en\u00e9, preto\u017ee na stupnici dominuj\u00fa ve\u013ek\u00e9 z\u00e1kladn\u00e9 hodnoty<\/li>\n\n\n\n
  • Nem\u00f4\u017eete zobrazi\u0165 \"prech\u00e1dzku\" od jednej hodnoty k druhej bez toho, aby ste grafy prestavali od za\u010diatku<\/li>\n<\/ul>\n\n\n\n

    Pre kontrol\u00f3rov a FP&A:<\/strong><\/p>\n\n\n\n

      \n
    • Mesa\u010dn\u00e1 uz\u00e1vierka trv\u00e1 dlh\u0161ie, preto\u017ee vysvetlenie odch\u00fdlok si vy\u017eaduje manu\u00e1lne zostavenie grafu<\/li>\n\n\n\n
    • Prezent\u00e1cie na n\u00e1stenk\u00e1ch vy\u017eaduj\u00fa export do programu PowerPoint a stratu interaktivity<\/li>\n\n\n\n
    • Nem\u00f4\u017eete sa dopracova\u0165 k odch\u00fdlkam, preto\u017ee va\u0161e grafy s\u00fa statick\u00e9 obr\u00e1zky.<\/li>\n\n\n\n
    • Prep\u00ednanie medzi r\u00f4znymi zobrazeniami (st\u013apcov\u00e9, vodop\u00e1dov\u00e9, trendov\u00e9) znamen\u00e1 udr\u017eiavanie viacer\u00fdch vizu\u00e1lov<\/li>\n\n\n\n
    • Zainteresovan\u00e9 strany sa p\u00fdtaj\u00fa \"\u010do sa zmenilo?\" a vy mus\u00edte ru\u010dne vypo\u010d\u00edta\u0165 odpove\u010f<\/li>\n<\/ul>\n\n\n\n

      Z\u00e1ver?<\/strong> Str\u00e1vite hodiny vytv\u00e1ran\u00edm diagramu, ktor\u00e9 by malo trva\u0165 nieko\u013eko min\u00fat. A va\u0161e zainteresovan\u00e9 strany s\u00fa st\u00e1le zm\u00e4ten\u00e9 z toho, \u010do je pr\u00ed\u010dinou \u010d\u00edsel.<\/p>\n\n\n\n

      <\/div>\n\n\n\n
      \n
      <\/div>\n\n\n\n

      \u010co skuto\u010dne z\u00edskate<\/strong><\/h3>\n\n\n\n

      Ka\u017ed\u00e1 funkcia. Bez kompromisov. Vytvoren\u00e9 finan\u010dn\u00fdmi profesion\u00e1lmi pre finan\u010dn\u00fdch profesion\u00e1lov.<\/em><\/p>\n\n\n\n

      <\/div>\n\n\n\n
      \n
      \n
      \"\"<\/figure>
      \n

      5 re\u017eimov grafu<\/strong><\/p>\n\n\n\n

      St\u013apcov\u00fd graf. Vodop\u00e1d. L\u00ednia. Plocha. Lollipop. Okam\u017eit\u00e9 prep\u00ednanie pomocou rozba\u013eovacieho zoznamu. Rovnak\u00e9 \u00fadaje, in\u00fd pr\u00edbeh. Zobrazte, \u010do je d\u00f4le\u017eit\u00e9 pre ka\u017ed\u00e9 publikum.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n

      <\/div>\n\n\n\n
      \n
      \n
      \"\"<\/figure>
      \n

      \u0160\u00edpky odch\u00fdlky<\/strong><\/p>\n\n\n\n

      Automatick\u00fd v\u00fdpo\u010det odch\u00fdlky. Indik\u00e1tory smeru hore\/dole. Zelen\u00e1 pre pozit\u00edvne, \u010derven\u00e1 pre negat\u00edvne. Absol\u00fatne hodnoty alebo percent\u00e1. Va\u0161e zainteresovan\u00e9 strany to kone\u010dne pochopia.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n

      \n
      \"\"<\/figure>
      \n

      Prest\u00e1vka v mierke<\/strong><\/p>\n\n\n\n

      Stla\u010dte os Y, aby ste sa zamerali na odch\u00fdlky, nie na z\u00e1kladn\u00e9 hodnoty. Prep\u00ednanie jedn\u00fdm kliknut\u00edm. Zobrazte mal\u00e9 zmeny, ktor\u00e9 s\u00fa d\u00f4le\u017eit\u00e9, aj ke\u010f s\u00fa z\u00e1kladn\u00e9 hodnoty ve\u013ek\u00e9.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n

      <\/div>\n\n\n\n
      \n
      \n
      \"\"<\/figure>
      \n

      Vodop\u00e1dov\u00e9 konektory<\/strong><\/p>\n\n\n\n

      Vizu\u00e1lne prietokov\u00e9 \u010diary medzi pruhmi. Pozrite sa, ako ka\u017ed\u00fd krok nadv\u00e4zuje na predch\u00e1dzaj\u00faci. Automaticky vypo\u010d\u00edtan\u00e9 priebe\u017en\u00e9 s\u00fa\u010dty. Preklenovac\u00ed graf, o ktor\u00fd \u017eiadal v\u00e1\u0161 finan\u010dn\u00fd riadite\u013e.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n

      <\/div>\n\n\n\n
      \n
      \n
      \"\"<\/figure>
      \n

      Plne reaguje<\/strong><\/p>\n\n\n\n

      Funguje na akejko\u013evek ve\u013ekosti obrazovky. Od dla\u017ed\u00edc na pr\u00edstrojovej doske a\u017e po prezent\u00e1cie na cel\u00fa obrazovku. \u0160t\u00edtky, \u0161\u00edpky a odstupy sa automaticky \u0161k\u00e1luj\u00fa. V\u0161ade vyzer\u00e1 profesion\u00e1lne.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n

      <\/div>\n<\/div><\/div>\n\n\n\n
      <\/div>\n\n\n\n

      Ako za\u010da\u0165 (je to hl\u00fapo jednoduch\u00e9)<\/h3>\n\n\n\n

      Krok 1:<\/strong> Po\u017eiadajte o sk\u00fa\u0161obn\u00fa licenciu ni\u017e\u0161ie (trv\u00e1 30 sek\u00fand)<\/p>\n\n\n\n

      Krok 2:<\/strong> In\u0161tal\u00e1cia vizu\u00e1lu v Power BI (trv\u00e1 2 min\u00faty)<\/p>\n\n\n\n

      Krok 3:<\/strong> Pripojenie \u00fadajov - kateg\u00f3ria, hodnota, pr\u00edpadne porovn\u00e1vacia hodnota (trv\u00e1 5 min\u00fat)<\/p>\n\n\n\n

      Krok 4:<\/strong> Sledujte, ako va\u0161e zainteresovan\u00e9 strany kone\u010dne pochopia, \u010do je pr\u00ed\u010dinou \u010d\u00edsel<\/p>\n\n\n\n

      To je v\u0161etko. \u017diadni konzultanti. \u017diadne \u0161kolenia. \u017diadne zlo\u017eit\u00e9 nastavenie. Sta\u010d\u00ed pripoji\u0165 \u00fadaje a za\u010da\u0165.<\/p>\n\n\n\n

      <\/div>\n\n\n\n

      Pre koho to je (a pre koho to nie je)<\/h3>\n\n\n\n

      Toto je pre v\u00e1s, ak:<\/strong><\/p>\n\n\n\n

        \n
      • Ste v FP&A<\/strong> a potrebu vysvetli\u0165 odch\u00fdlky v rozpo\u010dte ved\u00facim pracovn\u00edkom<\/li>\n\n\n\n
      • Ste Ovl\u00e1da\u010d<\/strong> prezent\u00e1cia v\u00fdsledkov mesa\u010dnej uz\u00e1vierky s anal\u00fdzou odch\u00fdlok<\/li>\n\n\n\n
      • Ste Obchodn\u00fd analytik<\/strong> vytv\u00e1ranie informa\u010dn\u00fdch panelov, ktor\u00e9 musia ukazova\u0165 \"pre\u010do\" za zmenami.<\/li>\n\n\n\n
      • Mus\u00edte zobrazi\u0165 pr\u00edjmov\u00e9 most\u00edky, \u010dlenenie n\u00e1kladov alebo prech\u00e1dzky s mar\u017eou<\/li>\n\n\n\n
      • Chcete porovnanie pl\u00e1nu so skuto\u010dnos\u0165ou s jasn\u00fdmi ukazovate\u013emi odch\u00fdlky<\/li>\n\n\n\n
      • U\u017e v\u00e1s nebav\u00ed vytv\u00e1ra\u0165 grafy most\u00edkov v programe Excel a kop\u00edrova\u0165 ich do prezent\u00e1ci\u00ed<\/li>\n\n\n\n
      • Va\u0161e zainteresovan\u00e9 strany sa p\u00fdtaj\u00fa \"\u010do sa zmenilo?\" a vy im to mus\u00edte n\u00e1zorne uk\u00e1za\u0165.<\/li>\n<\/ul>\n\n\n\n

        Toto NIE JE pre v\u00e1s, ak:<\/strong><\/p>\n\n\n\n

          \n
        • Potrebujete len jednoduch\u00fd st\u013apcov\u00fd graf bez anal\u00fdzy odch\u00fdlok (pou\u017eite vstavan\u00fd program Power BI)<\/li>\n\n\n\n
        • Nemus\u00edte vysvet\u013eova\u0165 zmeny ani ukazova\u0165 prechod medzi hodnotami<\/li>\n\n\n\n
        • Nepou\u017e\u00edvate Power BI (toto je vlastn\u00fd vizu\u00e1l Power BI)<\/li>\n\n\n\n
        • H\u013ead\u00e1te bezplatn\u00fd softv\u00e9r (toto je profesion\u00e1lny softv\u00e9r s podporou)<\/li>\n<\/ul>\n\n\n\n
          <\/div>\n\n\n\n

          Naj\u010dastej\u0161ie ot\u00e1zky (predt\u00fdm, ako sa op\u00fdtate)<\/h3>\n\n\n\n

          Ot\u00e1zka: Funguje s moj\u00edm existuj\u00facim d\u00e1tov\u00fdm modelom Power BI?<\/strong>
          Odpove\u010f: \u00c1no. Potrebujete pole Kateg\u00f3ria a pole Hodnota. Pr\u00edpadne pridajte pole Comparison Value (Porovn\u00e1vacia hodnota) na anal\u00fdzu odch\u00fdlok. Funguje s ak\u00fdmko\u013evek zdrojom \u00fadajov, ktor\u00fd Power BI podporuje.<\/p>\n\n\n\n

          Ot\u00e1zka: M\u00f4\u017eem prep\u00edna\u0165 medzi re\u017eimami grafu bez prestavovania?<\/strong>
          Odpove\u010f: \u00c1no. Prep\u00edna\u010d Bar, Waterfall, Line, Area, Lollipop s jedn\u00fdm rozba\u013eovac\u00edm zoznamom. Tie ist\u00e9 \u00fadaje, in\u00e1 vizualiz\u00e1cia. Okam\u017eit\u00e9.<\/p>\n\n\n\n

          Ot\u00e1zka: Ako funguje \u0161\u00edpka odch\u00fdlky?<\/strong>
          Odpove\u010f: Pridajte k \u00fadajom hodnotu Porovnanie. Vizu\u00e1l automaticky vypo\u010d\u00edta rozdiel a zobraz\u00ed \u0161\u00edpku hore\/dole s v\u00fd\u0161kou odch\u00fdlky alebo percentom.<\/p>\n\n\n\n

          Ot\u00e1zka: Ak\u00e1 je funkcia prelomenia stupnice?<\/strong>
          Odpove\u010f: V re\u017eime \u010diary alebo oblasti prejdite nad graf a kliknite na indik\u00e1tor preru\u0161enia mierky. Stla\u010d\u00ed os Y, aby sa zamerala na rozsah \u00fadajov namiesto toho, aby za\u010d\u00ednala od nuly. Kedyko\u013evek prepnite sp\u00e4\u0165.<\/p>\n\n\n\n

          Ot\u00e1zka: M\u00f4\u017eem prisp\u00f4sobi\u0165 farby tak, aby zodpovedali na\u0161ej firemnej zna\u010dke?<\/strong>
          Odpove\u010f: V\u0161etko je mo\u017en\u00e9 prisp\u00f4sobi\u0165. Pozit\u00edvne\/negat\u00edvne farby. Celkov\u00e1 farba li\u0161ty. Farby \u0161t\u00edtkov. Ve\u013ekosti p\u00edsma. Spojovacie \u010diary. Zos\u00fala\u010fte ho so svojou zna\u010dkou.<\/p>\n\n\n\n

          Ot\u00e1zka: Spracov\u00e1va spr\u00e1vne z\u00e1porn\u00e9 hodnoty?<\/strong>
          Odpove\u010f: \u00c1no. Z\u00e1porn\u00e9 st\u013apce klesaj\u00fa. Kladn\u00e9 st\u013apce id\u00fa nahor. Re\u017eim vodop\u00e1du zobrazuje spr\u00e1vny priebe\u017en\u00fd s\u00fa\u010det. Vizu\u00e1l spr\u00e1vne sprac\u00fava zmie\u0161an\u00e9 kladn\u00e9\/z\u00e1porn\u00e9 \u00fadaje.<\/p>\n\n\n\n

          <\/div>\n\n\n\n

          \u010co sa stane po vy\u017eiadan\u00ed sk\u00fa\u0161obnej licencie<\/h3>\n\n\n\n
            \n
          1. Vypln\u00edte vy\u0161\u0161ie uveden\u00fd formul\u00e1r (30 sek\u00fand)<\/li>\n\n\n\n
          2. E-mailom v\u00e1m za\u0161leme sk\u00fa\u0161obn\u00fd licen\u010dn\u00fd k\u00f3d (do 24 hod\u00edn)<\/li>\n\n\n\n
          3. In\u0161tal\u00e1cia vizu\u00e1lnej aplik\u00e1cie zo slu\u017eby Microsoft AppSource (2 min\u00faty)<\/li>\n\n\n\n
          4. Zad\u00e1te svoj licen\u010dn\u00fd k\u00f3d do okna form\u00e1tu (10 sek\u00fand).<\/li>\n\n\n\n
          5. Spoj\u00edte polia kateg\u00f3rie a hodnoty (2 min\u00faty)<\/li>\n\n\n\n
          6. Svoje \u00fadaje vid\u00edte ako vodop\u00e1d s ukazovate\u013emi odch\u00fdlok<\/li>\n\n\n\n
          7. Ak chcete zobrazi\u0165 trend, prepnite sa do re\u017eimu Line<\/li>\n\n\n\n
          8. V\u00e1\u0161 finan\u010dn\u00fd riadite\u013e sa p\u00fdta: \"Pre\u010do sme to nemali u\u017e sk\u00f4r?\"<\/li>\n<\/ol>\n\n\n\n

            Potom sa rozhodnite: Rozhodnite sa, \u010di ho budete pou\u017e\u00edva\u0165 \u010falej (zak\u00fapte si licenciu), alebo sa vr\u00e1tite k ru\u010dn\u00e9mu vytv\u00e1raniu grafov most\u00edkov v Exceli (pros\u00edm, nepou\u017e\u00edvajte).<\/p>\n\n\n\n

            <\/div>\n\n\n\n

            Vy\u017eiadajte si sk\u00fa\u0161obn\u00fa licenciu<\/h3>\n\n\n\n\n\n\n
            <\/div>\n\n\n\n

            E\u0161te jedna vec (Z\u00e1ruka)<\/h3>\n\n\n\n

            Sme presved\u010den\u00ed, \u017ee toto je najlep\u0161\u00ed vizu\u00e1l odch\u00fdlky vodop\u00e1du pre Power BI. Obdobie. Ale nebudeme dr\u017ea\u0165 va\u0161e peniaze ako rukojemn\u00edkov, ak s t\u00fdm nes\u00fahlas\u00edte.<\/p>\n\n\n\n

            Vysk\u00fa\u0161ajte sk\u00fa\u0161obn\u00fa licenciu. Ak nezobrazuje jasne odch\u00fdlky, plynule neprep\u00edna medzi re\u017eimami grafu alebo nezlep\u0161uje va\u0161e finan\u010dn\u00e9 prezent\u00e1cie - povedzte n\u00e1m to. Vyrie\u0161ime to alebo v\u00e1m vr\u00e1time peniaze. \u017diadne prek\u00e1\u017eky.<\/p>\n\n\n\n

            Vytvorili sme ju, preto\u017ee sme boli frustrovan\u00ed z anal\u00fdzy odch\u00fdlok v Power BI. Pou\u017e\u00edvame to. Na\u0161i klienti to pou\u017e\u00edvaj\u00fa pri prezent\u00e1ci\u00e1ch na spr\u00e1vnej rade. Funguje to.<\/p>\n\n\n\n

            Vy\u017eiadajte si sk\u00fa\u0161obn\u00fa licenciu ni\u017e\u0161ie. Vysk\u00fa\u0161ajte, ako funguje vo va\u0161om prostred\u00ed s va\u0161imi \u00fadajmi.<\/strong><\/p>\n\n\n\n

            <\/div>\n\n\n\n

            Od gener\u00e1lneho riadite\u013ea (pre\u010do sme to postavili)<\/h3>\n\n\n\n
            \n

            \"\"<\/p>\n\n\n\n

            Ja som Stefan. Gener\u00e1lny riadite\u013e spolo\u010dnosti LeapLytics.

            Vytvorili sme ju, preto\u017ee anal\u00fdza odch\u00fdlok v aplik\u00e1cii Power BI bola nefunk\u010dn\u00e1.

            Ka\u017ed\u00fd vizu\u00e1l vodop\u00e1du bol bu\u010f pr\u00edli\u0161 jednoduch\u00fd (len st\u013apce, bez odch\u00fdlok), alebo pr\u00edli\u0161 komplikovan\u00fd (vy\u017eadoval konfigur\u00e1ciu d\u00e1tov\u00e9ho vedca).

            Finan\u010dn\u00e9 t\u00edmy vytv\u00e1rali preklenovacie grafy v programe Excel a potom ich pren\u00e1\u0161ali do informa\u010dn\u00fdch panelov Power BI. Kontrol\u00f3ri nemohli zobrazi\u0165 pl\u00e1n v porovnan\u00ed so skuto\u010dnos\u0165ou so spr\u00e1vnymi ukazovate\u013emi odch\u00fdlky. FP&A tr\u00e1vil hodiny nad grafmi, ktor\u00e9 mali trva\u0165 nieko\u013eko min\u00fat.

            Tak sme postavili to, \u010do sme skuto\u010dne chceli:

            \u2192 5 re\u017eimov grafu v jednom vizu\u00e1li (nie 5 samostatn\u00fdch vizu\u00e1lov)
            \u2192 Automatick\u00fd v\u00fdpo\u010det odch\u00fdlky pomocou \u0161\u00edpok (nie manu\u00e1lne vzorce)
            \u2192 Rozdelenie stupnice pre cielen\u00fa anal\u00fdzu (nie nevidite\u013en\u00e9 pruhy)
            \u2192 Responz\u00edvny dizajn, ktor\u00fd funguje v\u0161ade (nie \"ru\u010dn\u00e1 zmena ve\u013ekosti\")
            \u2192 Vodop\u00e1dov\u00e9 konektory, ktor\u00e9 zobrazuj\u00fa tok (nie odpojen\u00e9 pruhy)
            \u2192 Porovnanie pl\u00e1n vs. skuto\u010dnos\u0165 vs. odhad (nie \"vybra\u0165 jedno\")

            Tento n\u00e1stroj pou\u017e\u00edvame interne. Na\u0161i poradensk\u00ed klienti ho pou\u017e\u00edvaj\u00fa na prezent\u00e1cie pre spr\u00e1vnu radu. Nie je dokonal\u00fd, ale je to najlep\u0161\u00ed vizu\u00e1lny n\u00e1stroj na zobrazenie odch\u00fdlok vodop\u00e1du v Power BI. Ove\u013ea.

            Ak vysvet\u013eujete odch\u00fdlky, vytv\u00e1rate preklenovacie grafy alebo ukazujete \"pre\u010do\" za va\u0161imi \u010d\u00edslami - toto je pre v\u00e1s.

            Stefan Preusler
            Gener\u00e1lny riadite\u013e, LeapLytics GmbH<\/p>\n<\/blockquote>\n\n\n\n

            <\/div>\n\n\n\n

            Za\u010dnite<\/h3>\n\n\n\n

            Vy\u017eiadajte si sk\u00fa\u0161obn\u00fa licenciu vy\u0161\u0161ie. K\u00f3d v\u00e1m po\u0161leme e-mailom do 24 hod\u00edn. In\u0161tal\u00e1cia z AppSource. Zadajte licenciu. Pripojte svoje \u00fadaje. Pozrite si, ako va\u0161a anal\u00fdza odch\u00fdlok o\u017e\u00edva.<\/p>\n\n\n\n

            <\/div>\n\n\n\n

            \u00dapln\u00fd zoznam funkci\u00ed (aby ste presne vedeli, \u010do dost\u00e1vate)<\/h3>\n\n\n\n

            Re\u017eimy grafu:<\/strong> St\u013apcov\u00fd graf - Vodop\u00e1d - \u010ciara - Oblas\u0165 - Lollipop - Prep\u00ednanie jedn\u00fdm kliknut\u00edm - Rovnak\u00e9 \u00fadaje, r\u00f4zne perspekt\u00edvy - Optimaliz\u00e1cie pre jednotliv\u00e9 re\u017eimy<\/p>\n\n\n\n

            Anal\u00fdza odch\u00fdlok:<\/strong> Automatick\u00fd v\u00fdpo\u010det odch\u00fdlky - Smerov\u00e9 \u0161\u00edpky hore\/dole - Absol\u00fatne a percentu\u00e1lne zobrazenie - Re\u017eim od prv\u00e9ho k posledn\u00e9mu alebo od skuto\u010dn\u00e9ho k porovn\u00e1van\u00e9mu - Farebn\u00e9 indik\u00e1tory (zelen\u00e1 pozit\u00edvna, \u010derven\u00e1 negat\u00edvna) - Citliv\u00e9 nastavenie ve\u013ekosti \u0161\u00edpok<\/p>\n\n\n\n

            Prest\u00e1vka v meradle:<\/strong> Stla\u010denie osi Y pre zameranie sa na rozsah \u00fadajov - Prep\u00ednanie pri nav\u00e1dzan\u00ed v re\u017eimoch Line\/Area - Vizu\u00e1lny indik\u00e1tor cik-cak - \u010cerven\u00e9 X sa zobraz\u00ed pri stla\u010den\u00ed - Okam\u017eit\u00e9 prepnutie sp\u00e4\u0165 na pln\u00fa mierku<\/p>\n\n\n\n

            Funkcie vodop\u00e1du:<\/strong> V\u00fdpo\u010det priebe\u017en\u00e9ho s\u00fa\u010dtu - Spojovacie \u010diary medzi st\u013apcami - Kladn\u00e9\/z\u00e1porn\u00e9 farebn\u00e9 k\u00f3dovanie - Zv\u00fdraznenie celkov\u00e9ho st\u013apca - Vizualiz\u00e1cia z\u00e1kladnej plochy - Siv\u00e1 z\u00e1kladn\u00e1 plocha v re\u017eime plochy<\/p>\n\n\n\n

            \u0160t\u00edtky a form\u00e1tovanie:<\/strong> \u0160t\u00edtky s hodnotami na st\u013apcoch - Vn\u00fatorn\u00e9 alebo vonkaj\u0161ie umiestnenie - Form\u00e1tovanie \u010d\u00edsel (K, M, B) - Vlastn\u00e9 \u0161t\u00edtky s mierami - Upravite\u013en\u00e9 \u0161t\u00edtky na objektoch - Reaguj\u00face nastavenie ve\u013ekosti p\u00edsma<\/p>\n\n\n\n

            Ovl\u00e1dacie prvky osi:<\/strong> Zobrazi\u0165\/skry\u0165 os X - Zobrazi\u0165\/skry\u0165 os Y - Prep\u00ednanie mrie\u017eky - Automatick\u00e9 \u0161k\u00e1lovanie - Mo\u017enosti form\u00e1tu \u010d\u00edsla (Auto, K, M, B) - Reaguj\u00face \u0161t\u00edtky os\u00ed<\/p>\n\n\n\n

            Farby a \u0161t\u00fdl:<\/strong> Pozit\u00edvna farba st\u013apca - Z\u00e1porn\u00e1 farba st\u013apca - Celkov\u00e1 farba st\u013apca - Farba spojovacej \u010diary - \u00dapln\u00e9 ovl\u00e1danie neprieh\u013eadnosti - Reaguje na vizu\u00e1lnu ve\u013ekos\u0165<\/p>\n\n\n\n

            Integr\u00e1cia Power BI:<\/strong> Kr\u00ed\u017eov\u00e9 filtrovanie - Podpora v\u00fdberu - Nat\u00edvne tooltipy - Podpora pol\u00ed s tooltipmi - Kompatibilita so z\u00e1lo\u017ekami - Export do PDF\/PowerPoint - Konfigur\u00e1cia podokna form\u00e1tu<\/p>\n\n\n\n

            Responz\u00edvny dizajn:<\/strong> Funguje od 150px do 4K - V\u0161etky prvky sa proporcion\u00e1lne \u0161k\u00e1luj\u00fa - \u0160t\u00edtky sa prisp\u00f4sobuj\u00fa dostupn\u00e9mu priestoru - \u0160\u00edpky menia ve\u013ekos\u0165 spolu s grafom - Nie je potrebn\u00e9 manu\u00e1lne nastavova\u0165 ve\u013ekos\u0165<\/p>\n\n\n\n

            <\/div>\n\n\n\n

            \u010co dostanete<\/h2>\n\n\n\n

            Pozrite si svoj pr\u00edbeh o odch\u00fdlkach v skratke<\/h3>\n\n\n\n
              \n
            • P\u00e4\u0165 re\u017eimov grafu, jeden vizu\u00e1lny<\/strong>: St\u013apcov\u00fd graf pre porovnanie, vodop\u00e1d pre mosty, \u010diara pre trendy, plocha pre kumulat\u00edvny vplyv, Lollipop pre \u010dist\u00e9 prezent\u00e1cie - prep\u00ednanie jedn\u00fdm kliknut\u00edm<\/li>\n\n\n\n
            • Skuto\u010dn\u00e1 integr\u00e1cia Power BI<\/strong>: Kliknite tu na li\u0161tu, vyfiltrujte v\u0161etko tam - cel\u00fd panel sa aktualizuje, preto\u017ee je postaven\u00fd na nat\u00edvnej architekt\u00fare Power BI.<\/li>\n\n\n\n
            • \u0160\u00edpky odch\u00fdlok, ktor\u00e9 maj\u00fa zmysel<\/strong>: Automatick\u00fd v\u00fdpo\u010det, jasn\u00e9 ukazovatele nahor\/nadol, zelen\u00e1 pre dobr\u00e9, \u010derven\u00e1 pre zl\u00e9 - ved\u00faci pracovn\u00edci okam\u017eite pochopia<\/li>\n\n\n\n
            • Prelomenie mierky pre skuto\u010dn\u00fa anal\u00fdzu<\/strong>: Ke\u010f je va\u0161a z\u00e1kladn\u00e1 hodnota mili\u00f3ny a odch\u00fdlky s\u00fa tis\u00edce, stla\u010dte stupnicu, aby ste videli, \u010do je d\u00f4le\u017eit\u00e9.<\/li>\n\n\n\n
            • Reaguje na v\u0161etko<\/strong>: dla\u017edice pr\u00edstrojovej dosky na prezent\u00e1cie na cel\u00fa obrazovku - \u0161t\u00edtky, \u0161\u00edpky a rozstupy sa automaticky \u0161k\u00e1luj\u00fa<\/li>\n<\/ul>\n\n\n\n

              Presta\u0148te vytv\u00e1ra\u0165 grafy most\u00edkov v programe Excel<\/h3>\n\n\n\n
                \n
              • Re\u017eim vodop\u00e1du zobrazuje prech\u00e1dzku<\/strong>: Po\u010diato\u010dn\u00e1 hodnota, ka\u017ed\u00e1 zmena, kone\u010dn\u00e1 hodnota - most\u00edk, o ktor\u00fd v\u00e1\u0161 finan\u010dn\u00fd riadite\u013e st\u00e1le \u017eiada, vytvoren\u00fd automaticky<\/li>\n\n\n\n
              • Spojovacie \u010diary zobrazuj\u00fa tok<\/strong>: Vizu\u00e1lne \u010diary medzi st\u013apcami, aby ka\u017ed\u00fd videl, ako sa hodnoty sp\u00e1jaj\u00fa<\/li>\n\n\n\n
              • Priebe\u017en\u00e9 s\u00fa\u010dty vypo\u010d\u00edtan\u00e9 za v\u00e1s<\/strong>: Nie s\u00fa potrebn\u00e9 \u017eiadne vzorce DAX - vizu\u00e1lne spracovanie kumulat\u00edvnych v\u00fdpo\u010dtov<\/li>\n\n\n\n
              • Spr\u00e1vne zaobch\u00e1dzanie s pozit\u00edvnymi a negat\u00edvnymi hodnotami<\/strong>: Zelen\u00e9 st\u013apce id\u00fa hore, \u010derven\u00e9 dole, s\u00fa\u010dty sa vyrovn\u00e1vaj\u00fa - jednoducho to funguje<\/li>\n<\/ul>\n\n\n\n

                Va\u0161e \u00fadaje. V\u00e1\u0161 sp\u00f4sob. Bez probl\u00e9mov.<\/h3>\n\n\n\n
                  \n
                • Jednoduch\u00e9 po\u017eiadavky na \u00fadaje<\/strong>: Pole Kateg\u00f3ria, pole Hodnota, pr\u00edpadne Porovnanie hodnoty - to je v\u0161etko, \u010do potrebujete<\/li>\n\n\n\n
                • Funguje s ak\u00fdmko\u013evek zdrojom<\/strong>: Excel, SQL, SAP, Oracle, Dynamics - ak sa k nim Power BI dok\u00e1\u017ee pripoji\u0165, m\u00f4\u017eeme ich vizualizova\u0165<\/li>\n\n\n\n
                • \u017div\u00e9 \u00fadaje, nie sn\u00edmky obrazovky<\/strong>: Obnovenie s\u00faboru \u00fadajov a vizu\u00e1lnych aktualiz\u00e1ci\u00ed - zobrazenie dne\u0161n\u00fdch \u010d\u00edsel, nie \u010d\u00edsel z minul\u00e9ho t\u00fd\u017ed\u0148a<\/li>\n\n\n\n
                • Pl\u00e1n vs. skuto\u010dne zabudovan\u00e9<\/strong>: Pridajte pole na porovn\u00e1vanie a automaticky zobrazte ukazovatele odch\u00fdlky<\/li>\n<\/ul>\n\n\n\n

                  Vyzer\u00e1 profesion\u00e1lne bez n\u00e1mahy<\/h3>\n\n\n\n
                    \n
                  • Prisp\u00f4sobenie farieb tak, aby zodpovedali va\u0161ej zna\u010dke<\/strong>: Pozit\u00edvne, negat\u00edvne, celkov\u00e9 nastavenie firemn\u00fdch farieb v priebehu nieko\u013ek\u00fdch sek\u00fand<\/li>\n\n\n\n
                  • \u0160t\u00edtky, ktor\u00e9 sa hodia<\/strong>: Inteligentn\u00e9 umiestnenie vo vn\u00fatri alebo mimo ty\u010d\u00ed, automatick\u00e9 skracovanie, citliv\u00e9 nastavenie ve\u013ekosti<\/li>\n\n\n\n
                  • Re\u017eim \u010distej prezent\u00e1cie<\/strong>: Skry\u0165 osi, zobrazi\u0165 len to, \u010do je d\u00f4le\u017eit\u00e9, ide\u00e1lne pre riadiace panely<\/li>\n\n\n\n
                  • Konzistentnos\u0165 medzi zariadeniami<\/strong>: Notebook, stoln\u00fd po\u010d\u00edta\u010d, tablet - v\u0161ade vyzer\u00e1 profesion\u00e1lne<\/li>\n<\/ul>\n\n\n\n

                    Pripravenos\u0165 na podnikanie<\/h3>\n\n\n\n
                      \n
                    • Optimalizovan\u00fd v\u00fdkon<\/strong>: Efekt\u00edvne vykres\u013eovanie ve\u013ek\u00fdch s\u00faborov \u00fadajov<\/li>\n\n\n\n
                    • V s\u00falade s bezpe\u010dnostn\u00fdmi predpismi<\/strong>: \u017diadny prenos \u00fadajov mimo prostredia Power BI<\/li>\n\n\n\n
                    • Spr\u00e1va licenci\u00ed<\/strong>: Podnikov\u00e9 licencie s overovan\u00edm<\/li>\n\n\n\n
                    • Profesion\u00e1lna podpora<\/strong>: Skuto\u010dn\u00ed \u013eudia, ktor\u00ed rozumej\u00fa financi\u00e1m a Power BI<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"

                      The Only Waterfall Chart Built for Finance Teams Who Need to Explain the “Why” in Power BI If you’re presenting variance analysis in Power BI and stakeholders keep asking “but what changed?”… if you’re manually building bridge charts in Excel because Power BI’s native charts can’t show the breakdown… if your CFO wants to see … <\/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-14529","page","type-page","status-publish","hentry","latest_post"],"_links":{"self":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages\/14529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/comments?post=14529"}],"version-history":[{"count":6,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages\/14529\/revisions"}],"predecessor-version":[{"id":14537,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages\/14529\/revisions\/14537"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/media?parent=14529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}