Month: January 2021

2021 Week 4 | Power BI: Drill Through

Introduction Thanks to everyone who participated in Week 3 of #WorkoutWednesday – Power BI edition. If you are joining this week, you may want to revisit the first couple challenges as this week will continue to build on the data model we created in W01 and the basic KPI report that we built in W02 and W03. This week …

2021 Week 4 | Power BI: Drill Through Read More

2021 Week 3 | Tableau : Can you build a Control Chart

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

2021 Week 3 | Power BI: Report Interactivity

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 …

2021 Week 3 | Power BI: Report Interactivity Read More

2021 Week 2 | Tableau : Can you build a Customer Lifetime Value Matrix?

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

2021 Week 2 | Power BI: Creating Basic KPI Report

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 …

2021 Week 2 | Power BI: Creating Basic KPI Report Read More

2021 Week 1: Can You Find the Variance Along the Line?

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

2021 Week 1 | Power BI: Connecting To & Modeling Data

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

Scroll to Top