Our analysis reveals a notable increase in the number of LEGO parts over time, indicating a trend towards greater complexity and specialization. The upward trajectory in part count and set count illustrates the evolving landscape of LEGO construction. However, a curious decline in LEGO production in 2007 prompts investigation, uncovering economic factors that led to outsourcing production to external partners.

A visual exploration (density map) unveils a "color explosion" in 2004-2005, reflecting the emergence of more intricate and commercially themed LEGO sets. Commercial themes have witnessed significant expansion, as depicted by the proportion of different theme groups. Moreover, the introduction of new colors, particularly for commercial themes, underscores LEGO's continuous innovation and response to market demands.

After we had the insights of Lego’s commercial themes was increased significantly, I decided to build 2 tree map to better show the ratio of Lego’s each themes. In the below 2 tree maps, the proportion of different theme groups over all themes is put into perspective. It’s apparent by the relative size and color that commercial themes have expanded most rapidly. (Red indicates Lego’s commercial theme)

Our analysis also focused on the evolution of LEGO’s color palette over time. I create following 2 grahs to illustrate this evolution, revealing a steady increase in the number of colors introduced. From the 1st graph, we observed the colors intorduced later in the decade had shorter lifespans compared to earlier introductions. From the 2nd graph, we noticed the majority of new colors were developed for commercial themes, highlighting LEGO's strategic approach to product innovation and differentiation.

A further analysis was conducted based on LEGO’s special pieces, particular focusing on the relationship between mini-figures and special themes. I designed the below combined graphs to show the trend that underscores LEGO's commitment to catering to diverse user preferences and enhancing the immersive experience of LEGO building.

The final visualization marked the complex nature of each major LEGO theme through a dynamic color count representation. This visual depiction offers insights into the thematic diversity and intricacies inherent in LEGO constructions, providing a comprehensive overview of LEGO's thematic evolution over time. The final delivery is an interactive dashboard, I put together a video forma tin order to better show the experience.

This project relies on two Lego datasets sourced from a LEGO fan website called Rebrickable. The primary database we utilized features a comprehensive schema and is regularly updated on a monthly basis. It encompasses detailed information on "The LEGO Parts/Sets/Colors and Inventories of every official LEGO set." This extensive database is organized into different datasets, as depicted in the schema below.