Week 4 - Together for Life: A Story of Global Awareness
Hello, beautiful community! 🌎 I decided to create this report because, in my experience, I have seen a wide variety of reports that we develop for our organizations or clients, but very few that provide value to all of us outside the business world.Rarely do we create reports that help us reflect on how we can act in favor of our society and the beings that inhabit it. For this reason, the main objective of this report is to raise awareness about the situation of other living beings that have no voice but are part of our world. In this work, I present an overview of their history, their current situation, key findings, and possible solutions.Personally, this project has been a great challenge. Designing reports in Power BI is something that many of us can do, but designing them for a different audience than usual represents a completely different challenge. This led me to explore other areas of knowledge, such as the accessibility principles of the WCAG. It took several days to create, but time becomes imperceptible when you work on something with passion ❤️ and with the certainty that it can help many people or, at the very least, convey a message of empathy.Moreover, I believe that accessibility and inclusivity are closely related. That’s why this report is available in three languages: English, Chinese Mandarin, and, of course, my native language, Spanish. I hope you like it! Best, Fernando eyJrIjoiNmU4MjRiNWMtNjdjMy00NjFiLWEzYjgtOTZjMjliOGE3ZTllIiwidCI6ImIyZjVmMjA1LTViMDItNDM3Mi1hNWUwLTc3Mjg5NmZhODZmNyIsImMiOjR9World Champion Winner - The world of peaches by Gus Bavia
🏆 2026 Power BI Dataviz World Championship ( Winner ) A global analysis of peach production and international trade using FAOSTAT data, covering production volumes, harvested area, yield efficiency, export/import values and trade balance across 79 countries. Design System Built around a custom design system: a unified set of tokens governing typography, color palette, spacing, border radius, and component behavior. Every button, card, badge, tooltip, and navigation element follows the same visual rules across all four pages. Original Imagery: All visuals are original. Backgrounds were AI-generated and art-directed to match the warm, earthy color language. Video transitions were authored, animated, rendered and self-hosted. No stock footage, no templates. Crafted from scratch. Custom Visuals: combined with custom HTML/SVG measures: hero KPI cards with contextual overlays, animated trend charts, waffle charts, and interactive donut breakdowns. Every custom element complements native functionality. Accessibility: Alt text on all visuals, logical tab order, WCAG-compliant contrast ratios, and guided tutorials on every page. This project pushed the boundaries of what I thought was possible inside Power BI. Visa complications, a microphone failure live on stage at FabCon, and the constant pressure of the clock... but every constraint sharpened the focus on what mattered most: delivering the best possible experience. Beyond the competition, the real reward is in the craft. I hope you enjoy exploring this dashboard as much as I enjoyed building it. Feedback and suggestions are always welcome. Cheers, Gus 🍑 eyJrIjoiODNlMjZiZWMtOTcxMS00NDI3LTk3MjQtZTY4ZWY4MDEyMTNmIiwidCI6IjlkOWJiNDE4LTAyY2EtNDFiZC05YTRkLTEwOGE5NmIxM2JmZCJ9Europe in Motion: A Dynamic Portrait of How Regions Balance Social and Environmental Dimensions
This report offers valuable insights for data analysts, data journalists, and anyone interested in understanding regional dynamics in Europe through three key dimensions. It enables users to explore patterns, contrasts, and trade-offs across countries and regions using interactive visualizations, filters, and comparisons. The structure supports both high-level overviews and detailed, indicator-specific analysis, making it a powerful tool for storytelling, policy evaluation, and data-driven exploration. Overview - The overview page presents a line chart of population growth from 2004 to 2023, a bar chart comparing regional performance across three dimensions, and a map dividing Europe into four regions, offering a dynamic visual summary of continental trends. Reading Between the Regions - The page features dynamic cards that act as context switchers for key indicators, each linked to native charts that highlight maximum and minimum values. A line chart compares regional trends over time against the European average, adapting dynamically when filters are applied. A DAX-powered bar chart ranks countries by performance. Below, a dynamic summary highlights key insights based on the selected context. Constrasts - This page presents a dynamic scatter plot that allows users to explore how regions balance their priorities based on selected indicators. Axes and bubble sizes are fully customizable, enabling comparative analysis across dimensions. A side panel summarizes the top three most balanced countries per region, based on the selected metrics. Head-to-Head: Countries - This page enables a straightforward comparison between two countries across three dimensions using independent filters. A central chart highlights which country performs better in each indicator. Despite its simple visual layout, the page integrates detailed logic and dynamic calculations to deliver accurate, context-aware results. eyJrIjoiODQwZDVmODMtNTRlOC00ZjI4LTliZmYtOGEwNDk4OWJkNjhiIiwidCI6IjE2Njk5MjVkLTJlNTItNDMzZC1hM2U1LTQwNGEzYWU5ZTZhNiJ9
Winner of Week 2 | Visit the US National Parks 🦅
Hello again Fabric Community and Judges! I am personally interested in this dashboard because my girlfriend and I have a goal to visit all the National Parks in the US. We've visited 8 of the 63 total National Parks so far and this dashboard was really eye opening and expanded my appreciation of the parks. To my delight, I found a dataset from the National Parks Service that tracks visitor data for all the parks all the way back to 1979, in which every park began reporting monthly statistics. The data quality is *chefs kiss* immaculate. This is the source for the NPS data. https://www.nps.gov/subjects/socialscience/visitor-use-statistics-dashboard.htm The query builder lets you choose the fields and time frames for the export. I combined this data with images and descriptions scraped from wikipedia: https://en.wikipedia.org/wiki/List_of_national_parks_of_the_United_States Data collection & presentation The data from the parks service is in .csv format. I wrote a short python script to scrape and clean the park descriptions and preview images from Wikipedia. All visuals are core Power BI visuals. I chose visuals that I personally felt would be helpful in understanding the visitation trends and popularity of the parks and included a helpful guide that suggests a National Park to visit based on certain criteria. Design choices For the report JSON theme file, I used natural tones with and earthy and organic feel to reflect the tones found in outdoor landscapes. Natioanl Parks have a rich history and are meant to be preserved for generations, so I avoided trendy colors to make it more timeless and appropriate. Accesibility Tab order and alt text was set in Power BI, and I ensured the dashboard passed multiple accessibility test by using the free browser plugin Skilltide. Land recognition It’s important to acknowledge that these parks exist on the ancestral lands of Indigenous peoples who have lived, traveled, and cared for them for thousands of years. Many of the places we visit today hold deep cultural and spiritual significance, and Indigenous communities continue to have lasting connections to these landscapes. We recognize the original stewards of these lands and the importance of preserving their histories, stories, and ongoing contributions to conservation. Jon Sandmann 🏔️ eyJrIjoiNzI3ZTJmNWItNTM1OS00ZWNhLTk1ZGItZmZlODdiM2ZjNzYwIiwidCI6Ijk2ODYwODk5LWFhODMtNGRiNy1hNzFiLTJhYTI5NmMyODIzNSIsImMiOjJ9Winning Report - World Champion - OECD Global Well-being
This report dives into the OECD Global well-being data. For my report I chose to focus on 3 key domains of well-being and present 3 measures for each domain. Each measure shows the global average with a dynamic, color coordinated SVG progress bar. Below the progress bar is the trend by year that uses anomaly detection to find possible explanations for deviations from expected values. Each section has a table that displays the observed values for each country, sorted highest to lowest. Selecting a country will cross-filter the svg and the trend to the chosen country. Users can select the domain button at the top to enable a sleek dropdown that allows for changing the domain. Each domain has a dynamic background color and accent image. The titles and subtitles of the page and the visuals are dynamic as well with the subtitle color changing to compliment the background color. On page 2, I focused on key areas of gender disparity to show the gaps between averages across countries for males and females. These charts use the small multiples feature and also have dynamic titles and subtitles to better explain the disparity. Thank you to the organizers and judges and a big thank you to my fellow competitors who made it such a stiff competition. Until next year! Jon Sandmann eyJrIjoiMWM5MTEyNzEtMGZkYy00YWIyLThiYjUtNzRiYzlhNWVmZjRlIiwidCI6Ijk2ODYwODk5LWFhODMtNGRiNy1hNzFiLTJhYTI5NmMyODIzNSIsImMiOjJ9World 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. eyJrIjoiNjFlNDFmNDMtYzc2My00YjYwLWI5MTItODU3OWQ1ZTg5MjAxIiwidCI6IjE2Njk5MjVkLTJlNTItNDMzZC1hM2U1LTQwNGEzYWU5ZTZhNiJ9The Tale of Genji - visualising Japanese most famous romantic literature
The Tale of Genji Project Background Hikaru Genji (光源氏) is the mesmerizing protagonist of “The Tale of Genji,” a timeless masterpiece of Japanese literature penned by Murasaki Shikibu during the Heian era (AD 1008). As the emperor's illustrious son, Genji enchanted many with his radiant beauty and captivating charm. His legacy endures as the most celebrated and adored figure in Japanese literary history. I have visualized his myriad—though most illustrious—affairs and relationships, employing diverse criteria. It's essential to acknowledge that numerous other relationships and affairs are not encompassed in my data. My aim was to celebrate and share the richness of Japan's ancient culture and literature through my data visualization. This project has been a deeply enjoyable endeavor for me. Data Collection I sourced my data primarily from a Japanese website, Genji Biyori. This site provided abundant valuable information about “The Tale of Genji,” and it inspired me to gather data from it. https://ryoutei-senryu.jp/ I also utilized Copilot to describe each princess' appearance, allowing the audience to visualize each individual more vividly. Visuals The choice of visuals was straightforward; I gravitate towards simple and basic visuals for presenting data. This approach enhances audience comprehension more effectively than sophisticated visuals. Background Design I crafted the Canvas background in PowerPoint, leveraging its graphic design tools. This method proved highly effective, and I saved the background as an SVG file before importing it into Power BI. Theme I meticulously crafted the Power BI Theme using traditional Japanese colors to enhance the cultural aesthetic for the audience. I sourced the color codes from the Nippon Colors website: https://nipponcolors.com/ Accessibility In my journey to enhance report design with accessibility in mind, I delved into the PL-300 course, which provided invaluable insights. My goal was to consistently incorporate accessibility principles into my report designs. Choosing between a completely “Accessible Colour Theme” and retaining elements of Japanese culture in the colour palette was a challenging decision. Ultimately, I opted for the latter, striking a balance between accessibility and cultural authenticity. As someone who is partially colour blind, I made a conscious effort to use more contrasting colours to ensure clarity and readability. Throughout this project, I learned how to effectively use “Alt Text” and “Tab Order” to make content more accessible. These techniques are something I intend to employ in my future work. Description of each tab 思ひ人（Omoibito） - Lover I analyzed the collected data based on three different criteria: Affair/relationship category Frequency of meetings Frequency of communication Each criterion is examined through the lens of remarkable versus unremarkable romances. Upon analysis, the data reveals that Genji was quite the romantic, despite his numerous relationships and affairs. 五色（Goshiki） - Diversity I explored the collected data concerning diversity and inclusion, focusing on three criteria: Social class Age Appearance The findings show that Genji was quite open to women of various backgrounds. However, it is noteworthy that he was perpetually drawn to the memory of Fujitsubo, his beautiful stepmother and first love. 年（Toshi） - Age I scrutinized the collected data using two criteria: Genji’s age and the number of his affairs/relationships The ages of Genji and his princesses at the time of their meetings or relationships Interestingly, Genji’s romantic peak occurred in his late teens, which seems early. But considering the average lifespan of that era, it is understandable that he had many affairs and relationships during his late teens and twenties. 地（Chi） - Location I visualized the locations where Genji met his princesses on a map. He encountered most of them within Kyoto and its suburbs. The table to the right shows the locations alongside the princesses’ names. By expanding a location name, you will reveal the corresponding princesses. Clicking on a princess’s name will filter the map accordingly. 恋ふ（Kou） - Fall in Love with I wished to use hand-drawn pictures of each princess, but due to copyright issues, I settled on a summary table instead. The numbers on the left represent the order in which Genji had affairs or relationships with the princesses. Further information about The Tale of Genji If you are interested in The Tale of Genji and Heian era this video on YouTube is interesting to watch. The Tale of Genji: Elegance That Transcends the Ages - Core Kyoto - YouTube eyJrIjoiNWQ2ZWEyZGUtNDE5My00NzBkLWJkZDUtOTFjMzQzYTRhNmRlIiwidCI6IjBhMTE3Yjc1LTVhYTktNDdlMS1hYjNmLTFiNzU2ODA5MGMxNCJ9Week 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=d3fdc3376804a8422f84
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 eyJrIjoiZDBkNTFjNGEtNzJjZi00N2EwLTk5OGMtN2EyZGRkODA3YjRhIiwidCI6ImU4NTg1Zjg3LTQ0MmUtNDk1ZS1hMGRiLWQ3YzM2MDA1ODUxZCIsImMiOjJ9
