Scatterplot visualization

Transcript

Hey everybody. It’s Doug. In this video, let’s look at the scatterplot visualization and add it to our project and take a look at what we get. Like several visualizations, the scatterplot visualization requires that we get data out of a freeform table. So, I’ve got a product revenue table here. I’ve got my products and I have revenue and I have how many unique visitors have interfaced with those products or touched on those products on the site. So, I’m just going to take that scatter and put it right up above there and drop it in. And as always want to make sure that it is associated with the right table. So, it looks like it is, and so I can just click out of that.

Now you can see that it’s going to take those two metrics and the needs two metrics 'cause you can see it’s going to plot these on a graph. So, we need both a Y axis and an X axis here. So, it takes the first one revenue and it’s on the Y axis, and we’ve got unique visitors and that’s on the X axis here. And we’ll take a look at what happens when we add one more metric in a moment. But first let’s take a look at this because what this is going to show us is basically the relationship between these two metrics. And this can be very powerful because we can see that when you have some kind of an outlier here, well, what does this mean? It means that it has a high revenue, but also had a high touch. Now what we might like is when we don’t have to get as many people to look at this product, but we still make a lot of revenue off of it. So, I kind of liked this one right up here, because you can see during the time period, this is last month, that we have 587,000 with about 500 visitors. And we have about the same revenue here, but it took 1800 visitors to make me that same amount of money. So, we want to kind of take a look at these over here. Now there are several reasons why it could be like that. This might be a higher priced item, right? So a luggage set might be more than this watch. So, we might want to take, the number of orders into consideration here as well. But at the end of the day, if you’re about revenue, if that’s what you’re about, and that’s what you want to know about, where’s it coming from, then you probably really like these over here that have higher revenue with less people because perhaps if it’ll convert this good for 500 people, then maybe we just can get it in front of more people and increase our revenue. So again, this is just one way to look at this scatterplot visualization with revenue and unique visitors. Now I mentioned a third metric. So, if we go up here and I’m going to type in orders. Okay, and then I’m going to drag that one on and put it at the end.

And now what you can see is that the third metric that you add is the size of the bubble. So, the bigger the bubble, the more orders for that item. So, you can see that indeed it didn’t take as many orders, only 76 orders of this to get to almost 600,000. And over here, it took 200 orders to get to about the same amount of money. And so clearly this luggage set is higher price than that watch, but it’ll give you an idea here, if you just want to be able to see that on the plot and say, okay, these are good. These are really good here and, but you know, this one’s pretty good too, because it has more orders. So, it was a little lower price to item and still did really well. So anyway, you can switch this around, however you want to so that you can see the thing that you want on the Y and X axis. And then the item that you want to show regarding the diameter of these bubbles. Hope that was helpful. Have a great day. -