Introduction This week’s challenge was inspired by a lively discussion I was a part of, covering what date calculations a data analyst should or should not know. We’ve already covered several common ones, such as the current time period vs the prior time period. So this week, I wanted to add another to the list: …
2024 Week 30 | Sigma: Can you show partial or whole months? Read More
Introduction It’s no surprise that many analysts tend to enjoy looking at data via a scatterplot. It’s a great way to show correlation across two measures for a cohort of dimensions. Additionally, one of the most popular charts of all-time is a line chart which shows historical trends. So how we do show correlation of …
Introduction Welcome to Week 29! When dealing with time series data, sometimes we want to see how the data changes from period to period, specifically how it increases and decreases. Enter, the waterfall chart. Waterfall charts are a great way to see the journey of a value from start to end, and to see how …
2024 Week 29 | Sigma: Can you create a Waterfall Chart? Read More
Introduction This week, we are recreating a previous Tableau workout in Power BI in which we build a segmented bar chart that contains a bar for the total amount followed by a bar that shows a categorical breakdown of that amount. This challenge involves a bit of data transformation as well as some more advanced …
2024 Week 29 | Power BI: Remake of a Tableau Segmented Bar Chart Read More
Introduction Tableau 2024.2 has recently released and I was excited to put together a New Features challenge for you all, including the Multi-Fact Relationship model and maybe a Viz Extension or two. While I’ve had a lot of fun diving deep into learning about Multi-Fact Relationships, I pretty quickly encoutered a limitation for incorporating it …
#WOW2024 | Week 29 | Formatting & Intermediate Tableau Charts Read More
Introduction Welcome back to Workout Wednesday! This week’s challenge is purely dataviz – there is no data transformation involved. A huge thanks to our friend and colleague Zoe Douglas for providing us with a beautiful and fun report to recreate. Find the data and instructions to complete the challenge below, and as always, have fun! Requirements …
2024 Week 28 | Power BI: Create custom navigation with Zoe Douglas Read More
Introduction Welcome to Week Twenty-Eight! Now that we are firmly in Summer Mode, let’s plan a lake vacation! This week, we’re going to evaluate water quality monitoring data in the Great Lakes. The dataset we’re using comes from Data.Gov. This dataset has many different characteristics measured in one long table. Don’t worry. I’ve already created a Sigma …
Introduction Do you like panel chart? I love it.It is often requested in practical work because it is suitable for getting an overview.This time, I am taking up some of the more challenging requests from past practical work.I believe this will help you level up your panel chart skills, so please enjoy the challenge! Click …
WOW2024 | Week 28 | Can you design a multi-dimensional Panel Chart for detailed analysis? Read More
Introduction Last week the challenge was how to create a quasi-histogram in CRM Analytics. Here is my solution, hope you guys like it. If you used a different solution, share it with us in the comments. Solution Let’s start by getting any numeric value from our dataset. You can upload your dataset. I am using …
Introduction I’ve always liked tracking my personal finances, partly out of necessity (I was a freelance musician for nearly a decade and I needed to keep track of *every* expense). Even before I got into data, I appreciated seeing my personal finances visualized cleanly so I could answer questions like ‘Did I spend too much …
2024 Week 27 | Sigma: Can you create a Cashflow Chart? Read More
