Histograms are visualizations that summarize the number of values that fall into discrete bins. In this video, learn how to create histograms.
- [Instructor] Analyzing individual values such as the largest sales day for a month, provides terrific insights into your business. Another way to visualize your data is to create a frequency table where you look at a collection of individual values and organize them into bins. For example, you might want to know how many orders, were for between one and 7,000 dollars, between seven and 14,000 and so on. In this movie, I will show you how to visualize data in this manner by creating a histogram. My sample file is 09_06 Histogram, and you can find it in the chapter nine folder of your exercise files collection. I have my read 30 tech order data, already loaded in to the workbook. And rather than look at all of our data, because we have everything from blueprints that cost around 10 dollars to drones that we sell to commercial customers for thousands of dollars. I want to instead focus on one product sold to wholesale customers who I assume will resell it. So the first thing I will do is drag my order total measure to the data area. And I see my total there, 6.97 million. And if you're going to create a histogram, you only need that one measure. However, in this case I want to focus a little bit more tightly, that is on a specific product to wholesale customers. So I need to add two filters. The first thing I will do is drag Order Type to the Filters card. And I will check the Wholesale box and click OK. Right, so that's been limited a bit. And now I want to focus on a specific product. So I'll drag Product Name to the Filters card. And from the Filter list, I'll click the box next to DX-145 Drone. So that's the product we're focusing on. Now click OK. And I see that we're down to 339,500. Now we can look at how the total for each order for this product is distributed by creating a histogram. So I'll go to the Show Me button, and at the bottom I will click Histogram. And I'll click Show Me again to clear that out of the way so we can see all of the data. So out of our orders, it appears that we had about 38 that were for between zero and 2,000 dollars. And then about, say 23 between three and 5000 and so on. At the right edge we'll see that we had a couple of orders in the 26,000 dollars range. So those were very big orders, probably a lot of units. But as you can see, the vast majority of orders were for between zero and about 5,000 dollars. The larger orders were probably for larger customers or distributors who were restocking.
- 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.