From the course: Complete Guide to Tableau for Data Scientists
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Solution: Analytics, part 2 - Tableau Tutorial
From the course: Complete Guide to Tableau for Data Scientists
Solution: Analytics, part 2
(upbeat music) - [Instructor] Okay, let's see what we can do with this. So, they love this box plot for what it gives them, but they've now decided they want to be able to look at any of these expenses, not just the two they originally told us. So we're going to need to make some changes to our data. Now, ideally I want to filter that's like a single dropdown that they can select, but I can't do it with the data in this way because my measures are measures not selectable dimensions. So I need to pivot this data. Trouble is I'm using this in other charts and that's definitely going to break them. So, first step, let's fix the data and then we'll fix the sheet. I think that will work. So let's edit our data source. Okay, so it's this expenses table that we're going to be changing. Let's have a little look at it. So I've got my date, and then I've got my calculation for the expenses date. Well, let's hide this 'cause I'm not interested in that date at the moment. So let's just hide that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
What is the Analytics pane?4m 49s
-
(Locked)
Create a constant reference line5m 2s
-
(Locked)
Create a dynamic average reference line7m 8s
-
(Locked)
How to create box plots5m 18s
-
(Locked)
Adding totals and sub-totals to a view6m 55s
-
(Locked)
Adding a forecast to a view4m 34s
-
(Locked)
Adding a trend line to a view5m 53s
-
(Locked)
Looking for clusters of data in a view5m 10s
-
(Locked)
Creating a reference band7m 22s
-
(Locked)
Challenge: Analytics, part 11m 21s
-
(Locked)
Solution: Analytics, part 16m 25s
-
(Locked)
Challenge: Analytics, part 21m 11s
-
(Locked)
Solution: Analytics, part 26m 49s
-
-
-
-
-