- \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":"
Na\u0161a mapa riz\u00edk \/ matica vy\u017eaduje ako hodnoty 1 a\u017e 10, ale \u010do robi\u0165, ak s\u00fa va\u0161e \u00fadaje spojit\u00e9 a nie s\u00fa v tomto intervale? Alebo ak vyjadrenia va\u0161ich riz\u00edk pozost\u00e1vaj\u00fa zo slov? Ni\u017e\u0161ie s\u00fa uveden\u00e9 \u0161tyri rie\u0161enia s binningom, kvantilmi, vlastn\u00fdmi prahov\u00fdmi hodnotami a mapovan\u00edm slov na \u010d\u00edsla. Binning V tomto pr\u00edstupe rie\u0161enia sa v\u0161etky ... <\/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