{"id":14568,"date":"2026-02-12T20:40:50","date_gmt":"2026-02-12T19:40:50","guid":{"rendered":"https:\/\/www.leaplytics.de\/?page_id=14568"},"modified":"2026-02-12T21:01:35","modified_gmt":"2026-02-12T20:01:35","slug":"maticova-tabulka","status":"publish","type":"page","link":"https:\/\/www.leaplytics.de\/sk\/maticova-tabulka\/","title":{"rendered":"Maticov\u00e1 tabu\u013eka"},"content":{"rendered":"

Jedin\u00e1 maticov\u00e1 tabu\u013eka vytvoren\u00e1 pre finan\u010dn\u00e9 t\u00edmy, ktor\u00e9 potrebuj\u00fa \u010d\u00edsla A vizualiz\u00e1cie v Power BI<\/h3>\n\n\n\n

Ak prezentujete finan\u010dn\u00e9 \u00fadaje v Power BI a zainteresovan\u00e9 strany neust\u00e1le \u017emurkaj\u00fa na riadky s \u010d\u00edslami... ak ru\u010dne prid\u00e1vate prskavky v Exceli, preto\u017ee nat\u00edvne tabu\u013eky Power BI nedok\u00e1\u017eu zobrazi\u0165 riadkov\u00e9 st\u013apce... ak v\u00e1\u0161 finan\u010dn\u00fd riadite\u013e chce vidie\u0165 kateg\u00f3rie s vizu\u00e1lnymi ukazovate\u013emi v\u00fdkonnosti a vy ich nem\u00f4\u017eete poskytn\u00fa\u0165...<\/p>\n\n\n\n

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

Toto je nie\u010do in\u00e9: Toto nie je \u010fal\u0161ia z\u00e1kladn\u00e1 vizu\u00e1lna tabu\u013eka. Ide o profesion\u00e1lnu maticov\u00fa tabu\u013eku s riadkov\u00fdmi grafmi, zmrazen\u00fdmi st\u013apcami kateg\u00f3ri\u00ed, re\u017eimom Small Multiples na porovn\u00e1vanie viacer\u00fdch meran\u00ed, synchronizovan\u00fdm zv\u00fdraz\u0148ovan\u00edm riadkov a responz\u00edvnym dizajnom, ktor\u00fd funguje od dla\u017ed\u00edc pr\u00edstrojovej dosky a\u017e po prezent\u00e1cie na celej obrazovke.<\/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

\"N\u00e1\u0161mu v\u00fdkonn\u00e9mu t\u00edmu mesa\u010dne predklad\u00e1me k\u013e\u00fa\u010dov\u00e9 ukazovatele v\u00fdkonnosti v 12 n\u00e1kladov\u00fdch stredisk\u00e1ch. Pred touto vizualiz\u00e1ciou sme mali tabu\u013eky s \u010d\u00edslami, na ktor\u00e9 sa nikto nechcel pozera\u0165. Teraz? Ka\u017ed\u00fd riadok zobrazuje kateg\u00f3riu s riadkov\u00fdmi st\u013apcami, ktor\u00e9 okam\u017eite informuj\u00fa o v\u00fdkonnosti. Re\u017eim mal\u00fdch n\u00e1sobkov n\u00e1m umo\u017e\u0148uje zobrazova\u0165 v\u00fdnosy, n\u00e1klady a mar\u017eu ved\u013ea seba. Na\u0161i ved\u00faci pracovn\u00edci sa teraz skuto\u010dne zaoberaj\u00fa \u00fadajmi.\"<\/em><\/p>\n\n\n\n

- Finan\u010dn\u00fd mana\u017e\u00e9r, maloobchodn\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

Riadkov\u00e9 st\u013apcov\u00e9 grafy v ka\u017edom riadku<\/strong>
\u010c\u00edsla s\u00fa dobr\u00e9. \u010c\u00edsla so st\u013apcami s\u00fa lep\u0161ie. Ka\u017ed\u00e1 hodnota sa zobrazuje s proporcion\u00e1lnym st\u013apcom, ktor\u00fd umo\u017e\u0148uje okam\u017eit\u00e9 porovnanie. U\u017e \u017eiadne skenovanie st\u013apcov s \u010d\u00edslami - v\u00fdkon vid\u00edte na prv\u00fd poh\u013ead.<\/p>\n\n\n\n

Re\u017eim mal\u00fdch n\u00e1sobkov<\/strong>
Zobrazenie viacer\u00fdch meran\u00ed ved\u013ea seba v maticovom rozlo\u017een\u00ed. V\u00fdnosy, n\u00e1klady, mar\u017ea - ka\u017ed\u00e1 vo vlastnom st\u013apci s riadkovan\u00edm. Porovn\u00e1vajte medzi kateg\u00f3riami A medzi opatreniami v jednom kompaktnom vizu\u00e1lnom zobrazen\u00ed.<\/p>\n\n\n\n

St\u013apec kateg\u00f3rie zmrazen\u00fdch v\u00fdrobkov<\/strong>
Pos\u00favajte sa v hodnot\u00e1ch, pri\u010dom \u0161t\u00edtky kateg\u00f3ri\u00ed zostan\u00fa vidite\u013en\u00e9. U\u017e nebudete str\u00e1ca\u0165 preh\u013ead o tom, na ktor\u00fd riadok sa pr\u00e1ve pozer\u00e1te. V\u010faka zmrazen\u00e9mu st\u013apcu je kontext v\u017edy vidite\u013en\u00fd.<\/p>\n\n\n\n

Synchronizovan\u00e9 zv\u00fdraz\u0148ovanie riadkov<\/strong>
Po nabehnut\u00ed na \u013eubovo\u013en\u00fa bunku sa zv\u00fdrazn\u00ed cel\u00fd riadok v zmrazen\u00fdch oblastiach a oblastiach s hodnotami. Sledujte v\u00fdkonnos\u0165 v r\u00e1mci jednotliv\u00fdch opatren\u00ed bez toho, aby ste sa stratili.<\/p>\n\n\n\n

<\/div>\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
  • Predklad\u00e1te tabu\u013eky s \u010d\u00edslami, ktor\u00e9 ved\u00faci pracovn\u00edci prehliadaj\u00fa alebo ignoruj\u00fa.<\/li>\n\n\n\n
  • Porovn\u00e1vanie hodn\u00f4t v jednotliv\u00fdch kateg\u00f3ri\u00e1ch si vy\u017eaduje ment\u00e1lnu matematiku namiesto vizu\u00e1lnych vzorov<\/li>\n\n\n\n
  • \u0160irok\u00e9 tabu\u013eky str\u00e1caj\u00fa kontext pri pos\u00favan\u00ed, preto\u017ee n\u00e1zvy kateg\u00f3ri\u00ed zmizn\u00fa<\/li>\n\n\n\n
  • Viacer\u00e9 opatrenia si vy\u017eaduj\u00fa viacero vizu\u00e1lov, ktor\u00e9 nie s\u00fa spr\u00e1vne zarovnan\u00e9<\/li>\n\n\n\n
  • Exportujete do programu Excel len preto, aby ste pridali podmienen\u00e9 form\u00e1tovanie a prskavky<\/li>\n<\/ul>\n\n\n\n

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

      \n
    • Mesa\u010dn\u00e9 spr\u00e1vy trvaj\u00fa dlh\u0161ie, preto\u017ee pre tie ist\u00e9 \u00fadaje potrebujete grafy A tabu\u013eky<\/li>\n\n\n\n
    • Zainteresovan\u00e9 strany sa p\u00fdtaj\u00fa: \"Ktor\u00e9 n\u00e1kladov\u00e9 stredisko je najhor\u0161ie?\" a vy uk\u00e1\u017eete na \u010d\u00edslo, ktor\u00e9 nevedia n\u00e1js\u0165.<\/li>\n\n\n\n
    • Porovnanie v\u00fdnosov vs. n\u00e1kladov vs. mar\u017ee znamen\u00e1 prep\u00ednanie medzi tromi samostatn\u00fdmi vizu\u00e1lnymi zobrazeniami<\/li>\n\n\n\n
    • Na pr\u00edstrojovej doske sa plytv\u00e1 miestom na nadbyto\u010dn\u00e9 tabu\u013eky a grafy zobrazuj\u00face rovnak\u00e9 \u00fadaje<\/li>\n\n\n\n
    • Anal\u00fdza na \u00farovni riadkov je bolestiv\u00e1, preto\u017ee stavy hoveru nepokr\u00fdvaj\u00fa cel\u00fd riadok<\/li>\n<\/ul>\n\n\n\n

      Z\u00e1ver?<\/strong> Va\u0161e tabu\u013eky s\u00fa len sklady \u00fadajov. Mali by by\u0165 komunika\u010dn\u00fdm n\u00e1strojom. \u010c\u00edsla s vizu\u00e1lnym kontextom s\u00fa zrozumite\u013en\u00e9. Samotn\u00e9 \u010d\u00edsla sa ignoruj\u00fa.<\/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

      Riadkov\u00e9 st\u013apcov\u00e9 grafy<\/strong><\/p>\n\n\n\n

      Ka\u017ed\u00e1 hodnota sa zobraz\u00ed pomocou proporcion\u00e1lneho pruhu. Okam\u017eite zist\u00edte, ktor\u00e9 kateg\u00f3rie ved\u00fa alebo zaost\u00e1vaj\u00fa. Nie je potrebn\u00e1 \u017eiadna ment\u00e1lna matematika - vzorce sa zobrazuj\u00fa vizu\u00e1lne.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n

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

      Re\u017eim mal\u00fdch n\u00e1sobkov<\/strong><\/p>\n\n\n\n

      Zobrazenie viacer\u00fdch meran\u00ed v maticovom rozlo\u017een\u00ed. V\u00fdnosy, n\u00e1klady, mar\u017ea - ka\u017ed\u00fd st\u013apec s vlastn\u00fdmi riadkov\u00fdmi st\u013apcami. Porovn\u00e1vajte jednotliv\u00e9 rozmery v jednom kompaktnom vizu\u00e1lnom zobrazen\u00ed.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n

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

      Mrazen\u00e9 kateg\u00f3rie<\/strong><\/p>\n\n\n\n

      \u0160t\u00edtky kateg\u00f3ri\u00ed zost\u00e1vaj\u00fa vidite\u013en\u00e9 aj pri prech\u00e1dzan\u00ed hodn\u00f4t. V \u0161irok\u00fdch tabu\u013ek\u00e1ch nikdy nestrat\u00edte kontext. V\u017edy viete, ktor\u00fd riadok analyzujete.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n

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

      Zv\u00fdraznenie riadkov<\/strong><\/p>\n\n\n\n

      Ke\u010f na \u0148u kdeko\u013evek nabehnete, cel\u00fd riadok sa zv\u00fdrazn\u00ed. Sledujte hodnoty v zmrazen\u00fdch a hodnotov\u00fdch st\u013apcoch bez straty miesta. Synchronizovan\u00e9 zv\u00fdraz\u0148ovanie vo v\u0161etk\u00fdch oblastiach.<\/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. St\u013apce, \u0161t\u00edtky a st\u013apce 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 - pol\u00ed Kateg\u00f3ria a Hodnota (trv\u00e1 5 min\u00fat)<\/p>\n\n\n\n

      Krok 4:<\/strong> Sledujte, ako va\u0161e zainteresovan\u00e9 strany kone\u010dne vidia vzory v \u010d\u00edslach<\/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 potrebuj\u00fa tabu\u013eky, ktor\u00e9 komunikuj\u00fa, nielen zobrazuj\u00fa \u00fadaje.<\/li>\n\n\n\n
      • Ste Ovl\u00e1da\u010d<\/strong> prezent\u00e1cia porovnania n\u00e1kladov\u00fdch stred\u00edsk s vizu\u00e1lnym kontextom<\/li>\n\n\n\n
      • Ste Obchodn\u00fd analytik<\/strong> vytv\u00e1ranie informa\u010dn\u00fdch panelov, kde tabu\u013eky musia rozpr\u00e1va\u0165 pr\u00edbeh.<\/li>\n\n\n\n
      • Potrebujete zobrazi\u0165 viacero meran\u00ed ved\u013ea seba s inline vizualiz\u00e1ciou<\/li>\n\n\n\n
      • Chcete tabu\u013eky so zmrazen\u00fdmi st\u013apcami, ktor\u00e9 pri pos\u00favan\u00ed nestratia kontext<\/li>\n\n\n\n
      • U\u017e v\u00e1s nebav\u00ed, \u017ee ved\u00faci pracovn\u00edci ignoruj\u00fa va\u0161e tabu\u013eky, preto\u017ee s\u00fa to len steny \u010d\u00edsel<\/li>\n\n\n\n
      • Va\u0161e zainteresovan\u00e9 strany potrebuj\u00fa vidie\u0165 vzory, nielen \u010d\u00edta\u0165 \u010d\u00edsla<\/li>\n<\/ul>\n\n\n\n

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

          \n
        • Potrebujete len jednoduch\u00fa d\u00e1tov\u00fa mrie\u017eku bez vizu\u00e1lnych prvkov (pou\u017eite vstavan\u00fa mrie\u017eku Power BI)<\/li>\n\n\n\n
        • Nepotrebujete riadkovacie li\u0161ty ani vizu\u00e1lne porovnanie v riadkoch<\/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. Pridajte viacero hodn\u00f4t pre re\u017eim Small Multiples (Mal\u00e9 n\u00e1sobky). Funguje s ak\u00fdmko\u013evek zdrojom \u00fadajov, ktor\u00fd Power BI podporuje.<\/p>\n\n\n\n

          Ot\u00e1zka: \u010co je to re\u017eim Small Multiples?<\/strong>
          Odpove\u010f: Pridajte viacero opatren\u00ed do po\u013ea Hodnota. Ka\u017ed\u00e9 meranie dostane vlastn\u00fd st\u013apec s riadkovan\u00edm. Porovn\u00e1vajte v\u00fdnosy, n\u00e1klady a mar\u017eu v jednom kompaktnom maticovom rozlo\u017een\u00ed.<\/p>\n\n\n\n

          Ot\u00e1zka: Ako funguj\u00fa inline li\u0161ty?<\/strong>
          Odpove\u010f: Ka\u017ed\u00e1 hodnota sa zobraz\u00ed s proporcion\u00e1lnym st\u013apcom, ktor\u00e9ho mierka zodpoved\u00e1 rozsahu \u00fadajov st\u013apca. V\u00e4\u010d\u0161ie hodnoty maj\u00fa dlh\u0161ie st\u013apce. Porovnanie je okam\u017eit\u00e9 a vizu\u00e1lne.<\/p>\n\n\n\n

          Ot\u00e1zka: \u010co je to st\u013apec mrazen\u00fdch kateg\u00f3ri\u00ed?<\/strong>
          Odpove\u010f: \u0160t\u00edtky kateg\u00f3ri\u00ed zostan\u00fa pripnut\u00e9 na \u013eavej strane, k\u00fdm sa pos\u00favate v st\u013apcoch s hodnotami. V\u017edy vid\u00edte, na ktor\u00fd riadok sa pr\u00e1ve pozer\u00e1te, a to aj v \u0161irok\u00fdch tabu\u013ek\u00e1ch.<\/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. Farby barov. Farby pozadia. Ve\u013ekosti p\u00edsma. \u0160\u00edrky st\u013apcov. Prisp\u00f4sobte to svojej zna\u010dke.<\/p>\n\n\n\n

          Ot\u00e1zka: Zvl\u00e1dne efekt\u00edvne ve\u013ea riadkov?<\/strong>
          Odpove\u010f: \u00c1no. Vizu\u00e1l je optimalizovan\u00fd na v\u00fdkon s citliv\u00fdm vykres\u013eovan\u00edm, ktor\u00e9 sa prisp\u00f4sobuje ve\u013ekosti va\u0161ich \u00fadajov.<\/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. \u00dadaje sa zobrazuj\u00fa ako maticov\u00e1 tabu\u013eka s riadkov\u00fdmi st\u013apcami<\/li>\n\n\n\n
          7. Prid\u00e1vate \u010fal\u0161ie opatrenia a sledujete, ako sa objavuj\u00fa mal\u00e9 n\u00e1sobky<\/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 (k\u00fapte si licenciu), alebo sa vr\u00e1tite k tabu\u013ek\u00e1m, ktor\u00e9 nikto ne\u010d\u00edta (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\u0161ia vizualiz\u00e1cia maticovej tabu\u013eky pre Power BI. Bodka. 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 va\u0161e \u00fadaje s jasn\u00fdmi riadkov\u00fdmi st\u013apcami, hladko sprac\u00fava mal\u00e9 n\u00e1sobky alebo rob\u00ed va\u0161e tabu\u013eky \u010ditate\u013enej\u0161\u00edmi - povedzte n\u00e1m to. Vyrie\u0161ime to alebo v\u00e1m vr\u00e1time peniaze. \u017diadne obru\u010de.<\/p>\n\n\n\n

            Vytvorili sme ju, preto\u017ee sme boli frustrovan\u00ed z tabuliek v Power BI. Pou\u017e\u00edvame to. Na\u0161i klienti to pou\u017e\u00edvaj\u00fa na riadiace panely. 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 tabu\u013eky v Power BI boli nefunk\u010dn\u00e9.

            Ka\u017ed\u00fd vizu\u00e1l tabu\u013eky bol bu\u010f pr\u00edli\u0161 jednoduch\u00fd (len \u010d\u00edsla, \u017eiadne vizu\u00e1ly), alebo pr\u00edli\u0161 zlo\u017eit\u00fd (vy\u017eadoval si vlastn\u00fd v\u00fdvoj na pridanie inline grafov).

            Finan\u010dn\u00e9 t\u00edmy predkladali m\u00fary \u010d\u00edsel, ktor\u00e9 ved\u00faci pracovn\u00edci preskakovali. Controlleri nemohli uk\u00e1za\u0165 porovnania n\u00e1kladov\u00fdch stred\u00edsk s vizu\u00e1lnym kontextom. Oddelenie FP&A muselo vytv\u00e1ra\u0165 samostatn\u00e9 grafy len preto, aby vizualizovalo tie ist\u00e9 \u00fadaje, ktor\u00e9 u\u017e boli v ich tabu\u013ek\u00e1ch.

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

            \u2192 Riadkov\u00e9 st\u013apcov\u00e9 grafy v ka\u017edom riadku (nie samostatn\u00e9 vizu\u00e1ly)
            \u2192 Re\u017eim mal\u00fdch n\u00e1sobkov na porovn\u00e1vanie viacer\u00fdch meran\u00ed (nie viacn\u00e1sobn\u00fdch tabuliek)
            \u2192 Zmrazen\u00e9 st\u013apce kateg\u00f3ri\u00ed, ktor\u00e9 zachov\u00e1vaj\u00fa kontext (nie \"pos\u00favanie a zabudnutie\")
            \u2192 Synchronizovan\u00e9 zv\u00fdraz\u0148ovanie riadkov (nie \"na ktorom riadku som bol?\")
            \u2192 Responz\u00edvny dizajn, ktor\u00fd funguje v\u0161ade (nie \"ru\u010dn\u00e1 zmena ve\u013ekosti\")
            \u2192 dynamick\u00e9 n\u00e1zvy z va\u0161ich \u00fadajov (nie pevne zak\u00f3dovan\u00e9 \u0161t\u00edtky)

            Tento n\u00e1stroj pou\u017e\u00edvame interne. Na\u0161i poradensk\u00ed klienti ho pou\u017e\u00edvaj\u00fa na v\u00fdkonn\u00e9 informa\u010dn\u00e9 panely. Nie je dokonal\u00fd, ale je to najlep\u0161ia vizu\u00e1lna maticov\u00e1 tabu\u013eka v Power BI. Ove\u013ea.

            Ak prezentujete tabu\u013ekov\u00e9 \u00fadaje a potrebujete ich vizu\u00e1lne sprostredkova\u0165 - 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 sa, ako va\u0161e tabu\u013eky o\u017e\u00edvaj\u00fa.<\/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

            Inline vizualiz\u00e1cia:<\/strong> Pomern\u00e9 st\u013apcov\u00e9 grafy v ka\u017edej bunke - Automatick\u00e9 \u0161k\u00e1lovanie na st\u013apec - Vizu\u00e1lne porovnanie v riadkoch - Okam\u017eit\u00e9 rozpoznanie vzoru - Farebne ozna\u010den\u00e9 st\u013apce<\/p>\n\n\n\n

            Re\u017eim mal\u00fdch n\u00e1sobkov:<\/strong> Viacero meran\u00ed ved\u013ea seba - Maticov\u00e9 rozlo\u017eenie s riadkov\u00fdmi st\u013apcami na meranie - Porovnanie kateg\u00f3ri\u00ed A meran\u00ed - Riadky osi pre v\u0161etky st\u013apce - N\u00e1zvy meran\u00ed v z\u00e1hlav\u00ed<\/p>\n\n\n\n

            Zmrznut\u00e9 st\u013apy:<\/strong> St\u013apec kateg\u00f3rie zost\u00e1va vidite\u013en\u00fd - Pos\u00favanie hodn\u00f4t bez straty kontextu - Synchronizovan\u00e9 farby pozadia - Profesion\u00e1lne rozlo\u017eenie s pevn\u00fdm st\u013apcom<\/p>\n\n\n\n

            Interakcia v riadku:<\/strong> Synchronizovan\u00e9 zv\u00fdraznenie pri prechode my\u0161ou - Zv\u00fdraznenie cel\u00e9ho riadku v zmrazen\u00fdch oblastiach a oblastiach hodn\u00f4t - Podpora kontextov\u00e9ho menu - V\u00fdber kliknut\u00edm a kr\u00ed\u017eov\u00fd filter<\/p>\n\n\n\n

            Dynamick\u00e9 hlavi\u010dky:<\/strong> N\u00e1zvy zo zobrazen\u00fdch n\u00e1zvov d\u00e1tov\u00fdch rol\u00ed - Hlavi\u010dky st\u013apcov z n\u00e1zvov meran\u00ed - Automatick\u00e9 ozna\u010dovanie z v\u00e1\u0161ho d\u00e1tov\u00e9ho modelu - \u017diadny pevne zak\u00f3dovan\u00fd text<\/p>\n\n\n\n

            \u0160t\u00edtky a form\u00e1tovanie:<\/strong> \u0160t\u00edtky s hodnotami v bunk\u00e1ch - Podpora form\u00e1tovania \u010d\u00edsel - Reaguj\u00face nastavenie ve\u013ekosti p\u00edsma - \u010cist\u00e9 umiestnenie \u0161t\u00edtkov - Zn\u00ed\u017een\u00e9 vyp\u013a\u0148anie pre kompaktn\u00e9 zobrazenie<\/p>\n\n\n\n

            Farby a \u0161t\u00fdl:<\/strong> Prisp\u00f4sobite\u013en\u00e9 farby st\u013apcov - Ovl\u00e1danie farby pozadia - Zodpovedaj\u00face zmrazen\u00e9 pozadie st\u013apcov - Profesion\u00e1lny vzh\u013ead - Pripraven\u00e9 na firemn\u00e9 zna\u010dky<\/p>\n\n\n\n

            Integr\u00e1cia Power BI:<\/strong> Kr\u00ed\u017eov\u00e9 filtrovanie - Podpora v\u00fdberu - Nat\u00edvna kontextov\u00e1 ponuka - Podpora tipov - 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 mal\u00fdch dla\u017ed\u00edc a\u017e po 4K - V\u0161etky prvky sa proporcion\u00e1lne \u0161k\u00e1luj\u00fa - Pr\u00fa\u017eky sa prisp\u00f4sobuj\u00fa \u0161\u00edrke st\u013apcov - \u0160t\u00edtky sa prisp\u00f4sobuj\u00fa dostupn\u00e9mu priestoru - 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 d\u00e1tov\u00fd pr\u00edbeh na prv\u00fd poh\u013ead<\/h3>\n\n\n\n
              \n
            • Inline li\u0161ty, ktor\u00e9 komunikuj\u00fa<\/strong>: Ka\u017ed\u00e1 hodnota sa zobraz\u00ed v proporcion\u00e1lnom st\u013apci - vzory vysko\u010dia, porovnania s\u00fa okam\u017eit\u00e9, nie je potrebn\u00e1 \u017eiadna ment\u00e1lna matematika<\/li>\n\n\n\n
            • Skuto\u010dn\u00e1 integr\u00e1cia Power BI<\/strong>: Kliknite na riadok tu, filtrujte 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
            • Mal\u00e9 n\u00e1sobky, ktor\u00e9 maj\u00fa zmysel<\/strong>: Viacer\u00e9 opatrenia v maticovom usporiadan\u00ed - v\u00fdnosy, n\u00e1klady, mar\u017ea ved\u013ea seba s vizu\u00e1lnym kontextom pre ka\u017ed\u00e9 z nich<\/li>\n\n\n\n
            • Zmrazen\u00e9 st\u013apce pre re\u00e1lnu anal\u00fdzu<\/strong>: \u0160t\u00edtky kateg\u00f3ri\u00ed zost\u00e1vaj\u00fa vidite\u013en\u00e9 aj po\u010das sk\u00famania hodn\u00f4t - nikdy nestrat\u00edte preh\u013ead o tom, ktor\u00fd riadok analyzujete<\/li>\n\n\n\n
            • Reaguje na v\u0161etko<\/strong>: dla\u017edice pr\u00edstrojovej dosky na prezent\u00e1cie na cel\u00fa obrazovku - li\u0161ty, \u0161t\u00edtky a st\u013apce sa automaticky \u0161k\u00e1luj\u00fa<\/li>\n<\/ul>\n\n\n\n

              Presta\u0148te vytv\u00e1ra\u0165 samostatn\u00e9 grafy pre tabu\u013ekov\u00e9 \u00fadaje<\/h3>\n\n\n\n
                \n
              • Riadkov\u00e9 li\u0161ty Nahradi\u0165 duplicitn\u00e9 grafy<\/strong>: Nepotrebujete tabu\u013eku A st\u013apcov\u00fd graf zobrazuj\u00face tie ist\u00e9 \u00fadaje - z\u00edskate oboje v jednom vizu\u00e1lnom zobrazen\u00ed.<\/li>\n\n\n\n
              • Mal\u00e9 n\u00e1sobky nahr\u00e1dzaj\u00fa viacn\u00e1sobn\u00e9 vizualiz\u00e1cie<\/strong>: Porovnanie opatren\u00ed v jednej kompaktnej matici namiesto troch samostatn\u00fdch tabuliek<\/li>\n\n\n\n
              • Zv\u00fdraznenie riadkov v\u00e1s udr\u017e\u00ed v orient\u00e1cii<\/strong>: Naje\u010fte na \u013eubovo\u013en\u00e9 miesto a uvid\u00edte rozsvieten\u00fd cel\u00fd riadok - bez n\u00e1mahy sledujte st\u013apce<\/li>\n\n\n\n
              • Dynamick\u00e9 hlavi\u010dky z va\u0161ich \u00fadajov<\/strong>: N\u00e1zvy opatren\u00ed sa automaticky st\u00e1vaj\u00fa z\u00e1hlaviami st\u013apcov - nie je potrebn\u00e9 ru\u010dn\u00e9 ozna\u010dovanie<\/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 - pridajte \u010fal\u0161ie hodnoty pre Mal\u00e9 n\u00e1sobky<\/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
                • Okam\u017eit\u00fd vizu\u00e1lny kontext<\/strong>: Pridajte svoje \u00fadaje a riadkov\u00e9 li\u0161ty sa zobrazia automaticky - nie je potrebn\u00e1 \u017eiadna konfigur\u00e1cia<\/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>: Farby pruhov, pozadia - nastavte si firemn\u00e9 farby v priebehu nieko\u013ek\u00fdch sek\u00fand<\/li>\n\n\n\n
                  • \u0160t\u00edtky, ktor\u00e9 sa hodia<\/strong>: Inteligentn\u00e9 polohovanie, citliv\u00e9 nastavenie ve\u013ekosti, \u010dist\u00e9 form\u00e1tovanie v ka\u017edej bunke<\/li>\n\n\n\n
                  • \u010cist\u00fd profesion\u00e1lny vzh\u013ead<\/strong>: Ur\u010den\u00e9 pre riadiace panely a prezent\u00e1cie na spr\u00e1vnej rade<\/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 Matrix Table Built for Finance Teams Who Need Numbers AND Visuals in Power BI If you’re presenting financial data in Power BI and stakeholders keep squinting at rows of numbers… if you’re manually adding sparklines in Excel because Power BI’s native tables can’t show inline bars… if your CFO wants to see categories … <\/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-14568","page","type-page","status-publish","hentry","latest_post"],"_links":{"self":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages\/14568","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=14568"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages\/14568\/revisions"}],"predecessor-version":[{"id":14579,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages\/14568\/revisions\/14579"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/media?parent=14568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}