Week 2 | Tourism in the UK: Office of National Statistics
This week's report is from the UK's very own Office of National Statistics. I wanted to show some of the amazing things Power BI can do - from shape maps to the rarely used treemap (does this count as a horizontal Mikko chart maybe?) to enhanced data labels and even some overlapping columns. I wanted the design to be intuitive - the user starts by looking at a regional comparison, and they can drill down by hovering on any of the cards to a specific region - and seeing which countries send them the most visitors - by spending, nights spent, or by # of visits. I'm also very proud of the vertical SVG you can see in the Matrix in the details tab - this is an SVG I made for this entry. It combines each SVG from each row to create a cohesive visual inside the matrix. Hope you like this one! Data Source: Office for National Statistics. (n.d.). Overseas travel and tourism: Quarterly estimates of overseas residents’ visits and spending [Data set]. Retrieved February 22, 2025, from https://www.ons.gov.uk/peoplepopulationandcommunity/leisureandtourism/datasets/overseastravelandtourism Topojson file used for Shape Map: https://github.com/ONSvisual/topojson_boundaries/blob/master/geogUKregion.json eyJrIjoiNzU3YmNhZTAtMzlmZS00ZDY4LTg3NjktNzhhZTU3YTAzYzBhIiwidCI6IjM0YTk4Yzk0LWI1M2MtNGU0My1iNzlkLWUxMGNhYjIwYWY5NiIsImMiOjl9&pageName=d3fdc3376804a8422f84World Champion Winner - Live Finale Build - Europe's Flavor Story
Europe's Flavor Story – A vivid painting os life across Coffee, Chocolate and Life Satisfaction The report is structured into two main pages, each designed to present data in a clear and interactive way. Page 1 - Home Page – Interactive Map Overview Displays a dynamic map of Europe, highlighting countries based on selected indicators. Users can filter by region (Eastern, Northern, Southern, Western) to explore specific areas. Color palettes adjust automatically based on the selected type of color blindness, ensuring accessibility. The introduction outlines the three key themes: coffee consumption, chocolate consumption, and life satisfaction. Page 2 – Main Page - Fully Responsive Visuals The entire page adapts to the selected parameter (Coffee, Chocolate, or Wellbeing). Each selection changes: The overall color scheme Titles and explanatory texts Tooltips and chart content Key indicators, such as average consumption and historical variation Charts and tables update to reflect the most relevant data for the chosen theme. The “Shifting Pulse” table presents a dynamic Top/Bottom N view, showing how countries have moved over time—highlighting which ones are gaining or losing relevance in the selected indicator. Interactivity as a Core Focus A key goal was to ensure the user could actively explore the data, not just read it. Every visual element responds to user input, creating a context-aware experience. Navigation is guided by simple interactions, with visuals that shift to match the selected topic. The intent is to bring the data to life, allowing users to observe patterns, compare regions, and follow trends in a way that feels intuitive and engaging. eyJrIjoiNjFlNDFmNDMtYzc2My00YjYwLWI5MTItODU3OWQ1ZTg5MjAxIiwidCI6IjE2Njk5MjVkLTJlNTItNDMzZC1hM2U1LTQwNGEzYWU5ZTZhNiJ9
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.
World Champs Finalist - Live Finale Build - Chocolate or Coffee?
Have you ever imagined creating a report from scratch in just 20 minutes, live on stage, in front of a large audience at a Microsoft conference event? That was exactly my experience with this report, presented as a finalist in the grand finale of the Power BI DataViz World Championships. I had the great honor of sharing the stage with three outstanding Power BI professionals (my deepest respect and admiration for them). The report is designed to provide an overview of coffee and chocolate statistics in terms of kilograms per capita available for human consumption, across different regions, many countries, and trends over time. You’ll also be able to explore key indicators and navigate through a timeline spanning more than 60 years of history. Thank you for visiting my report I truly hope you enjoyed it. Sincerely, Daniel Guevara eyJrIjoiZDBkNTFjNGEtNzJjZi00N2EwLTk5OGMtN2EyZGRkODA3YjRhIiwidCI6ImU4NTg1Zjg3LTQ0MmUtNDk1ZS1hMGRiLWQ3YzM2MDA1ODUxZCIsImMiOjJ9Week 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 eyJrIjoiNDEyNjEzZGYtMjU3ZS00Yzg2LTk3NGQtYjI3NTAwMzQ1ZWZhIiwidCI6IjM0YTk4Yzk0LWI1M2MtNGU0My1iNzlkLWUxMGNhYjIwYWY5NiIsImMiOjl9World Champs Finalist - Live Finale Build - A Coffee/Chocolate data story
Hi everyone, I’m excited to share my Power BI report created for the finals! The topic explores coffee and chocolate consumption across the world since the 1960s, with a special look at: Global trends over time – how coffee and chocolate consumption evolved. Regional contrasts – showing that producing countries are not always the biggest consumers. Nordic focus – where coffee culture meets life satisfaction (hello, Fika ☕). Final takeaway – it’s not just about the quantity consumed, but the quality of the moment shared. This report was designed with curious travelers, lifestyle enthusiasts, and everyday readers in mind, not statisticians. My goal was to keep it clear, engaging, and visually compelling while telling a story. eyJrIjoiYWVlYjhiMGMtYmU1NC00NzgyLThjN2MtMWUyNmQ5YjFhODc5IiwidCI6ImM1YTgxZjQ5LWVhYTEtNGQ5Yy1hNjg5LTg1NzJiMzgwMjlhNCJ9World Champs Finale Build - Feeling Peachy?
Page 1: Landing Page I always like starting with a landing page because it sets the tone. It gives users a quick idea of what to expect- there’s a title, a short description, a few key KPIs, and a navigation button to guide them into the report. Think of it as the “welcome screen” that gets you started. Page 2: Global Overview Here, we’re looking at peaches across the world. I start with three key KPIs: production, area harvested, and yield. And the order matters- First, what are we producing, then where are we growing, and finally how efficiently we’re doing it. Next, we have trend charts to quickly see how things have changed over time, along with a map-just a fun, visual way to explore the data. On the right, I’ve highlighted a few interesting insights: First, a dumbbell chart comparing production from 2010 to 2024. It clearly shows the shift over time and yes, China is way ahead, so there’s a slider to make comparisons easier. Then, a table looking at growth % and efficiency index. Some countries like Turkey and Uzbekistan show high growth, but surprisingly, their efficiency isn’t as high. So growth doesn’t always mean efficiency. And finally, a top 5 comparison based on growth and efficiency. One surprising insight- China doesn’t show up here, even though it’s a global leader. Instead, countries like Afghanistan stand out with high growth. Page 3 is where things get a bit more focused and fun. We zoom into the United States. At the top, we have a few KPIs and trends. One clear story: The area harvested is decreasing, and naturally, production is going down too. Possible reasons? Urbanization, rising labor costs, and competition. There’s also a ranking chart showing how the U.S. position has changed over time and you can clearly see the decline. Now comes my favorite part- I always believe a report should help you take action, not just show data. So I built a “comeback scenario” using what-if analysis. We have two sliders: area change % and yield improvement %. Right now, both are set to zero- which tells us that if nothing changes, the U.S. could drop to rank 11 in the next 5 years. But as you play around with the sliders, you can see how improvements can change the ranking. It’s not a prediction-but it’s a great starting point for thinking about what could be done. And a quick fun fact to end on. The most stressful but fruitful 20 minutes of my life indeed! My heart is happy and full of gratitude 🙂 eyJrIjoiZTQxZTZiZWItZWVkZi00Nzc0LTkyN2QtOWQzMDQ4NTRhNjMzIiwidCI6ImNhODc1ZjVhLTcwNmMtNDFmNS04YTczLWNlMTQ0ZjMxMDhlMyIsImMiOjF9Miniviz May - Week 4 Challenge - Where are the good vibes?
This week is all about maps - but not the kind that just sit there looking pretty. Use your map to show a pattern or difference across locations, not just where things are. For my example, I created a fictional dataset that assigns each country a dominant vibe. The goal isn’t accuracy - it’s to show how a single category can reveal something interesting across the world. This is the Shape Map visual, with an imported .json world map. Use the slicer to explore different vibes and see how the pattern shifts. A few tips: Keep it simple - one measure or category Limit your categories so it’s easy to read Make your map do the storytelling Have fun with it - this is a great week to get creative ✨ If you missed any of the other weeks, you can read about them at aka.ms/MinivizMayMiniviz May - Week 3 Challenge - What Matters Most?
This week we’re exploring one of the most revealing chart types: the treemap. We’re not just showing categories - we’re uncovering what actually takes over. 📊 Your challenge: Build a treemap that reveals where your time is really going - and what’s driving it. Check out the starter file and build your own tree map! You are welcome to use the data in the starter file or create your own. The key: keep it simple! Ensure your visual is accessible. Set tab order, alt text, and ensure proper color contrast. Have FUN! Need more info about the contest? Visit aka.ms/MinivizMayMiniviz May - Week 1 Challenge - What Changed?
1️⃣ Week 1 Challenge - now live! Let’s kick things off with one of the most important (and misunderstood) business metrics… headcount. This week, you’re not just showing a number - you’re telling the story behind how it changed. Your challenge: Build a waterfall chart that explains how headcount moved from Jan 1 → Mar 31 Check out the starter file and build your own waterfall chart! You are welcome to use the data in the starter file or create your own. The key: keep it simple! Need more info about the contest? Visit aka.ms/MinivizMay
