{"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\/cs\/maticova-tabulka\/","title":{"rendered":"Maticov\u00e1 tabulka"},"content":{"rendered":"

Jedin\u00e1 maticov\u00e1 tabulka vytvo\u0159en\u00e1 pro finan\u010dn\u00ed t\u00fdmy, kter\u00e9 v Power BI pot\u0159ebuj\u00ed \u010d\u00edsla A vizualizace<\/h3>\n\n\n\n

Pokud prezentujete finan\u010dn\u00ed data v Power BI a zainteresovan\u00e9 strany neust\u00e1le m\u017eouraj\u00ed na \u0159\u00e1dky \u010d\u00edsel... pokud v Excelu ru\u010dn\u011b p\u0159id\u00e1v\u00e1te prskavky, proto\u017ee nativn\u00ed tabulky Power BI neum\u00ed zobrazit inline sloupce... pokud v\u00e1\u0161 finan\u010dn\u00ed \u0159editel chce vid\u011bt kategorie s vizu\u00e1ln\u00edmi ukazateli v\u00fdkonnosti a vy mu je nem\u016f\u017eete poskytnout...<\/p>\n\n\n\n

Nejste sami.<\/strong><\/p>\n\n\n\n

V \u010dem se li\u0161\u00ed: Nejde o dal\u0161\u00ed z\u00e1kladn\u00ed vizu\u00e1ln\u00ed tabulku. Jedn\u00e1 se o profesion\u00e1ln\u00ed maticovou tabulku s inline sloupcov\u00fdmi grafy, zmrazen\u00fdmi sloupci kategori\u00ed, re\u017eimem Small Multiples pro porovn\u00e1v\u00e1n\u00ed v\u00edce m\u011b\u0159en\u00ed, synchronizovan\u00fdm zv\u00fdrazn\u011bn\u00edm \u0159\u00e1dk\u016f a responzivn\u00edm designem, kter\u00fd funguje od dla\u017edic na panelu a\u017e po celoobrazovkov\u00e9 prezentace.<\/p>\n\n\n\n

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

Skute\u010dn\u00e9 finan\u010dn\u00ed t\u00fdmy. Skute\u010dn\u00e9 v\u00fdsledky.<\/h3>\n\n\n\n

\"M\u011bs\u00ed\u010dn\u011b p\u0159edkl\u00e1d\u00e1me na\u0161emu v\u00fdkonn\u00e9mu t\u00fdmu kl\u00ed\u010dov\u00e9 ukazatele v\u00fdkonnosti ve 12 n\u00e1kladov\u00fdch st\u0159edisc\u00edch. P\u0159ed touto vizualizac\u00ed jsme m\u011bli tabulky s \u010d\u00edsly, na kter\u00e9 se nikdo necht\u011bl d\u00edvat. Nyn\u00ed? Ka\u017ed\u00fd \u0159\u00e1dek zobrazuje kategorii s vlo\u017een\u00fdmi sloupci, kter\u00e9 okam\u017eit\u011b informuj\u00ed o v\u00fdkonnosti. Re\u017eim mal\u00fdch n\u00e1sobk\u016f n\u00e1m umo\u017e\u0148uje zobrazit vedle sebe v\u00fdnosy, n\u00e1klady a mar\u017ei. Na\u0161i vedouc\u00ed pracovn\u00edci se nyn\u00ed do dat skute\u010dn\u011b zapojuj\u00ed.\"<\/em><\/p>\n\n\n\n

- Finan\u010dn\u00ed mana\u017eer, maloobchodn\u00ed spole\u010dnost<\/strong><\/p>\n\n\n\n

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

Tady je to, co z\u00edsk\u00e1te (a nikde jinde to nedostanete)<\/h3>\n\n\n\n

\u0158\u00e1dkov\u00e9 sloupcov\u00e9 grafy v ka\u017ed\u00e9m \u0159\u00e1dku<\/strong>
\u010c\u00edsla jsou dobr\u00e1. \u010c\u00edsla se sloupci jsou lep\u0161\u00ed. Ka\u017ed\u00e1 hodnota se zobrazuje s proporcion\u00e1ln\u00edm sloupcem, kter\u00fd umo\u017e\u0148uje okam\u017eit\u00e9 srovn\u00e1n\u00ed. U\u017e \u017e\u00e1dn\u00e9 skenov\u00e1n\u00ed sloupc\u016f \u010d\u00edsel - v\u00fdkonnost uvid\u00edte na prvn\u00ed pohled.<\/p>\n\n\n\n

Re\u017eim mal\u00fdch n\u00e1sobk\u016f<\/strong>
Zobrazen\u00ed v\u00edce m\u011b\u0159en\u00ed vedle sebe v maticov\u00e9m uspo\u0159\u00e1d\u00e1n\u00ed. V\u00fdnosy, n\u00e1klady, mar\u017ee - ka\u017ed\u00e1 ve vlastn\u00edm sloupci s \u0159\u00e1dkov\u00fdmi sloupci. Srovn\u00e1v\u00e1n\u00ed nap\u0159\u00ed\u010d kategoriemi A nap\u0159\u00ed\u010d opat\u0159en\u00edmi v jednom kompaktn\u00edm vizu\u00e1ln\u00edm zobrazen\u00ed.<\/p>\n\n\n\n

Sloupec zmrazen\u00e9 kategorie<\/strong>
Proch\u00e1zejte hodnoty, zat\u00edmco popisky kategori\u00ed z\u016fst\u00e1vaj\u00ed viditeln\u00e9. U\u017e nebudete ztr\u00e1cet p\u0159ehled o tom, na kter\u00fd \u0159\u00e1dek se pr\u00e1v\u011b d\u00edv\u00e1te. D\u00edky zmrazen\u00e9mu sloupci je kontext v\u017edy viditeln\u00fd.<\/p>\n\n\n\n

Synchronizovan\u00e9 zv\u00fdraz\u0148ov\u00e1n\u00ed \u0159\u00e1dk\u016f<\/strong>
Kdy\u017e najedete kurzorem my\u0161i na libovolnou bu\u0148ku, zv\u00fdrazn\u00ed se cel\u00fd \u0159\u00e1dek v oblasti zmrazen\u00fdch a hodnot. Sledujte v\u00fdkonnost nap\u0159\u00ed\u010d opat\u0159en\u00edmi, ani\u017e byste ztratili m\u00edsto.<\/p>\n\n\n\n

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

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

Pro finan\u010dn\u00ed t\u00fdmy:<\/strong><\/p>\n\n\n\n

    \n
  • P\u0159edkl\u00e1d\u00e1te tabulky s \u010d\u00edsly, kter\u00e9 vedouc\u00ed pracovn\u00edci p\u0159ehl\u00ed\u017eej\u00ed nebo ignoruj\u00ed.<\/li>\n\n\n\n
  • Porovn\u00e1v\u00e1n\u00ed hodnot v jednotliv\u00fdch kategori\u00edch vy\u017eaduje ment\u00e1ln\u00ed matematiku nam\u00edsto vizu\u00e1ln\u00edch vzorc\u016f.<\/li>\n\n\n\n
  • \u0160irok\u00e9 tabulky ztr\u00e1cej\u00ed p\u0159i posouv\u00e1n\u00ed kontext, proto\u017ee miz\u00ed n\u00e1zvy kategori\u00ed<\/li>\n\n\n\n
  • V\u00edcen\u00e1sobn\u00e1 opat\u0159en\u00ed vy\u017eaduj\u00ed v\u00edcen\u00e1sobn\u00e9 vizualizace, kter\u00e9 nejsou spr\u00e1vn\u011b zarovn\u00e1ny.<\/li>\n\n\n\n
  • Exportujete do Excelu jen proto, abyste p\u0159idali podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed a prskavky.<\/li>\n<\/ul>\n\n\n\n

    Pro controllery a FP&A:<\/strong><\/p>\n\n\n\n

      \n
    • M\u011bs\u00ed\u010dn\u00ed zpr\u00e1vy trvaj\u00ed d\u00e9le, proto\u017ee pro stejn\u00e1 data pot\u0159ebujete grafy A tabulky.<\/li>\n\n\n\n
    • Zainteresovan\u00e9 strany se zeptaj\u00ed \"kter\u00e9 n\u00e1kladov\u00e9 st\u0159edisko je nejhor\u0161\u00ed?\" a vy jim uk\u00e1\u017eete \u010d\u00edslo, kter\u00e9 nemohou naj\u00edt.<\/li>\n\n\n\n
    • Srovn\u00e1n\u00ed v\u00fdnos\u016f a n\u00e1klad\u016f a mar\u017ee znamen\u00e1 p\u0159ep\u00edn\u00e1n\u00ed mezi t\u0159emi samostatn\u00fdmi vizu\u00e1ln\u00edmi prvky.<\/li>\n\n\n\n
    • Na p\u0159\u00edstrojov\u00e9 desce se pl\u00fdtv\u00e1 m\u00edstem na nadbyte\u010dn\u00e9 tabulky a grafy zobrazuj\u00edc\u00ed stejn\u00e1 data.<\/li>\n\n\n\n
    • Anal\u00fdza na \u00farovni \u0159\u00e1dku je bolestiv\u00e1, proto\u017ee stavy hoveru nepokr\u00fdvaj\u00ed cel\u00fd \u0159\u00e1dek.<\/li>\n<\/ul>\n\n\n\n

      Se\u010dteno a podtr\u017eeno?<\/strong> Va\u0161e tabulky jsou jen v\u00fdpisy dat. M\u011bly by b\u00fdt komunika\u010dn\u00edm n\u00e1strojem. \u010c\u00edsla s vizu\u00e1ln\u00edm kontextem jsou srozumiteln\u00e1. Samotn\u00e1 \u010d\u00edsla jsou ignorov\u00e1na.<\/p>\n\n\n\n

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

      Co skute\u010dn\u011b z\u00edsk\u00e1te<\/strong><\/h3>\n\n\n\n

      Ka\u017ed\u00e1 funkce. Bez kompromis\u016f. Vytvo\u0159eno finan\u010dn\u00edmi profesion\u00e1ly pro finan\u010dn\u00ed profesion\u00e1ly.<\/em><\/p>\n\n\n\n

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

      \u0158\u00e1dkov\u00e9 sloupcov\u00e9 grafy<\/strong><\/p>\n\n\n\n

      Ka\u017ed\u00e1 hodnota se zobraz\u00ed pomoc\u00ed proporcion\u00e1ln\u00edho sloupce. Okam\u017eit\u011b zjist\u00edte, kter\u00e9 kategorie vedou nebo zaost\u00e1vaj\u00ed. Nen\u00ed t\u0159eba po\u010d\u00edtat - vzorce vyskakuj\u00ed vizu\u00e1ln\u011b.<\/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\u00e1sobk\u016f<\/strong><\/p>\n\n\n\n

      Zobrazen\u00ed v\u00edce m\u011b\u0159en\u00ed v maticov\u00e9m uspo\u0159\u00e1d\u00e1n\u00ed. V\u00fdnosy, n\u00e1klady, mar\u017ee - ka\u017ed\u00fd sloupec s vlastn\u00edmi \u0159\u00e1dkov\u00fdmi sloupci. Porovn\u00e1vejte jednotliv\u00e9 rozm\u011bry v jednom kompaktn\u00edm vizu\u00e1ln\u00edm zobrazen\u00ed.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n

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

      Kategorie zmrazen\u00fdch produkt\u016f<\/strong><\/p>\n\n\n\n

      Popisky kategori\u00ed z\u016fst\u00e1vaj\u00ed viditeln\u00e9 i p\u0159i proch\u00e1zen\u00ed hodnot. V \u0161irok\u00fdch tabulk\u00e1ch nikdy neztrat\u00edte kontext. V\u017edy v\u00edte, kter\u00fd \u0159\u00e1dek analyzujete.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n

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

      Zv\u00fdrazn\u011bn\u00ed \u0159\u00e1dk\u016f<\/strong><\/p>\n\n\n\n

      Naje\u010fte na libovoln\u00e9 m\u00edsto a cel\u00fd \u0159\u00e1dek se zv\u00fdrazn\u00ed. Sledujte hodnoty nap\u0159\u00ed\u010d zmrazen\u00fdmi a hodnotov\u00fdmi sloupci, ani\u017e byste ztratili m\u00edsto. Synchronizovan\u00e9 zv\u00fdrazn\u011bn\u00ed ve v\u0161ech oblastech.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n

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

      Pln\u011b responzivn\u00ed<\/strong><\/p>\n\n\n\n

      Funguje na libovoln\u00e9 velikosti obrazovky. Dla\u017edice na p\u0159\u00edstrojov\u00e9 desce a\u017e po celoobrazovkov\u00e9 prezentace. Sloupce, popisky a sloupce se automaticky \u0161k\u00e1luj\u00ed. V\u0161ude vypad\u00e1 profesion\u00e1ln\u011b.<\/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

      Jak za\u010d\u00edt (je to hloup\u011b jednoduch\u00e9)<\/h3>\n\n\n\n

      Krok 1:<\/strong> Po\u017e\u00e1dejte o zku\u0161ebn\u00ed licenci n\u00ed\u017ee (trv\u00e1 30 sekund)<\/p>\n\n\n\n

      Krok 2:<\/strong> Instalace vizu\u00e1ln\u00ed aplikace v Power BI (trv\u00e1 2 minuty)<\/p>\n\n\n\n

      Krok 3:<\/strong> P\u0159ipojen\u00ed dat - pole kategorie a hodnoty (trv\u00e1 5 minut)<\/p>\n\n\n\n

      Krok 4:<\/strong> Sledujte, jak va\u0161e zainteresovan\u00e9 strany kone\u010dn\u011b vid\u00ed vzory v \u010d\u00edslech<\/p>\n\n\n\n

      To je v\u0161e. \u017d\u00e1dn\u00ed konzultanti. \u017d\u00e1dn\u00e1 \u0161kolen\u00ed. \u017d\u00e1dn\u00e9 slo\u017eit\u00e9 nastaven\u00ed. Sta\u010d\u00ed p\u0159ipojit data a spustit.<\/p>\n\n\n\n

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

      Pro koho to je (a pro koho to nen\u00ed)<\/h3>\n\n\n\n

      Tohle je pro v\u00e1s, pokud:<\/strong><\/p>\n\n\n\n

        \n
      • Jste v FP&A<\/strong> a pot\u0159ebuj\u00ed tabulky, kter\u00e9 komunikuj\u00ed, nejen zobrazuj\u00ed data.<\/li>\n\n\n\n
      • Jste \u0158\u00eddic\u00ed jednotka<\/strong> prezentace srovn\u00e1n\u00ed n\u00e1kladov\u00fdch st\u0159edisek s vizu\u00e1ln\u00edm kontextem.<\/li>\n\n\n\n
      • Jste Obchodn\u00ed analytik<\/strong> vytv\u00e1\u0159en\u00ed \u0159\u00eddic\u00edch panel\u016f, kde tabulky mus\u00ed vypr\u00e1v\u011bt p\u0159\u00edb\u011bh.<\/li>\n\n\n\n
      • Pot\u0159ebujete zobrazit v\u00edce m\u011b\u0159en\u00ed vedle sebe pomoc\u00ed inline vizualizace.<\/li>\n\n\n\n
      • Chcete tabulky se zmrazen\u00fdmi sloupci, kter\u00e9 p\u0159i posouv\u00e1n\u00ed neztr\u00e1cej\u00ed kontext.<\/li>\n\n\n\n
      • U\u017e v\u00e1s unavuje, \u017ee vedouc\u00ed pracovn\u00edci ignoruj\u00ed va\u0161e tabulky, proto\u017ee jsou to jen st\u011bny \u010d\u00edsel.<\/li>\n\n\n\n
      • Va\u0161e zainteresovan\u00e9 strany pot\u0159ebuj\u00ed vid\u011bt vzory, ne jen \u010d\u00edst \u010d\u00edsla.<\/li>\n<\/ul>\n\n\n\n

        Tento produkt NEN\u00cd pro v\u00e1s, pokud:<\/strong><\/p>\n\n\n\n

          \n
        • Pot\u0159ebujete pouze jednoduchou datovou m\u0159\u00ed\u017eku bez vizu\u00e1ln\u00edch prvk\u016f (pou\u017eijte vestav\u011bnou m\u0159\u00ed\u017eku Power BI).<\/li>\n\n\n\n
        • Nepot\u0159ebujete \u0159\u00e1dkov\u00e9 sloupce ani vizu\u00e1ln\u00ed porovn\u00e1n\u00ed nap\u0159\u00ed\u010d \u0159\u00e1dky.<\/li>\n\n\n\n
        • Nepou\u017e\u00edv\u00e1te Power BI (jedn\u00e1 se o vlastn\u00ed vizualizaci Power BI).<\/li>\n\n\n\n
        • Hled\u00e1te software zdarma (jedn\u00e1 se o profesion\u00e1ln\u00ed n\u00e1stroje s podporou).<\/li>\n<\/ul>\n\n\n\n
          <\/div>\n\n\n\n

          Nej\u010dast\u011bj\u0161\u00ed ot\u00e1zky (ne\u017e se zept\u00e1te)<\/h3>\n\n\n\n

          Ot\u00e1zka: Funguje s m\u00fdm st\u00e1vaj\u00edc\u00edm datov\u00fdm modelem Power BI?<\/strong>
          Odpov\u011b\u010f: Ano. Pot\u0159ebujete pole Kategorie a pole Hodnota. Pro re\u017eim mal\u00fdch n\u00e1sobk\u016f p\u0159idejte v\u00edce hodnot. Funguje s jak\u00fdmkoli zdrojem dat, kter\u00fd Power BI podporuje.<\/p>\n\n\n\n

          Ot\u00e1zka: Co je to re\u017eim Small Multiples?<\/strong>
          Odpov\u011b\u010f: P\u0159idejte do pole Hodnota v\u00edce opat\u0159en\u00ed. Ka\u017ed\u00e1 m\u00edra z\u00edsk\u00e1 vlastn\u00ed sloupec s \u0159\u00e1dkov\u00fdmi sloupci. Porovn\u00e1vejte v\u00fdnosy, n\u00e1klady a mar\u017ee v jednom kompaktn\u00edm maticov\u00e9m uspo\u0159\u00e1d\u00e1n\u00ed.<\/p>\n\n\n\n

          Ot\u00e1zka: Jak funguj\u00ed \u0159adov\u00e9 ty\u010de?<\/strong>
          Odpov\u011b\u010f: Ka\u017ed\u00e1 hodnota se zobraz\u00ed s proporcion\u00e1ln\u00edm sloupcem, jeho\u017e m\u011b\u0159\u00edtko odpov\u00edd\u00e1 rozsahu dat sloupce. V\u011bt\u0161\u00ed hodnoty maj\u00ed del\u0161\u00ed sloupce. Porovn\u00e1n\u00ed je okam\u017eit\u00e9 a vizu\u00e1ln\u00ed.<\/p>\n\n\n\n

          Ot\u00e1zka: Jak\u00fd je sloupec zmrazen\u00e9 kategorie?<\/strong>
          Odpov\u011b\u010f: Popisky kategori\u00ed z\u016fst\u00e1vaj\u00ed p\u0159ipnut\u00e9 vlevo, zat\u00edmco proch\u00e1z\u00edte sloupce hodnot. V\u017edy vid\u00edte, na kter\u00fd \u0159\u00e1dek se d\u00edv\u00e1te, a to i v \u0161irok\u00fdch tabulk\u00e1ch.<\/p>\n\n\n\n

          Ot\u00e1zka: Mohu si p\u0159izp\u016fsobit barvy tak, aby odpov\u00eddaly na\u0161\u00ed firemn\u00ed zna\u010dce?<\/strong>
          Odpov\u011b\u010f: V\u0161e je mo\u017en\u00e9 p\u0159izp\u016fsobit. Barvy pruh\u016f. Barvy pozad\u00ed. Velikosti p\u00edsma. \u0160\u00ed\u0159ky sloupc\u016f. P\u0159izp\u016fsobte to sv\u00e9 zna\u010dce.<\/p>\n\n\n\n

          Ot\u00e1zka: Zpracov\u00e1v\u00e1 efektivn\u011b mnoho \u0159\u00e1dk\u016f?<\/strong>
          Odpov\u011b\u010f: Ano. Vizu\u00e1l je optimalizov\u00e1n pro v\u00fdkon s responzivn\u00edm vykreslov\u00e1n\u00edm, kter\u00e9 se \u0161k\u00e1luje podle velikosti dat.<\/p>\n\n\n\n

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

          Co se stane po vy\u017e\u00e1d\u00e1n\u00ed zku\u0161ebn\u00ed licence<\/h3>\n\n\n\n
            \n
          1. Vypln\u00edte v\u00fd\u0161e uveden\u00fd formul\u00e1\u0159 (30 sekund).<\/li>\n\n\n\n
          2. Po\u0161leme v\u00e1m e-mailem zku\u0161ebn\u00ed licen\u010dn\u00ed k\u00f3d (do 24 hodin).<\/li>\n\n\n\n
          3. Nainstalujete vizu\u00e1ln\u00ed aplikaci ze slu\u017eby Microsoft AppSource (2 minuty).<\/li>\n\n\n\n
          4. Zadejte licen\u010dn\u00ed k\u00f3d do okna form\u00e1tu (10 sekund).<\/li>\n\n\n\n
          5. Propoj\u00edte pole Kategorie a Hodnota (2 minuty).<\/li>\n\n\n\n
          6. Data se zobraz\u00ed jako maticov\u00e1 tabulka s \u0159\u00e1dkov\u00fdmi sloupci.<\/li>\n\n\n\n
          7. P\u0159id\u00e1v\u00e1te dal\u0161\u00ed opat\u0159en\u00ed a sledujete, jak se objevuj\u00ed mal\u00e9 n\u00e1sobky.<\/li>\n\n\n\n
          8. V\u00e1\u0161 finan\u010dn\u00ed \u0159editel se pt\u00e1: \"Pro\u010d jsme to nem\u011bli u\u017e d\u0159\u00edve?\"<\/li>\n<\/ol>\n\n\n\n

            Pak se rozhodn\u011bte: Rozhodn\u011bte se, zda ji budete pou\u017e\u00edvat d\u00e1l (kupte si licenci), nebo se vr\u00e1t\u00edte k tabulk\u00e1m, kter\u00e9 nikdo ne\u010dte (pros\u00edm, ne\u010dt\u011bte).<\/p>\n\n\n\n

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

            Po\u017e\u00e1dejte o zku\u0161ebn\u00ed licenci<\/h3>\n\n\n\n\n\n\n
            <\/div>\n\n\n\n

            Je\u0161t\u011b jedna v\u011bc (Z\u00e1ruka)<\/h3>\n\n\n\n

            Jsme p\u0159esv\u011bd\u010deni, \u017ee se jedn\u00e1 o nejlep\u0161\u00ed vizualizaci maticov\u00e9 tabulky pro Power BI. Te\u010dka. Ale nebudeme dr\u017eet va\u0161e pen\u00edze jako rukojm\u00ed, pokud s t\u00edm nesouhlas\u00edte.<\/p>\n\n\n\n

            Vyzkou\u0161ejte zku\u0161ebn\u00ed licenci. Pokud nezobrazuje va\u0161e data s p\u0159ehledn\u00fdmi \u0159\u00e1dkov\u00fdmi sloupci, nezvl\u00e1d\u00e1 hladce mal\u00e9 n\u00e1sobky nebo neumo\u017e\u0148uje lep\u0161\u00ed \u010ditelnost tabulek - sta\u010d\u00ed n\u00e1m to \u0159\u00edct. Vy\u0159e\u0161\u00edme to nebo v\u00e1m vr\u00e1t\u00edme pen\u00edze. \u017d\u00e1dn\u00e9 obstrukce.<\/p>\n\n\n\n

            Vytvo\u0159ili jsme ji, proto\u017ee n\u00e1s frustrovaly tabulky v Power BI. Pou\u017e\u00edv\u00e1me to. Na\u0161i klienti to pou\u017e\u00edvaj\u00ed pro \u0159\u00eddic\u00ed panely. Funguje to.<\/p>\n\n\n\n

            Zku\u0161ebn\u00ed licenci si m\u016f\u017eete vy\u017e\u00e1dat n\u00ed\u017ee. Vyzkou\u0161ejte si, jak funguje ve va\u0161em prost\u0159ed\u00ed s va\u0161imi daty.<\/strong><\/p>\n\n\n\n

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

            Od gener\u00e1ln\u00edho \u0159editele (Pro\u010d jsme to postavili)<\/h3>\n\n\n\n
            \n

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

            J\u00e1 jsem Stefan. Gener\u00e1ln\u00ed \u0159editel spole\u010dnosti LeapLytics.

            Vytvo\u0159ili jsme ji, proto\u017ee tabulky v Power BI byly nefunk\u010dn\u00ed.

            Ka\u017ed\u00fd vizu\u00e1l tabulky byl bu\u010f p\u0159\u00edli\u0161 jednoduch\u00fd (jen \u010d\u00edsla, \u017e\u00e1dn\u00e9 vizu\u00e1ly), nebo p\u0159\u00edli\u0161 slo\u017eit\u00fd (vy\u017eadoval vlastn\u00ed v\u00fdvoj pro p\u0159id\u00e1n\u00ed inline graf\u016f).

            Finan\u010dn\u00ed t\u00fdmy p\u0159edkl\u00e1daly st\u011bny \u010d\u00edsel, kter\u00e9 vedouc\u00ed pracovn\u00edci p\u0159eskakovali. Controlle\u0159i nemohli zobrazit srovn\u00e1n\u00ed n\u00e1kladov\u00fdch st\u0159edisek s vizu\u00e1ln\u00edm kontextem. Odd\u011blen\u00ed FP&A muselo vytv\u00e1\u0159et samostatn\u00e9 grafy jen proto, aby vizualizovalo stejn\u00e1 data, kter\u00e1 ji\u017e byla v jejich tabulk\u00e1ch.

            Tak jsme postavili to, co jsme skute\u010dn\u011b cht\u011bli:

            \u2192 \u0158\u00e1dkov\u00e9 sloupcov\u00e9 grafy v ka\u017ed\u00e9m \u0159\u00e1dku (ne samostatn\u00e9 vizualizace)
            \u2192 Re\u017eim mal\u00fdch n\u00e1sobk\u016f pro porovn\u00e1v\u00e1n\u00ed v\u00edce m\u011b\u0159en\u00ed (ne v\u00edce tabulek)
            \u2192 Zmrazen\u00e9 sloupce kategori\u00ed, kter\u00e9 zachov\u00e1vaj\u00ed kontext (nikoli \"posouv\u00e1n\u00ed a zapom\u00edn\u00e1n\u00ed\").
            \u2192 Synchronizovan\u00e9 zv\u00fdraz\u0148ov\u00e1n\u00ed \u0159\u00e1dk\u016f (ne \"na kter\u00e9m \u0159\u00e1dku jsem byl?\")
            \u2192 Responzivn\u00ed design, kter\u00fd funguje v\u0161ude (ne \"ru\u010dn\u00ed zm\u011bna velikosti\")
            \u2192 dynamick\u00e9 n\u00e1zvy z va\u0161ich dat (nikoliv pevn\u011b zak\u00f3dovan\u00e9 \u0161t\u00edtky)

            Tento n\u00e1stroj pou\u017e\u00edv\u00e1me intern\u011b. Na\u0161i poraden\u0161t\u00ed klienti jej pou\u017e\u00edvaj\u00ed pro mana\u017eersk\u00e9 \u0159\u00eddic\u00ed panely. Nen\u00ed dokonal\u00fd, ale je to nejlep\u0161\u00ed vizu\u00e1ln\u00ed n\u00e1stroj pro maticov\u00e9 tabulky v Power BI. A to hodn\u011b.

            Pokud prezentujete tabulkov\u00e1 data a pot\u0159ebujete je vizu\u00e1ln\u011b sd\u011blit, je to pro v\u00e1s.

            Stefan Preusler
            Gener\u00e1ln\u00ed \u0159editel spole\u010dnosti LeapLytics GmbH<\/p>\n<\/blockquote>\n\n\n\n

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

            Za\u010dn\u011bte<\/h3>\n\n\n\n

            Zku\u0161ebn\u00ed licenci si m\u016f\u017eete vy\u017e\u00e1dat v\u00fd\u0161e. K\u00f3d v\u00e1m za\u0161leme e-mailem do 24 hodin. Instalace z AppSource. Zadejte licenci. P\u0159ipojte sv\u00e1 data. Pod\u00edvejte se, jak va\u0161e tabulky o\u017e\u00edvaj\u00ed.<\/p>\n\n\n\n

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

            \u00dapln\u00fd seznam funkc\u00ed (abyste p\u0159esn\u011b v\u011bd\u011bli, co dost\u00e1v\u00e1te)<\/h3>\n\n\n\n

            Inline vizualizace:<\/strong> Propor\u010dn\u00ed sloupcov\u00e9 grafy v ka\u017ed\u00e9 bu\u0148ce - Automatick\u00e9 \u0161k\u00e1lov\u00e1n\u00ed na sloupec - Vizu\u00e1ln\u00ed srovn\u00e1n\u00ed nap\u0159\u00ed\u010d \u0159\u00e1dky - Okam\u017eit\u00e9 rozpozn\u00e1n\u00ed vzor\u016f - Barevn\u011b odli\u0161en\u00e9 sloupce<\/p>\n\n\n\n

            Re\u017eim mal\u00fdch n\u00e1sobk\u016f:<\/strong> V\u00edce m\u011b\u0159en\u00ed vedle sebe - Rozlo\u017een\u00ed matice s \u0159\u00e1dkov\u00fdmi sloupci pro ka\u017ed\u00e9 m\u011b\u0159en\u00ed - Porovn\u00e1n\u00ed nap\u0159\u00ed\u010d kategoriemi A m\u011b\u0159en\u00edmi - \u010c\u00e1ry osy pro v\u0161echny sloupce - N\u00e1zvy m\u011b\u0159en\u00ed v z\u00e1hlav\u00edch<\/p>\n\n\n\n

            Zmrzl\u00e9 sloupy:<\/strong> Sloupec kategori\u00ed z\u016fst\u00e1v\u00e1 viditeln\u00fd - Proch\u00e1zen\u00ed hodnot bez ztr\u00e1ty kontextu - Synchronizovan\u00e9 barvy pozad\u00ed - Profesion\u00e1ln\u00ed rozvr\u017een\u00ed s pevn\u00fdm sloupcem<\/p>\n\n\n\n

            Interakce v \u0159ad\u011b:<\/strong> Synchronizovan\u00e9 zv\u00fdrazn\u011bn\u00ed p\u0159i najet\u00ed my\u0161\u00ed - Zv\u00fdrazn\u011bn\u00ed cel\u00e9ho \u0159\u00e1dku ve zmrazen\u00fdch oblastech a oblastech hodnot - Podpora kontextov\u00e9ho menu - V\u00fdb\u011br kliknut\u00edm a k\u0159\u00ed\u017eov\u00fd filtr<\/p>\n\n\n\n

            Dynamick\u00e9 z\u00e1hlav\u00ed:<\/strong> Nadpisy ze zobrazovan\u00fdch n\u00e1zv\u016f datov\u00fdch rol\u00ed - Z\u00e1hlav\u00ed sloupc\u016f z n\u00e1zv\u016f m\u011b\u0159en\u00ed - Automatick\u00e9 ozna\u010dov\u00e1n\u00ed z datov\u00e9ho modelu - \u017d\u00e1dn\u00fd pevn\u011b zadan\u00fd text<\/p>\n\n\n\n

            \u0160t\u00edtky a form\u00e1tov\u00e1n\u00ed:<\/strong> Popisky hodnot v bu\u0148k\u00e1ch - Podpora form\u00e1tov\u00e1n\u00ed \u010d\u00edsel - Citliv\u00e9 nastaven\u00ed velikosti p\u00edsma - \u010cist\u00e9 um\u00edst\u011bn\u00ed popisku - Redukovan\u00fd padding pro kompaktn\u00ed zobrazen\u00ed<\/p>\n\n\n\n

            Barvy a styling:<\/strong> P\u0159izp\u016fsobiteln\u00e9 barvy sloupc\u016f - Ovl\u00e1d\u00e1n\u00ed barvy pozad\u00ed - Odpov\u00eddaj\u00edc\u00ed pozad\u00ed zmrazen\u00e9ho sloupce - Profesion\u00e1ln\u00ed vzhled - P\u0159ipraveno pro firemn\u00ed zna\u010dku<\/p>\n\n\n\n

            Integrace Power BI:<\/strong> K\u0159\u00ed\u017eov\u00e9 filtrov\u00e1n\u00ed - Podpora v\u00fdb\u011bru - Nativn\u00ed kontextov\u00e1 nab\u00eddka - Podpora n\u00e1pov\u011bdy - Kompatibilita se z\u00e1lo\u017ekami - Export do PDF\/PowerPoint - Konfigurace podokna form\u00e1tu<\/p>\n\n\n\n

            Responzivn\u00ed design:<\/strong> Funguje od mal\u00fdch dla\u017edic a\u017e po 4K - V\u0161echny prvky se proporcion\u00e1ln\u011b \u0161k\u00e1luj\u00ed - Sloupce se p\u0159izp\u016fsobuj\u00ed \u0161\u00ed\u0159ce sloupc\u016f - \u0160t\u00edtky se p\u0159izp\u016fsobuj\u00ed dostupn\u00e9mu prostoru - Nen\u00ed t\u0159eba ru\u010dn\u011b m\u011bnit velikost.<\/p>\n\n\n\n

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

            Co z\u00edsk\u00e1te<\/h2>\n\n\n\n

            Pod\u00edvejte se na sv\u016fj datov\u00fd p\u0159\u00edb\u011bh na prvn\u00ed pohled<\/h3>\n\n\n\n
              \n
            • \u0158adov\u00e9 pruhy, kter\u00e9 komunikuj\u00ed<\/strong>: Ka\u017ed\u00e1 hodnota se zobraz\u00ed v proporcion\u00e1ln\u00edm sloupci - vzorce vysko\u010d\u00ed, porovn\u00e1n\u00ed jsou okam\u017eit\u00e1, nen\u00ed nutn\u00e1 \u017e\u00e1dn\u00e1 du\u0161evn\u00ed matematika.<\/li>\n\n\n\n
            • Skute\u010dn\u00e1 integrace Power BI<\/strong>: Klikn\u011bte na \u0159\u00e1dek zde, vyfiltrujte v\u0161e zde - cel\u00fd panel se aktualizuje, proto\u017ee je postaven na nativn\u00ed architektu\u0159e Power BI.<\/li>\n\n\n\n
            • Mal\u00e9 n\u00e1sobky, kter\u00e9 maj\u00ed smysl<\/strong>: V\u00edce opat\u0159en\u00ed v maticov\u00e9m uspo\u0159\u00e1d\u00e1n\u00ed - v\u00fdnosy, n\u00e1klady, mar\u017ee vedle sebe s vizu\u00e1ln\u00edm kontextem pro ka\u017ed\u00e9 z nich.<\/li>\n\n\n\n
            • Zmrazen\u00e9 sloupce pro skute\u010dnou anal\u00fdzu<\/strong>: Popisky kategori\u00ed z\u016fst\u00e1vaj\u00ed viditeln\u00e9 i p\u0159i zkoum\u00e1n\u00ed hodnot - nikdy neztrat\u00edte p\u0159ehled o tom, kter\u00fd \u0159\u00e1dek analyzujete.<\/li>\n\n\n\n
            • Reaguje na v\u0161e<\/strong>: Dla\u017edice p\u0159\u00edstrojov\u00e9 desky na prezentaci p\u0159es celou obrazovku - li\u0161ty, popisky a sloupce se automaticky \u0161k\u00e1luj\u00ed.<\/li>\n<\/ul>\n\n\n\n

              P\u0159estat vytv\u00e1\u0159et samostatn\u00e9 grafy pro tabulkov\u00e1 data<\/h3>\n\n\n\n
                \n
              • \u0158\u00e1dkov\u00e9 sloupce Nahradit duplicitn\u00ed grafy<\/strong>: Nen\u00ed pot\u0159eba tabulka A sloupcov\u00fd graf zobrazuj\u00edc\u00ed stejn\u00e1 data - z\u00edsk\u00e1te oboj\u00ed v jednom vizu\u00e1ln\u00edm zobrazen\u00ed.<\/li>\n\n\n\n
              • Mal\u00e9 n\u00e1sobky nahrazuj\u00ed v\u00edcen\u00e1sobn\u00e9 vizualizace<\/strong>: Porovn\u00e1n\u00ed opat\u0159en\u00ed v jedn\u00e9 kompaktn\u00ed matici nam\u00edsto t\u0159\u00ed samostatn\u00fdch tabulek<\/li>\n\n\n\n
              • Zv\u00fdrazn\u011bn\u00ed \u0159\u00e1dk\u016f v\u00e1s udr\u017e\u00ed v orientaci<\/strong>: Naje\u010fte kamkoli my\u0161\u00ed a uvid\u00edte rozsv\u00edcen\u00fd cel\u00fd \u0159\u00e1dek - bez n\u00e1mahy m\u016f\u017eete sledovat sloupce.<\/li>\n\n\n\n
              • Dynamick\u00e9 hlavi\u010dky z va\u0161ich dat<\/strong>: N\u00e1zvy opat\u0159en\u00ed se automaticky st\u00e1vaj\u00ed z\u00e1hlav\u00edmi sloupc\u016f - nen\u00ed nutn\u00e9 je ozna\u010dovat ru\u010dn\u011b.<\/li>\n<\/ul>\n\n\n\n

                Va\u0161e data. V\u00e1\u0161 zp\u016fsob. Bez starost\u00ed.<\/h3>\n\n\n\n
                  \n
                • Jednoduch\u00e9 po\u017eadavky na data<\/strong>: Pole Kategorie, pole Hodnota - p\u0159idejte dal\u0161\u00ed hodnoty pro Mal\u00e9 n\u00e1sobky<\/li>\n\n\n\n
                • Funguje s jak\u00fdmkoli zdrojem<\/strong>: Excel, SQL, SAP, Oracle, Dynamics - pokud se k nim Power BI dok\u00e1\u017ee p\u0159ipojit, m\u016f\u017eeme je vizualizovat.<\/li>\n\n\n\n
                • \u017div\u00e1 data, ne sn\u00edmky obrazovky<\/strong>: Obnovte soubor dat a vizu\u00e1ln\u00ed aktualizace - zobrazte dne\u0161n\u00ed \u010d\u00edsla, ne \u010d\u00edsla z minul\u00e9ho t\u00fddne.<\/li>\n\n\n\n
                • Okam\u017eit\u00fd vizu\u00e1ln\u00ed kontext<\/strong>: P\u0159idejte sv\u00e1 data a \u0159\u00e1dky se zobraz\u00ed automaticky - nen\u00ed t\u0159eba \u017e\u00e1dn\u00e9 konfigurace.<\/li>\n<\/ul>\n\n\n\n

                  Vypad\u00e1 profesion\u00e1ln\u011b bez n\u00e1mahy<\/h3>\n\n\n\n
                    \n
                  • P\u0159izp\u016fsobte si barvy tak, aby odpov\u00eddaly va\u0161\u00ed zna\u010dce<\/strong>: Barvy pruh\u016f, pozad\u00ed - nastaven\u00ed firemn\u00edch barev b\u011bhem n\u011bkolika sekund<\/li>\n\n\n\n
                  • \u0160t\u00edtky, kter\u00e9 se hod\u00ed<\/strong>: Inteligentn\u00ed polohov\u00e1n\u00ed, citliv\u00e9 p\u0159izp\u016fsoben\u00ed velikosti, \u010dist\u00e9 form\u00e1tov\u00e1n\u00ed v ka\u017ed\u00e9 bu\u0148ce<\/li>\n\n\n\n
                  • \u010cist\u00fd profesion\u00e1ln\u00ed vzhled<\/strong>: Ur\u010deno pro \u0159\u00eddic\u00ed panely a prezentace pro spr\u00e1vn\u00ed rady.<\/li>\n\n\n\n
                  • Konzistentn\u00ed nap\u0159\u00ed\u010d za\u0159\u00edzen\u00edmi<\/strong>: Notebook, stoln\u00ed po\u010d\u00edta\u010d, tablet - v\u0161ude vypad\u00e1 profesion\u00e1ln\u011b<\/li>\n<\/ul>\n\n\n\n

                    P\u0159ipraveno pro podniky<\/h3>\n\n\n\n
                      \n
                    • Optimalizovan\u00fd v\u00fdkon<\/strong>: Efektivn\u00ed vykreslov\u00e1n\u00ed velk\u00fdch soubor\u016f dat<\/li>\n\n\n\n
                    • V souladu se zabezpe\u010den\u00edm<\/strong>: \u017d\u00e1dn\u00fd p\u0159enos dat mimo prost\u0159ed\u00ed Power BI<\/li>\n\n\n\n
                    • Spr\u00e1va licenc\u00ed<\/strong>: Podnikov\u00e9 licencov\u00e1n\u00ed s ov\u011b\u0159ov\u00e1n\u00edm<\/li>\n\n\n\n
                    • Profesion\u00e1ln\u00ed podpora<\/strong>: Skute\u010dn\u00ed lid\u00e9, kte\u0159\u00ed rozum\u00ed financ\u00edm 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\/cs\/wp-json\/wp\/v2\/pages\/14568","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=14568"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages\/14568\/revisions"}],"predecessor-version":[{"id":14579,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages\/14568\/revisions\/14579"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/media?parent=14568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}