Hello everyone. This is Professor Majed Al-Ghandour. It's pleasure to be here to continue all of those series for the videos for the use Tableau for your Data Science workflow. Today we'll go and talk about the course number 2, data storytelling and the topic for Module 1, we're going to cover you in this video, how to do scatter plot, and we're going to walk through with you, and also show some correlation. Let's go ahead and do it. Remember, last module, we're already we connect to the data source for superstore. We did our measure and dimension, and we did that univariate, if you remember that. Let me pull this down here. Where we did the histogram and looking for analysis for one variables. We did also the table function. You can see, I'm dragging these, you can drag them anywhere you want. All as we keep the dashboard and the story at the end. But here's what we did last video as well. That being said, let's go ahead and now we're interested to go and do a scatterplot. We're going to add another sheet from here. Let's call it Scatterplot. Again, the name just to know what we're doing here. But you can call it sale, you can call it K 401, you can call whatever you want to call it. Scatterplot is like x and y. That's why we tried to do a graph, and that's why I tried to use it also for the next thing we will do, we'll do something called correlation. Very nice. You've got your measures here. Usually, when you do x and y, you usually like a dot, that's what you need two majors. The first thing we'll go ahead and pull the profit, put it on one of these columns or rows, doesn't matter, and now we can see it gives you all these. We're going to take the sales and drag them also in the rows. Now, we give you only one point. That's the total sums of both when you hover over it like this, those are the profit and the sales. Definitely, what we interested now to make this analysis, remove those aggregation measures, the totals. So we got analysis in the menu. You will unselect this checkbox. Now, we can see here's every dot from the 9,246, I believe, records that we got. You can see every point there. Interesting. Now, we can see the outliers, I'll talk about them also next videos, very cool, you can see that the scatter plot very nicely. What you can do also, you can do something called trend analysis very quick, go and say, "Hey, show me the trend line." Show the trend line. Now, which is nice, you can see it's very strong in a positive way. You can see also the equation, if you're doing some very simple linear regression, that's the relationship between the sales and the profit. See that equation, looks like it's sales equal constant plus the profit with the coefficients. That's the scatterplot. Of course, you can change those plots. Anytime, we've seen already selected here, we can change them anything we want, but we would like to keep just scatterplot.
