gistfile1.md

Data Analysis Assessment Task

Purpose

This task has been designed to assess the following areas:

• SQL
• Python
• Data extraction and manipulation
• Data visualisation
• Code standards and quality

Duration

Spend no longer than four hours on this project; the task is assessing how far you can get and the approach you take, not requiring perfection.

Context

The Museum of Modern Art (MoMA) makes regular data dumps of its records publicly available. A database containing a subset of these records has been made available to you.

Database

The data is stored on a Postgres database containing two linked tables:

• artist
• artwork

Connection details for this database will be sent to you separately.

Brief

Using the provided database, create an interactive, visually-engaging dashboard that allows non-technical users to

• View the number of artworks available in the collection
• See a breakdown of artist demographics (i.e. gender, nationality)

The dashboard should provide functionality to filter by

• Department
• Date range

For simplicity, all untitled artworks should be ignored and not included in any visualisations.

There is no requirement for the dashboard to be hosted anywhere.

Outputs

• An interactive dashboard
• A repository containing the complete code required to extract the data and build the dashboard