2021 Week 15 | Power BI: Bivariate Choropleth Map
Power BI Conditional Formatting using Background Color, Font Color, and Icons
Year: 2021
2021 Week 15 | Tableau: Website Analytics
Introduction Lately I’ve been working with Google Analytics data, so I thought I’d pass on a data set to you! Our data set was created by you the audience – it’s extracted directly from our website analytics. This week’s challenge focuses on a lot of little things coming together – dashboard design, formatting, and reference …
2021 Week 14 | Power BI: Accessibility Enhancements
Power BI Conditional Formatting using Background Color, Font Color, and Icons
2021 Week 14 | Tableau: Can You Recommend Profitable Return Customer Bundles?
Introduction Have you ever purchased something on Amazon and they show an extra random list of products in the “Customers that purchased X also purchased…” section and you think to yourself, “How in the world did they come up with that combination (e.g., sponges and Skittles)?” They likely have high-powered recommender engines doing all of …
2021 Week 14 | Tableau: Can You Recommend Profitable Return Customer Bundles? Read More
2021 Week 13 | Tableau: What percentage of sub-orders are profitable?
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
2021 Week 13 | Power BI: Create a Bubble Chart with a Custom Overlay
Power BI Conditional Formatting using Background Color, Font Color, and Icons
Week 12: Can you do Comparative Quantity Analysis?
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.
2021 Week 12 | Power BI: Custom Sorting
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 …
2021 Week 11 | Power BI: Can you Turn a Ribbon Chart into a Bump Chart?
Power BI Conditional Formatting using Background Color, Font Color, and Icons
2021 Week 11 | Tableau : Can you recreate the work of Hans Rosling?
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