Source

This section identify the type of data you should load

Datama source is basically a flat table.

As in other well known analytics software (e.g. Tableau), we differentiate Metrics and Dimensions. Think Metrics & Dimensions as columns of a spreadsheet.

Datama demo has a series of saved versions using different sources that you can get inspired from looking at this Google Sheet.

As for example:

Metrics

Metrics are always numeric values. As an input, you need to put only metrics that can be aggregated (i.e. summed). To simplify, this basically means that it has a business sense to sum this Metric. Eg. « Revenues » is something you can sum. However, a ratio like « Revenues/ Purchase » is something that doesn’t have much business sense to sum.

To decide which metrics you want in your source, everything depends on your use case. However, it’s safe to say that you want at least the metrics that you need to compute the KPI you want to explain. Then you would need all the metrics that are required to compute your « market equation ». Please report to Metric Relation section for more details.

For more information, you can also read our article about metric relation.

Dimensions

Dimensions can be either dates, characters, or even numeric values.

To decide which dimensions you want in your source, you may want to think about which dimension has an impact on your business, but also which dimension you’re able to collect, and cross your metrics on. At any rate, you certainly want to have one dimension that is the dimension you want to compare on. E.g. if you want to compare two periods, you want a ‘Period’ dimension. If you want to compare two business units, you certainly want a ‘BU’ dimension.

If a dimension is continuous (i.e. numeric) and has more than 6 possible values, it will get discrete by a partition algorithm, in order to be able to compute mix effects & performance. See Clustering methodology.

Number of dimension are theoretically unlimited. However, as your data set get bigger and bigger when you add new dimensions, you may want to limit yourself to a set of 3 to 8 dimensions, just for performance reasons.

Tip: Datama PIVOT is a tool that can help you in selecting and understanding the dimensions you’re selecting.

Warning: Datama JOURNEY requires at least a ‘Journey’ column within its dimensions. See Journey Source for more details.