This week’s workout comes from a recent conversation I had. The goal was to figure out the best periods of sales (whether that was best days, best weeks, or best months) and to understand more context around those dates. Was the increase in sales driven by holidays or other external events, or perhaps it was …
Week 44: Can you build a Sales Calendar with top 3 highlighting? Read More
We are on the home run for #Data19, so what better way that to map all the casinos around Mandalay Bay? This week we take a few new features and plot them onto a mobile friendly dashboard. Requirements Dashboard Size 350 x 800 Input custom number of miles Create Map showing selected casino and all …
Week 43: Show me all the casinos within X miles of X casino by metres Read More
This week’s challenge is taken directly from a situation I recently had on a project. The goal of the project was to be able to isolate out time periods of a specific length and compare it to the time period directly before it. So as an example, if it’s October 2019, I want to look …
Week 42: Can you build a comparative line chart with dynamic inputs? Read More
Once again, this week comes from a real life challenge. This real-life scenario involves a scatterplot of customers and a long, long table. The first requirement was to keep all the customers in the list, but also highlight those customers. After a round of feedback our stakeholder decided they wanted the selected customers to “surface …
I was recently helping a coworker on a dashboard and mentioned sheet swapping as a potential solution to a problem. My coworker stopped me mid-sentence and said “What on earth is sheet swapping?!” We operate in our own Tableau bubble, and sometimes assume everyone else knows exactly what we do, I’m hoping Workout Wednesday is …
This week’s #WorkoutWednesday idea comes from creating a product portfolio. The customer wanted to see how much a product has grown and what it’s market share was. We are going to recreate the BCG Growth-Share Matrix for our superstore sub categories and manufacturers. “The BCG Growth-Share Matrix is a portfolio planning model developed by Bruce …
Week 39: Can you create a BCG growth share matrix with Sales and Orders? Read More
This week I’m tackling a topic that nearly everyone has been asked – visualizing good/bad as performance indicators that are red or green. At least here in the western world, the busy executive tends to think about things in terms of traffic lights. So this week your task is to create something that satisfies their …
Week 38: Can you build a sales comparison chart with performance indicators? Read More
This week we are making bar charts. Of course, this week there is a small twist to the bar charts. The ends of the bar charts need to be rounded. There are several ways to do this. I’d personally suggest unioning the data to itself–but like I said, there is more than one way to …
2019 Week 37: What percent of sales is from the east region? Read More
After four amazing challenges from the Tableau Community, we are back in the drivers seat to provide you with this week’s challenge! For your challenge this week, we are focused on interactivity over anything else; This week is simply about getting to know the tool and being creative with your data solutions. So can you …
Week 36: Can you build a custom axis with a tracking reference line? Read More
In the final week of the community challengers we have Rosario Guana. She is a Tableau Ambassador and a Tableau Zen Master. Rosario has been championing WorkoutWednesday since day 1, she writes blog posts about solutions and other tips and tricks in both English and Spanish. When Tableau 2019.2 was launched, I soon found myself testing …
Week 35: Drill Down & Up on Sales with Subtotals using Parameter Actions Read More
