Tableau Assignment with Movies Data
Use MovieData.xlsx posted on Blackboard as the original data1
. This dataset contains the title,
genre, studio, ratings, and profitability for movies released from 2007 to 2011. Each row
represents a unique movie. Variables contained in the dataset are defined as follows:
Variable Definition
Film Name of the film
Genre Genre of the film
Lead Studio Lead studio that produced the film
Audience score % The audience rating of the film
Profitability Profitability of the film, calculated as % of the budget recovered
Rotten
Tomatoes % The rotten tomatoes rating of the film
Worldwide Gross Worldwide gross box office of the film, denominated in millions of USD
Year The year in which the film was released
1. Use Tableau to analyze the dataset and answer the following questions:
a. Worksheet 1: MoviesbyYear
Which year has the highest total worldwide gross box office for all movies
produced in that year? Which year has the highest average profitability per
movie?
b. Worksheet 2: MoviesbyGenre
Which genre of film has the highest total worldwide gross box office? Which
genre has the highest average profitability per movie?
c. Worksheet 3: MoviesbyStudio
In year 2008 alone, which lead studio has the highest average audience score per
movie? Which lead studio has the highest average rotten tomatoes score per
movie?
d. Worksheet 4: MoviesbyScore
Explore the relationship between rotten tomatoes scores and worldwide gross
box office. Do films with high rotten tomatoes scores tend to have higher
1 Note: this dataset is downloaded from http://public.tableau.com/en-us/s/resources, original data are composed by
InformationIsBeautiful.net at http://www.informationisbeautiful.net/data/.
worldwide gross box office results? Use a scatterplot and insert a trendline to
assess the statistical significance of the relationship between the two variables.
e. Worksheet 5: Interactive Dashboard
Create a Dashboard that includes the four worksheets created in the previous
steps. Insert two global filters: Year and Genre.
For questions a to d, create a worksheet in Tableau for each question then take a screenshot
of each of the four Tableau charts using the Snipping Tool in Windows (or the corresponding
shortcuts in Mac).
For the interactive dashboard created in question e, set your filter to year=2009 and
Genre=Comedy. Then take a screenshot of the interactive dashboard with the filters applied
(only apply filters after you have taken the screenshots for the first four Tableau charts, as filters will
change the first four charts as well).
Make sure your screenshot only includes the Tableau chart, not your entire screen. Copy and
paste the screenshot to a Microsoft Word file, and then type in a short sentence describing
your result in the Word file immediately below the pasted Tableau chart. For the screenshot
for the interactive dashboard, make sure you select year=2009 and Genre=Comedy. Answer all
questions in ONE Word file and upload the Word file as well as the packaged Tableau
workbook to Blackboard.
