2022 Week 47 | Power BI: WoW on Twitter

Introduction Welcome back to Workout Wednesday! This week we’re going to visualize Twitter data using Twitter’s API to retrieve tweets that have been made about Workout Wednesday! You have complete creative license to visualize the data in any way that you see fit. If you have a Power BI premium license, I encourage you to […]

2022 Week 47 | Power BI: WoW on Twitter Read More »

Power BI, Workout Wednesday

#WOW2022 | Week 47 | Can you label and sort small multiples?

Introduction Small multiples can be a good way to see overall trends across several categories, but sometimes it can be tricky to get the sorting and labels right, so that’s what we’ll practice this week! Since baseball season is over now, we’ll look at overall win percentage from 1998 to 2022 for Major League Baseball

#WOW2022 | Week 47 | Can you label and sort small multiples? Read More »

Tableau, Workout Wednesday

#WOW2022 | Week 45 | Average Patient Waittimes

Introduction This week’s challenge was derived from a project that I helped some colleagues with. My colleagues were working on a client project for a travel company. They wanted to be able to compare a selected “Event Date” with an average travel day. The aim was to see if and how travel patterns might be

#WOW2022 | Week 45 | Average Patient Waittimes Read More »

community, Tableau, Workout Wednesday
How Brits met their partners

2022 Week 45 | Power BI: Ribbon Chart (Advanced)

Introduction Another Deneb visual this week – creating a custom Ribbon Chart.   This ribbon chart takes on a slightly different form than the ribbon charts you may be used to. This ribbon chart is focused on highlighting the change in rank and proportion of response types between the first and last dates of a

2022 Week 45 | Power BI: Ribbon Chart (Advanced) Read More »

Power BI, Workout Wednesday

2022 Week 44 | Power BI: Customer Lifetime Value

Introduction This week, our challenge is to calculate customer lifetime value by quarter using DAX.  This is an advanced challenge so buckle up! As I was working on my challenge for week 44, I stumbled upon the drafted challenge for Tableau on the same week.  The Tableau challenge was… you guessed it… developing a chart

2022 Week 44 | Power BI: Customer Lifetime Value Read More »

Power BI, Workout Wednesday

2022 – WEEK 44: What is the lifetime value of customers?

Introduction This is probably my favorite challenge of the year. So i’m saving it for near the end. You’ll need level-of-detail and table calculations to solve this one. For this challenge you need to calculate customer lifeftime value (in sales). While their are many ways to do this. We are going to keep this as

2022 – WEEK 44: What is the lifetime value of customers? Read More »

Tableau, Workout Wednesday

#WOW2022 W43: Advanced Formatting by Jeremy Anderson

Introduction Conditional formatting is a robust feature in Power BI that you can leverage to help users gain insights. Typically, we see conditional formatting applied to the table and matrix visuals. For example, you might apply a background color, font color, or icons to the values based on a set of rules.  Conditional formatting of

#WOW2022 W43: Advanced Formatting by Jeremy Anderson Read More »

community, Power BI, Workout Wednesday

#WOW2022 | Week 43 | Selected Subcategory Influence

Watch Introduction Hi Workout Wednesday friends!  I’m back, just in time for the Tableau 2022.3 release, which means we’ll be exploring Dynamic Zone Visibility.  This new feature allows you to use calculations and logic to dynamically show and hide dashboard elements (pretty powerful).  So in this challenge, you’ll get some hands on exposure to this

#WOW2022 | Week 43 | Selected Subcategory Influence Read More »

Tableau, Workout Wednesday