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.
Challenge: Analytics, part 1 - Tableau Tutorial
From the course: Complete Guide to Tableau for Data Scientists
Challenge: Analytics, part 1
(cheerful upbeat music) - [Instructor] Oh, here we go again. Okay. "I've got some questions about our expenses." Okay. "I want to know per hotel, what's the distribution of spend for Annual Payroll and Building Maintenance? Who's keeping control of expenses year on year, and who's keeping costs down?" Hmm, okay. That's going to require some analytic work, I think. All right. Now we're going to do this one. So we're going to need to create a chart to show expenses for each hotel. We're going to have to have some annual data, so we're going to need to use the year for when that spend occurred. We need to show the payroll and the building maintenance. Those are the two measures they're interested in. And we need to be able to show who's keeping control of expenses and who's keeping them down across all of those years. Sounds like we might need to use a box plot. Maybe a box plot showing the hotel name by year for each of those expenses. Okay. To the analytics pane.
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
-
-
-
-
-