Successfully Run your 1st DataMa report and learn how to use DataMa Compare (and DataMa Prep)
Let’s start with a simple case, with an excel dataset. There are multiple other ways to load data.
Step 1: Check your data
Check your column :
- 1st column is what you want to compare (date, device, country…)
- Followed by the rest of the dimensions (if any)
- And after come the metrics, quantitative columns which are summable (no ratio, %…) in the order of a funnel or what we call “Market Equation”.
Read more about source
In the “Get inspired” section you will find examples of workbook in multiple area (AB Test, Business Performance, Marketing,…)
Step 2: Create new Workbook
Here is the Homepage of DataMa with all the workbook saved by you or your team
Click to “Add new workbook” to access DataMa Prep and connect (or load) your data.
Step 3: Add your source to Datama Prep
In the list of available connectors select the one that match your data source
Step 4: Check your Column and define your steps
In the DataMa output block:
- Select the columns that should be considered as a Dimensions and Metrics
- Define the steps of your metric relation and refine your case (adapt name, define a unit, or a threshold,…)
Read more about the Output block
If your dataset is properly split between Dimensions and metrics, and the metrics relations makes sense, you can select a DataMa solution.
Bonus: Check your Column and define your steps
What is a waterfall graph ?
A waterfall allows to quickly identify and understand the factors that cause your performance indicator to rise or fall from Start to End
- As for example, this waterfall below is explaining the gap of -28,1% in Revenue from last year (45,549€) to This year (32,747€)
- Each step is a variation that explain the gap of -28.1% (mainly due to -11.7% of Users and -26.7% of Checkout/ Session)
- When the Checkout/ Sessions drops from -26.7% it has an impact of 12,298€ in Revenue
After seeing the quantitative variation of your Revenue, it’s time to understand what causes this variation.
By clicking on a step, the graph displays the dimension that mainly explain the gap and the impact each element of this dimension has on that variation.
Each variation is split between mix and perf (see article or next slide to understand the difference)
The Moves « graphe » is a representation of both Mix & Perf effect
If you still need some information to create your Workbook, just let us know