[MUSIC] As we're finishing up this dashboard, I want to make sure we review the key best practices of building a dashboard. So we can evaluate our dashboard against it. The first is we want to choose the metrics that matter. The second is we want to keep it visual. The third is we want to make it interactive for collaboration. The fourth is Is we want to pull data from all sources to get the full picture and keep the dashboards up to date or refreshed. And, finally, the fifth is we want to make it simple to access and easy to use. Finally, we want to ensure we avoided the seven common mistakes. I think we hit on all of those. I think that the live and refreshable point is always tricky with this type of data, but otherwise I think we've done a good job here. So let's improve this even more by adding some really cool actions, and filters to really get the dashboard usable and user-friendly. One of the issues that we have, as you can see in the screen in front of you, is that the customer rankings go far down the page, which makes it difficult to navigate. Furthermore, we can't hover over the scatter plot. It's very difficult to figure out who is doing what. So the first thing we're going to do is we're going to add a little bit of information. And that little bit of information is going to be added to the scatter pot. So let's go ahead and navigate over to the Customer Scatterplot worksheet. We're going to use the detailed marks to get more information to the scatter plot. So we are going to drag the Customer Name field, as you can see in front of you here, down to the Details and drop it over the Detail marks, right there, perfect. And now what we're going to do, look at that. We can see the customer name is kind of tiny there, or it's normal sized I should say. What we're going to do is expand the size of it like we did with others. We're going to make it 15 font and bold. So we go again to the Tooltip. We click on the Tooltip, like so. And then, we make modifications in the Tooltip box by upping the font to 15 and making it bold. And then we'll click OK. And so what we'll see here is that the names are much more prominent which is exactly what we want. So let's go take a look at the customer rank and just make sure that it also has the Tooltip as we need it. And it does, as you can see here, we're looking at Hunter Lopez, and in fact, the name is much more prominent. So this is exactly what we want on both of these, because it's going to be sort of customer centered, this particular dashboard. And you can see that. Well go back to the dashboard now, and we see that, in fact, this is exactly what's happening. But even though you can hover over these names, you can't actually, unless you happen to get lucky, be able to connect the scatterplot with the customer ranking. And so that's not very helpful. What we're going to do to deal with that is we're going to create a dashboard action. In fact, we're going to create three dashboard actions. And the first is going to be looking at the overview and allowing us to look at the scatterplot and rankings by region. So here's how we're going to do it. We're going to head up to Dashboard and then click on Actions. Then the actions box pops up, and then we'll press Add Action as I'm doing here and click on Filter. And then here you get a bunch of choices, and it gets a little bit tricky sometimes. You often have to play around with it. If you get lucky, your going to get it right the first time. But sometimes you have to try one, let's see if it's works, and then go to another one, and that's totally okay. Totally normal part of developing dashboards. What I'm going to do here, is first I'm going to rename this by calling it Filter Region. And then on the Customer Dashboard Source Sheet I'm going to uncheck Customer Rank and Customer Scatterplot, and then I'm going to select the Select action. And on the target Sheet I'm going to unselect Customer Overview. And then under Clearing the selection will, on the right hand side, leave it as Show all values. Then at the bottom where it says Target Filters, I would like you to select the Selected Fields, and then we're going to add a filter. You click on that and another box pops up. And then you go to Field and you look at the huge number of fields here. And you select Region, and then you click OK if everything looks okay. And then, click OK again, and this will be added to your list of actions on the next screen. Click OK. Now we see that there is an action there called Filter Region runs on Select. Source is Customer Dashboard. Field is Region. And now, let's try this out. So I'm going to click on Central here and see what happens to the filter. It should filter everything at the bottom. And let's see if it does. So again, just single click, don't use double clicks. Single click on Central on the Quantity and see what happens. Look at that, it filters it based on the geography, right? So I click on Central, it filters it. And then I click it again, and it unfilters it. And that's Quantity in the Central Region. But now what if I want to click on a name, what's going to happen here? The answer is right now nothing. So we do have to deal with that too. And one of the ways that we can do that, actually the way to do that is to add an action. So we go back to Dashboard. We click on Actions again. The box boots up. You notice that the previous filled action that we built is still there, but we're going to add another action. It's going to say Add Action. And this time, I'm going to do a highlight, so let's click on Highlight. And the Highlight Action appears. And we're going to rename this Highlight Customer. And then we're going to unselect Customer Overview. And this one here, we're going to select the Hover, under Run action on. And then here on the Target Sheets, I want to unselect Customer Overview as well. And, we're going to select, Selected Fields under Target Highlighting, and select the Customer Name. And when we're done we'll hit OK. And now we'll have two actions, Filter Region and Highlight Customer. Click OK on that. And now when I hover over to Customer Ranking, look at that, it automatically highlights where the other person's sales are, but it doesn't do that on the, It doesn't quite do it on the other side, it does but it doesn't, right? When I hover, it doesn't quite work. So let's do something that maybe will fix this. And so this is kind of new to Tableau 9, believe it or not, which is making modifications to the size of the dashboard. So, what you're going to do is you're going to go to the left hand side under Size, and on mine it says Desktop Browser. It's the default. Even though I'm working on a laptop. And what I'm going to do here is I'm going to change this. Instead of doing a fixed size, which it is now, I'm going to click on that. And I'm going to select Automatic. So under Fixed Size, select Automatic. In fact, the default should be Automatic, but it isn't in this version of Tableau, which is kind of annoying. But here now, when I hover, I can see the names. But we still have a problem, because Customer Ranking is still really big, right? I have to really scroll down to find it. So I can scroll down to Cindy Stewart and find it, but you have a problem. You have to kind of know where the ranking is to be able to select it. So we still have an issue of being accessible to users. So we have to do more stuff on it to make it a little bit more accessible. And we're going to do that by having another action. Click on Dashboard, then Actions. And we're going to add an action called Filter Lower. And on this, we're going to deselect everything but the Customer Scatterplot on the top. We're going to run the action as a Select. And then in the Target Sheets, we're going to deselect everything but the Customer Rank. And then show all values in the targeted fields. It's going to be the Customer Name again. And then once you're done with that, we are going to click OK. We'll click OK to clear the actions, and now we'll click on, say, Grant Thornton, and we see that it comes up immediately. And it looks like there are at least three sales too that are below zero in profit and one that's a little bit above. So this is actually an example of how we can use Tableau's very powerful capabilities on actions and filters to be able to do some powerful stuff. It is also all about hierarchies, which you learned about in the previous course. I know I didn't use the word hierarchy very much, but in fact, these filters and these actions, are in fact hierarchies, where you can look and iteratively filter down to information that you need. It is really the fundamental piece of dashboarding. I'm going to be talking more about it as we evolve the dashboards into stories in the remaining lessons in this module, and also in the final module of the course. I really look forward to catching up with you all in the next lessons. So take care everybody. Bye.
