Skip to content

EXAMPLE DATASETS

Dataset screenshots

The app requires the dataset to have a "tidy" structure. The date and metric columns must have a defined naming convention. Beyond these requirement, the app is relatively agnostic and accepts a wide variety of different dataset setups. Here are a few examples.

1. Period column, units, amount, discounts, cogs

A dataset with this setup will return the sales and the gross margin variance of the two periods, with price - volume - mix split. It will separately detail the impact on variance of changes in unit discount from the impact on variance of changes in unit cost.

image

2. Period column, units, amount, cogs, indirect costs.

A dataset with this setup will return the same as 1 above, but will not detail the impact of changes in unit discount since it have not discount column. Since there is an indirect costs column, it will return net margin variance, not gross margin variance.

image-20210611195320269

3. Period column, units, amount, discounts, cogs, visits, conversions

A dataset with this setup will return same as 1 above, plus the impact of visits and conversion drivers on sales variance.

image (1)

4. Period column, units, amount, discounts, weighted distribution

A dataset with this setup will return same as 1 above, but not gross margin variance. It will also return the impact on sales variance of the change of distribution.

image (3)

5. Period column, units (defects), amount (downtime)

To analyze supplier quality analysis. The units column maps the number of defects. The amount column maps the downtime generated by the defects. Price maps the gravity of the defect.

image (4)

6. Period column, amount

A dataset with this setup will return the aggregated sales or cost variance column without the price-volume split since there is no unit column.

image (6)

7. Period column, units (investment amount), amount (revenues or costs)

To calculate the ROI variance of a set of initiatives between two periods. The amount column maps the revenues (with positive sign) and the costs (with negative sign) of a given initiative. The unit column maps the investment cost of the initiative (in positive). The "metric" column (that does not need to be named "metric" ) is a dimension column that simply describes the nature of the revenues and costs.

image (2)

8. Plan/Actual column, units, amount, cogs

A dataset with this setup will return same as 1 above. Sales and margin variance are not measured between two periods but between actual and plan scenarios, with price - volume - mix split. It will not detail the impact of changes in unit discount since there is no discount column.

image (5)

9. Plan/Actual column, date column, unit, amount, cogs

A dataset with this setup will return same as 7 above. The date column makes it possible to compare actual and plan across different intervals.

image-20210611193226079

10. Plan/Actual column, date column, amount, cogs

A dataset with this setup will return same as 7 above, excluding price-volume split, since there is no unit column. The date column makes it possible to compare actual and plan across different intervals.

image-20210611192157803