Excel
This page does not apply to the environment you selected. It covers: Excel.
In Excel, Datama is an add-in: it analyses a range of your workbook, without exporting it to another tool. Use it to analyse operational data where it lives, or to prototype an analysis before moving it to a BI tool.
Install the add-in
Section titled “Install the add-in”Install Datama from Microsoft AppSource, or in Excel from Home › Add-ins, searching for Datama.
If your Microsoft 365 account is managed by your organisation, your administrator may need to install it for you.
Prepare and select your data
Section titled “Prepare and select your data”Datama needs an aggregated table, like a pivot table: dimensions first, the dimension to compare on in first position, then the metrics of your market equation. See Data requirements.
Open the add-in, then check in its side panel that the right range is selected. Datama detects the dimensions and metrics; adjust them if needed.
Settings
Section titled “Settings”- Paste your licence key in the Editor settings tab.
- With a paid licence, click Save in the header of Datama: your settings are stored in the Config JSON field of the Editor settings tab, and come back when you or others reopen the workbook.
- Turn Edit mode off in the Editor settings tab so others only see the analysis.
See Environments for the trial and the licence, and the Excel add-in privacy policy.