Skip to content

angelaboo/lego-sets-powerbi-dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 

Repository files navigation

LEGO Sets Explorer: A Power BI Dashboard

Overview

This project is a guided initiative from Maven Analytics, designed to create an interactive Power BI dashboard that helps LEGO enthusiasts explore and discover LEGO sets based on specific criteria.


Project Objective

The goal of this project is to build a custom interactive Power BI dashboard that enables LEGO collectors to:

  • Simplify the process of finding the perfect LEGO sets released between 1970 and 2022.
  • Filter and narrow down sets based on criteria such as theme group, theme, recommended age range, and retail price.

Learning Objectives

Through this project, I aimed to:

  1. Load and transform data for analysis using Power BI.
  2. Design an intuitive layout with effective visuals.
  3. Incorporate interactive components to enhance user experience.

Dashboard Preview

Below is a preview of the Power BI dashboard:

1. Main Page

The main page provides an overview of all LEGO sets, allowing users to filter and explore data dynamically. Key metrics such as the total number of sets, total pieces, and average retail price are displayed. Dashboard Preview - Page 1

2. Decomposition Tree

The decomposition tree visual enables users to drill down into the data by specific dimensions, such as category, theme group, theme, subtheme, and name, to uncover insights. Dashboard Preview - Page 2


Data Used

Source: The dataset for this project is provided by Maven Analytics and includes LEGO sets released from 1970 to 2022.

Size: 18,458 records across 14 columns.

Description: The dataset includes the following columns:

  • set_id: Official LEGO item number
  • name: Name of the LEGO set
  • year: Release year
  • theme: LEGO theme the set belongs to
  • subtheme: Subtheme within the theme
  • themeGroup: Overall group the theme belongs to
  • category: Type of set
  • pieces: Number of pieces in the set
  • minifigs: Number of mini figures included in the set
  • agerange_min: Minimum age recommended
  • US_retailPrice: US retail price at launch
  • bricksetURL: URL for the set on brickset.com
  • thumbnailURL: Small image of the set
  • imageURL: Full-size image of the set

Note: Please refer to Maven Analytics for access to the dataset.


Documents

Key Takeaways Mindmap Image


Acknowledgments

  • Maven Analytics for providing the dataset and project guidance.

Author

Angela Boo

Feel free to reach out with any questions or feedback, or use this as inspiration for your own dashboarding journey! Happy building! 🚀