Each of the games: preference and recognition produce a Json file containing the results. The data is continuously appended to the Json file as new players play. A Power BI report reads these Json files into PowerPivot.
The preference data is pivoted into a report that lists the players that were tested and their Average of final positions (i.e. their relative preference among peers). The report is sorted on Average of final positions.
The recognition data is pivoted into a report that lists the count and percentages of the players that Correctly guess the names as well as those that say they don’t know, and those that are guessed incorrectly. The report is sorted by %correct.