- \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":"
Our Risk Heatmap \/ Matrix requires 1 to 10 as values, but what to do if your data is continuous and not in this interval? Or if the expressions of your risks consist of words? Below are four solutions with binning, quintiles, custom thresholds and words to numbers mapping. Binning In this solution approach, all … <\/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