DASHBOARD TO MAP SALES PERSON WITH SKILL SETS WHO WILL BE SUITABLE TO SELL CERTAIN PRODUCTS

[Anonymous]

Hi All,

I am unable to think of how I can create a dashboard to show management which employees have skills to sell certain products.

Consider the data below as an example:

Any suggestions or pointing to link where similar scenario is addressed will be really helpful.

Regards

Rahul

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file(see attachment) for you base on provided data, please check whether that is what you want.

Best Regards

[Anonymous]

Hi,

I tried to publish the report using this measure and ran into memory issue which restrict the visual to get loaded. Is there any way I can load the matrix created in the visual in a table in the data model so that the data load is easier and uses less memory?

If there is any link to how can I create such table will be helpful.

[Anonymous]

Hi @Anonymous ,

Please review the method in the following link, hope it can help you.

The “Visual Has Exceeded The Available Resources” Error In Power BI

Optimize memory

Couldn't load the data for this visual Error

Best Regards

[Anonymous]

Thanks @Anonymous I will go through the links.

I am facing issue when I publish the report in workspace. The users are unable to see the visuals for the full dataset. They need to filter to smaller volume to visualize the data.

I am not facing any issue while I am visualizing in PBI Desktop.

[Anonymous]

Thanks a lot @Anonymous. The solution is very apt to my situation, as I am unable to find anyone who have all the skills needed. So I became  a bit lineant and used the last condition as :

IF ( _escount >= _pscount-2, "Y", BLANK () ) and able to find few Employee who have the correct skills.

Regards

Rahul

[lbendlin]

Looks pretty simple. Products require a list of skills. Find all employees that cover these lists.  Sounds like a job for INTERSECT(). (mentally translate "list" to "single column table").  You could then even be a bit lenient and show employees that only have two out of the three required skills etc.

Please provide sample data in usable format (not as a picture).