- \n
- 0 ila 20<\/em><\/li>\n\n\n\n
- 21 ila 40<\/em><\/li>\n\n\n\n
- 41 ila 60<\/em><\/li>\n\n\n\n
- 61 ila 80<\/em><\/li>\n\n\n\n
- 81 ila 100<\/em><\/li>\n<\/ul>\n\n\n\n
Dolay\u0131s\u0131yla bu, m\u00fcnferit kutulardaki risk miktar\u0131n\u0131 dikkate almamaktad\u0131r.<\/strong> Veri aral\u0131klar\u0131 yaln\u0131zca e\u015fit olarak b\u00f6l\u00fcnm\u00fc\u015ft\u00fcr.<\/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\nKenar \u00e7ubu\u011funda, \u00f6nce d\u00f6n\u00fc\u015ft\u00fcrmek istedi\u011finiz alana sa\u011f t\u0131klay\u0131n. Bizim \u00f6rne\u011fimizde \"Etki \u00d6rne\u011fi\" alan\u0131.<\/p>\n\n\n\n
Ard\u0131ndan sol t\u0131klama ile \"Yeni grup\" se\u00e7ene\u011fini se\u00e7in. \"Gruplar\" penceresi a\u00e7\u0131l\u0131r.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nBurada \"Kutu tipi\" i\u00e7in \"Kutu say\u0131s\u0131\" se\u00e7ene\u011fini se\u00e7ersiniz. Sol alt tarafa \"Kutu Say\u0131s\u0131\" olarak \"10\" de\u011ferini girersiniz. Daha sonra \"Kutu boyutu\" alt\u0131nda kutular\u0131n geni\u015fli\u011fini otomatik olarak hesaplar.<\/p>\n\n\n\n
Son olarak \"Tamam \"a t\u0131klay\u0131n.<\/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\nSon ad\u0131mda, kenar \u00e7ubu\u011funda yeni olu\u015fturulan alana tekrar t\u0131klay\u0131n.<\/p>\n\n\n\n
\u015eimdi \"Gruplar\" penceresi tekrar g\u00f6r\u00fcn\u00fcr.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nBurada \"Kutu\" yerine \"Liste\" grup t\u00fcr\u00fcn\u00fc se\u00e7ersiniz. Gruplanmam\u0131\u015f de\u011ferler soldaki kutuda g\u00f6r\u00fcn\u00fcr.<\/p>\n\n\n\n
\u015eimdi her bir de\u011feri ba\u015flat\u0131p se\u00e7in ve \"Grupla\" d\u00fc\u011fmesi arac\u0131l\u0131\u011f\u0131yla sa\u011f s\u00fctuna ta\u015f\u0131y\u0131n.<\/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\nNeredeyse haz\u0131r! \u015eimdi her bir \u00fcst gruba \u00e7ift t\u0131klayarak ve de\u011ferleri ekleyerek 1'den 10'a kadar olan de\u011ferleri on de\u011fere atay\u0131n. Son olarak \"Tamam \"a t\u0131kl\u0131yorsunuz.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nTamamland\u0131! Verileri d\u00f6n\u00fc\u015ft\u00fcrd\u00fcn\u00fcz ve art\u0131k Risk Matrisimizdeki bir eksene s\u00fcr\u00fckleyebilirsiniz.<\/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\n\u00d6nce ayr\u0131kla\u015ft\u0131rmak istedi\u011fimiz alana tekrar sa\u011f t\u0131kl\u0131yoruz. Bizim \u00f6rne\u011fimizde bu alan \"Etki \u00d6rne\u011fi\". Ard\u0131ndan \"Yeni hesaplama \"y\u0131 se\u00e7iyoruz. DAX D\u00fczenleyici g\u00f6sterge tablosunun \u00fczerinde a\u00e7\u0131l\u0131r.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\u015eimdi veri k\u00fcmenizdeki tabloya ve istenen s\u00fctuna g\u00f6re \u00f6zelle\u015ftirilmi\u015f a\u015fa\u011f\u0131daki kodu ekliyoruz. \u00d6nemli - bu be\u015fte birlik dilimler i\u00e7in bir \u00f6rnektir. Gerekirse bunu y\u00fczdelik dilimlere uyarlayabilirsiniz:<\/p>\n\n\n\n
Kuantil =\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 BuVal = Min(Tablo[S\u00fctun])\nd\u00f6n\u00fc\u015f\nIF(HASONEVALUE(Tablo[S\u00fctun]),\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\nHaz\u0131r! B\u00f6ylece 1'den 5'e kadar olan de\u011ferleri ayr\u0131kla\u015ft\u0131rd\u0131k ve elde ettik. Art\u0131k bu alan\u0131 Risk Matrisimiz i\u00e7in kullanabiliriz!<\/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\n\u00d6zel E\u015fikler<\/h2>\n\n\n\n
\n\n<\/figure>\n<\/div>\n\n\n\n\n\u00d6nce ayr\u0131kla\u015ft\u0131rmak istedi\u011fimiz alana tekrar sa\u011f t\u0131kl\u0131yoruz. Bizim \u00f6rne\u011fimizde bu alan \"Etki \u00d6rne\u011fi\". Ard\u0131ndan \"Yeni hesaplama \"y\u0131 se\u00e7iyoruz. DAX D\u00fczenleyici g\u00f6sterge tablosunun \u00fczerinde a\u00e7\u0131l\u0131r.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\u015eimdi veri k\u00fcmenizdeki tabloya ve istenen s\u00fctuna g\u00f6re \u00f6zelle\u015ftirilmi\u015f a\u015fa\u011f\u0131daki kodu ekliyoruz:<\/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 BuVal = Min(Tablo[S\u00fctun])\nd\u00f6n\u00fc\u015f\nIF(HASONEVALUE(Tablo[S\u00fctun]),\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\nKelimelerden Say\u0131lara<\/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\n\u00d6nce men\u00fcdeki \"Verileri d\u00f6n\u00fc\u015ft\u00fcr\" se\u00e7ene\u011fine t\u0131klay\u0131n. Bu, Power Query Editor'\u00fc a\u00e7ar.<\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nD\u00f6n\u00fc\u015ft\u00fcrmek istedi\u011finiz s\u00fctunu se\u00e7ersiniz. Bu \u00f6rnekte bu s\u00fctun \"Olas\u0131l\u0131k Metni\" s\u00fctunudur. Ard\u0131ndan sol \u00fcst k\u00f6\u015fedeki \"\u00d6rneklerden S\u00fctun \"a t\u0131klay\u0131n ve \"Se\u00e7imden\" se\u00e7ene\u011fini se\u00e7in.<\/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\nYeni bir s\u00fctun eklenir. Yeni s\u00fctunun ilk h\u00fccresine t\u0131klars\u0131n\u0131z ve istedi\u011finiz say\u0131sal de\u011feri girersiniz. \u00d6rne\u011fimizde, \"Remote\" (en d\u00fc\u015f\u00fck ifade) \"1\" de\u011ferine kar\u015f\u0131l\u0131k gelir. T\u00fcm de\u011ferleri tek tek de\u011fi\u015ftirmeniz gerekmez. Power BI, say\u0131lar\u0131 tan\u0131r ve bunlar\u0131 a\u015fa\u011f\u0131dakilere g\u00f6re otomatik olarak e\u015fler <\/strong><\/em>iki<\/strong> Senin \u00f6rneklerinden.<\/strong><\/em><\/p>\n<\/div>\n<\/div>\n\n\n\n
\n\nBunu veri setinizdeki her ifade i\u00e7in tekrarlars\u0131n\u0131z ...<\/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\nSon ifadenizi e\u015fle\u015ftirdikten sonra, son olarak \"Tamam \"a t\u0131klay\u0131n. \u0130\u015fte oldu: \"Olas\u0131l\u0131k\" i\u00e7in d\u00f6n\u00fc\u015ft\u00fcr\u00fclm\u00fc\u015f bir s\u00fctun. Bunu \"Etki\" ile tekrarlad\u0131\u011f\u0131n\u0131zda gerekli veri format\u0131na sahip olursunuz. Bu 1'den 10'a kadar olan mant\u0131\u011f\u0131 se\u00e7tik, \u00e7\u00fcnk\u00fc herkesin be\u015f kategori i\u00e7in farkl\u0131 bir ifadesi var.<\/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\/tr\/wp-json\/wp\/v2\/pages\/8499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/tr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/tr\/wp-json\/wp\/v2\/comments?post=8499"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/tr\/wp-json\/wp\/v2\/pages\/8499\/revisions"}],"predecessor-version":[{"id":13647,"href":"https:\/\/www.leaplytics.de\/tr\/wp-json\/wp\/v2\/pages\/8499\/revisions\/13647"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/tr\/wp-json\/wp\/v2\/media?parent=8499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- 21 ila 40<\/em><\/li>\n\n\n\n