28.3. Studio: Tableau Part 4 - Stories and Dates

28.3.1. Getting Started

This is a group studio. Your group has been asked to create a visual for the International Fencing Federation (FIE). Work through the data analysis steps that you have been learning in this program to create your final viz.

As a group, explore your data and decide upon:

  1. A business issue or a question you want to explore further.

  2. Next clean, and manipulate the data to create vizzes that provide insight to your business issue or question.

  3. Your final output should be a dashboard that best provides insight on your discoveries.

  4. You will present your dashboard at the end of class.

  5. Suggested Topics to Explore:

    1. Weapons

    2. Handedness

    3. Category

    4. Ages

    5. Location and/or Time Zone

    6. What factors predict wins?

You are not limited to these topics. If you discover something more interesting, explore away!

28.3.1.1. Setting Up the Studio:

Download FIE Fencing Womens Foil data set. There are 4 CSV files. To download all CSV files at once, click on the Download bubble next to the New Notebook bubble. An orange arrow is pointing to the Download bubble in the image below.

An orange arrow points to the ``Download`` bubble, highlighting the ``Download`` option of kaggle.

  1. Open the CSV file in Tableau Public.

  2. When you open this data set, you may want to create a relationship between the CSV files.

    1. You will explore this in the EDA section below.

  3. Here is more information about the International Fencing Federation.

28.3.1.2. EDA

  1. The dataset contains 4 CSVs. You only need to work with the ones that will provide answers to your questions.

  2. Explore the tables and play with the columns you think you might use.

    1. When you get a viz that you like, ask yourself the following questions:

      1. Why do you like it? What is it showing?

      2. Would it work better with a calculation or any manipulation?

      3. Would looking at a smaller sample, like the top 100, help?

28.3.1.3. Cleaning

  1. Do you need to clean any of the data you have decided to work with?

    1. Any nulls?

      1. Are they appropriate for the data?

    2. Any discrepancies?

      1. Hint: ages might need some attention.

28.3.1.4. Manipulation

  1. Do you need to use any calculations to answer the questions?

  2. Thinking of your dashboard, how do you think you would like to present your data to your audience?

  3. In order to do this, do you need:

    1. Filters?

    2. Groups?

    3. Parameters?

    4. Calculations?

28.3.1.5. Dashboard and Finesse

  1. Create a final dashboard viz that answers the question(s)/topic(s) you explored.

  2. Now is a good time to update labels and colors for an easily digestible report.

  3. Hide your worksheets

28.3.1.6. Finishing Touches

Before you turn in your vizzes:

  1. Make sure that they are easy to read.

  2. Review and edit any axes so that they don’t contain any file information.

  3. Make sure any filtering, group, or set information is easy to understand.

  4. If you want to explore fonts and colors, go right ahead.

28.3.1.7. Present Your Dashboard to the class and provide feedback to your classmates.

  1. Share even if your group dashboard is not complete, we want to see your unique ideas.

28.3.2. Submitting Your Work

When finished make sure to save and publish your work to your Tableau Public account. Copy the URL to your published Tableau project and paste it into the submission box in Canvas for Studio: Visualization with Tableau Part 4 and click Submit.