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

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…

Contents