We came to a conclusion where we thought to build a dashboard to visualize the CWG data from various trustable data sources. We wanted to filter the data to dive deeper into the analysis and drill down the information for better understanding.
There are endless Business Intelligence (BI) tools in the market designed to capture, categorize and analyze data to understand the best practices for an improved decision making. For this dashboard, we took help of the Tableau desktop. It helped convey the information of many worksheets and related information all at one place that helped us gain insights on trends and behaviors to compare and monitor a variety of data simultaneously.
The final dashboard
The dashboard informs with a glance that the winning team- Australia had their specialization, as well as participation maximized in games like Athletics, Boxing, Cycling, Lawn bowls, and Swimming - which also at the same time had the maximum number of events at CWG. So, if the number of sports events in games like Shooting, Weightlifting, Wrestling, Table Tennis and Badminton (which were also India’s top 5 sports) were increased, then India could have conveniently grabbed the trophy for CWG 2018.
To have a look at the interactive tableau dashboard, please follow this link: https://public.tableau.com/profile/sumit5242#!/vizhome/cwgwith8003400/CWG-2018