Tableau Assessment

Abu Dhabi School of Management

Masters of Science in Business Analytics

Course: Data Visualization

Group Out of class assessment (60 %)

Question1: (20 marks)

i. Review the dashboard below. List and briefly discuss at least 3 weaknesses of this viz.

For each weakness, provide a suggestion for improvement. (10 marks)

ii. Which of the following charts have the best design for the two scenarios proposed

below, choose the best design with proper argument, your argument should show your

understanding for data visualization concepts learnt during the classes, and should show

the results you reveal from each (10 marks)

1-

2-

Question 2: (18 MARKS)

Develop a Vis for each of the following using Tableau, create your own data and give a summary

for it. (include x-axes)

a) The largest number of employees earn between $50,000 and $60,000.

b) In November, the turnover rates for the four divisions were about the same.

c) There is a strong correlation between profitability and compensation.

d) Using a scatter plot-The size of company pay increases is not related to tenure.

e) The Engineering manager spends only 30% of his time in the field (don’t use a pie chart).

f) The typical salary range for Analyst is approx. 10% higher than the programmer.

Question3 (22 marks)

This Tableau file contains information on all U.S. airline flights from 2010 and 2011. Create a

Tableau worksheet to answer each of the following questions:

FILE to use: Flights_data.twbx

1. A quick viz of flights over time shows a drop of more than 300,000 flights from 2010 to 2011:

From your experience, you know that flight activity did not drop so significantly between 2010 and 2011.

Why does this viz seem to indicate otherwise? Investigate flights over time in more detail to

determine why these yearly numbers show such a large drop.

2. You are interested in identifying days that are particularly light in terms of travel each year. Are

there particular holidays that seem to experience substantially lower numbers of flights?

3. Next, you want to know who operates the most flights. Is there one airline that operated more

flights than any other single airline for each week in this dataset?

4. You would also like to know which states tend to experience the longest departure delays. Create a

map that visualizes the departure delay that you can expect in each origin state. Allow the user to

filter by airline. Colors should range from dark blue for states with short departure delays to dark

red for states with long departure delays.

5. Create a dashboard that shows all previous tasks (from number 1 to 4), choose the design that you

think it is appropriate with Justification.

6. Define and describe four new tasks you think that the management will be interested in, draw

proper Vis for each task and create a dashboard that shows all those four new tasks, then explain

why did you choose this Vis and present your tasks inside the class, the presentation will take place

in the class time that will be announced in the LMS (12 marks)