Back to Course

Exploratory Analysis | Quiz

Quiz 1 of 0

Exploratory Analysis | Quiz

You have been hired by a media company and asked to research the history of film.
You have been given a data set of the top 1000 rated films on IMDb.

First you will need to insert 2 columns next to genre, then click text to columns to split up the multiple genres. The questions in the quiz will refer to the “Primary Genre” i.e. the first genre listed.

Use pivot tables to build out a dashboard.

Start with a chart displaying the maximum rating and the average rating by genre, add a slicer on year released.

Next to this add a chart displaying the average and maximum gross by genre.

Consider what other features you might add to your dashboard.

You will need to create other charts than those listed to answer the questions in the quiz.