April 2018 - Tabvizexplorer.com

#WorkoutWednesday Week 14 – Frequency Matrix

This week’s #workoutwednesday was about building frequency matrix using color to represent the frequency intensity.

Use sub-categories
Dashboard size is 1000 x 900; tiled; 1 sheet
Distinctly count the number of orders that have purchases from both sub-categories
Sort the categories from highest to lowest frequency
White out when the sub-category matches and include the number of orders
Calculate the average sales per order for each sub-category
Identify in the tooltip the highest average spend per sub-category (see Phones & Tables)
If it’s the highest average spend for both sub-categories, identify with a dot in the square
Match formatting & tooltips – special emphasis on tooltip verbiage

This week uses the superstore dataset. You can get it here at data.world

Below is my attempt to meet the above requirements:

Thanks for reading 🙂

Do subscribe to blog for keep receiving updates

This week in #makeovermonday challenge was about World wine production between 2012 to 2016.

Here is the original report and how it looks:

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

Here is my attempt for #makeovermonday for World Wine Production:

Thanks!!
Do subscribe to keep receiving regular updates

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

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