Introduction This week for Workout Wednesday we will be trying our hand at non-linear regression with the Deneb custom visual. With Vega and Vega-Lite we can create a non-linear line of best fit over our data points and utilise the statistical API to return a correlation coefficient. Requirements Power Query Obtain the dataset from the …
Introduction For this week’s challenge, we are creating a calendar heatmap. There is no default visual for this, and many of the custom visuals are not very flexible, but Deneb has us covered. Requirements Create a calendar visual: Show day of the week on rows and week on columns. (Hint: If you get stuck on …
2023 Week 06 | Power BI: Create a Calendar Heatmap Read More
Introduction Hello and welcome back to Workout Wednesday! If you’re joining us for the first time, be sure to check out our complete list of challenges. This week we’re looking at data from the American Academy Awards, also known as the Oscars. The Oscars are awards for artistic and technical merit for the American film industry …
2023 Week 05 | Power BI: Visualize the Oscars with an Isotype/Pictogram Chart Read More
Introduction Hello everyone! I’m excited to have my first challenge of 2023 up and ready for your enjoyment. Last year I got a reputation as providing challenges that were, let’s say….a little on the easier side, so this year I’m just going to own it! I was scrolling Twitter in hopes of finding some inspiration …
2023 Week 04 | Power BI: Mortgage Rates Area Chart Read More
Introduction Howdy All! We’re all topsy-turvey this week turning line charts on their side! ⇩ This weeks challenge was inspired by Nick Desbarats article Are Vertical Line Charts Ever a Good Idea? Can you find some other examples where vertical line charts may be a good idea? ⋟^◕ܫ◕^⋞ Happy Vizzing Requirements Power Query Obtain the voteview_polarization_data.csv …
Introduction For our second week of Workout Wednesday 2023 Power BI Edition, we are taking inspiration from a recent Washington Post interactive story titled “See just how bad a year it was for your retirement account — and why”. The article looks at the closing price of the S&P 500, comparing the value at the …
2023 Week 02 | Power BI: Create layered line/area charts with labels and annotations Read More
Introduction Welcome to Workout Wednesday 2023, Power BI edition! If this is your first time joining us, we’re happy you’re here. The goal of this initiative is to help you build your Power BI skills. We provide the data and the instructions, and you build the visuals! We hope you have fun and learn a new …
2023 Week 01 | Power BI: Use DAX to control visual display Read More
Introduction “Hot days, warm nights, beaches, backyard cricket and Christmas celebrations are all part of summer in the Southern Hemisphere.” This week we will be connecting to a public flickr photo gallery from the State Library of South Australia, to create an image carousel using a custom visual from AppSource. Requirements Power Query Connect to the …
Introduction Me and my family love sitting down and watching Christmas movies during the holiday season! In this challenge we are going to be breaking down the words used in Christmas movie titles. Check out the word cloud that we are going to be creating below! Requirements Power Query In order to get this data …
It’s hard to believe that 2022 is coming to an end here before long! The second year of #PowerBI #WorkoutWednesday has been a great one. Thank you to everyone who has been a participant, a guest host, or interacted with our challenges in some way – you all are the reason why we do this! …
