Another way to visualize your data is to separate it into bins. This video shows you how to visualize data in this manner by using 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 separate it into bins. For example, you might want to know how many items of a particular product that you sold within a given month. In this movie, I will show you how to summarize that information visually by creating a histogram. My sample file is the 10_06_Histogram workbook. You can find it in the Chapter 10 folder of your exercise files collection.
A histogram quantifies data by dividing it into bins, and it's easier to show than to explain, so I will start by dragging a single item into the body of the visualization. So I will make that Quantity and drag that to the data area, and I get my sum of 2,714, which doesn't really tell me anything. So what I would like to do is to create a vertical bar chart or column chart to indicate how those values are spread out.
So I will click Show Me on the toolbar, and then, on the next to bottom row, you'll see that Histogram is highlighted, so I'll click that. And if I click Show Me again to hide it, you see that I have quite a few orders of different quantities. It looks like the most orders were of quantities between seven and eight. So we start at six, but we actually have six as the top bound of the previous bin. So we have a seven and eight, and then looks like we had a lot with 12 and 13, or 11 and 12 rather, 13 and 14 and so on.
So what you can see is that most of the orders had quite a few items, and there were a few, as well, that had one or two, three or four. If you wanted to, you could add a filter, perhaps by product category. So if I go over to the Data panel, scroll down to your Products and click Product Category and put that on Filters, then I can select what I want to see. And in this case, I'll go ahead and do just orders for solar panels and wind harvesters, green energy generation.
And I'll click OK, and the changes. You can see that I had 10 orders of quantity one or two, eight of quantity three or four and so on. If I want to remove the filter, I can just drag the Product Category pill from the Filter card and I'm back to my original dataset.
- Managing data sources and visualizations
- Managing Tableau worksheets and workbooks
- Creating custom calculations and fields
- Analyzing data using statistical tools
- Sorting and filtering Tableau data
- Defining groups and sets
- Creating and pivoting crosstabs
- Formatting Tableau visualizations
- Creating basic charts
- Annotating and formatting charts
- Mapping geographic data
- Creating dashboards and actions
Skill Level Beginner
Creating Interactive Dashboards in Tableau 10with Nate Makdad2h 24m Intermediate
Integrating Tableau and R for Data Sciencewith Ben Sullins1h 10m Intermediate
1. Introducing Tableau
2. Manage Data Sources and Visualizations
3. Managing Tableau Worksheets and Workbooks
4. Creating Custom Calculations and Fields
5. Analyzing Data Using Statistical Tools
6. Sorting and Filtering Tableau Data
7. Defining Groups and Sets
8. Creating and Pivoting Crosstabs
9. Formatting Tableau Visualizations
10. Creating Basic Charts
11. Annotating and Formatting Charts
12. Mapping Geographic Data
13. Creating Dashboards and Actions
Next steps1m 7s
- 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.