Skip to content

SMART🧠PLOTTING EXAMPLE

Here is an example of set of analyses you can complete with the tool in less than half a day of work .

Promise.

We use a test dataset that ships with Tableau. It contains information about products, sales and profits. To run it, open the "choose a sample dataset" widget and load the "Tableau Superstore" file in the Get started page. This document has been written a while ago, and some charts might looks slightly different. Please refer to the Gallery page for the most recent version.

PLOTTING SALES AND MARGINS

As a first step lets run a few plots to understand more about our fictitious company.

Give a look at the charts below.

In a nutshell, the company sells three categories of products (Technology, Office Supplies and Furniture).

stackedcolumn (5)

Technology is growing the fastest and brings in the largest share of profits. Furniture has a problem of low margins.

stackedcolumn (7)

In terms of Segment, the company operates in the Home Office, Corporate and Consumer Segment with all three of its Categories. The three segments have similar profit margins. Home Office is growing the fastest.

In terms of Geography, the South and the West Region are driving growth, with the West enjoying the highest 4-year CAGR. Margins are significantly lower in the South and Central Regions.

Products shipped First Class and Same-Day are growing the most. Same-Day deliveries are significantly less profitable.

marimekko

multi_tier_bar

stackedcolumn (10)

multi_tier_bar (1)

stackedcolumn (11)

barmekko (1)

marimekko (7)

stackedpareto (4)

stackedpareto (5)

stackedpareto (2)

stackedpareto (3)

pareto (1)

pareto (2)

pareto (3)

barmekko (2)

marimekko (1)

multi_tier_bar (2)

stackedcolumn (12)

barmekko (4)

marimekko (15)

marimekko (2)

multi_tier_bar (3)

stackedcolumn (13)

barmekko (5)

marimekko (14)

multi_tier_bar (4)

marimekko

multi_tier_bar

stackedcolumn (14)

barmekko (6)

marimekko (13)

Most customers buy products in two or in all three categories.

image-20211213113407433

VARIANCE CALCULATION

Let's calculate variance in terms of sales and margins, both aggregated and split in its different components (volume, price, mix).

In a nutshell, the company's 20% sales increase was driven by higher volumes, at flat prices and unchanged mix and discount levels. The growth was driven by new offerings.

Margins remained sluggish and grew less than sales, driven by volumes.

image-20210913174133418

image-20210913175035287

image-20210913175618566

image-20210913180056988

image-20210913175953980

image-20210914100344923

EBITDA BRIDGE

If the dataset contains indirect cost data..

multi_tier_bar (1)

...the EBITDA bridge is automatically returned.

image-20211122122815954

VARIABLE DIMENSION SALES VARIANCE

Variance is generally calculated along a given dimension, for instance by Country, or by Channel.

Unfortunately there is no guarantee that a single given dimension will always best "explain" the change in sales.

For example, say that "increase of sales in China" is the most important driver. The second most important might not well be not the change of sales in a different Country, but rather "increase of sales in the Direct Channel (China excluded)". Sometimes a combination of dimensions - for instance "increase of sales in China in the Direct Channel" - provides the best explanation of the change of sales.

This is "variable dimension" variance.

Below an example. Office Supplies Category sales, with 34% change, represent the top driver of growth. The second factor, however, are Home Office Segment sales that, net of Office Supplies, grew 93%. Each result row is detailed in its elements.

It is possible to plot the data of a given result row. This is helpful, for instance, to understand precisely which "non Office Supplies" Home Office Sub Categories had a 93% growth rate.

The tool generates alternative sets of results, which helps not to miss hidden insights. For instance, we might discover that First Class Shipping orders grew 70%, more than 3x the average 20% rate.

If a dimension, for example Shipping Mode, is not relevant, it can be excluded from the analysis: we get yet another set of results high-lighting the growth of the West Region (+33%).

image-20220105161154325

image-20220105161241139

multi_tier_bar

waterfall (1)

VARIABLE DIMENSION MARGIN VARIANCE

Margin variance can be similarly calculated.

waterfall (2)

multi_tier_bar (1)