Forum Discussion
Capability profile matrix heatmap
Hi, I want to create capability profile matrix on which I could compare employee skills with requirements for some job position. I manually created table with three columns (skill id, discipline...
Hi Anonymous ,
thank you for your message.
These are my tables:
Assessment
| ID | EMP_ID | SKILL_ID | RATE |
| 1 | 1 | 1 | 3 |
| 2 | 1 | 3 | 2 |
Employee:
| ID | EMP_NAME | EMP_ROLE |
| 1 | Kamil Kowalski | Junior Specialist |
| 2 | Anna Nowak | Junior Specialist |
Skills:
| ID | SKILL_NAME | SKILL_CATEGORY |
| 1 | Python | Programming |
| 2 | SQL | Programming |
And manualy created table with profiles:
| ID | POSITION | SKILL_ID | RATE |
| 1 | 1 | 1 | 3 |
| 2 | 1 | 3 | 1 |
Tables are connected in snowflake schema with assessment table in center.
Kind regards
HI Anonymous,
I'd like to suggest you create a calculated table to extract and merge all skill category and employee roles, then you can and add a new column to configure the main category of these values.
After these steps, you can use employee id on two, new table main categories and detail value(employee role, skill type) as column write a measure to use current value(employee id and skill category) to lookup and summarize correspond rate value.
Regards,
Xiaoxin Sheng