Power Pivot and Basketball Superstars: Many-to-Many and USERELATIONSHIP
Friends at a company play pick-up basketball during their lunch hour. Since there are no established teams, players can be randomly matched up. But these folks happen to be engineers/data-nerds, so they keep detailed track of games, teams, players and win/loss. The diagram view of the data is shown further below. Question: How can we determine which player pairing is the most successful? Since players are randomly teamed up, are there combinations which when teamed up have an unusually high winning percentage?
Read more...