Maven LEGO Challenge

Challenge Objectives

For the Maven LEGO Challenge, you'll need to stack your imagination and analytical prowess to piece together an interactive dashboard or visual that lets users explore the history and evolution of LEGO sets from the past 5 decades.

1. Prepare the data for analysis
2. Explore the data
3. Create an interactive dashboard

The Data Set

LEGO sets released from 1970 to 2022, including details on each set's theme, pieces, recommended age, retail price, and image.

• File type: CSV
• Data structure: Single table
• # of records: 18459
• # of fields: 14

Execution and Results

1. Prepare the data for analysis

The data set was checked for any inconsistencies or missing data. Nothing of note was found, and empty values were to be treated as such, and filtered out of affected visuals.

Merchandise such as Books and Gear were filtered out of the data set for this analysis.

For easier analysis Set_ID and Name was combined in a calculated column SetAndName.

2. Explore the data

The data set contained interesting data points such as Theme, number of pieces, number of minifigures and age range. The following visuals were decided on for the main page:

• of Sets over Year

• Theme Group by # of sets
• Theme by # of sets
• Sets by # of pieces

A drill-through page for set details was also decided on, containing these visuals:

• Set ID and Name

• of Pieces

• of Minifigs

• Retail Price
• Theme

3. Create an interactive dashboard

Main Page

Set Details