Developed under a tight timeframe, this project involved visualizing the daily results of a round-robin style tournament. Using Excel, Power Query, and Power BI, a dynamic dashboard was created. Crucially, the process incorporated a fully automated pipeline utilizing Power BI service alerts and Google Apps Script to route result images accurately to over 400 participants distributed across different countries.
With a very short margin of time, the project kicked off by rapidly gathering requirements. The goal was to build a clear, engaging visual representation of a round-robin tournament, tracking daily matchups and overall standings.
Tournament data was centralized using Excel. Power Query was then utilized to extract, clean, and transform the daily matchup statistics, ensuring the dataset was structured perfectly for analytical visualization.
The polished data was imported into Power BI, where an interactive and dynamic dashboard was developed to display the round-robin results. It allowed users to track team progress, daily metrics, and performance over the course of the tournament.
To distribute the daily outcomes without manual effort, a subscription and forwarding automation was set up in the Power BI web service. This generated an email containing a snapshot image of the daily results.
When the automated email arrived from Power BI, a custom Google Apps Script intercepted it. The script analyzed the email and autonomously routed the daily result images to over 400 participants, properly filtering and sending notifications depending on the country of each competing team.
