Skip to content

COST ANALYSIS

By default the app consider more "better", and therefore plots positive variances in green and negative variances in red. Positive variances of discounts and of COGS will be plotted red.

If you are analyzing cost rather than revenue data you need to modify the default behavior. Simply set the Variance🚦widget to 🟢-🔴+ (less is good, more is bad) instead of the default 🔴-🟢+ (less is bad, more is good).

image-20221207160700816

The charts will show positive variances in red and the metric will automatically be shown as "Costs" instead of "Sales"

image-20221206075311737

If the dataset does not contain quantity information variance will be computed as an aggregate.

image-20221206075448034

COST ANALYSIS EXAMPLE

As an example we have loaded NYC budget example dataset on the site. If we run a "a variable dimension" bridge with standard parameters, we get this. Notice that the most important items is "N/A" as Responsibility Center Name. The field seems to be often empty.

image-20221206075731513

image-20221206075806121

Lets drop the responsibility center name column from our analysis

image-20221206075843580

Here is the new output.

image-20221206080002512

image-20221206080020542

We are showing this chart with the initial and final totals. You can also see it without by changing the wizard below.

image-20221206080147082

Here is the result

image-20221206080300817

image-20221206080317258

We want to understand better that first "Contractual services" row so we drill down

image-20221206080423272

The app now also returns a more detailed report.

image-20221206080546198

image-20221206080620346