Introduction July is “Power Query Month”, where the theme is focused less on visualization and more on data preparation. Every Power BI challenge requires Power Query to get and transform data, but now we’re going deeper in July! If you haven’t checked out Dave’s challenge from last week, make sure to check it out here. This …
2021 Week 28 | Power BI: Web Scraping with Power Query Read More
Introduction This week’s Workout Wednesday is brought to you by Josh Jackson. For those who don’t know, Josh is my husband! He typically prefers to stay in the background, but asked if he could borrow one of my weeks to share this challenge. Here’s the challenge in his own words: This week is inspired by …
2021 Week 28 | Tableau: Can you build an app to visualize wildfires? Read More
Introduction July is “Power Query Month”, where the theme is focused less on visualization and more on data preparation. Every Power BI challenge requires Power Query to get and transform data, but now we’re going deeper in July! Starting off the month, you’ll use Power Query to perform preliminary cleanup and filtering of data exported …
2021 Week 27 | Power BI: Data Transformation with Power Query Read More
Introduction Like a fine pinot grigio, I really enjoy a good box-and-whisker plot. There is so much good stat stuff in one place like the min/max, median, top/bottom performers, and outliers in the data set. I have found, however, that they are rarely used and some business end users find them hard to read. …
2021 Week 27: Can you find the top and bottom performers? Read More
Introduction This is our last week using the Nobel Prize data. We are again looking at the age of the laureate when they were awarded the prize. This time we will examine it using a histogram. Histograms measure the distribution of data within defined ranges. So we are calculating age and creating bins of equal …
2021 Week 26 | Power BI: Make a Histogram with Equal Size Bins Read More
Introduction This week we are going to do two things: look at alternative for the most common scatterplot I see in Tableau. use a very uncommon unsynchronized dual axis chart. First, the chart I always run into is this scatterplot of total sales and total profit by order. While we can see which orders were …
2021 Week 26 – Tableau: Profitability with Dual Axis Charts Read More
Introduction This week we’re going to reach back in the WOW catalog to week 24 of 2017. Do you remember where you were in your Tableau journey back then? Workout Wednesday was just kicking off with Andy Kriebel and Emma Whyte and in week 24, Emma presented this challenge to the community. Now, normally, I …
Introduction This week we are building on Meagan and David’s challenges using the Nobel Prize data. We’re also continuing on our customization journey and will have a bit of fun using unicode values. Unicode is a standard numeric value that represents a character, which can easily be transformed into a character in Power BI using a bit …
Introduction This week we are continuing with the Nobel laureates data and taking a look at gender diversity of Nobel laureates. We’ll do this by using an isotype visualization. Isotype visuals use an icon that is related to the subject matter being depicted and often use multiples to represent quantitative data. You can learn more about …
2021 Week 24 | Power BI: Create an Isotype Visualization Read More
Introduction How is it that time of the week already? This week I have a challenge for you which hones in on some of the Map Layers and Spatial Calculations. It is using a dataset recreated by a colleague of mine Dan Farmer as he posted a similar visualisation internally. Thanks for the inspiration Dan. …
2021 Week 24 | Tableau: Can you visualise the Cholera Outbreak? Read More
