#WOW2024 | Week 29 | Formatting & Intermediate Tableau Charts

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

2024 Week 28 | Power BI: Create custom navigation with Zoe Douglas

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

2024 Week 28 | Sigma: Are you ready for vacation?

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 …

2024 Week 28 | Sigma: Are you ready for vacation? Read More

WOW2024 | Week 28 | Can you design a multi-dimensional Panel Chart for detailed analysis?

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

CRM Analytics: Quasi-Histogram – SOLUTION

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 …

CRM Analytics: Quasi-Histogram – SOLUTION Read More

2024 Week 27 | Sigma: Can you create a Cashflow Chart?

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

2024 Week 27 | Power BI: Scatter plot showing the path of selected data points

Introduction The challenge for this week is to first build a scatter plot of fertility vs life expectancy of different countries. However, this will not just be for a single year, but will contain information across many years, making it possible to slide the year and see how all the bubbles move. The key challenge …

2024 Week 27 | Power BI: Scatter plot showing the path of selected data points Read More

2024 Week 27 | CRM Analytics: Quasi-Histogram

Introduction Hello again, everyone. One of the things that CRM Analytics misses in its variety of charts is a histogram. A histogram is a chart that displays the frequency (count) of rows within a range of numeric values. For example: you have opportunity records with several amounts (2500,3000,5000.8750.10000, etc). In a histogram, we’d create a …

2024 Week 27 | CRM Analytics: Quasi-Histogram Read More

#WOW2024 | Week 27 | Can you show YTD and PYTD, whilst also being able to change the date range and switch between Month & Week?

Introduction One of the perks of my job is that I get to help colleagues solve puzzles that clients throw at them. This is where this came from. Well in fact – the original idea came from a Power BI report, and I wanted to prove it was doable in Tableau.  Click to open in …

#WOW2024 | Week 27 | Can you show YTD and PYTD, whilst also being able to change the date range and switch between Month & Week? Read More

2024 Week 26 | Sigma: Can you calculate RunRates?

Introduction Welcome to Week 26! When we dive into monthly data, it’s often more helpful to predict the current month’s numbers rather than relying on incomplete data for an incomplete month. This week, we’re trying out three different ways to estimate sales projections for the ongoing month, also known as the run rate. Dealing with …

2024 Week 26 | Sigma: Can you calculate RunRates? Read More

Scroll to Top