\n\t\t\t
For the final project of the “Data Visualization Fundamentals with Tableau” course I took from UC Davis, I used a dataset from data.world and created a dashboard to explore the data. In this post, I will give some details about the data and the key takeaways from the visualization I have created which consists of 5 different analysis combined in a single dashboard.
The Dataset
The dataset I have used was originally used in the article “Why is the US So Good At Women’s Soccer?” and visualized the rise of soccer amongst high school female athletes over the years as can be seen below.
This data was shared in data.world which distributes data about familiar and consistent business concepts for anyone to find, understand and use. Below is a link to this dataset.
The summary of the columns and the scope of the data can be seen below:
55,135 (Rows) X 7 (Columns)
Tableau Dashboard
You can view the live Tableau Dashboard I have created for this project by clicking here . Below is a snapshot of this dashboard:
Goals / Key Takeaways
This dashboard aims to elaborate on the previous article about how soccer has become more popular amongst girls by answering the following questions:
1. What is the ratio of girls participation to boys participation?
– 2018 ratio by state and national trend over the years has been visualized. While national average is 75% on average, it varies significantly by state.
2. What are the five most popular sports by gender?
– Two separate tables show five most popular sports for girls and boys.
Track & Field, soccer, basketball are in top 5 charts for both boys and girls while volleyball and softball are replaced by baseball and football for boys.
3. How did the five most popular sports change over the years for girls?
– This table shows shows how the most popular sports have changed in years for not only soccer but also other sports in top five.
4. How does the picture change by state?
– Tableau dashboard allows the user to select any state as a filter and the dashboard is updated automatically for the selected state.
Conclusion
Tableau is a very powerful data exploration and visualization tool which makes it very easy to upload data, explore it visually and create visualizations to be easily shared with anyone, without writing a single line of code.
Tableau would be very useful for product managers and alike to track product performance frequently and create collaboration and alignment with stakeholders by looking at the same key performance indicators (KPIs).