Tableau can rearrange a crosstab, which displays data using row and column headers, as a table made up of columns. In this video, learn how to unpivot a crosstab.
- [Instructor] Creating a crosstab from a list of data, which Tableau refers to as a pivot, lets you analyze your data across both rows and columns. If you would prefer to work with your data as a list, you can unpivot your crosstab to transform it into that format. I'll demonstrate how to perform that task in this movie. My sample file is 08_02 unPivot, and you can find it in the chapter eight folder of the exercise files collection. I'm working with the worksheet named category and region two on which I have a crosstab. You can see that I have sales region as the row header, and product category as the column header. If I want to render this data as a list, then I need to decide whether I want sales region or product category as the first level of organization. Let's say I want to see data by sales region, and then by product category to start with. To unpivot I will direct product category to the right of sales region on the rows shelf, and there you see I have my data broken down first by region, and then by category. If I'd rather see it by category and then by region, I can drag sales region to the right of product category, and I changed the way my data is broken down. So as you can see, unpivoting data is a straightforward operation. The order of the pills on the row shelf matters though, so experiment and pick the one you like.
- 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.