DS44 Dashboard Week: Day 2

It’s day 2 of dashboard week for DS44.

Today the team are going to focus on a popular dashboard week theme which is the Lego dataset, courtesy of Will Sutton. This dataset contains a variety of different tables, so narrowing their focus will be important today. 

We have seen an increase in the number of people needing SQL skills, so for Day 2, I want the team to practise their SQL and Power BI skills as today’s challenge requires them to do the data preparation within SQL and visualisation in Power BI.

SELECT Bricks FROM LEGO WHERE FunLevel > 9000

Requirements: 

  • Scope, Plan and Sketch your work
  • Use your SQL skills to join the data sets together
  • Create a report in Power BI
  • Feel free to find additional data that might supplement your analysis
  • Post your blog before presenting at 3:30pm

You should present your:

  • Plan & sketches
  • SQL statements
  • Power BI Dashboard

Good Luck team!

Finer Details:

  • Lego
    • DB: TIL_PORTFOLIO_PROJECTS
    • Schema: staging
Author:
Ruth Amarteifio
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