- \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
Nezoh\u013ead\u0148uje sa teda mno\u017estvo riz\u00edk v r\u00e1mci jednotliv\u00fdch ko\u0161ov.<\/strong> Rozsahy \u00fadajov s\u00fa rozdelen\u00e9 rovnomerne.<\/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 bo\u010dnom paneli najprv kliknite prav\u00fdm tla\u010didlom my\u0161i na pole, ktor\u00e9 chcete transformova\u0165. V na\u0161om pr\u00edklade je to pole \"Pr\u00edklad vplyvu\".<\/p>\n\n\n\n
Potom kliknite \u013eav\u00fdm tla\u010didlom my\u0161i na polo\u017eku \"Nov\u00e1 skupina\". Otvor\u00ed sa okno \"Skupiny\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nTu vyberte mo\u017enos\u0165 \"Number of bins\" (Po\u010det ko\u0161ov) pre \"Bin type\" (Typ ko\u0161a). V\u013eavo dole zad\u00e1te hodnotu \"10\" ako \"Bin Count\" (Po\u010det ko\u0161ov). Potom sa automaticky vypo\u010d\u00edta \u0161\u00edrka ko\u0161ov v polo\u017eke \"Bin size\" (Ve\u013ekos\u0165 ko\u0161a).<\/p>\n\n\n\n
Nakoniec kliknite na \"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 poslednom kroku op\u00e4\u0165 kliknite na novovytvoren\u00e9 pole v bo\u010dnom paneli.<\/p>\n\n\n\n
Teraz sa op\u00e4\u0165 zobraz\u00ed okno \"Skupiny\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nV tomto pr\u00edpade vyberte typ skupiny \"List\" namiesto \"Bin\". Nezoskupen\u00e9 hodnoty sa zobrazia v \u013eavom poli.<\/p>\n\n\n\n
Teraz spust\u00edte a vyberiete ka\u017ed\u00fa hodnotu a presuniete ju do prav\u00e9ho st\u013apca pomocou tla\u010didla \"Group\".<\/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\nTakmer pripraven\u00e9! Teraz prirad\u00edte hodnoty 1 a\u017e 10 desiatim hodnot\u00e1m tak, \u017ee dvakr\u00e1t kliknete na ka\u017ed\u00fa nadskupinu a vlo\u017e\u00edte hodnoty. Nakoniec kliknete na \"OK\".<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nHotovo! \u00dadaje ste transformovali a teraz ich m\u00f4\u017eete presun\u00fa\u0165 na os v na\u0161ej matici riz\u00edk.<\/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\nNajprv op\u00e4\u0165 klikneme prav\u00fdm tla\u010didlom my\u0161i na pole, ktor\u00e9 chceme diskretizova\u0165. V na\u0161om pr\u00edklade je to \"Pr\u00edklad dopadu\". Potom vyberieme mo\u017enos\u0165 \"New measure\" (Nov\u00e9 opatrenie). Nad pr\u00edstrojovou doskou sa otvor\u00ed editor DAX.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Teraz prid\u00e1me nasleduj\u00faci k\u00f3d prisp\u00f4soben\u00fd tabu\u013eke a po\u017eadovan\u00e9mu st\u013apcu v s\u00fabore \u00fadajov. D\u00f4le\u017eit\u00e9 - toto je pr\u00edklad pre kvantily. V pr\u00edpade potreby ho m\u00f4\u017eete upravi\u0165 na 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(Table[Column])\nreturn\nIF(HASONEVALUE(Table[Column]),\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\nPripraven\u00fd! Takto sme diskretizovali a z\u00edskali hodnoty 1 a\u017e 5. Teraz m\u00f4\u017eeme toto pole pou\u017ei\u0165 pre na\u0161u maticu riz\u00edk!<\/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\u00e9 prahov\u00e9 hodnoty<\/h2>\n\n\n\n
\n\n<\/figure>\n<\/div>\n\n\n\n\nNajprv op\u00e4\u0165 klikneme prav\u00fdm tla\u010didlom my\u0161i na pole, ktor\u00e9 chceme diskretizova\u0165. V na\u0161om pr\u00edklade je to \"Pr\u00edklad dopadu\". Potom vyberieme mo\u017enos\u0165 \"New measure\" (Nov\u00e9 opatrenie). Nad pr\u00edstrojovou doskou sa otvor\u00ed editor DAX.<\/p>\n<\/div>\n<\/div>\n\n\n\n
Teraz prid\u00e1me nasleduj\u00faci k\u00f3d prisp\u00f4soben\u00fd tabu\u013eke a po\u017eadovan\u00e9mu st\u013apcu v s\u00fabore \u00fadajov:<\/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(Table[Column])\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\nPremena slov 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\nNajprv kliknite na polo\u017eku \"Transformova\u0165 \u00fadaje\" v ponuke. T\u00fdm sa otvor\u00ed editor Power Query.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nVyberiete st\u013apec, ktor\u00fd chcete transformova\u0165. V tomto pr\u00edklade je to st\u013apec \"Text pravdepodobnosti\". Potom kliknite na polo\u017eku \"St\u013apec z pr\u00edkladov\" v \u013eavom hornom rohu a vyberte mo\u017enos\u0165 \"Z v\u00fdberu\".<\/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\nPrid\u00e1 sa nov\u00fd st\u013apec. Kliknite na prv\u00fa bunku nov\u00e9ho st\u013apca a vlo\u017ete po\u017eadovan\u00fa \u010d\u00edseln\u00fa hodnotu. V na\u0161om pr\u00edklade \"Remote\" (najni\u017e\u0161\u00ed v\u00fdraz) zodpoved\u00e1 hodnote \"1\". Nemus\u00edte meni\u0165 v\u0161etky hodnoty jednotlivo. Power BI rozpozn\u00e1 \u010d\u00edsla a automaticky ich prirad\u00ed pod\u013ea <\/strong><\/em>dva<\/strong> va\u0161e pr\u00edklady.<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nTento postup zopakujte pre ka\u017ed\u00fd v\u00fdraz v s\u00fabore \u00fadajov...<\/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 namapovan\u00ed posledn\u00e9ho v\u00fdrazu nakoniec kliknite na tla\u010didlo \"OK\" . A je to: Transformovan\u00fd st\u013apec \"Pravdepodobnos\u0165\". Zopakujete to s \"Impact\" a m\u00e1te po\u017eadovan\u00fd form\u00e1t \u00fadajov. Zvolili sme t\u00fato logiku od 1 do 10, preto\u017ee ka\u017ed\u00fd m\u00e1 in\u00e9 znenie piatich kateg\u00f3ri\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\/sk\/wp-json\/wp\/v2\/pages\/8499","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=8499"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages\/8499\/revisions"}],"predecessor-version":[{"id":13647,"href":"https:\/\/www.leaplytics.de\/sk\/wp-json\/wp\/v2\/pages\/8499\/revisions\/13647"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/sk\/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