Tutorial: Get Started with Tableau Desktop

In the last step you discovered that Tennessee, North Carolina, and Florida have negative profit. To find out why, you decide to drill down even further and focus on what's happening in those three states alone.

Pick up where your map view left off

As you saw in the last step, maps are great for visualizing your data broadly. A bar chart will help you get into the nitty-gritty. To do this, you create another worksheet.

1. Double-click Sheet 3 and name the worksheet Profit Map.

2. Right-click Profit Map at the bottom of the workspace and select Duplicate . Name the new sheet Negative Profit Bar Chart.

3. In the Negative Profit Bar Chart worksheet, click Show Me, and then select horizontal bars.

   Show Me highlights different chart types based on the data you've added to your view.

   Note: At any time, you can click Show Me again to collapse it.



You now have a bar chart again—just like that.



4. To select multiple bars on the left, click and drag your cursor across the bars between Tennessee, North Carolina, and Florida. On the tooltip that appears, select Keep Only to focus on those three states.

   

   Note: You can also right-click one of the highlighted bars, and select Keep Only.

   Notice that an Inclusions field for State is added to the Filters shelf to indicate that certain states are filtered from the view. The icon with two circles on the field indicates that this field is a set. You can edit this field by right-clicking the field on the Filters shelf and selecting, Edit Filter.

Now you want to look at the data for the cities in these states.

5. On the Rows shelf, click the plus icon on the State field to drill-down to the City level of detail.

There’s almost too much information here, so you decide to filter the view down to the cities with the most negative profit by using a Top N Filter.

Create a Top N Filter

You can use a Top N Filter in Tableau Desktop to limit the number of marks displayed in your view. In this case, you want to use the Top N Filter to hone in on poor performers.

1. From the Data pane, drag City to the Filters shelf.

2. In the Filter dialog box, select the Top tab, and then do the following:

1. Click By field.

2. Click the Top drop-down and select Bottom to reveal the poorest performers.

3. Type 5 in the text box to show the bottom 5 performers in your data set.

Tableau Desktop has already selected a field (Profit) and aggregation (Sum) for the Top N Filter based on the fields in your view. These settings ensure that your view will display only the five poorest performing cities by sum of profit.



4. Click OK.

You're on to something! But there are six cities in the view, including Jacksonville, North Carolina, which has a positive profit. Why would a city with a positive profit show up in the view when you created a filter that was supposed to filter out profitable cities?

Jacksonville, North Carolina is included because City is the lowest level of detail shown in the view. For Tableau Desktop to know the difference between Jacksonville, North Carolina, and Jacksonville, Florida, you need to drill down to the next level of detail in the location hierarchy, which, in this case, is Postal Code. After you add Postal Code, you can exclude Jacksonville in North Carolina without also excluding Jacksonville in Florida.

3. On the Rows shelf, click the plus icon on City to drill down to the Postal Code level of detail.

4. Right-click the postal code for Jacksonville, North Carolina, 28540, and then select Exclude.

Postal Code is added to the Filters shelf to indicate that certain members in the Postal Code field have been filtered from the view. Even when you remove the Postal Code field from the view, the filter remains.

5. Drag Postal Code off the Rows shelf.

Your view updates to look like this:

Now that you've focused your view to the least profitable cities, you can investigate further to identify the products responsible.

Identify the troublemakers

You decide to break up the view by Sub-Category to identify the products dragging profit down. You know that the Sub-Category field contains information about products sold by location, so you start there.

1. Drag Sub-Category to the Rows shelf, and place it to the right of City.

2. Drag Profit to Color on the Marks card to make it easier to see which products have negative profit.

3. In the Data pane, right-click Order Date and select Show Filter.

   You can now explore negative profits for each year if you want, and quickly spot the products that are losing money.

   Machines, tables, and binders don’t seem to be doing well. So what if you stop selling those items in Jacksonville, Concord, Burlington, Knoxville, and Memphis?

Verify your findings

Will eliminating binders, machines, and tables improve profits in Florida, North Carolina, and Tennessee? To find out, you can filter out the problem products to see what happens.

1. Go back to your map view by clicking the Profit Map sheet tab.

2. In the Data pane, right-click Sub-Category and select Show Filter.

   A filter card for all of the products you offer appears next to the map view. You'll use this filter later.

3. From the Data pane, drag Profit and Profit Ratio to Label on the Marks card.

   • To format the Profit Ratio as a percentage, right-click Profit Ratio, and select Format. Then, for Numbers in the Default section, choose Percentage and set the number of decimal places you want displayed on the map. For this map, we'll choose zero decimal places. Then close the format pane.

   Now you can see the exact profit of each state without having to hover your cursor over them.

4. In the Data pane, right-click Order Date and select Show Filter to provide some context for the view.

   A filter card for YEAR(Order Date) appears in the view. You can now view profit for all years or for a combination of years. This might be useful for your presentation.

5. Clear Binders, Machines, and Tables from the list on the Sub-Category filter card in the view.

   Recall that adding filters to your view lets you include and exclude values to highlight certain parts of your data.

As you clear each member, the profit for Tennessee, North Carolina, and Florida improve, until finally, each has a positive profit.




Hey, you made an interesting discovery!

Binders, machines, and tables are definitely responsible for the losses in Tennessee, North Carolina, and Florida, but not for the rest of the South. Do you notice how profit actually decreases for some of the other states as you clear items from the filter card? For example, if you toggle Binders on the Sub-Category filter card, profit drops by four percent in Arkansas. You can deduce that Binders are actually profitable in Arkansas.

You want to share this discovery with the team by walking them through the same steps you took.

6. Select (All) on the Sub-Category filter card to include all products again.

Now you know that machines, tables, and binders are problematic products for your company. In focusing on the South, you see that these products have varying impacts on profit. This might be a worthwhile conversation to have with your boss.

Next, you'll assemble the work you've done so far in a dashboard so that you can clearly present your findings.

More on working with maps and geographic roles in the Learning Library (in the top menu).

Continue to Step 6: Build a dashboard to show your insights.