Week 1: Briarport's Urban Performance Through an Executive Sustainability Lens
A comprehensive analysis of urban livability across 12 cities between 2015 and 2024, examining Livability Index, Housing Affordability, Transit Quality, Green Space, and Emissions. Built on principles of visual clarity and cognitive efficiency, the design presents sophisticated analytics through a clean, minimalist approach. The interface prioritizes information hierarchy over decoration, using strategic whitespace and monochromatic color schemes to maintain executive-level professionalism while ensuring accessibility compliance. Key features include a contextual alert system, where a notification bell icon surfaces important insights without page navigation, keeping users in their analytical flow, as well as guided tutorials on each page that explain metrics, interactions, and analytical focus areas. Accessibility compliance is addressed through alt text on all visuals, logical tab order, and WCAG-compliant color contrast ratios. Native Power BI charts such as bars, lines, and tables are combined with custom HTML and SVG sparklines and performance cards only where they add analytical value. Semantic accuracy is ensured through proper handling of inverted metrics, such as Affordability and Emissions where lower values indicate better performance, with correct color coding and trend indicators. The report is structured across four pages: an Executive Summary with single metric analysis, year trends, and city comparison; a Performance view featuring a radar chart showing multi-dimensional performance with sparkline cards; a Rankings page with five bar charts comparing cities across all metrics with ranking positions; and a Temporal Analysis presenting trend lines for each metric alongside performance summary cards. Rather than overwhelming users with dashboard complexity, this solution practices deliberate visual restraint, where every chart, card, and interaction serves a clear analytical purpose. Guided tutorials and accessibility features demonstrate that powerful analytics and inclusive design are complementary rather than competing priorities. Custom visuals are used to complement native functionality, demonstrating that innovation lies in thoughtful execution and integration rather than technical novelty alone. This dashboard meets competition requirements while delivering a cohesive analytical experience that respects both the data narrative and the users cognitive capacity. Beyond competition, the real satisfaction lies in the craft itself. I hope you enjoy exploring this dashboard as much as I enjoyed building it, and feedback, suggestions, and constructive criticism are always welcome. Cheers, Gus eyJrIjoiNzMwYmRiZjgtOWM4Yy00ZTFmLTgxNWUtMjRkZWM0YjZiMmRjIiwidCI6IjlkOWJiNDE4LTAyY2EtNDFiZC05YTRkLTEwOGE5NmIxM2JmZCJ9
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)
Week 1: Briarport Benchmark Report
Hi Everyone, The core visual in this dashboard compares Briarport with other cities in Rivermere across key city planning categories. The goal was to make it interactive, allowing users to explore the data, compare regions, and follow trends in a way that feels intuitive and engaging. On the second page, the trend analysis displays Briarport alongside other cities, allowing for filtering by region. This makes it easier to spot patterns and compare performance without overcrowding the visuals or losing context. Finally, I added a short recommendations/insight section highlighting strengths, weaknesses, and opportunities based on my analysis, along with a ranking. This page is designed to be static to give city planners, policy analysts, and community stakeholders a quick yet meaningful snapshot for their discussions. My Approach - Everything was done on Power BI Desktop. I preferred using default visuals to not make it design-heavy, and rather focus on usability. To avoid overwhelming users with excessive data, I ensured that the data was presented intentionally. For example, the summary page allows year-based trend filtering only for Briarport, keeping the focus clear. The second page is where users can deep dive into time-series analysis and cross-city comparisons. Navigation is simple, with alt text and tab order added to support accessibility. Overall, the aim was to maintain a balance between insight, design, and effectiveness.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
The LEGO Paradox: More Bricks ≠ More Complexity
I have created the Power BI Report for Power BI Dataviz World Champs Round 2: Brick by Brick. Most people assume that bigger LEGO sets are automatically more complex. This report challenges that idea using the Rebrickable LEGO Database. Through set comparisons, theme patterns, reusable parts, and decade-level trends, the story shows that LEGO’s true complexity comes from a balance of repetition, unique part designs, colors, and characters - not just the number of bricks in the box.
Week 2: Climate Change - Unequal Responsibility, Shared Impact
The Narrative: From Human Habit to Planetary Impact This report tracks the journey from how we live (individual emissions) to what we have built (historical legacy), ending with the physical bill the planet is currently paying. The narrative structure moves from individual carbon intensity (per capita) to the cumulative historical burden, concluding with the observable impact on the global climate system. The Challenge: Making a Logical Jump The biggest challenge was connecting the dots between two very different types of data. Chapters 1 and 2 look at specific countries and regions, while Chapter 3 looks at the planet as a whole. To make this transition work, the report shifts from looking at where emissions happen to what they eventually do to the Earth. It frames the global temperature and sea level changes as the combined physical "receipt" for all that regional activity we looked at earlier. Chapter 1 - The Current State. This chapter uses a world map to visualize the wide range in per capita CO₂ emissions across nations. Chapter 2 - The Trajectory. A line chart and a continental heatmap track 174 years of emission shifts, capturing how regional trajectories have diverged over time, from the Early Industrial Era to the Paris Agreement. Chapter 3 - The Collective Impact. This final section shifts to planetary outcomes, using a 10-year lag and 0-100 normalization to align temperature anomalies with rising sea levels. Technical Notes 0–100 Normalization: Comparing degrees Celsius directly to millimeters is not mathematically sound. Normalization was used to rescale both variables to a 0–100 range, allowing for a precise visual comparison of their relative trajectories and rates of change over the 174-year timeline. 10-Year Temporal Lag: A 10-year lag was applied to the sea level data to account for the physical response time of the climate system. This adjustment aligns the atmospheric "cause" with the oceanic "effect" on a shared horizontal axis, making the coupled relationship between the two indicators visible. *Please note this entry has been previously submitted via a wrong email address. This is my official entry.Hospital Report
📊 Hospital Patient Analytics Dashboard – Feedback Welcome! Hello everyone, I recently completed a Hospital Patient Analytics Dashboard project using Power BI as part of my data analytics learning journey. Key highlights: • Analyzed 4,000+ patient records • Built interactive dashboards and KPI visualizations • Tracked patient admissions, discharge trends, and treatment metrics • Created data-driven insights to support healthcare decision-making Tools Used: • Power BI • Excel • Data Analysis • Data Visualization I would appreciate any feedback on dashboard design, KPI selection, visualization best practices, and areas for improvement. I'm also interested in learning how industry professionals would enhance a healthcare analytics dashboard like this. Thank you!Week 3: 126 Years, 3 Stories.
About This Report This report explores over 125 years of Olympic Games history (1896–2022), surfacing non-obvious insights into medal dominance, Winter Games exclusivity, geopolitical shifts, and the strategies that define Olympic success. Primary Data Source Kaggle Olympic Summer & Winter Games dataset modified by Stéphane Bruno 162,000+ competition results across 53 Olympic Games 75,900 unique athletes, 238 countries, 86 disciplines License: CC BY-NC-SA 4.0 Supplemental Data Sources World Bank Population Data (SP.POP.TOTL indicator, CC BY 4.0) 204 countries with 2022 population figures Enables per-capita medal analysis — reframing Olympic dominance entirely e.g., Norway earns 104 medals per million people vs. the USA's 8.9 Milan-Cortina 2026 Winter Olympics Event List (Wikipedia, CC BY-SA 3.0) ~116 medal events across 16 disciplines Includes new events: Ski Mountaineering, Women's Large Hill, Mixed Team Skeleton, and more Connects historical trends to the upcoming Games eyJrIjoiNDEyNjEzZGYtMjU3ZS00Yzg2LTk3NGQtYjI3NTAwMzQ1ZWZhIiwidCI6IjM0YTk4Yzk0LWI1M2MtNGU0My1iNzlkLWUxMGNhYjIwYWY5NiIsImMiOjl9PitchSide Pro - Executive Growth & Commercial Efficiency Dashboard
This Power BI report analyzes PitchSide Pro’s commercial performance and translates revenue, funnel quality, category growth, and execution priorities into an executive decision journey. The dashboard is structured across five pages: 1. Revenue Momentum An executive overview of revenue performance, YoY growth, net margin, sales, average ticket, and the key drivers behind the current business momentum. 2. Revenue Drivers A dynamic analysis by Axis and Metric, allowing users to switch between Channel, Macroregion, Country, Product, and Customer views to understand where growth is created or lost. 3. Funnel Quality A commercial efficiency view showing how traffic moves from sessions to cart and conversion, highlighting bounce risk, revenue per session, and efficiency scores by macroregion or selected axis. 4. Growth Opportunities A category and product opportunity view that combines revenue, YoY growth, net margin, conversion, ticket, and incremental potential to identify where the business should scale next. 5. Executive Action Plan A prioritization layer that translates insights into action, using an impact x effort matrix, macroregion focus, 90-day roadmap, risks, and expected business impact. The report uses native Power BI visuals for the core analysis, supported by custom HTML cards, tooltips, narrative panels, and executive summaries to improve storytelling and decision clarity. Key features: - Dynamic Axis and Metric selectors - Executive KPI cards with contextual insights - Funnel efficiency scoring - Growth x margin opportunity matrix - Impact x effort prioritization - 90-day execution roadmap - Consistent sports retail visual theme This dashboard is designed for executive decision-making: where to focus, what to fix, and how to scale growth with commercial discipline. slindsay eyJrIjoiNDIzMjNmNGMtYjdiYi00Y2Y0LTljODMtM2RkMGQ4MTQ4ODAxIiwidCI6IjMxYzJjZDk3LWE3MGItNDgwYy1iZTM1LTBhMGRiMzgwZTNlNCJ9
PitchSide Pro: Executive Football Commerce & Retail Analytics Hub
Project Overview PitchSide Pro is an end-to-end executive retail intelligence solution built for modern football commerce businesses. The system integrates cross-functional telemetry across financial performance, product hierarchies, digital conversion funnels, and brand equity pricing power to provide C-level executives with unified, actionable insights. Comprehensive Page-by-Page Breakdown 1. Executive Financial Pulse (Page 1) Objective: Acts as the strategic control center, mapping macroeconomic commercial velocity. Key Visuals & Metrics: Houses premier KPIs including Total Net Revenue ($11.2M), Total Profit ($5.93M), and an elite Profit Margin of 52.81%. Advanced Analytics: Features localized geo-spatial matrices mapping Tier-based market performance, revealing that Tier 1 Markets (led by the United Kingdom) stand as the core engine driving over 18.53% of global profits. It tracks seasonal trends, showing peak convergence in August ($1.15M) and identifying structural winter dips. 2. Product & Merchandise Sales Core (Page 2) Objective: Drills deep into the unit economics of inventory and merchandise performance. Key Visuals & Metrics: Monitors granular unit metrics like Total Units Sold (153.77K), Home Kit Revenue ($1.64M), and Total Promotional Discounts Given ($279.54K). Advanced Analytics: Implements an interactive Decomposition Tree to dissect revenue pipelines from top-tier Categories down to individual product-level skus. It tracks promotional impacts by customer profiles, identifying that "Casual Fans" drive 55.3% of Home Kit revenues, while "Hardcore Fans" and "Collectors" maintain stronger baseline pricing power. 3. Digital Funnel & Channel Velocity (Page 3) Objective: Evaluates user experience efficiency and friction points across the online purchasing journey. Key Visuals & Metrics: Analyzes high-level e-commerce funnels covering 9M Total Sessions, Add-To-Cart Rates (14.91%), and Global Conversion Rates (3.24%). Advanced Analytics: Features a multi-channel funnel analysis highlighting severe drop-offs (78.26% Cart Abandonment Rate). Integrates Power BI's AI Key Influencers visual, mathematically proving that Mobile App channels optimize the conversion rate by a lift factor of +0.45% compared to baseline web channels. 4. Executive Brand Equity & Pricing Strategy (Page 4) Objective: Audits product pricing elasticity and discount degradation across specific tournament windows and campaigns. Key Visuals & Metrics: Displays an elite, multi-layered matrix breaking down ASP, Price Realization %, and Discount Impacts by major Product Lines and Moment Labels. Advanced Analytics: Employs precise conditional formatting and heat-mapping to isolate the brand lines. It uncovers that AeroKick serves as the supreme profit anchor ($2.16M profit), while highlighting critical margin bleeds in PitchSide Elite during "Holiday & Gifting" due to high promotional impacts (6.78%).
