Power Pivot and Basketball Superstars: Many-to-Many and USERELATIONSHIP
By Avi Singh [Twitter] 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. […]