Sales vs Forecast | Dashboard
This dashboard was developed as part of an interview assessment to compare actual sales against forecast across Americas, EMEA and Asia. The solution used SQL Server for data ingestion, staging, cleaning, standardization and reporting views, followed by Power BI and DAX measures for KPI calculation and interactive analysis. A key insight was that actual sales exceeded forecast across the analyzed years, while approximately 7% of sales records had no matching forecast and require further business review. eyJrIjoiYmUzMTNkNTQtMmQzMC00M2U0LWE2MmItMzgzMDBiOTIzYWZlIiwidCI6ImI0MzBjNjVhLTlmY2ItNGQ4Yi1hNDU4LTBhNzJhYTI0YzQzMyJ9
Beyond the Box Office: The Anatomy of Movie Success
Beyond the Box Office explores what really makes a movie successful. Through financial performance, audience response, market popularity, and production factors, this report reveals that success cannot be defined by a single metric. Each perspective tells a different part of the story—highlighting the importance of balanced, responsible data-driven analysis.
Workout Wednesday 2026 Week 25 - Sales Difference
Here is my submission for the Data Days QuickViz - Workout Wednesday Remix (2026 Week 25). Challenge: Diverging Bar Chart showing sales differences compared to the selected sub-category. Features Built: Custom DAX measure for sales variance, dynamic labels with (+) and ( - )formatting, and custom color rules. QuickViz Challenges | Fabric Data Days Workout Wednesday 2021 | Week 6 - Long Labels 2026 Week 25 | Power BI: Find the difference from a selected value / Power BI, Workout Wednesday / By Meagan Longoria Introduction, We have a new contributor to WoW for Power BI, Robbin Vernooij.
THE LEGO BIG BANG
🧱 THE LEGO BIG BANG — A Data Story in Four Chapters In 1949, LEGO released 1 set. Today it exceeds 1,000 per year. This report tells the story of that explosive growth through four chapters: Chapter 1 — The Beginning: The scale of the LEGO universe today (27,000+ sets, 251 colors, 62K parts, 17K minifigures) Chapter 2 — The Growth: How annual releases grew exponentially, and how sets got bigger decade by decade Chapter 3 — The Catalyst: Licensed themes (Star Wars, Harry Potter, Marvel) rewired LEGO from "toy" to "platform" Chapter 4 — The Universe Today: The biggest sets ever made (World Map: 12,107 parts), and how color diversity expanded alongside complexity KEY TAKEAWAY: LEGO's growth is exponential, not linear — and licensed franchises were the catalyst that transformed a simple brick into an infinite creative universe. Design: Book/storybook theme with narrative-first layout. Each page reads like a chapter, with text guiding the audience through the data. Source: Rebrickable LEGO Database (rebrickable.com)
Brick by Brick: From Simple Bricks to Endless Worlds
Brick by Brick: From Simple Bricks to Endless Worlds explores how LEGO evolved through decades of innovation. Using the Rebrickable LEGO Database, this report examines how themes shaped the LEGO universe, how set complexity increased over time, how parts and colors define creativity, and how iconic minifigures became recognizable across generations. The report is structured as an interactive story across five chapters: • Home • Themes • Sets Overview • Parts & Colors • Collectors Key Takeaway: LEGO's growth has been driven by increasing complexity, evolving themes, specialized parts, and iconic characters that transformed simple bricks into a global creative universe. Source: Rebrickable LEGO Database (rebrickable.com)
Brick by Brick: The Evolution of LEGO Universe
🧱 Brick by Brick: The Evolution of LEGO Universe This Power BI report transforms the Rebrickable LEGO Database into a story-driven data visualization experience. The report explores how LEGO has evolved over decades by analyzing: • Growth of LEGO sets over time • Evolution of official LEGO colors • Most popular LEGO themes • Diversity of LEGO minifigures The report follows a storytelling approach across five pages: 📊 Overview 🎨 Color Universe 🧱 Theme Insights 🧍 Minifigures 📖 Final Story Key Takeaway: LEGO has grown into one of the world's largest creative ecosystems with over 27,000 sets, 275 official colors, and nearly 17,000 unique minifigures, showcasing decades of creativity, innovation, and imagination. Source: Rebrickable LEGO Database (rebrickable.com) Built using Microsoft Power BI Desktop. Thank you to the Power BI Community and Rebrickable for providing this exciting storytelling challenge. eyJrIjoiMzJlNjA2NjQtZWI2Mi00ZWY5LTkyMDItNWEyYjhlMTRjMTQ4IiwidCI6IjNlMTI1NDQ5LWI1ODYtNGU4ZS1iYzdmLWM1ZThlOWY3ZjkwNyJ9The Evolution of LEGO: One Brick at a Time
The Evolution of LEGO: One Brick at a Time is a data storytelling report built using the Rebrickable LEGO dataset. Through four interactive dashboard pages, the report explores LEGO's journey from simple construction toys to a diverse collection of highly detailed and innovative building experiences. The report highlights the growth of LEGO sets, themes, parts, and colors over time, compares popularity with build complexity across themes, examines how colors and commonly used parts contribute to modern LEGO designs, and showcases the evolution of iconic themes such as Star Wars and Technic alongside the introduction of new themes over the decades. Designed with a LEGO-inspired visual identity, each page features a distinct color theme while maintaining consistent layouts, typography, and storytelling elements. The result is an engaging, visually appealing dashboard that transforms historical LEGO data into meaningful insights for both LEGO enthusiasts and the data visualization community.When LEGO Grew Up: A Brand That Grew With Its Fans Mostrar mais linhas
As LEGO fans grew up, LEGO grew with them. This report explores how LEGO evolved from simple building toys into immersive worlds, creative challenges, and lifelong passions. The story begins with the increasing complexity of LEGO sets, followed by the growth in scale of modern builds. It then explores the rise of iconic franchises such as Star Wars, Harry Potter, Marvel, and Minecraft, showing how LEGO shifted from selling products to creating worlds and stories. The analysis also highlights how LEGO expanded beyond children, becoming a hobby, passion, and creative outlet for adult builders and collectors. Rather than focusing on rankings or individual sets, this report tells a broader story about the relationship between a brand and its community. Key insights include: • LEGO sets became increasingly complex over time. • Modern LEGO builds are significantly larger than early sets. • LEGO evolved from building sets to immersive story worlds. • Adult builders became an important part of the LEGO ecosystem. • LEGO evolved alongside the generations that loved it. Ultimately, this report demonstrates that LEGO did not simply become bigger. It became a lifelong experience. LEGO didn't grow up. We grew together. eyJrIjoiYTFiNDgzYzMtZTFjNS00M2Y4LTg3ZWMtMmI0NzIyZGUzNzE1IiwidCI6ImJmZTc5Yzg1LTIxMmYtNDk0YS1hOGRkLTFjYTY5NmFiYjcwOSJ9
World Champs BCN 2026 - Round 2
Report Summary This report explores the evolution of LEGO over the decades through a data storytelling approach using the Rebrickable LEGO Database. Rather than focusing solely on descriptive statistics, the analysis uncovers how LEGO has transformed its product portfolio, design philosophy, and customer experience. The report examines five key themes: The Evolution of LEGO – Traces LEGO's growth in the number of sets released over time and highlights major milestones in its history. The Licensed Revolution – Demonstrates how partnerships with franchises such as Star Wars, Harry Potter, Marvel, and Disney reshaped LEGO's product strategy and became a significant driver of new releases. Bigger Isn't Everything – Explores the increasing complexity of LEGO sets while showing that small- and medium-sized builds continue to form the foundation of LEGO's portfolio. A World in Color – Investigates how LEGO's expanding color palette enabled more realistic designs, greater creativity, and increasingly diverse themes. Characters Bring LEGO to Life – Highlights the growing importance of minifigures in creating immersive, story-driven building experiences and strengthening the appeal of licensed themes. Each page combines interactive visualizations, concise insights, and clear key takeaways to communicate meaningful patterns that are accessible to both LEGO enthusiasts and general audiences. The report concludes that LEGO's enduring success comes from balancing innovation with accessibility—embracing licensed franchises, richer designs, and collectible characters while continuing to offer products for builders of all ages. Data Source: Rebrickable LEGO Database Visualization Tool: Microsoft Power BI
