Roles and Skills Analysis - Similarity in Roles

[Anonymous]

Hi All,

I am not able to get this logic working in my dashboard for one of my projects, do let me know how to solve this in Power BI for the following scenario:-

1) When a user selects a role, the visual has to show underlying skills associated with that role. It shouold also show closest roles sorted by skill similarity.

For example, Account Manager role has 6 associated skills. Account Manager role is closest to Demand Manager role, as they have 3 skills in common. Business Manager role is the second closest one to Account Manager role, etc.

Please find the link to the data:-

https://docs.google.com/spreadsheets/d/1TbWId-ZvTvHudYwyfIWdjrVxNVSDx-MCpLlXcel0Av8/edit?usp=sharing

Thank you for your help!!

@amitchandak @parry2k @VijayP 

[Anonymous · Accepted solution]

Found the solution for my scenario in this wonderful post:-

https://community.powerbi.com/t5/Desktop/Select-Product-and-show-similar-products-based-on-multiple/...

[VijayP]

@Anonymous 

I have create a first level view. Check this and in the mean time will be sharing much improved version

[Anonymous]

Hi Vijay,

Thanks for helping out this is somewhat similar to requirement that I have but I would need the analysis without having a filter on ET Skill and which would give the exact story as per the end user requirement.

I am greatful for your help.

@VijayP 

[VijayP]

@Anonymous 

If you could share some sample data it is much easier to give logical solution!

I mean , need to understand the data structure!

[Anonymous]

Hi Vijay, 

Thanks for taking time to reply.. please find the link to the dummy data. Those are the only 2 columns in the table given by the end user. Hope this help:-

https://docs.google.com/spreadsheets/d/1TbWId-ZvTvHudYwyfIWdjrVxNVSDx-MCpLlXcel0Av8/edit?usp=sharing