Skip to content

BIKE BRAND

Siva Juliet – Contoso Bikes

Contoso Bikes LLC a bicycle manufacturer in the Contoso Group. To run the dataset in the app, type "MS Financial Sample" in the "choose a sample dataset" widget.

THE COMPANY

Multi-tier bar chart

See how a dimension - here segment- plays out in the two periods on a metric - here amount.

All segments have been growing at more or less the same rate in terms of sales,...

multi_tier_bar (2)

...in terms of margins all segments up around 70% except Enterprise, whose negative margins worsened.

multi_tier_bar (4)

Marimekko Plot

See how a metric, here revenue, interacts along a pair of dimensions, here segment and country.

The company sells in five countries, with similar breakdown by segment.

marimekko

Barmekko Plot

See how two metrics - here sales and margins - play along a given dimension, here segment.

The Entreprise segment is loosing money.

barmekko (3)

Taking only Enterprise sales, the loss of margins was tied to high and medium discount band.

multi_tier_bar (6)

Government represents, across the whole period, the largest and most profitable segment.visualization (8)

Dumbbell Plot

See how a dimension - here segment - plays out in the two periods on a set of metrics - here amount, COGS and gross margin.

Entreprise reduced margins due to a more than proportionate increase in COGS.

visualization (24)

The proportion of high discount band sale is similar across segments...

marimekko (1)

High discount band sales have lower margins.

barmekko (4)

France has the higher margins.

barmekko (5)

The product breakdown is similar across segments.

marimekko (3)

Marginality is broadly similar across products.

barmekko (5)

Sales variance analysis

See aggregated sales variance or split variance between its components (volume, price, mix, drivers,..). Revenues grew substantially driven by volume.

newplot (1)

All metrics point north...

visualization (9)

...and are actually improving across the year

ac_vs_py

The price distribution has remained basically unchanged.

distribution (1)

WHAT CHANGED IN SALES

FIRST RESULT COMBINATION

Largest growth in Government and Small Business in terms of Segment.

image-20210414191229815

The first waterfall simply slices by segment. The dataset is built with most items in most dimensions growing more or less at the same rate, so keeping the same dimension in all row results makes sense, since changing dimensions does not add much insight value.

SECOND RESULT COMBINATION

Largest growth in USA, Canada and France in terms of Country.

image-20210414191328674

The second waterfall simply slices by country. The dataset is built with most items in most dimensions growing more or less at the same rate, so keeping the same dimension in all row results makes sense, since changing dimensions does not add much insight value.

THIRD RESULT COMBINATION

Sales growth driven by volume. Paseo price reduction in Government Segment compensated by price hikes in other products sold to Government.

image-20210414191443856

The third waterfall splits volume and price variance. The Paseo model is called out for a relatively significant negative price variance, that carries a potential negative impact on margins. Note that the average price of Paseo bicycles is growing significantly between the two periods.

visualization (10)

It is only when one filters the Paseo bikes by their most important segment, Government, that the drop in prices becomes evident.

visualization (11)

Every dataset is different

This use case is based on a fake dataset. Test run the app with your data to confirm the advantages of the variable dimension variance approach in your specific use case.

FORTH RESULT COMBINATION

Sales growth driven by New volume in all main segments.

image-20210414191901470

The forth waterfall splits volume variance between new, changed and lost combinations. Growth in the small business segment is coming from new combinations, not present in the first period.

WHAT CHANGED IN MARGINS

Margins grew substantially....

newplot (7)

...but stayed stable in % of revenues

newplot (8)

FIFTH RESULT COMBINATION

4M Margin increase driven by Government and by Low/No Discount Band Sales. Negative increase for Enterprise Segment and High Discount Band.

image-20210414192613509

The fifth waterfall splits margin variance by segment following mostly, but not totally, the revenue variance order. High discount enterprise sales are flagged as loosing margins.

SIXTH RESULT COMBINATION

Margin increase in all markets.

image-20210414192654272

The sixth waterfall splits margin variance by country, showing margin growth not strictly tied to sales growth.

The Enterprise segment responsible for a 200K reduction of the Margin, especially in the High Discount Band.

image-20210414211515571

Volumes, not costs, drove margin growth.

waterfall (8)

SEVENTH RESULT COMBINATION

Margin growth driven by Government volumes. Reduction in Paseo price compensated by cost improvement.

image-20210424133516299

The seventh waterfall splits margin variance by variance type. Government Paseo sales, that suffered negative price variance, are not surprisingly a driver of negative margin due to lower prices. What is more interesting is that Government Paseo unit cost fell almost in proportion to the price loss.

EIGHT RESULT COMBINATION

