As April turns to May, we aren't just looking at plastic bricks—we’re looking at life itself. With Sir David Attenborough’s 100th birthday approaching this May, your mission is to document the "natural history" of the LEGO universe. Will you cultivate a digital garden with the Botanical Collection, or track the evolution of LEGO Animals across the Great Rebrickable Plains?
The choice of habitat is yours, but the goal remains the same: treat this data with the wonder it deserves.
Your Task
- Field Research: Download the Rebrickable CSV tables and upload them individually to your own schema on Snowflake (feel free to add additional data if you can find it)
- Species Identification: Use SQL to clean and join your data. You must choose your "kingdom": focus your analysis on Botanical/Floral sets OR the Animal/Creature kingdom.
- The Hunt for Keywords: Use keyword analysis to isolate your chosen species—search for everything from "Orchid" and "Wildflower" to "Elephant," "Shark," or the elusive "Moulded Dinosaur."
- Biological Evolution: Map the trends in the data, such as:
- Biodiversity: How has the variety of specialised animal or plant parts increased over the last decade?
- Camouflage & Pigment: Analyze the color palettes—are we seeing more "Earth" tones or vibrant "Floral" hues?
- Growth Patterns: Compare set complexity (part counts) between nature-themed sets and traditional City or Technic builds.
- The Broadcaster’s View: Connect your Snowflake data to a visualisation tool you haven't used yet this week. Build an interactive dashboard that even Sir David would find "simply... magnificent."
- Archive the Findings: Commit your SQL scripts, dashboard links, and "field notes" (documentation) to a GitHub repo.
The natural world is full of wonder, but it’s also full of data. You have until 3:30pm to capture it. Let's make this centenary one to remember!