Scatter plots are visualizations that relate two sets of numerical values. In this video, learn how to create scatter plots.
- [Narrator] So far in this course, most of the data we have looked has had a category, such as product category, and associated numerical values. In this movie, I'd like to show you how to create a scatterplot which shows the relationship between two numerical values. My sample file is 0904 Scatter, and you can find it in the chapter nine folder of your exercise files collection. The data set that we're working with here has only a set of measures in it, so if we look over at the data panel and look under measures, we'll see that I have order total and then time since previous order. So order total is in dollars, and at time since previous order is in days. And I want to see if there is any sort of a correlation or relationship between the time since a customer previously ordered and the amount that they order when they do make a purchase. So I will start by adding the time since previous order field to the Column shelf. You could put this on Rows if you wanted to, but I prefer Columns. And then I will drag order total to the Rows area, the Rows shelf. When I do, I get a scatterplot, but you'll notice that there is only a single point that shows the order total and time since previous order in aggregate. If I want to show the individual values, I need to change from measures to dimensions. To make that change in this case, I will go to the Analysis menu and I currently have Aggregate Measures selected, I will click that item again to deselect it, and there you see the data in the body of the scatterplot. There are a couple of other changes that I want to make, the first is to change the shape from an open circle to a filled circle, so on the Marks card, I'll click the shape box, and I'll change to a filled circle, and I also want to make the circles a little bit larger, so I'll click the size button. That's a little big, slide it back, there we go. So there the circles are the size that I want, and I will be able to continue my analysis from here. A lot of analysts forget about the step where you need to turn off Aggregate Measures. If you're creating a scatterplot, you don't want the totals, instead, you want the individual values. So, Aggregate Measures, from the Analysis menu, needs to be turned off.
- Explain where a user would navigate to seek specific help in Tableau.
- Determine the best approach for using Excel in Tableau.
- Interpret how to use the features and functions of Tableau when creating charts.
- Describe how best to manage data in a worksheet or visualization.
- Explain how to create a selection filter for certain values.
- Explain how to manage data for different chart formats.
Skill Level Beginner
1. Introducing Tableau
2. Managing Data Sources and Visualizations
3. Managing Tableau Worksheets and Workbooks
4. Creating Custom Calculations and Fields
5. Analyzing Data
6. Sorting and Filtering Tableau Data
7. Defining Groups and Sets
8. Creating and Pivoting Crosstabs
9. Creating Basic Visualizations
10. Formatting Tableau Visualizations
11. Annotating and Formatting Visualizations
12. Mapping Geographic Data
13. Creating Dashboards and Actions
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.