Back to Projects
Case Study
Data Analysis and Visualization

LEGO Sets Analysis Dashboard

A Power BI dashboard that helps understand LEGO set growth, themes, prices, piece counts, minifigures, and detailed set performance.
Live Production AppDiscuss Project
LEGO Sets Analysis Dashboard cover image

Key Metrics Analyzed

Total LEGO Sets18K
Average Number of Pieces178
Number of Themes152
Average Retail Price$14.20
Most Popular ThemeGear
Most Expensive ThemeStar Wars
Set with Most PiecesWorld Map

Overview & Objectives

This project analyzes LEGO sets data using Power BI. It helps users understand total LEGO sets, average number of pieces, number of themes, average retail price, yearly growth, theme performance, set prices, minifigures, piece count distribution, and detailed set-level insights. The dashboard includes three report pages. The first page focuses on overview metrics, yearly growth, top themes, average price, and piece count distribution. The second page explores themes, most popular themes, most expensive themes, minifigures, and theme-level analysis. The third page provides detailed set analysis including top sets by pieces, age range distribution, top theme groups, minifigure counts, and price versus pieces.

Project Goal

Build a clear Power BI dashboard that helps users explore LEGO sets, compare themes, understand price trends, and identify top-performing sets.

The Business Problem

LEGO set data includes many details such as themes, sub-themes, piece counts, prices, minifigures, categories, years, and set names. It can be difficult to understand growth, pricing, theme popularity, and set performance without a clear interactive dashboard.
Methodology

My Approach

  • 1I cleaned and prepared the LEGO sets dataset.
  • 2I created Power BI measures for total sets, average pieces, number of themes, average retail price, theme counts, and set-level performance.
  • 3I designed dashboard pages for overview, thematic exploration, and detailed set analysis.
  • 4I added visual comparisons by year, category, theme, sub-theme, piece count, minifigures, age range, and price.
Implementation

Roadmap Execution

Data Preparation

Cleaned and prepared the LEGO sets dataset for analysis.

Data Modeling

Created the Power BI data model for sets, themes, sub-themes, years, prices, pieces, and minifigures.

DAX Development

Built measures for total sets, average pieces, theme count, average retail price, set rankings, and growth trends.

Overview Dashboard

Designed the overview page with key metrics, yearly growth, theme rankings, price trends, and piece count distribution.

Theme Analysis

Created thematic exploration visuals for popular themes, expensive themes, minifigures, and category distribution.

Detailed Set Analysis

Built detailed set-level visuals for top sets, age range, theme groups, minifigures, and price versus pieces.

Key Features

Overview and key metrics page
Yearly growth of LEGO sets
Top 10 themes by sets
Average set price over time
Average number of pieces over time
Distribution of sets by piece count
Most popular theme analysis
Most expensive theme analysis
Theme with most minifigures
Themes by set count over time
Average set price by theme
Detailed set analysis
Top sets by year based on pieces
Age range distribution
Price versus pieces analysis

Business Impact

Helps users understand LEGO set growth over time
Makes theme and set comparison easier
Shows price and piece count patterns clearly
Identifies popular and expensive LEGO themes
Reduces manual exploration by using one interactive Power BI dashboard

Challenges Overcome

  • Combining set, theme, price, minifigure, piece count, and year data into one dashboard
  • Making LEGO theme performance easy to understand
  • Showing long-term LEGO growth clearly
  • Comparing set price and piece count trends
  • Designing simple visuals for detailed set exploration
Outcomes

Final Outcomes & Learnings

  • The final dashboard gives a clear view of LEGO set growth, theme popularity, pricing patterns, minifigure distribution, piece count trends, and detailed set performance.
  • Users can quickly identify the most popular themes, most expensive themes, sets with the most pieces, and pricing relationships across LEGO sets.

Project Gallery & Screenshots

Power BI LEGO dashboard showing overview and key metrics including total LEGO sets, average pieces, themes, retail price, yearly growth, top themes, and piece count distribution
Power BI LEGO dashboard showing thematic exploration with popular themes, expensive themes, minifigures, theme distribution, and average price by theme
Power BI LEGO dashboard showing detailed set analysis with most pieces, expensive set, minifigures, widest age range, top sets by year, and price versus pieces

Technologies Used

Power BIPower QueryDAXExcelData ModelingData Visualization

Data Sources

LEGO sets datasetTheme dataSet price dataPiece count dataMinifigure dataYearly release dataCategory and sub-theme data

Need similar outcomes in your business?

Let's scope your metrics and construct dashboards tailored to your parameters.

Discuss Similar Projects