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