JOIN DIM DATASETS

To avoid doing the vlookup in excel you can add dimension columns to your dataset. Simply upload one or more "dimension" datasets to 'Mparanza along with your main "fact" dataset.

Just make sure that the key columns in the two files have the same name and that the key column in the dimension file does not have duplicate entries.

Say this is your main csv file

img

Problem: your "fact" dataset has a "Country" column but you want to analyze by "Continent".

Solution: You prepare a "dimension" file like this, where the "Country" key column has the same name as in your main "fact" dataset.

image-20210312130125871

You can upload more than one "dimension" file. A dimension file can have more than two columns.

image-20210312130309275

Upload your "dimension" files using the "Upload and join dimension tables" upload widget. This widget will appear once you have uploaded your main "fact" csv file.

image-20210312122316999

'Mparanza will automatically left-merge the two "dimension" files to your "fact" file and your output waterfall report will include your new dimensions, if these dimensions "explain" the most important change.

image-20210312122341773

In this case "Material", "Product" and "Category" explain the change without need of looking into "Continent" and "Country".

image-20210422165342432

If you want to see the impact of "Continent", add "Continent" to the "choose columns you want to see in every report row" widget and submit again.

image-20210422165441393

The report now includes the "Continent" dimension in every row.

image-20210422165510442

Note that both reports are factually true. The reason 'Mparanza automatically came up with the first and not the second, is because "Steel" (number 1 in the first waterfall) accounts for an increase of 42M, double the increase of "North America" (number 1 in the second waterfall). The % increases are similar (225% vs 288%). Note that if "North America" had shown a (much) higher growth rate than "Steel" it might have come up first even though it is half the size.