how to build a skill matrix with power bi? is this possible??

[Anonymous]

Hi guys,

I’m trying to build a skill matrix from three data files, but i can't!!!!! Help meeeee

1.  the first file, contains all the various business workstations with their prescriptions, like this:

   prescription	area 1	area 2	area 3	area 4	area 5
   Weights greater than 20 kg	1	0	1	0	1
   standing work	0	1	0	1	1
   working above the shoulders	0	0	1	0	1
   otoprottetors	1	0	1	1	1

   0 is not present
   1 is present
2. the second file is a registry of workers with their problems :

   prescription	Weights greater than 20 kg	standing work	working above the shoulders	otoprottetors
   Nome 1	1	1	1	0
   Nome 2	0	1	0	1
   Nome 3	0	0	1	0
   Nome 4	1	0	1	1

   0 is not present
   1 is present
3. The third file, it connects my skills.
   For every worker tells me, if you are skilled for that workstation:

   	nome 1	nome 2	nome 3	nome 4
   area 1	1	0	0	1
   area 2	1	1	1	0
   area 3	0	1	1	0
   area 4	1	0	1	0

   0 has no competence
   1 has competences

I would like to synchronize these files, so as to get a matrix that tells me for a given work area, which workers I can employ knowing their prescriptions and those of the work area

I apologize for my English, I hope there is someone who can help me or direct me on the right path

thank you very much!!

[Ashish_Mathur]

Hi,

Please show the expected result very clearly.

[lbendlin]

I get rather different results. Maybe I don't understand your matching rules.

[Anonymous]

Can I add a file with the number of requirements per area?
like this:

area	total employer
area 1	3
area 2	2
area 3	4
area 4	1
area 5	4

taking the result of your example :

 I would like to add a column that takes into account the Total employer set  and subtracts the number of positive matches that meets 

area	nome 1	nome 2	nome 3	nome 4	Delta
area 1	0	0	0	1	- 2
area 2	1	1	0	0	0
area 3	0	0	0	1	- 3
area 4	0	1	0	0	0
area 5	0	0	0	0	- 4

[lbendlin]

I think you will want to consider this a bit more.  What you are ultimately trying to achieve is not just a yes/no answer (can the person do the job)  but also how qualified each person is for each job  (ie are the meeting the requirements exactly, are they vastly overqualified, or are they just missing out  etc).

[Anonymous]

you are as you say!!!
I would like to know the limits of the person, the limits of the working area, the degree of competence of the person for that task. Hence my initial question if a speaking skill matrix was possible

[lbendlin]

Missing:  Number of skills the worker is missing for that area

Extra:  Skills the worker has that are not required for the area.