Skip to content

Quick start

This guide runs a first Compare analysis: it explains the variation of one KPI between two periods. It takes about ten minutes once your data is ready.

Datama reads a table with one row per segment and period:

  • a column for what you want to compare, often a date, or a dimension such as device or country;
  • the other dimensions that may explain the variation (channel, country, product…);
  • the metrics: quantitative columns that can be summed, with no ratios or percentages, ideally in the order of your funnel (sessions, then orders, then revenue).

See Data requirements for details and examples.

Web app

In Datama Studio, click + next to the story tabs (Add a story).

Looker Studio, Tableau, Power BI, Qlik

Add the Datama visual to your report, then map your dimensions and metrics to its fields. The page of your tool in Environments describes both steps. Then go to step 4.

Excel, Google Sheets

Open the Datama add-on and select your data. The page of your spreadsheet in Environments describes both steps. Then go to step 4.

AI Skill

Install the skill and give it your data. See AI Skill. The steps below explain how to read the result.

Web app

In the Create a story window:

  1. Type a Story title and, if you like, pick a Story icon.
  2. Under Choose a preset, select Compare. The Modules list now holds a Waterfall module.
  3. Keep Display on Scroll and Layout on Default.
  4. Click Create.

See Create a story for every option.

Datama proposes a first set-up from your data. Check the two settings that matter most, then click Apply:

  • the comparison: the two periods or segments to compare (Start and End);
  • the market equation: how your metrics combine into your main KPI.

The waterfall explains the gap of your KPI from Start to End. For example:

  • Revenue fell by 28.1%, from 45,549 € last year to 32,747 € this year.
  • Each bar is one step of the market equation: here, users fell by 11.7% and checkouts per session by 26.7%.
  • The size of a bar is its impact on revenue: the drop of checkouts per session costs 12,298 €.

Click a step to see which dimension explains it best, and how much each of its segments contributes. Each contribution splits into a mix effect and a performance effect (see Key concepts).

Web app