Tableau (II)


(This is a part of week 6’s learning challenge)

It is all about maps!

Download and install Tableau Desktop. This version requires a license. The free trial period is 14 days. Students can apply for a free one-year license on this page.

Watch the basic mapping tutorial video.

Use this dataset (the link below) as you follow along the tutorial:

Sample - Superstore Sales Multi-language (Extract)

You will need Tableau Desktop to be able to open this dataset file. Tableau Public doesn’t allow you to open this file.

Checkpoints

As you follow along the tutorial, you will create a series of visulizations. They may not look exactly the same as what is shown in the video because the dataset is slightly different.

Checkpoint 1

When you are able to produce something similar to below, take a screenshot and submit.

map1

Hint: You will need to select “Tableau Classic” map to get Data Layer to work.

classic_map

Checkpoint 2

When you are able to produce something similar to below, take a screenshot and submit.

map2

Checkpoint 3

When you are able to produce something similar to below, take a screenshot and submit.

map3

Checkpoint 4

When you are able to produce something similar to below, take a screenshot and submit.

map4

Challenges

1. Which cities generated relatively big sales figures but not making money (name two?)

  • Cities: Map
  • Sales: Area
  • Profits: Color

city_sales_profit

Reproduce the visualization above as close as possible to support your answer.

2. Which combination of customer segment and department generated the highest total profit?

segment_department

Reproduce the visualization above as close as possible to support your answer.

3. Which countries were similar to Egypt in terms of total sales but had trouble turning a profit in one department (i.e., technology, office supplies, or furniture) (name two)?

  • States: Map
  • Sales: Size
  • Categories: Pie/Color

sales_profits_country

Reproduce the visualization above as close as possible to support your answer.

4. Consider various combinations of customer segment and ship mode, which cities had been losing significant money with respect to a particular combination?

  • Cities: Map
  • Profits: Color

city_profit_segment_ship_mode

Reproduce the visualization above as close as possible to support your answer.

5. In which customer segment did Texas significantly outperform California in terms of total profits?

texas_vs_cal

Reproduce the visualization above as close as possible to support your answer.

6. Average shipping cost

Your boss suspected that the company is paying way too much on average for shipping by truck in some states (US) compared to the others. Yes or no? Make your own visualization to support your answer.

7. Average profits

Your boss wanted to know in what aspects Colorado’s market is different from that of the other states.However, he is only interested in comparing Colorado to its peers in terms of market size (measured by total sales). He doesn’t want to compare apples to oranges. What will you show to the boss? Make your own visualization to support your answer.

Hints: Some sub-questions you need to answer first.

  • What is the total sales of Colorado?
  • What other states had similar sales (pick 4)?
  • Along what measures these states may differ?
  • Along what dimensions these states may differ?
  • Where does Colorado jump out as unique visually (e.g., the greenest, the biggest, the only red … etc)?