Hello everyone. Welcome back. This is Professor Majed Al-Ghandour from UCI Division of Continuing Education. Let's go ahead and talk about the second video for your class to use Tableau for your data science workflow. This is where we continue the Course 1, data visualization best practices. Now we'd like to cover in Module 4; what are the dimensions and measures in Tableau and we'll talk about univariate analytics in Tableau and also talk about a couple of table function. Let's go ahead and do it. Remember, last module we already, we connect to our Superstore. We browse the data, we understand where is the data and now we are interested to go ahead and talk about the first thing which we call sheets. We have a bunch of sheets here, worksheets. Then the next one we call the dashboards, and the next one we call it stories. We'll talk about these also later on, but this is always when you start working, you start by working with Sheet 1 and the Sheet 1 always it's a good practice to go ahead and rename it right away. Let's call it measures and dimensions. But this is just a name just to tell you that. What's measure and dimensions? This is when you bring the data source, they go and look for that Abc's and in numeric. Abc is what we call dimensions or tables and here they are: Category Abc, Containers Abc, Item Abc, Department Abc's, and then, here are the measures after this line. These are the numeric ones. You can view any of these, you can just guide like this and you can look at it as well and definitely you can look for a lot of things. You can describe it as we said earlier. You have about 20 of 1,282 so it's a big list that, but definitely you can go and view any of these as well when you work with it when you need it. Let's go ahead and talk about how you can bring those in this Canvas. What we have, we have a menu at the top, we have icons, and we have two tabs; Data, Analytics, and that's where you can do more analytics, but we aren't just focusing in the data. What you do, you go and drag these, you have a bunch of options. You can drag it to the Canvas here. You can drag it to the markers. You can drag it to the filters. You can drag it to the pages, or you can drag it to the columns and rows. So you have a bunch of options that you can work with and that's great, very easy in Tableau to drag those. Let's go ahead and start drawing the region to the columns and be sure this will appear and be sure that you see that triangle, there. If you are a little bit off, you will not see it. We are not really dragging it. Now let's go and put that region. Then let's go ahead and get the sales, for example, in the rows. When you do that, by default, you get a very nice graph and this is the graph that we are interested to share with you and that's exactly where you can see, make connection between the regions and the cells. Very simple, nice sharp, and thus called where you can work with dimensions and measures. Let's go ahead and add another sheet. We're going to click on the plus, of course, there is a lot way to do it. You can go worksheet, a new sheet, you can have Control M. So either way, I've got to like, use those icons here and now we are gone to Sheet 2. Let's talk about univariate analytics. Let me spell it correct. There you go, finally, and that's where we interested to highlight for you what is that univariate analytics. You are really exploring the data analysis and you try to explore one variable at a time. That's maybe the best thing. We can go and drag the sales and put it in the columns or in the row, either way, let's go in the rows, and now we can see are exploring that. This is the total sales. You can change this variation to averages. You can see the value can change. You can change it to different measures, counts. We have 9,000, remember that 9,000 referring records, and you can change it to minimum of the sales. You can change it to the maximum of the sales. We can change these very nice standard deviation variances. That's why you study univariate analytics. At the same time, you can go right-click here and click something called "Summary" and that's matching what we are doing here a little bit in that term. We go back to the sum. That's exactly, you can see 8,952,000, much about that number. See that in the chart and that's exactly where you can do those called univariate analytics that interested in that. You can do a lot of things. You can do histograms. Let's go ahead and show me there and let's go and look for that kind of histogram frequency. Click on this guy here and then you'll be able to see that as above here, you can see that it's already distributed with its queue and this means that the median should be also used in the measures for your median in your right queue as well. Definitely, you can start studying these and this is show on and show off basically and that's what you're tried to do as well. Let's go ahead and do one more here and let's call it table functions. Let's go and build a table. So it's called, table function. Again, it's just a name, really just to know what we try to do. You can double-click and thus you can delete it if you don't like that, you can add more, 2021 sales, for example. Some of that can make it center. So all these are themes and settings. You can change the color as well. You can do that, and we'll talk about that also later on, but this is cool. You can see that. Now we can delete it, and say no, let's give just default on the sheet name and you can take these as well. Now, we're interested to drag a couple of things. Let's go and drag the shift mode to the rows. Let's go ahead and drag sales to the columns. Now I start getting some graph. You're going to show me and we go and change it to a table, very nice. Now we can get a table and that's exactly what you got. You got all these are the sums per ship mode as you see there and now we can move those type functions as we mentioned earlier. You can have averages. Here are the average per mode of shipping. You can change it also to say, give me the medians and all these aggregation you can do and show me the minimum. Show me what's the maximum, and always remember that summary give you also very nice aggregations and result as well. All right, thank you very much for talking about this module and we'll go and join you in the next video. Thank you.
