Skip to content

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 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.

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.

  • 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.