Lego's Journey of Decades - Children's Educational Friend

About this project

Problem Statement :-

For the Maven LEGO Challenge, you'll need to stack your imagination and analytical prowess to piece together an interactive dashboard or visual that lets users explore the history and evolution of LEGO sets from the past 5 decades.

The data is given from 1970 to till now

We need you to consolidate and clean up the raw data, and create a dashboard or report to help us understand patterns and trends.

Steps Performed :-

1) As this data have multiple sheets & the data is very messy so our first task is to make one combined sheet, for that, need to merge all the sheets & make one common sheet.

2) Next step is to clean all the dataset

3) Analyze & found meaningful insights from the given dataset & make the dashboard by using Power BI.

Output :-

1) Top 10 Theme Vs Pieces - Duplo is highest with 1098 pieces, then star Wars with 652 pieces after that Town with 645 pieces

2) Top 10 Theme Vs Minifigs - Duplo is highest with 735 minifigs, then collectable minifigures with 591 minifigs after that Town with 574 minifigs

3) Top 10 Sub Theme Vs Pieces - Magazine Gift with 448 pieces, then promotional with 398 pieces, than Classic with 146 pieces

4. Top 10 Sub Theme Vs Minifigs - Magazine Gift with 310 minifigs, then promotional with 183 minifigs, than Classis with 135 minifigs

5. The overall data is of 53 years

6. Total count of pieces was 14533

7. No. of category 7

8. No. of sub theme 893

9. No of Theme 153

10. No of Theme Groups 16