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 1 - Tableau Tutorial
From the course: Complete Guide to Tableau for Data Scientists
Solution: Analytics, part 1
(upbeat music) - [Instructor] Okay, so we're going to need to make use of the analytics plan. So I think a box plot is probably the best solution for what we're after. So we want to know how well people are controlling their expenses, and the two we're interested in is the annual payroll and the building maintenance. Now this is annual data, so we know we have the year in the expenses date, and we've got the payroll and the maintenance. Then we're going to need the hotel name for our other data. So let's build the chart first, and then we'll apply the box plot afterwards. So I know we need the hotel name because I'm looking to compare each hotel. So let's put the hotel name on our column to begin with. Now I'm going to look at the payroll and the building maintenance. So let's add the annual payroll to my row and let's add building maintenance as well. Okay, so I've got my two charts, so that's good, and this is showing the total spend for all years for each of the hotels in the…
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
-
-
-
-
-