Ta-Daa!

Domain again made history! And this time by publishing the World’s very first International Foosball Cup Analytical Dashboard!

After some meticulous statistical collection efforts by Lupco, Peter and Brett, now we are proud to present the result of their work in form of a fully interactive Tableau dashboard!

The news!

The news was so big, that some members of higher management held an urgent meeting to review this achievement. A leaked photo of this meeting is already out there in the media:

The competition

Competition was fierce as 16 entrants battled it out over a gruelling knock out tournament. Present at each game was a stats collector, who collected multiple data points, including

each goal event including the exact time

the scoring action stick

the scoring player

Insights:

This sophisticated analytical dashboard is now publicly available in Tableau:

For Public users, the interactive Dashboard is now available in Tableau Public website

For Domain Tableau Account holders it is available at Domain Tableau Server













Some shocking facts!

This complex Dashboard has been designed by Rogerio (Data Team) and with the help of the Tournament officials. It reveals some shocking insights like:

Rogerio himself is the king of own goals by scoring 5 against his team.

Mark (C) and Paul managed to boost other teams confidence by graciously accepting 20 goals and scoring only 1 to be in the contest for Fair play cup!

Dan Johnson has managed to score two own goals from Attack sticks (Whaaa?!) against his team!

Best striker is Mark (P) followed by Josh

Meiling , as the only lady of the tournament, managing to score 10 goals. That puts her amongst top strikers!

Time distribution graphs says Brett J scored more goals than anyone else in first 4 minutes of games.

For more insights simply give it a go and let us know what did you discover!

The Winners

There can only be one winning team and for this competition it was Gonzalo and Mark P. They can now proudly show off their winners trophy until the next tournament starts. Next tournament the stats will be even more interesting once we’re able to see who has been the most-improved, consistent, and who simply hasn’t been training hard enough.

Data Collection

The data was collected manually by a scorekeeper during each game. Given tournament popularity and number of matches, a systematic mini ETL pipeline powered was assembled..

Data collection was defined through shared google sheets with a predefined template. Data then was imported to our “staging” schema in Redshift as the usual landing site for snapshot data. We analyzed the data and created a script to automatically normalize data as it arrived post-match. We then created a small Data Mart to extract the dimensions (e.g. Match, Players, Stickers, Teams) and also a fact table “Match Stats”. We blended this data and finally we set up a live data source in tableau on top of this data mart. We then created the visual dashboards based on the live data source in Tableau which will automatically get updated as each match data gets transferred from Google Sheets into the Redshift landing zone.

Future Data Projects

We’re lucky enough in the Domain office to have an in-house barista making us delicious coffee all morning. Wouldn’t it be interesting to know the distribution of coffee orders, busiest times of the morning and most popular coffee consumed by the Domain team? Stay tuned for future data projects…

Pooyan

Data is Power!