Introduction This week we are going to be exploring how to use Bookmarks to toggle between different views in a report. There are a number of things you can do with Bookmarks, but in this week’s example we are going to use them to toggle between chart views and then as a Reset Filters button. […]
2021 Week 32 | Power BI: Toggling Views with Bookmarks Read More »
Introduction We recently wrapped up a Survey for the Workout Wednesday community gauged at understanding what YOU are interested and what areas of opportunity our team may have. During our latest group meeting I was struck with the idea that this was the perfect opportunity to get a twofer – practice visualizing survey data AND
2021 Week 32 | Tableau: Visualize our Survey Data Read More »
Introduction Over the course of Power BI’s Workout Wednesday challenges, you’ve had a chance to try several “custom” visuals. These are typically developed by third parties and may or may not appear on Microsoft’s AppSource marketplace. Generally, you don’t have much control over the visualization apart from whatever format options the developer creates. This week,
2021 Week 31 | Power BI: Declarative Visualization with Deneb Read More »
Introduction The ability to efficiently find the proverbial needle in a haystack is worth its weight in gold. How many times has a key stakeholder asked you to give them a shortlist of products (insert the focus of your analysis) to focus on for business improvement/optimization opportunities…and they’ve asked you to get back to them
2021 Week 31: Can You Find the Needle in the Haystack? Read More »
I love puzzles, it’s the reason I love #WorkoutWednesday and have since it began in 2017. This week we’re tackling a recent puzzle I was confronted with. Let’s count the number of consecutive weeks with more sales than the week before. Can you solve it?
#WOW2021 | 30 | Let’s go Streaking! Read More »
Introduction To celebrate our fourth week of Power Query month, we are going to use Power Query to analyze text data. Inspired by Chris Webb’s blog post, we are going to analyze word usage in Mary Wollstonecraft Shelley’s Frankenstein; Or, The Modern Prometheus. The Power Query techniques used in this week’s challenge are a bit
2021 Week 30 | Power BI: Remove Punctuation and Count Words With Power Query Read More »
Introduction This week we are collaborating with Preppin’ Data to get a close look at the schedule for the 2020 Olympic Games! We’re also collaborating with the Tableau team and we invite you to take a look at both challenges! With the opening ceremony 2 days away, we thought we’d visualize the schedule in our own time zone. We encourage you
2021 Week 29 | Power BI: Let’s Watch the Olympics! Read More »
Introduction This week we have teamed up with the Preppin Data team and the PBI team, to come up with a challenge cross over. As the Olympics is starting imminently we thought it would be appropriate to visualise the Olympic Schedule. We would encourage you to take a look at all challenges this week to
2021 Week 29 | Tableau: Can you rebuild the Olympic Schedule? 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! 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 »
