#workoutwednesday | Data Visualization | Tableau

#WorkoutWednesday Week 13 – Color and ordering

This week’s #workoutwednesday was about comparing last 2 periods sales for a sub-category using date functions with customize tooltips.

Requirements

  • Dashboard size should be 1000×600.
  • Sub-Category on the Rows Shelf, and Year of Order Date on the Columns Shelf
  • There are 3 measures, Sales, % of Total (in year) and % Difference
  • Only the Sales Measure has color (which colors you use don’t matter, just that Sales is the only measure colored).
  • Users can select a Year and a Measure and sort the table in Descending order by that measure in that year.

Dataset used was superstore dataset available with Tableau

Below is my attempt to meet the above requirements:

Thanks for reading 🙂

Do subscribe to blog for keep receiving updates

#MakeoverMonday | Data Visualization | Tableau

#Makeover Monday: What is the UK’s Favorite Chocolate Bar?

This week in #makeovermonday challenge was about UK’s Favorite Chocolate Bar as we are approaching Easter this week

Data was shared by CDA

Here is the original report and how it looks:

Data is share on makeovermonday.co.uk week 13.

In my attempt I tried to use the sigmoid function and tried to create Sankey chart.

Here is my attempt for #makeovermonday for UK’s Favorite Chocolate:

Thanks!!
Do subscribe to keep receiving regular updates

 

#workoutwednesday | Data Visualization | Tableau

#WorkoutWednesday Week 12 – SUB-CATEGORY SALES CHANGE IN THE LAST TWO PERIODS

This week’s #workoutwednesday was about comparing last 2 periods sales for a sub-category using date functions with customize tooltips.

Requirements

  • Dashboard size should be 600×700.
  • The Change field should be displayed as a number, not a string.
  • Sub-Category should be sorted ascending by Change.
  • Tooltips should match exactly.
  • Prior Month and Most Recent Month should always be matching days, for example: If the max order date is 6/15/2017: the most recent month range should be orders between 6/1/2017-6/15/2017 and the prior month range should be 5/1/2017-5/15/2017.
  • Make sure your audience knows the dates in question by providing a note about the date ranges above the viz, and make sure that the date range displays match the colors of the dots in the viz..
  • Display the x-axis on top of the viz, and use the traditional x-axis space for a color legend.
  • Show the mark label on hover *for the most recent month only*. If the value for the most recent month is *lower* than the prior month, the mark label should be displayed to the left of the dot. If the value for the most recent month is *higher* than the prior month, the mark label should be displayed to the right of the dot.

Below is my attempt to meet the above requirements:

Thanks for reading 🙂

Do subscribe to blog for keep receiving updates