- \n
- 0 a\u017e 20<\/em><\/li>\n\n\n\n
- 21 a\u017e 40<\/em><\/li>\n\n\n\n
- 41 a\u017e 60<\/em><\/li>\n\n\n\n
- 61 a\u017e 80<\/em><\/li>\n\n\n\n
- 81 a\u017e 100<\/em><\/li>\n<\/ul>\n\n\n\n
Nezohled\u0148uje tedy mno\u017estv\u00ed rizik v jednotliv\u00fdch ko\u0161\u00edch.<\/strong> Rozsahy dat jsou rozd\u011bleny pouze rovnom\u011brn\u011b.<\/em><\/p>\n\n\n\n
\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-4.png\")
<\/figure>\n<\/div>\n\n\n\n\nNa postrann\u00edm panelu nejprve klikn\u011bte prav\u00fdm tla\u010d\u00edtkem my\u0161i na pole, kter\u00e9 chcete transformovat. V na\u0161em p\u0159\u00edpad\u011b pole \"P\u0159\u00edklad dopadu\".<\/p>\n\n\n\n
Pot\u00e9 kliknut\u00edm lev\u00fdm tla\u010d\u00edtkem my\u0161i vyberte mo\u017enost \"Nov\u00e1 skupina\". Otev\u0159e se okno \"Skupiny\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nZde vyberte mo\u017enost \"Number of bins\" (Po\u010det ko\u0161\u016f) pro \"Bin type\" (Typ ko\u0161e). Vlevo dole zad\u00e1te hodnotu \"10\" jako \"Bin Count\". Pot\u00e9 se automaticky vypo\u010d\u00edt\u00e1 \u0161\u00ed\u0159ka ko\u0161\u016f v polo\u017ece \"Bin size\" (Velikost ko\u0161e).<\/p>\n\n\n\n
Nakonec klikn\u011bte na tla\u010d\u00edtko \"OK\".<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-5.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\n\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-6.png\")
<\/figure>\n<\/div>\n\n\n\n\nV posledn\u00edm kroku znovu klikn\u011bte na nov\u011b vytvo\u0159en\u00e9 pole v postrann\u00edm panelu.<\/p>\n\n\n\n
Nyn\u00ed se op\u011bt zobraz\u00ed okno \"Skupiny\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nZde vyberte typ skupiny \"Seznam\" nam\u00edsto \"Ko\u0161\". Neseskupen\u00e9 hodnoty se zobraz\u00ed v lev\u00e9m poli.<\/p>\n\n\n\n
Nyn\u00ed spust\u00edte a vyberete jednotliv\u00e9 hodnoty a p\u0159esunete je do prav\u00e9ho sloupce pomoc\u00ed tla\u010d\u00edtka \"Seskupit\".<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-7.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\n\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-8.png\")
<\/figure>\n<\/div>\n\n\n\n\nT\u00e9m\u011b\u0159 hotovo! Nyn\u00ed p\u0159i\u0159ad\u00edte hodnoty 1 a\u017e 10 deseti hodnot\u00e1m tak, \u017ee dvakr\u00e1t kliknete na ka\u017edou nadskupinu a vlo\u017e\u00edte hodnoty. Nakonec kliknete na \"OK\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nHotovo! Data jste transformovali a nyn\u00ed je m\u016f\u017eete p\u0159et\u00e1hnout na osu v na\u0161\u00ed matici rizik.<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-9.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\nQuintiles<\/h2>\n\n\n\n
\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-11.png\")
<\/figure>\n<\/div>\n\n\n\n\nNejprve op\u011bt klikneme prav\u00fdm tla\u010d\u00edtkem my\u0161i na pole, kter\u00e9 chceme diskretizovat. V na\u0161em p\u0159\u00edkladu je to \"Impact Example\". Pot\u00e9 vybereme mo\u017enost \"Nov\u00e9 opat\u0159en\u00ed\". Nad p\u0159\u00edstrojovou deskou se otev\u0159e editor DAX.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Nyn\u00ed p\u0159id\u00e1me n\u00e1sleduj\u00edc\u00ed k\u00f3d, p\u0159izp\u016fsoben\u00fd tabulce a po\u017eadovan\u00e9mu sloupci v datov\u00e9 sad\u011b. D\u016fle\u017eit\u00e9 - toto je p\u0159\u00edklad pro kvantily. V p\u0159\u00edpad\u011b pot\u0159eby jej m\u016f\u017eete upravit pro percentily:<\/p>\n\n\n\n
Kvantil =\nvar FirstQuantile = CALCULATE(PERCENTILE.INC(Table[Column], .2), ALL(Table[Column]))\nvar SecondQuantile = CALCULATE(PERCENTILE.INC(Table[Column], .4), ALL(Table[Column])\nvar ThirdQuantile = CALCULATE(PERCENTILE.INC(Table[Column], .6), ALL(Table[Column])\nvar FourthQuantile = CALCULATE(PERCENTILE.INC(Table[Column], .8), ALL(Table[Column])\nvar ThisVal = Min(Tabulka[Sloupec])\nreturn\nIF(HASONEVALUE(Tabulka[Sloupec]),\n\t\tIF(ThisVal FirstQuantile && ThisVal SecondQuantile && ThisVal ThirdQuantile && ThisVal <= FourthQuantile, 4,\n\t\t\t\t5)\n\t\t\t)\n\t\t)\n) )<\/code><\/pre>\n\n\n\n\n\nP\u0159ipraveno! T\u00edm jsme diskretizovali a z\u00edskali hodnoty 1 a\u017e 5. Nyn\u00ed m\u016f\u017eeme toto pole pou\u017e\u00edt pro na\u0161i matici rizik!<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-12.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\nVlastn\u00ed prahov\u00e9 hodnoty<\/h2>\n\n\n\n
\n\n<\/figure>\n<\/div>\n\n\n\n\nNejprve op\u011bt klikneme prav\u00fdm tla\u010d\u00edtkem my\u0161i na pole, kter\u00e9 chceme diskretizovat. V na\u0161em p\u0159\u00edkladu je to \"Impact Example\". Pot\u00e9 vybereme mo\u017enost \"Nov\u00e9 opat\u0159en\u00ed\". Nad p\u0159\u00edstrojovou deskou se otev\u0159e editor DAX.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Nyn\u00ed p\u0159id\u00e1me n\u00e1sleduj\u00edc\u00ed k\u00f3d, p\u0159izp\u016fsoben\u00fd tabulce a po\u017eadovan\u00e9mu sloupci v datov\u00e9 sad\u011b:<\/p>\n\n\n\n
Custom_Thresholds =\nvar FirstThreshold = your_first_threshold_value_here\nvar SecondThreshold = your_second_threshold_value_here\nvar ThirdThreshold = your_third_threshold_value_here\nvar FourthThreshold = your_fourth_threshold_value_here\nvar ThisVal = Min(Tabulka[Sloupec])\nreturn\nIF(HASONEVALUE(Table[Column]),\n\t\tIF(ThisVal FirstThreshold && ThisVal SecondThreshold && ThisVal ThirdThreshold && ThisVal <= FourthThreshold, 4,\n\t\t\t\t5)\n\t\t\t)\n\t\t)\n) )<\/code><\/pre>\n\n\n\nP\u0159evod slova na \u010d\u00edsla<\/h2>\n\n\n\n
\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-17.png\")
<\/figure>\n<\/div>\n\n\n\n\nNejprve klikn\u011bte na mo\u017enost \"Transformovat data\" v nab\u00eddce. T\u00edm se otev\u0159e editor dotaz\u016f Power Query.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nVyberete sloupec, kter\u00fd chcete transformovat. V tomto p\u0159\u00edkladu je to sloupec \"Text pravd\u011bpodobnosti\". Pot\u00e9 klikn\u011bte na \"Sloupec z p\u0159\u00edklad\u016f\" v lev\u00e9m horn\u00edm rohu a vyberte \"Z v\u00fdb\u011bru\".<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-18.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\n\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-19.png\")
<\/figure>\n<\/div>\n\n\n\n\nJe p\u0159id\u00e1n nov\u00fd sloupec. Klikn\u011bte na prvn\u00ed bu\u0148ku nov\u00e9ho sloupce a vlo\u017ete po\u017eadovanou \u010d\u00edselnou hodnotu. V na\u0161em p\u0159\u00edkladu odpov\u00edd\u00e1 \"Remote\" (nejni\u017e\u0161\u00ed v\u00fdraz) hodnot\u011b \"1\". Nemus\u00edte m\u011bnit v\u0161echny hodnoty jednotliv\u011b. Power BI rozpozn\u00e1 \u010d\u00edsla a automaticky je namapuje podle nich. <\/strong><\/em>dva<\/strong> va\u0161e p\u0159\u00edklady.<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nTento postup opakujte pro ka\u017ed\u00fd v\u00fdraz v souboru dat...<\/p>\n<\/div>\n\n\n\n
\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-20.png\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\n\n\n![\"\"](\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/grafik-21.png\")
<\/figure>\n<\/div>\n\n\n\n\nPo namapov\u00e1n\u00ed posledn\u00edho v\u00fdrazu nakonec klikn\u011bte na tla\u010d\u00edtko \"OK\" . A je to: Transformovan\u00fd sloupec \"Pravd\u011bpodobnost\". Tento postup zopakujete s \"Dopadem\" a m\u00e1te po\u017eadovan\u00fd form\u00e1t dat. Zvolili jsme tuto logiku 1 a\u017e 10, proto\u017ee ka\u017ed\u00fd m\u00e1 jin\u00e9 zn\u011bn\u00ed p\u011bti kategori\u00ed.<\/p>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"
Na\u0161e teplotn\u00ed mapa \/ matice rizik vy\u017eaduje hodnoty v rozmez\u00ed 1 a\u017e 10, ale co d\u011blat, pokud jsou va\u0161e data spojit\u00e1 a nespadaj\u00ed do tohoto intervalu? Nebo pokud jsou va\u0161e rizika vyj\u00e1d\u0159ena slovy? N\u00ed\u017ee uv\u00e1d\u00edme \u010dty\u0159i \u0159e\u0161en\u00ed zahrnuj\u00edc\u00ed seskupov\u00e1n\u00ed do interval\u016f, kvintily, vlastn\u00ed prahov\u00e9 hodnoty a p\u0159evod slov na \u010d\u00edsla. Seskupov\u00e1n\u00ed do interval\u016f V tomto p\u0159\u00edstupu se v\u0161echna \u2026 <\/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-8499","page","type-page","status-publish","hentry","latest_post"],"_links":{"self":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages\/8499","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=8499"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages\/8499\/revisions"}],"predecessor-version":[{"id":13647,"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/pages\/8499\/revisions\/13647"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/cs\/wp-json\/wp\/v2\/media?parent=8499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- 21 a\u017e 40<\/em><\/li>\n\n\n\n