Introduction Is it too late now to start the post with Happy New Year? Well it’s my first Workout of the year so Happy New Year everyone, it’s really great to be back for my third year! After completing the first two workouts from this year (because I suck at Table Calculations), I wanted to …
2021 Week 3 | Tableau : Can you build a Control Chart Read More
Introduction Thanks to everyone who participated in Week 2 of #WorkoutWednesday – Power BI edition. If you are joining this week, you may want to revisit the first couple challenges as this week will build on the data model that we created in W01 and the basic KPI report that we built in W02. This week we are going to …
Introduction This year we’ve made a commitment to start with the basics and build, so this challenge is designed to do just that. This week, you’ll be constructing a Customer Lifetime Value Matrix (CLTV). This viz is frequently used in marketing and retail industries to understand the value of each customer. Specifically, the interesting insights …
2021 Week 2 | Tableau : Can you build a Customer Lifetime Value Matrix? Read More
Introduction Thanks to everyone who participated in Week 1 of #WorkoutWednesday – Power BI edition. If you are joining this week, you may want to revisit the first week’s challenge as this week will build on the data model that we created in W01. We also have the PBIX file available here. This week we are going …
Introduction For the longest time, I avoided table calculations as much as I could because I thought they were overly complicated (compute using…relative to…sort by…nested…ughhhh) especially when I had LODs in my back pocket. But, over time, I’ve made my peace with them (dare I say, a fan now) as I recognized how powerful they …
2021 Week 1: Can You Find the Variance Along the Line? Read More
Introduction Hey all! Thank you so much for checking out the new Power BI edition of #WorkoutWednesday. Although the Tableau version of #WorkoutWednesday has been going on for several years, this is our first attempt at creating a similar community with Power BI. If you’re unfamiliar with the concept, we will release a challenge every …
2021 Week 1 | Power BI: Connecting To & Modeling Data Read More
Introduction Brad Werner is responsible for this week’s Workout Wednesday Challenge. Here are all the details in Brad’s own words: I have a confession. When I first started using Tableau, I was a strict advocate for #TeamFloating. Yes, I used to float ALL objects on my Tableau dashboards. I would decide on a dashboard layout …
Introduction It feels like it has been a very long time since my last Workout Wednesday, but here I am with my last one of the year. I thought we would have a little bit of fun with some Christmas Songs Data. The data contains top 200 songs everyday from 31/10 to 31/12. This currently …
Introduction This is my last Workout Wednesday for 2020 (don’t worry, I’ll be back in 2021!), so I thought I’d take it easy on everyone. This week you’ll be building a single chart – a divergent histogram. I first saw a divergent histogram via the Economist almost 3 years ago and tagged it as a …
2020 Week 51: Can you build a Divergent Histogram? Read More
Introduction This week we are throwing it back to using measure names and measure values. There are two levels to this challenge: Level 1 Showing the visualization as is, but without the circles around the white dots in each line Level 2 Adding a ring around the white dots on the viz. There is no …
2020 Week 50: Can you highlight profits with measure names? Read More
