__STYLES__
Tools used in this project
Maven LEGO Challenge

LEGO Minifigures PowerBI Dashboard

About this project

Project Report: Exploration of LEGO Minifigure Evolution

Objective: This project aimed to explore the history and evolution of LEGO minifigures, tracing their growth and development over the years. The analysis focused on understanding trends in minifigure inclusion in LEGO sets, changes in design and diversity, and the impact of market and consumer preferences on LEGO's minifigure strategy.

Methodology:

  1. Data Collection and Initial Analysis with Excel:
    • A comprehensive dataset of LEGO sets was provided for this challenge, including details on the year of release, theme, number of pieces, and minifigures.
    • Preliminary exploratory data analysis (EDA) was conducted using Excel. This phase involved filtering, sorting, and basic statistical analysis to identify initial trends and patterns in the data, particularly focusing on the frequency and characteristics of minifigures in the sets.
  2. Advanced Visualization with Power BI:
    • The cleaned and structured dataset from Excel was imported into Power BI.
    • Advanced visualizations were created to illustrate the evolution of LEGO minifigures. These included time-series analyses showing the growth in the number of minifigures, thematic comparisons, and the relationship between set complexity and minifigure inclusion.
    • Interactive elements were incorporated to allow dynamic exploration of the data, such as filtering by year, theme, or set complexity.
  3. Supplementary Internet Research:
    • To augment the data analysis, additional research was conducted via the Internet. This research provided context on key milestones in LEGO minifigure history, such as the introduction of the modern minifigure in 1978, the expansion of themed and licensed sets in the 2000s, and recent trends towards increased diversity and character-driven sets.
    • This qualitative information was crucial in interpreting the data trends and provided a narrative to the story of LEGO minifigures.

Findings:

  • Growth Trends: A significant increase in minifigures per set was observed, especially post-2000, coinciding with LEGO's strategic shift towards licensed themes and character-driven sets.
  • Theme and Design Evolution: Changes in minifigure design and variety were closely tied to introducing new themes, especially licensed franchises.
  • Market Influence: Consumer preferences and the collector's market appeared to significantly influence LEGO's minifigure strategy, evident from the introduction of the Collectible Minifigures series and increased diversity in minifigure representation.

Conclusion: The project successfully mapped the historical trajectory of LEGO minifigures, revealing how changes in market strategies, consumer preferences, and cultural trends have shaped their evolution. The combination of quantitative data analysis with qualitative research provided a comprehensive understanding of the minifigures' journey from simple, generic figures to diverse, character-rich elements that are central to the LEGO experience.

Additional project images

Discussion and feedback(13 comments)
comment-890-avatar
Siddharth Warrier
Siddharth Warrier
9 months ago
Congratulations Jack! Great work!

comment-891-avatar
Claire Soh
Claire Soh
9 months ago
Amazing work Jack. Thank you for sharing. The dashboard is neat and clean. I love how you partition each decade and everything fits nicely into our screens.

comment-901-avatar
Parvez Alam
Parvez Alam
9 months ago
Congratulations!!!

comment-906-avatar
Shanil Vashi
Shanil Vashi
9 months ago
Nice job Jack very nice, neat and clean dashboard

comment-917-avatar
Szymon Świeży
Szymon Świeży
9 months ago
How did you make those highlighted periods on the chart?

comment-926-avatar
Chijioke Chidiebere
Chijioke Chidiebere
9 months ago
This is amazing, very simple description.

comment-1609-avatar
Erzsébet Kalamán
Erzsébet Kalamán
4 months ago
Gratulations! Did you manage to make the video?

comment-1679-avatar
Geoff Kitt
Geoff Kitt
3 months ago
Super clean dashboard with a very easy to digest format and solid user interface! I really like the conditional formatting used within the KPIs comparing decades.
2000 characters remaining
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.