DRIVER VARIANCE

Under Get Started load the dataset "01 Travel". The dataset looks like this.

img

The "amount" is the monetary value of sales. Nights is the "units" sold column . Visits is the number of visits to the site. Bookings is the number of "checkouts". Amount minus Commission is Net Sales. Net Sales minus COGS is Margin.

Hit on submit and you get the first report. An increase of travelers coming to France represents the most important item in terms of Price and Volume Variance. Variance Running Total converges at 33,000 which equals the difference between the two years.waterfall (8)

image-20210705164618597

Let's play with drivers now. Set "Show variance as" to "Price, Volume & Mix, Drivers" variance and hit submit. The increase average ticket sale fell, but was compensated by more visits and more checkouts of customers wishing to travel to France. .

waterfall (9)

image-20210705164752506

We can drill down the first row result to understand more of the reduction in average ticket amount. It mainly concerns travelers to France, whose number and conversion rate as we know swelled.

waterfall (10)

image-20210705164940302

If we choose "Price, Volume, Mix, Drivers Variance" we get a slightly different results that splits the change in average ticket sale (shown as "average ticket" variance) from the overall impact of the "mix" of accommodations we are selling (shown as "mix" variance). Both are going down in this case.

waterfall (11)

image-20210705165115095