Our client then uses Power Query to aggregate the data from these different team databases with the national database, to push out their dashboard.

Of course, the players play in different clubs, each of which has an analyst who records this information into their team database on a daily basis. For instance he wants to know things like - have they been injured, how many training sessions they’ve done, their training data (GPS, Heart rates etc), and other wellness information. The National Team coach wants a report every week on the status of the current National Team players. The scenario is based around high level soccer (football) players. Let’s take a look at this and explore a solution.

His company doesn’t have a solid IT infrastructure for sharing data, and he’s trying to figure out the best method for sharing Power Query solutions with a colleague so that he’s not the only one with the power to update. One of the attendees at today’s Power Query Workshop asked about a specific scenario today.

What is a dropbox workbook