Introduction The goal is a modified mekko chart. My guess is you will need LODs to solve but it is 100% possible with table calculations. Click to open in Tableau Public Requirements Dashboard Size: 800px by 400 px Set the bar height to be percent profitable. The level of analysis should be at the sub-category …
2021 Week 13 | Tableau: What percentage of sub-orders are profitable? Read More
Power BI Conditional Formatting using Background Color, Font Color, and Icons
The Fixed LOD gets a lot of the spotlight in tableau but we shouldn’t forget about its cousins INCLUDE & EXCLUDE. Have a go at this challenge to practice use those functions.
Introduction Thanks to everyone who has ben participating in #WorkoutWednesday – Power BI edition. This week we are going to be diving into a couple of different ways to custom sort your data. End users will often ask for specific sorting order, so figuring out how to do this in Power BI can be extremely …
Power BI Conditional Formatting using Background Color, Font Color, and Icons
Introduction This week I wanted to throw it back to an old classic chart by Hans Rosling, if you haven’t seen the TED talk I highly recommend watching it. Hans shows how fertility rate and life expectancy has changed over the years. With this example we are going to look at Income per GDP and …
2021 Week 11 | Tableau : Can you recreate the work of Hans Rosling? Read More
Introduction This week’s challenge is pulled directly from a work challenge I encountered recently. The ask was to build a filtering system that would allow the user to initially filter data and then add a secondary requirement of inclusion. Using the Superstore data set, the functionality we wanted to achieve was: Allow user to filter …
2021 Week 10 | Tableau: Can you build a must include filter? Read More
Introduction Thanks for joining us for Week 10 of Workout Wednesday – Power BI Edition. This week our challenge is to use the Violin Plot custom visual. There are no dependencies on prior weeks for this workout, so feel free to jump right in. Custom visuals are additional visuals created by Microsoft and Microsoft partners …
2021 Week 10 | Power BI: Violin Plot Custom Visual Read More
Introduction Welcome back for Week 9 of Workout Wednesday, Power BI edition. If you’re joining us for the first time, welcome! You can jump right in this week, where we’ll be exploring our data in Power BI. For this week’s challenge are going to use anomaly detection and forecasting to gain a deeper understanding of what’s going on now …
2021 Week 9 | Power BI: Forecasting and Anomaly Detection Read More
Introduction So, I’m a little late for Mardi Gras – but that didn’t stop me from thinking about King Cake, a New Orleans tradition (with French roots) where a little plastic baby is put inside of a cake that is plastered with green, yellow, and purple frosting with tons of sprinkles. Anyone teeth hurt yet? …
2021 Week 9: Can You Hide A Chart in the Map Layers? Read More