Finding patterns in data

'Mparanza uses variable dimension variance to help find patterns in the data that could be missed with a traditional slice and dice approach.

Positive impact on volumes of Low Discount Band increase in volumes. Goverment Paseo High Discount Band has price and cost impact balancing out.

image-20210424133914282

The eighth waterfall splits margin variance on the discount band dimension. Interestingly Government Paseo negative price and positive unit cost variance impact on margins are tied to high discount band sales.

ANNEX - VARIANCE BY DIMENSION

In this section the data is analyzed with a standard slicing by dimension approach.

The dataset contains four different dimensions.

image-20210403185821357

VARIANCE BY SEGMENT

Government is the key segment. Enterprise negative margin.

visualization

Steady sales improvement across the year.

ac_vs_py (1)

AGGREGATE VARIANCE ON SALES

Sales growing nicely across Segments.

newplot (9)

PRICE AND VOLUME VARIANCE

Sales growing nicely across Segments.

newplot (10)

PRICE, VOLUME, MIX VARIANCE

Positive mix impact on Government Segment.

newplot (11)

NEW AND LOST VOLUME VARIANCE

Growth driven by new volume.

newplot (12)

PRICE, VOLUME AND DISCOUNT VARIANCE

Marginal increase in discounts in all Segments.

newplot (13)

AGGREGATE VARIANCE ON MARGINS

Margins driven by Government.

newplot (14)

The Enterprise Segment is loosing margins in most Countries...

newplot (16)

..products..

newplot (16)

...and especially in the High Discount Band.

newplot (18)

PRICE, VOLUME & MIX, COST VARIANCE ON MARGINS

Volume impact margins positively.

waterfall

VARIANCE BY COUNTRY

All Countries performing well.

visualization (1)

AGGREGATE VARIANCE ON SALES

Sales growing nicely across Countries.

newplot (19)

PRICE AND VOLUME VARIANCE

Growth driven by volumes, with flat prices. Limited negative price pressure on Canada.

newplot (2)

PRICE, VOLUME, MIX VARIANCE

Positive mix impact in Canada.

newplot (6)

NEW AND LOST VOLUME VARIANCE

Growth driven by new volume.

newplot (9)

PRICE, VOLUME AND DISCOUNT VARIANCE

Marginal increase in discounts in all Countries.

newplot (12)

AGGREGATE VARIANCE ON MARGINS

Margins growing nicely across Countries.

newplot (15)

PRICE, VOLUME & MIX, COST VARIANCE ON MARGINS

Volumes drive margin. In Canada, price decreases compensated by cost improvement.

waterfall (1)

VARIANCE BY PRODUCT

Paseo is the number one Product.

visualization (2)

AGGREGATE VARIANCE ON SALES

Paseo highest growing product in terms of sales

newplot

PRICE AND VOLUME VARIANCE

Some negative pressure on Paseo prices. Positive price increases on other models.newplot (3)

PRICE, VOLUME, MIX VARIANCE

Positive mix impact on Paseo.

newplot (7)

NEW AND LOST VOLUME VARIANCE

Growth driven by new volume.

newplot (10)

PRICE, VOLUME AND DISCOUNT VARIANCE

Marginal increase in discounts in all products

newplot (13)

AGGREGATE VARIANCE ON MARGINS

Margins growing nicely across Products.

newplot (16)

PRICE, VOLUME & MIX, COST VARIANCE ON MARGINS

Negative margin impact of price on Paseo offset by improved costs.

waterfall (2)

VARIANCE BY DISCOUNT BAND

Higher margin growth in all Bands.

visualization (3)

No Discount has more low ticket sales...

distribution (2)

... and a lowering average price.

visualization (4)

Revenues in the High Discount Band are lower compared to the corresponding month of last year.

ac_vs_py (3)

AGGREGATE VARIANCE ON SALES

High sales growth in all Discount Bands

newplot (1)

PRICE AND VOLUME VARIANCE

Negative price pressure on High Discount Band and on No Discount.

newplot (4)

PRICE, VOLUME, MIX VARIANCE

Positive mix impact on Medium Discount Band

newplot (8)

NEW AND LOST VOLUME VARIANCE

Growth driven by new volume.

newplot (11)

PRICE, VOLUME AND DISCOUNT VARIANCE

Marginal increase in discounts.

newplot (14)

AGGREGATE VARIANCE ON MARGINS

Margins growing nicely across Bands.

newplot (17)

PRICE, VOLUME & MIX, COST VARIANCE ON MARGINS

Negative price impact compensated by improved cost in High and No Discount Band. Opposite dynamic in other Bands.

waterfall (3)