#WOW2022 | 16 | Can you make a Hexbin Map?
One of the forgotten functions of Tableau is the hexbin functions
#WOW2022 | 16 | Can you make a Hexbin Map? Read More »
Tableau, Workout Wednesday
2022 W16 | Power BI : Quadrant Plot with Jitter
Introduction Your challenge this week is to create a Quadrant Plot. It should include different colors in each quadrant and the points should be jittered to try and reduce data overlap. Please note, that it is not expected to create the quadrants, quadrant lines, and color change by selecting any individual data point (if someone figures out how
2022 W16 | Power BI : Quadrant Plot with Jitter Read More »
Power BI, Workout Wednesday
2022 Week 15 | Power BI: March Madness
Introduction For basketball fans in the United States, March is a special time. It is when 64 of the best college basketball teams match up in a single elimination tournament to see who is the NCAA Men’s Basketball champion. The early rounds of the tournament provide long days of basketball games across several TV stations.
2022 Week 15 | Power BI: March Madness Read More »
Power BI, Workout Wednesday
#WOW2022 | Week 15 | Filter Challenge
Introduction I’ve heard last week’s challenge was a tough one, but it was great to see so many people participating and learning from it! My challenge this week was inspired by a colleague at work. Without revealing too much, it has been designed to test your understanding of how filters work in Tableau, based on
#WOW2022 | Week 15 | Filter Challenge Read More »
Tableau, Workout Wednesday
2022 Week 14 | Power BI: Create an achromatic report
Introduction April is colour month for Power BI Workout Wednesday 2022. First up we are going to try our hand at creating reports WITHOUT hue. Using a file from a previous challenge, can you create an achromatic report that uses contrast and lightness effectively? There will be some creative freedom involved in this challenge, no
2022 Week 14 | Power BI: Create an achromatic report Read More »
Power BI, Workout Wednesday
2022 – Week 14: Can you track headcount?
Introduction This week we are looking at HR headcount data. Headcount data can sometimes seem straightforward to work with, but sometimes the reporting rules can be a bit complicated–particularly with large organizations. This week you will attempt to measure the headcount of a large organization using data from the Real World Fake Data project by
2022 – Week 14: Can you track headcount? Read More »
Tableau, Workout Wednesday
2022 Week 13 | Power BI: Build a Bullet Chart with Deneb
Introduction For this last week of March, we are continuing our project management theme. The challenge this week is to use Deneb to build bullet charts using the provided data. Bullet charts were created by Stephen Few to offer an alternative to clunky gauges. Bullet charts are used to compare a featured measure to one or
2022 Week 13 | Power BI: Build a Bullet Chart with Deneb Read More »
Power BI, Workout Wednesday
#WOW2022 W13: Can you use multiple Mark Layers?
Introduction This week I hone in on majority of those spatial calculations within Tableau. I love the flexibility that Mark Layers allows us to have. Prior to Tableau 2020.4 maps could only have 2 layers and creating this hub and spoke style map would require some serious data preparation. This workout requires 6 calculations. Click
#WOW2022 W13: Can you use multiple Mark Layers? Read More »
Tableau, Workout Wednesday
2022 Week 12 | Power BI: Build a Slicer Panel
Introduction Welcome back to Workout Wednesday – we’re glad you’re here! This week, we’re continuing on with our project management theme. We’re tracking project progress using data generated from Microsoft Planner. Using Power BI with Planner (as opposed to using the inbuilt charts) enables us to both customize visuals and to view more than one plan at
2022 Week 12 | Power BI: Build a Slicer Panel Read More »
Power BI, Workout Wednesday
2022 Week 12: Can you create a jittered boxplot?
Introduction Last week a colleague reached out for help creating a boxplot to look at age distribution for different subscription methods, and my first thought was, “I know how to do that, but I don’t remember how to do that.” So I went back to find one I had made previously, and we were able to
2022 Week 12: Can you create a jittered boxplot? Read More »
Tableau, Workout Wednesday