This week we will be looking at Sub-Category Sales by Month, and creating a highlight table of which sub-categories were the Max and Min Sales in that Month.Each Month will Highlight the MIN Sales in Red, Max Sales in Blue.Allow users to Filter by Year and/or Category.Pay attention to formatting and how the Table adjusts in size according to how many Sub-Categories are being shown.
This week we will need to use some formatting skills and the knowledge of formatting color. You’ll also be using the rarely-utilized hierarchy on this dashboard and you’ll need to utilize the “+” and “-” to drill in and out of the hierarchy.As you complete this example, feel free to share on Twitter using the #WorkoutWednesday hashtag. Don’t forget to tag @VizWizBI, @RodyZakovich, and @LukeStanke. We really want to see your work.
I was checking #Workoutwednesday challenge the other night and came across the following Bar Chart combined with Line Chart along with axis labeling to display the months rather than numbers as Jeffrey has done.Quantity for the East and West regions should display as side-by-side bars
Sales for the East and West regions should be displayed as lines
This week Andy is back with a challenge and it’s very straightforward. You need to create two quarters starting with the month selected and show months for everything else.As you complete this example, feel free to share on Twitter using the #WorkoutWednesday hashtag. Don’t forget to tag @VizWizBI, @RodyZakovich, and @LukeStanke. Also, if you want your efforts throughout 2018 tracked, feel free to fill out this Google Form mentioned in the blog.
Do you enjoy working with Tableau? Are you looking for an additional challenge? Workout Wednesday might be what you need. WorkoutWednesday a set of weekly challenges from Andy Kriebel and Emma Whyte (for 2017) and Rody Zakovich and Luke Stank.This week Rody and Luke asked us to build a simple text table with a twist of course.You cannot use any LoD and Table Calculations
Do you enjoy working with Tableau? Are you looking for an additional challenge? Workout Wednesday might be what you need. The idea is to replicate the challenge that they pose as closely as possible. When you think you have it, leave a comment with a link to your visualization and post a pic on Twitter for others to enjoy.This week the challenge will be with both parameters and the window_sum() function. This visualization may look simple but it was a challenge for both Rody and Luke.
An effective and visually engaging way of presenting the main figures in a dashboard is to build a KPI belt by combining text, visual cues, and icons. By using KPI dashboards, organizations can access their success indicators in real time and make informed decisions that bring closer to achieving long-term goals.Business heads often use KPI tracking dashboards that provide a quick overview of their company’s performance and well-being.