MENU
Continuing our Tableau learning series (click here to start from the beginning), you've created a view of your data broken down by some basic categories and sub-categories. You are starting to get somewhere, but that is a lot of data to sort through. You need to easily find the interesting data points and focus on specific results. Well, Tableau has some great options for that!
Filters and colors are ways you can add more focus to the details that interest you. After you add focus to your data, you can begin to use other Tableau Desktop features to interact with that data.
You can use filters to include or exclude values in your view. In this example, you decide to add two simple filters to your worksheet to make it easier to look at product sales by sub-category for a specific year.
The filters are added to the right-hand side of your view in the order that you selected them. Filters are card types and can be moved around on the canvas by clicking on the filter and dragging it to another location in the view. As you drag the filter, a dark black line appears, showing you where you can drop the filter to move it.
Adding filters helps you to sort through all this data—but wow, that’s a lot of blue! Time to do something about that.
Currently, you are looking at sales totals for your various products. You can see that some products have consistently low sales, and might be good candidates for reducing sales efforts for those product lines, but what does overall profitability look like for your different products? You decide to drag Profit to color to see what happens. From Measures, drag Profit to Color on the Marks card.
By dragging Profit to Color you now see that you have negative profit in Tables, Bookcases, and even Machines. Another insight is revealed!
Note: Tableau automatically added a color legend and assigned a diverging color palette because your data includes both negative and positive values.
As you've learned, you can explore your data as you build views with Tableau Desktop. Adding filters and colors helps you better visualize your data and can identify problems right away.
The next step is to interact with your view so that you can begin drawing conclusions.
Looking at your view, you saw that you had some unprofitable products, but now you want to see if these products have been unprofitable year over year.
Time to use your filters to take a closer look.
Now you can see that, in some years, Bookcases and Machines were profitable. However, in 2017, Machines became unprofitable. While you've made an important discovery, you want to gather more information before proposing any action items to your boss.
On a hunch, you decide to break up your view by region:
Tableau creates a view with multiple axes broken down by region.
Now you see sales and profitability by product for each region. By adding region to the view, you notice that machines in the South are reporting a higher negative profit overall than in your other regions. You've discovered a hidden insight!
This view best encapsulates your work so far. Select All in the Sub-Category filter card (if you changed your filter) to show all sub-categories again, name the worksheet and add a title.
You choose to focus your analysis on the South, but you don't want to lose the view you've created. In Tableau Desktop, you can duplicate your worksheet to continue where you left off.
Your view updates to look like the image below.
Now you can focus on sales and profit in the South. You immediately see that machine sales had negative profit in 2014 and again in 2017. This is something to investigate!
In this step you used filter and color to make working with your data a bit easier. You also learned about a few fun features that Tableau offers to help you answer key questions about your data. You learned how to:
Having explored your data in Tableau Desktop, you've identified areas of concern. You know sales and profit in the South are a problem, but you don't yet have a solution. You want to look at other factors that might be contributing to these results. Next, you'll leverage another key feature in Tableau to work with geographic data.
If you agree that it’s time to stop making decisions based on poor quality data or the opinions of a few, and start making fact-based decisions supported by hard data, get in touch with Onebridge today using the link below. You can also join us in a conversation on Twitter, Facebook or LinkedIn.
