Intermediate

Introduction Welcome back to Workout Wednesday! This week, we’re shining a spotlight on an incredible solution shared by community member Valerie Junk. It’s always inspiring to see how ideas ripple through the community—Valerie’s post was sparked by none other than Nikola Ilic, a powerhouse of creativity and insight in our space. I’m continuing my theme of community gratitude, …

2024 Week 51 | Power BI: Highlight Data with a Slicer by Valerie Junk Read More

Introduction Welcome back to Workout Wednesday! I’ve been getting so much of my inspiration from the community lately, and this week’s challenge is no exception! Recently, Andy Kriebel posted a cool calendar filter on LinkedIn, that he built using Tableau. Our very own guest contributor and friend Erik Svensen took Andy’s post and re-created it …

2024 Week 48 | Power BI: Use a Calendar as a Filter Read More

Introduction Utilising the dataset from a previous challenge (week 43), this week we are going to build a bubble likert chart. Likerts are usually ordered categorical data, and often it does not make sense to convert categories to a numerical  score to find averages. Sometimes, likerts can be treated as interval data. https://www.scribbr.com/methodology/likert-scale/. For the …

2024 Week 46 | Power BI: Likert Bubble Read More

Introduction Scatterplots are one of the most useful visual chart types for data exploration. You can use them to identify relationships among two or more variables, find clusters of data, encode data in several ways for communicating insights etc. This is especially useful when working with large datasets. In this WoW challenge, our goal is to use marker …

2024 Week 42 | Power BI: Scatter Plot Dynamic Colour Density Read More

Introduction Welcome back to Workout Wednesday. This week we’re extending the #FabConEurope edition of Workout Wednesday. We’re hosting a contest and three winners will receive a 30-minute one-on-one mentoring session with one of the three Workout Wednesday hosts. For more information on how to enter, see contest details below. Requirements   Get and transform data Get …

2024 Week 40 | Power BI: #FabConEurope Edition – Contest Deadline Extended! Read More

Introduction Welcome back to Workout Wednesday. This week we’ve got a special #FabCon Edition of Workout Wednesday. We’re hosting a contest and three winners will receive a 30-minute one-on-one mentoring session with one of the three Workout Wednesday hosts. For more information on how to enter, see contest details below. Requirements   Get and transform data Get …

2024 Week 39 | Power BI: #FabConEurope Edition Read More

Introduction Ternary plots are a unique plot that is typically used to look at the mineral composition of rocks. However these plots have been adapted in data journalism for looking at voting intention in varying demographics. Each point on the plot comprises a percentage of each dimension e.g of the 65+ age demographic, 16% of …

2024 Week 38 | Power BI: Ternary Plot Read More

Introduction In honor of the Power BI Desktop dark mode being scheduled for public preview this month, we are making a report that allows you to switch between light mode and dark mode.  Requirements Get the data from Data.World.  Filter the report to the year 2024. Create a card that shows current year sales. Create …

2024 Week 37 | Power BI: Create a Report with Light and Dark Mode Read More

Introduction Welcome back to Workout Wednesday. This week we’re taking inspiration from the incredible infographics team over at the New York Times. Their 2015 article looks at the average American’s contribution to the drought in California. As of today (Sep 2024), about a third of California remains abnormally dry. This challenge features some fun data work …

2024 Week 36 | Power BI: Recreate a NYT Interactive Article Read More