Dashboard Week - Day 2 - Lego

For Day 2 of Dashboard Week, DS44 was assigned a task that required combining planning, SQL & Power BI skills to create a LEGO themed report. We had to scope and plan a dashboard based on a Snowflake schema, we then had to query the data we required to build a report on Power BI.

I began by sketching out by doing some data discovery to understand the available data. I created the below schema to help me understand each table and how they each relate to one another.

Untitled
Lego Data Schema

After some brainstorming and some scoping I made the decision to create a report exploring the data through the lens of Lego sets and themes. For this I mainly required the two tables outlined in red on the schema above. To pull this from Snowflake I wrote the following SQL query:

Untitled
SQL Query

Having my data in order, I then began to sketch what my report would look like. I ended up with the following sketch.

Untitled
Report Sketch

The sets and theme data was limited with only 6 fields and 2,321 rows but I was happy with my ideas and felt like I could execute them in the allotted time. The below screenshot is of the final report:

Final Report

Overall, I was happy with my work for the day. While I believe that the report lacks a deep level of analysis, I was successful in scoping and planning appropriately to have a polished report. I very much enjoyed working with the data and look forward to the rest of dashboard week!

Author:
Alvaro Gonzalez
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab