VARIANCE­čôłOPTIONS BASICS

image-20221213125648153

If you are analyzing costs and not revenues, you need to tell the system that a positive variance is "bad" (and should be rendered in red ­čö┤), while a negative variance is "good" (and should be rendered in ­ččó). The system will not values as "Costs" instead as as "Sales."

image-20221208111827179

By default the app skips the variance analysis calculation. You can choose whether to perform variance analysis along one dimension or along a variable set of dimensions

image-20221213125814419

Depending on the structure of your dataset, you will be presented a list of possible variance calculations you can choose from, beyond the default aggregated difference. For instance, if you have a units column in your dataset, the system will be able to compute prices, and thus to split variance into its price and volume components.

image-20221208111845843

It is also possible to calculate variance as an index, and as percent of revenues.

image-20221208111944534

If you leave the "Choose dimension to plot on waterfall chart" widget on None the app will plot the total variance. If you select a dimension (such as Country, Product, Client,...) the app will plot variance along said dimension.

image-20221208111927096

Alternatively, you can ask the app to calculate all the combinations along all the dimensions, and return a "variable dimension" variance calculation with the set of most relevant combinations. You can choose between 10 different possible sets of results. And you can drill down each result.

variable_dimension_variance