Compate combinations of data based on Customer Sat Score

Question

Community:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have a need to find the BEST combinations of people.Example:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have 4 Resources on a given Project.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Project Manager&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Resource Type 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Resource Type 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Resource Type 3&nbsp;At the end of the Project, the team gets a Survey score.&nbsp;The next project will consist of combinations of people in each role.I try to assign the resources that have work together, so I have Data that would tell me when a given team is paired.&nbsp;My question is:&nbsp;&nbsp;&nbsp;&nbsp; What would be the best way to articulate the best combinations of people.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; What is the Best way to present the visual of that Data?&nbsp;Dataset Example:&nbsp;Project #&nbsp; | Project Manager Name | Resource 1 Name | Resource 2 Name&nbsp; |&nbsp; Resource 3 Name |&nbsp; Sat Score | Date of Survey&nbsp;

v-qiuyu-msft · Answer

Hi&nbsp;amenne,
&nbsp;
What you mean about "The next project will consist of combinations of people in each role."? Would you please share some sample data and show the expected results?&nbsp;
&nbsp;
Best Regards,Qiuyun Yu&nbsp;

amenne · Answer

&nbsp;I am looking for a single visual based on the Data-set below. I would like a Line(?) Representation of the 4 roles.Possibally a Circle would have 4 quarters:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -Each Quarter would be a role.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -The Line Matrix would connect all the resources with a different color per "common" project. Example: all Projects worked by: Larry,Betty,Maxwell, and Bobbie, the average of that combination would be represented by each line. (The Visual will need to detirmine the combination and average of that combination)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - The Weight of the line would be determined by Score OR Duration.Business Need: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I want to detirmine the best and worst combination of people based on duration and Customer Sat.If Anyone has a better Idea, I am all ears!!DataSet Sample:Project #,Project Manager,HR Consultant,PR Consultant,Labor Consultant,Sat Score,Duration123,Bob,Jerry,Shelly,Bobbie,9,187 127,Bob,Tim,Joe,Anthony,2,189131,Bob,Tim,Maxwell,Anthony,8,99 135,Bob,Betty,Shelly,Randy,9,98139,Bob,Danielle,Jacob,Randy,10,172 126,Larry,Danielle,Maxwell,Jeff,3,90130,Larry,Jerry,Jacob,Randy,4,90 134,Larry,**bleep**,Joe,Bobbie,2,128138,Larry,Betty,Maxwell,Bobbie,2,124 142,Larry,Jerry,Shelly,Bobbie,5,142125,Sue,Betty,Jacob,Anthony,2,138 129,Sue,Jerry,Joe,Bobbie,8,147133,Sue,Danielle,Shelly,Jeff,10,143 137,Sue,Tim,Jacob,Jeff,5,96141,Sue,Danielle,Joe,Jeff,9,135 124,Tom,Tim,Joe,Randy,10,133128,Tom,Danielle,Shelly,Jeff,10,102 132,Tom,Betty,Maxwell,Jeff,9,111136,Tom,Jerry,Joe,Anthony,8,166 140,Tom,Tim,Maxwell,Anthony,4,172

Forum Discussion

Compate combinations of data based on Customer Sat Score

2 Replies

Related content

Tables combine

Power Query custom connector with combined authentication types

Data Combining Problem

Combine Column

Dynamic RLS combination