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.
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.
Through this project, I aimed to:
- Load and transform data for analysis using Power BI.
- Design an intuitive layout with effective visuals.
- Incorporate interactive components to enhance user experience.
Below is a preview of the Power BI dashboard:
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.
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.
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 numbername
: Name of the LEGO setyear
: Release yeartheme
: LEGO theme the set belongs tosubtheme
: Subtheme within the themethemeGroup
: Overall group the theme belongs tocategory
: Type of setpieces
: Number of pieces in the setminifigs
: Number of mini figures included in the setagerange_min
: Minimum age recommendedUS_retailPrice
: US retail price at launchbricksetURL
: URL for the set on brickset.comthumbnailURL
: Small image of the setimageURL
: Full-size image of the set
Note: Please refer to Maven Analytics for access to the dataset.
- Dashboard PDF: A PDF version of the dashboard.
- Key Takeaways Mindmap: A visual summary of insights and learnings from the project.
- Maven Analytics for providing the dataset and project guidance.
Angela Boo
- GitHub: GitHub
- Kaggle: Kaggle
- LinkedIn: Connect with Me
Feel free to reach out with any questions or feedback, or use this as inspiration for your own dashboarding journey! Happy building! 🚀