Hi, I'm Adrian, and Welcome to 53 years of Play! This interactive dashboard aims to be as playful and eye-catching as the actual LEGO sets.
The dashboard is composed of 3 parts: Through The Years, All The Sets, and Trivia! Each of these were designed to focus on different elements of the challenge and beyond.
I'm too poor for PowerBI premium so check the links below to see the project for yourself:
The idea behind the dashboard was that you weren't using a dashboard, you were PLAYING with a LEGO set. The background itself is a LEGO style base and the elements used have been painstakingly formatted to fit within the grid of the base, as if the objects were snapped on like LEGO bricks. Images have all been passed through PPT for background removal and composition assembly.
Majority of the colors, fonts, and design choices were inspired by LEGO's 2023 annual report and the LEGO website.
This section is dedicated to the LEGO company itself from 1970 and onward. In terms of historical moments, there wasn't that much to play around with in the core dataset so I had to think outside of the brick. I lifted the information here (https://en.wikipedia.org/wiki/Lego_timeline) and manually organized the data into years and decades in excel.
The visuals used are straightforward, a two-column table and a slicer for selecting the decades.
Section 2: All The Sets
This section is an interactive and filterable LEGO catalogue viewer. The main image box is a third-party visual I downloaded from the store. It is the most intricate in terms of construction due to the dynamic elements at play.
When there are multiple sets available, the catalogue viewer will look like so:
KPI Cards are hidden, the dynamic bricksetURL button is not usable, and images cannot be displayed. They rely on DAX such as the following:
Once ONE set has been selected the appropriate information will begin to display and the brickset link will be made available (provided the specific set has a link).By default, the cards will display "Not Available" when the corresponding metric column is null. Using 0 may be misleading and may imply the wrong idea.
Section 3: Trivia!
This section is dedicated to facts from the core datasets. Given how these facts are immutable I had to compensate lack of interactivity with visual appeal.
I hope you enjoyed viewing this project as much as I enjoyed making it. Thanks!
Connect with me in LinkedIn: https://www.linkedin.com/in/adrian-emmanuel-ramos-604332b4/