Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello world,
I have a set of 21 parameters(Performance Indicators), based on which I want to indentify high risk assets. The excel below is a sub set of actual data which contains 21 parameters and 374 assets. Each asset is deisgnated a score based on predefined criteria which is the Performance Indicator(PI). The Score starts at 1 which is a low risk and goes all the way upto 5 which is a high risk. We wanted to build a measure which can help me identify assets which need my immediate attention. the measure should essentially check the following,
Any 1 PI score of 5
or
Any 3 PI score of 4
or
Any 7 PI score of 7
For instance "Alpha Asia" has a score of 5 in the COC column, so it automatically needs my attention. However, if it had a score of 4 in any of the 16 variable, it would still need my attention or a score of 3 in any seven PI.
I hope someone here can help me with a measure to help me identify high risk assets.
Thanks in advance,
WIth best regards,
Kryptonian
Update:
@v-piga-msft I have 21 paramters in my orginal data set, out of which I am using 13 here in the data. the parameters in the excel are as follows:
Asset code column is a code assigned to my assets in the orgnization. Agsint each asset, i see the score of a paramter. The score ranges from 1 to 5. Score of 1 being a low score(good) and 5 being a high risk(extremely bad).
For me to prioritize my focus, I need to focus on assets
1 score of 5 in any of the 13 columns
or
3 score of 4 in any of the 13 columns
or
7 score of 3 in any of the 13 columns
I need to prepare some sort of measure, which indentifies the any asset which falls in the above criteria.
Please let me know if it need further clarifications
Asset Code | Ageing | Emp Score | COC | Critical M/C Failure | Insurance Rank | CAT Score | Near Miss | Overdue Invoices | OverDue Relief | PSC Score | Resthour Violations | Safety EQ Failure | Insurance Claims |
Alpha-Asia | 2 | 2 | 5 | 1 | 1 | 1 | 1 | 2 | 1 | 4 | 2 | 1 | 1 |
Alpha-Sea | 5 | 1 | 5 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 |
Alpha-Ore | 5 | 1 | 5 | 1 | 1 | 1 | 1 | 4 | 1 | 4 | 2 | 1 | 1 |
Alpha-Yuan | 5 | 1 | 5 | 1 | 1 | 1 | 1 | 5 | 1 | 2 | 2 | 1 | 1 |
Alpha-Winc | 5 | 1 | 5 | 1 | 1 | 1 | 2 | 4 | 1 | 4 | 2 | 1 | 1 |
Alpha-Mand | 5 | 1 | 5 | 1 | 4 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 4 |
Alpha-Nere | 5 | 1 | 5 | 1 | 5 | 1 | 1 | 4 | 1 | 1 | 1 | 1 | 5 |
Alpha-Ana | 5 | 1 | 5 | 1 | 5 | 1 | 1 | 4 | 1 | 1 | 2 | 1 | 5 |
Alpha-Parn | 5 | 1 | 5 | 1 | 5 | 1 | 1 | 5 | 2 | 4 | 5 | 1 | 5 |
Alpha-Inte | 5 | 2 | 5 | 1 | 5 | 1 | 1 | 4 | 1 | 4 | 2 | 1 | 5 |
Alpha-Eos | 5 | 1 | 5 | 1 | 5 | 2 | 1 | 4 | 1 | 1 | 1 | 1 | 5 |
Alpha-Tese | 5 | 1 | 5 | 1 | 5 | 2 | 1 | 4 | 1 | 1 | 2 | 1 | 5 |
Alpha-Hero | 5 | 2 | 5 | 1 | 5 | 2 | 1 | 4 | 1 | 4 | 1 | 1 | 5 |
Alpha-Gene | 5 | 2 | 3 | 1 | 1 | 1 | 1 | 5 | 1 | 1 | 2 | 1 | 1 |
Alpha-Kemp | 5 | 1 | 3 | 1 | 1 | 2 | 1 | 4 | 1 | 1 | 4 | 1 | 1 |
Alpha-Ming | 5 | 1 | 3 | 1 | 1 | 2 | 1 | 5 | 1 | 1 | 1 | 1 | 1 |
Alpha-Shan | 5 | 2 | 3 | 1 | 1 | 2 | 1 | 3 | 1 | 4 | 3 | 1 | 1 |
Alpha-MSC | 5 | 1 | 2 | 1 | 4 | 1 | 3 | 4 | 1 | 4 | 2 | 1 | 4 |
Alpha-Mine | 5 | 1 | 2 | 1 | 5 | 1 | 1 | 5 | 1 | 1 | 2 | 1 | 5 |
Alpha-Anto | 5 | 1 | 2 | 1 | 5 | 1 | 1 | 5 | 1 | 1 | 3 | 5 | 5 |
Alpha-Gott | 5 | 1 | 2 | 1 | 5 | 1 | 1 | 5 | 1 | 4 | 1 | 1 | 5 |
Alpha-MSC | 5 | 1 | 2 | 1 | 5 | 1 | 2 | 5 | 1 | 1 | 2 | 1 | 5 |
Alpha-Maer | 5 | 2 | 2 | 1 | 1 | 1 | 1 | 5 | 1 | 1 | 2 | 1 | 1 |
Alpha-ROSC | 5 | 2 | 2 | 1 | 1 | 1 | 1 | 5 | 1 | 4 | 1 | 1 | 1 |
Alpha-Koku | 5 | 2 | 2 | 1 | 1 | 2 | 1 | 5 | 1 | 4 | 1 | 1 | 1 |
Alpha-Inte | 5 | 2 | 2 | 1 | 5 | 3 | 1 | 4 | 1 | 4 | 2 | 1 | 5 |
Alpha-Al G | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Alpha-Al R | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Alpha-Al S | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Solved! Go to Solution.
Occam's razor (also Ockham's razor or Ocham's razor; Latin: lex parsimoniae "Law of Parsimony") is the problem-solving principle that the simplest solution tends to be the right one. When presented with competing hypotheses to solve a problem, one should select the solution with the fewest assumptions.
I managed to find a solution to problem. Thankfully, there were not many variable to deal with. In the below table I created an additonal column for each variable. It was a calculated column, which checks if the variable value is 4, if yes then 1 else 0. Then I simply added all the calculated columns and check if the sum was greater than or equal to 3.
Occam's razor (also Ockham's razor or Ocham's razor; Latin: lex parsimoniae "Law of Parsimony") is the problem-solving principle that the simplest solution tends to be the right one. When presented with competing hypotheses to solve a problem, one should select the solution with the fewest assumptions.
I managed to find a solution to problem. Thankfully, there were not many variable to deal with. In the below table I created an additonal column for each variable. It was a calculated column, which checks if the variable value is 4, if yes then 1 else 0. Then I simply added all the calculated columns and check if the sum was greater than or equal to 3.
Hi @bikram_laishram,
I'm still a little confused about your sceanrio, what is the 21 parameters?
In addition, could you share your desired output so that we can help further on it?
Best Regards,
Cherry
@v-piga-msft I have 21 paramters in my orginal data set, out of which I am using 13 here in the data. the parameters in the excel are as follows:
Asset code column is a code assigned to my assets in the orgnization. Agsint each asset, i see the score of a paramter. The score ranges from 1 to 5. Score of 1 being a low score(good) and 5 being a high risk(extremely bad).
For me to prioritize my focus, I need to focus on assets
1 score of 5 in any of the 13 columns
or
3 score of 4 in any of the 13 columns
or
7 score of 3 in any of the 13 columns
I need to prepare some sort of measure, which indentifies the any asset which falls in the above criteria.
Please let me know if it need further clarifications
@v-piga-msft Hope you have had some breakthrough man. I have googled to get results but not able to get this one
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |