Skip to content

Tip of the week

Every week, Datama publishes a tip or a trick to get the most out of the product. The same tips appear in the news panel of Datama.

Some older tips mention the previous names of the product: Datama Light for the extensions, Prep for data layers, and workbook views for stories.

The tips are also published in French: Astuces de la semaine.

Keep your waterfall readable with Remaining

5 November 2026

Too many bars on your waterfall when you explore a step ? 📊

In Datama Compare, only the most impacting bars stay visible. The rest are grouped into a single Remaining bar, so your story stays readable and nothing is lost.

How to do it 👇

  • 🔢 Settings › Compare › Items displayed: choose how many bars stay visible before Remaining (6 by default, up to 50)
  • 🖱️ Click Remaining to expand more elements
  • ↩️ Right-click › Regroup remaining to collapse them again
  • 🧮 Group equation steps: turn it on to let market equation steps be folded into Remaining too (off by default)

✨ A clean slide for your audience, and the full detail one click away.

Show the gap with Difference arrows

29 October 2026

Want the audience to see the gap, not just read it? 🏹

In Datama Compare, add a think-cell style Difference arrow between two bars of your Waterfall. It stays anchored to the data, so it survives drill, reverse axis and layout changes.

How to do it 👇

  • 🖱️ Right-click the Waterfall and choose Annotate › Difference arrow
  • 📏 Link two bars: the level difference between neighbours, or the total difference across a range of steps
  • 📈 Optional: a CAGR-style growth arrow
  • 🎨 Click the line to cycle through the three style presets
  • 🔢 Click the label to switch between % change, impact in points and both

✨ The key gap of your story, highlighted in one slide-ready visual.

Four keyboard shortcuts to speed up Datama Compare

22 October 2026

Still reaching for the mouse every time you change view? ⌨️

The redesigned Datama Compare extension has four keyboard shortcuts. Flip your story from Waterfall to Tree, reverse the axes or jump straight to a setting, without leaving the keyboard.

Try them 👇

  • 🔄 Shift + R: reverse the axes of the Waterfall and / or the Tree
  • 📊 Shift + W: switch to the Waterfall view
  • 🌳 Shift + T: switch from the Waterfall to the Tree
  • 🔎 Shift + S: open the settings panel with the cursor already in the search bar, which also finds the options of the analysis panels (Comparison, Modeling, Dimensions…)

✨ Faster live demos, and the right setting one search away.

What If, test a scenario before you commit

15 October 2026

What would happen to your KPI if conversion improved by 10%? 🔮

With What If in the Datama Compare extension, simulate it on your own data and read the answer in the usual Waterfall, Tree or Table. No spreadsheet on the side.

How to do it 👇

  • ⚙️ Open Settings › What If and add a scenario: give it a name and pick the baseline (whole dataset, or a dimension with selected segments)
  • 🎯 Add a KPI impact: choose a step of your market equation, an optional segment scope, and a relative (%) or absolute change
  • ✅ Turn on Use as comparison, then Apply: the waterfall now compares baseline vs scenario
  • 🖱️ Faster: right-click a waterfall bar to create a scenario already prefilled with the step and segment
  • 📌 Pin an impact to get a live shortcut on the visual

✨ Know which lever is worth pulling before you pull it.

📖 Learn more about What If

Make your waterfall look like your brand

8 October 2026

Your analysis is right. Does your waterfall look like your brand? 🎨

In the Datama Compare extension, every visual detail is yours to style, live, without recomputing anything.

How to do it 👇

  • 🎨 Settings › Colors › Palette: pick a palette, or click a swatch to set your own Up, Down, Start and End colors
  • 🔤 Settings › Chart: restyle the Slide title, the Chart title and the Comment
  • 🏷️ Settings › Waterfall › Labels: tune the Values and Top line labels (size, weight, font, color, position)
  • 🖱️ Shortcuts: right-click a bar, a value label or a top-line label of the Waterfall to restyle it right where it is
  • ⚡ Start from a Preset (Modern, Vintage, Presentation…), then refine

✨ A slide-ready visual in your own colors and fonts.

Note: with the Datama skill, you can edit the style of your waterfall directly through a prompt.

Explore your market equation with 'Sub-steps'

1 October 2026

Does your market equation break down into several levels? 🔎

With ‘Sub-steps’ on the Datama Compare extension, nest equations inside a step. Example: Revenue = Sessions × Conversion Rate × AOV 💶, then detail the Conversion Rate as Add to Cart Rate × Cart to Order Rate 🛒. Sub-steps apply to both the Waterfall 📊 and the Tree 🌳.

How to use them 👇

  • ⚙️ Open Settings › Market Equation and build your steps with the card editor: hover a card → ‘Add a sub-step’, indent / outdent, edit the formula
  • 🏷️ Prefer meaningful step names: formulas reference steps by name, and names must be unique among steps (the Main KPI may reuse a step label)
  • 🖱️ On the Waterfall 📊, right-click a composite bar → ‘Split by › Sub-steps’ to open it into its child sub-steps, and find the same hierarchy in the Tree 🌳

✨ Perfect to explain a variation down to the smallest stage of your funnel 🚀

📖 Learn more about Sub-steps

Out of scope, Layer Source & more in Datama Extensions

24 September 2026

New Datama Extensions version is out. Six upgrades to sharpen Compare and every visual 🚀

  • Out of scope segments 🧭 : new and discontinued segments move into their own bar after Start, so volume, mix and performance stay like-for-like.
  • Layer Source 🔍 : preview the data behind any visual with See Source, and edit it in PowerPoint, HTML exports and the Datama AI skill.
  • Long tail clustering 📊 : pool the smallest segments into “Other” while it stays under X% of your KPI, however long the tail.
  • Source text variables ✍️ : inject a source column value into any text with @Column[n]. Titles and labels follow your filters.
  • Hierarchical mix 🪜 : cascade mix effects along the hierarchy so each level is measured against its parent.
  • Excel Export output 📤 : write waterfall results into a worksheet table on every compute, ready for your formulas.

📖 Learn more about Out of scope · Layer Source

New features on the Compare extension

17 September 2026

Four new powers just landed in Datama Compare 🚀

  • What If scenarios 🔮 : simulate a KPI impact and watch it flow through your Waterfall, Tree, or Table.
  • Sub-steps 🧩 : break a step into its own mini equation, then split its bar by sub-step.
  • Covariance, tamed ⚖️ : choose per step if it should catch the covariance, or isolate it in its own bar.
  • Remaining bars 📊 : the 6 most impacting bars stay visible by default (up to 50), equation steps stay out unless you opt in, right-click to Regroup remaining.

📖 Explore all new features

Stage your waterfall story with 'Sub-pillars'

10 September 2026

Want your waterfall to tell a clearer story to stakeholders? 🧑‍💻

With ‘Sub-pillars’ on the Datama Compare extension, add checkpoints 🚩 on the waterfall, without changing your market equation.

How to use them:

  • Right-click a bar → ‘Add pillar’ (before or after)
  • Name the checkpoint (e.g. “After mix”, “After price”) and choose the impact reference (vs previous net or vs Start)
  • Edit them later under Waterfall › Elements › Pillars, or remove them with a right-click then select ‘Remove pillar’

✨ Perfect to stage the narrative of the variation step by step.

The redesigned Datama Compare waterfall is here

1 September 2026

Datama Compare just got a major upgrade — and your waterfall analysis will never feel the same 🚀

The redesigned Compare is now rolling out in marketplace extensions (Power BI, Tableau, Looker Studio, Qlik, Excel, and more). Here is what changes the game:

  • Drill without limits : explore by dimension or by step, as deep as your data goes, with smooth morphing bars and a narrative that follows every split
  • Stage your story : drop custom pillars on the waterfall (“After mix”, “After price”) and define dimension hierarchies (Country → Region → City) in seconds
  • One view : pin Waterfall, Table, Tree, and Comment side by side; every hover and drill stays in sync
  • Settings where you need them : right-click any bar, use the hover shortcut bar, or open the searchable side panel; no more hunting for the right toggle

👉 Open Compare in your favorite BI tool and feel the difference. Same serverless security, far more power at your fingertips.

📖 Explore all new features

Interactive Datama extension in PowerPoint

3 August 2026

Would you like to display your Datama charts interactively rather than as screenshots in your PowerPoint slides? 📊

With the free HTML viewer by Datama PowerPoint add-in, keep Compare, Detect, Assess, and Explore interactive inside your presentation—including in slideshow mode.

How to use it:

  • Install the add-in from the PowerPoint marketplace (search for HTML viewer by Datama or Datama) 🔌
  • In another Datama extension (Compare, Detect, Assess et Explore), click on the Export button ⬇️
  • In PowerPoint, import via File upload or paste the HTML in Custom code 📥

✨ Same interactivity as in the source extension (zoom, drill-down, filters)—with a fixed dataset from the HTML export. Completely free, as a complement to your existing Datama extensions.

⬇️ Download it from the marketplace

📖 More informations in the documentation

More focused Extension Datama Detect

23 July 2026

With the Extension Datama Detect, you can make anomaly detection smarter and more focused by setting a minimum impact threshold and choosing exactly which steps of your metrics relation can be reported as anomalies in the right panel where metrics/segments are ranked per impact on the main KPI.

In the “Settings” in the “Scope” section, you can define:

  • 🎯 Last point only: analyse only the last point or all the available points (by default).
  • 🚩 Above/ Bellow flag: choose to focus on positive or negative anomaly.
  • 📊 Min impact threshold: ignore anomalies with too little impact on your global main KPI — set at 0.5% by default, and adjustable to focus on what truly matters.
  • ⚙️ Considered Steps: keep all steps in your metrics relation, but exclude the ones that should not trigger alerts.

👉 You get the list of anomalies, prioritized by impact, exactly on the scope that matters for your business.

Mix and Performance effects

9 July 2026

To dig deeper 🔍 into the cause of a change, the Split Mix Effect and Performance Effect help you break down the drivers behind your results:

📊 Mix Effect highlights the impact of changes in distribution.

📈 Performance Effect isolates the actual change in performance.

Both effects are available directly in:

  • 🌊 Waterfall visualizations (by expanding a step when Mix effects are significant)
  • 🧭 Moves visualizations (for a vector view of the variation)

Note: In the settings, there is a “Split Mix & Perf” option where you can choose between “auto,” “always,” or “never” for the display

Customize your comments with the “Edit sentence” feature

2 July 2026

In Datama Light extensions, you can tailor the comments generated by Datama to perfectly match your tone and business needs using the “Edit sentence” feature (accessible via the “Edit template” pop-up window). This allows you to fully customize the wording of the analyses without altering the underlying analysis. ✍️

🧩 Tailor the wording: modify sentences to match your internal vocabulary or reporting style

🎯 Highlight what matters: emphasize specific dimensions (e.g., Channel, Region…) in your narrative

🔁 Use dynamic variables: leverage placeholders such as {step.name}, {step.variation}, or {list} to keep your insights automated while still being personalized

🎨 Control the formatting: add structure and clarity to make your insights easier to read and share

Analysing your margin carefully

25 June 2026

Does your margin analysis really give you the right answers?

Between the effects of volume, price, costs and product mix, in-house Excel models often end up creating more uncertainty than helping with decision-making. 🤨

Result: discrepancies that are difficult to reconcile and, at times, misguided corrective actions. ❌

Find out how an additive breakdown can precisely identify the drivers of margin variation in this article. 📖

An ideal use case for the Datama Excel add-in to share with the finance team. 🤓

Datama, right in your AI chat

15 June 2026

A big shift for anyone who already works with an AI assistant 🤓

You can now get a real Datama visualization — waterfall, breakdown, drill-down — delivered straight in the conversation 🎉

Ask a business question in plain language. When it’s relevant, your assistant doesn’t just answer in text: it renders Datama for you, interactively, in the chat.

  • “Why did revenue drop between Q1 and Q2?”
  • “Break down conversion by device and channel.”
  • “What drove the change in margin on mobile vs desktop?”

No switching tools. No rebuilding a chart by hand. The analysis shows up where you’re already thinking.

➡️ Why teams love it:

  • Stay in the flow: explore a KPI variation without leaving Claude, Cursor, ChatGPT, or your usual AI workspace.
  • Instant insight: a full interactive visualization — not a static screenshot — ready to open, share, or dig into.
  • Your data stays yours: everything runs in the browser; nothing is uploaded to Datama servers for rendering.

Install the Datama Skill once from your account, then just ask. The assistant knows when Datama is the right answer.

🖱️ Get started with Datama Skills

Automate your exports 🗓️

11 June 2026

A properly configured export ensures that the right information reaches the right people at the right time.

✨ That’s why in the Datama web app, you can schedule your reports to be sent automatically:

  • Via email, Slack or Teams 📩
  • At the frequency of your choice (daily, weekly, monthly… on the days of your choice) ⏰

💡 Be sure to test your export (using the “preview” and/or a test send) before activating it to verify the output and recipients.

Reverse Axis – change your perspective in a single click

28 May 2026

In Explore charts, Waterfalls or decision trees, do you sometimes struggle to find the most intuitive view for your audience, or are you limited by space on your dashboards?

👉 Try the “Reverse Axis” feature.

With a single click, it lets you switch from a horizontal view to a vertical one… and vice versa 😉

Use Datama Spreadsheet for Excel-like work on BI data

8 May 2026

Despite years of beautiful dashboards and governed metrics, many teams still export to Excel for the last mile—formatting, ad hoc layout, and cell formulas that never quite fit in SQL or the BI calculation layer. Datama Spreadsheet leans into that habit: it gives you an Excel-like interface inside the BI tool, so you stay in context while you work the grid.

What it is: pivot-style mapping (Rows, Columns, Values) plus spreadsheet features (formatting, filters, functions). Built on the open-source Luckysheet project.

Licensing: the extension is available to all for free. For Tableau and Power BI, you still need an extension licence aligned with your contract so viewers can access the visual.

Where it runs: light extension in Tableau, Power BI, Qlik, and Looker Studio (not in Google Sheets or Excel, obviously!).

Getting started: Looker Studio, Power BI, Tableau, Qlik.

🖱️ Overview: Datama Spreadsheet

Use Datama Compare as a Microsoft Excel add-in

4 May 2026

A big step for everyone who works in Excel 🤓

You can use Datama Compare directly in your workbook 🎉

  • Install from the Microsoft AppSource listing, or in Excel go to Home > Add-ins and search for Datama Compare (if your Microsoft 365 is managed by your organization, an admin may need to allow the add-in first).
  • Prepare an aggregated table (KPI, comparison dimension, steps, explanation dimensions)—same logic as in our other Compare extensions.
  • Open the add-in task pane, select your data range, adjust dimensions and metrics if needed, then run the analysis.
  • Optional: start a paid trial from the footer to unlock branding removal and saved settings; paste your licence key under Editor Settings as described in the docs.

➡️ Why teams like it:

  • Stay in the grid: explain variations where the data already lives—no copy-paste into another tool.
  • Live what-if feel: change numbers or scenarios in the sheet and re-read impact on the waterfall and tree as you usually iterate in Excel.
  • Full Compare toolkit: waterfall and performance tree, smart scoring, mix effect, intelligent comments, and interactive drill-down.

🖱️ Learn more in the Excel Compare documentation

‘Compare by Metric’ in the Compare Light extension

30 April 2026

Do you have pairs of metrics in your dataset (e.g., Sales and Sales N-1, Units and Units N-1)?

👉 ‘Compare by Metric’ is perfectly suited for this use case. It allows you to directly compare these metrics with each other and explain variations in a KPI without relying on a simple time-series comparison.

⚙️ To enable it:

  • Go to settings
  • Select Compare by “metric”
  • Then select the currency pairs in the order specified in your market equation

Adjust your market equation at any time

23 April 2026

With Datama, you can define and update your market equation at different times, depending on your needs.

🛠️ When creating your use case: define your initial equation in Datama Prep whilst configuring your dataset.

🔁 During analysis: adjust it at any time directly in the ‘Settings’ of each solution (Compare, Detect, Assess…) to refine the steps by:

  • adding/removing steps
  • renaming steps
  • defining units
  • and adding ‘Focus’ or ‘Excluded’ dimensions

PS: a handy shortcut using CTRL + F and searching for ‘market equation’ gives you direct access to the market equation menu 😉

Using the Overlay Feature in Datama Explore

9 April 2026

With the “Overlay” feature in Datama Explore, display your chart as an overlay to get a clear view of the variations in your KPIs based on the dimensions shown.

For example, when comparing:

  • dates, you’ll see periods with significant variations 🗓️
  • other dimensions, you’ll identify the segments that have varied the most in your comparison 📈

➕ New metrics are available for this visualization, including absolute and relative variations of your indicators.

A simple way to highlight variations! 🚀

Use Datama as a Google Sheets extension

1 April 2026

Happy day for all Google Sheets users! 🤓

You can now use Datama Compare directly in Google Sheets 🎉

  • Install it from Google Workspace here
  • Open your favorite spreadsheet in Google Sheets
  • Select a range of data cells on which you want to analyse variations
  • Click on Extensions > Datama Compare
  • Define your settings & licence key and click on “See Chart”
  • Save your use case with a name so that others can use it

➡️ Main advantages of using Datama in Gsheet are :

  • Seamless & Self Service: Anyone with access to the spreadsheet can explain variations without leaving the spreadsheet
  • Modelisation: Exploring live scenarios impact by changing the data and see the impact on analysis immediately in “Excel” mode
  • Security: No data shared outside of Google Sheets
  • Democratization: If installed in Google Workspace at the organization level, anyone will have access to Datama directly

🖱️Click here to learn more

PS: For Microsoft Excel users, quick teaser, this might come also soon on your side 😘 #Teaser

Focused & Excluded Dimensions in the Market Equation

26 March 2026

At certain steps of your market equation, you may want to:

  • focus primarily on breaking down that step by a specific dimension 🔍
  • or exclude a dimension that isn’t relevant to a given step 🔻

You can do this in the market equation menu by adding the dimension in question to the corresponding “Focused Dimension” or “Excluded Dimension” column 🤓

Note: For the main KPI, this prioritization or exclusion has an impact in “Dimension then step” mode 😉

Dynamic filter enablement

26 February 2026

In Datama Waterfall, you can refine your analysis in just a few clicks using the segment filter.

  • Hover over the segment you want to focus on
  • Right-click and select Keep only or Exclude
  • The Waterfall chart is instantly recalculated based on your selected scope

A quick way to deep-dive into what really drives your performance 🚀

Secondary Comparison fonctionality

19 February 2026

Want to go further in your analysis on Compare?

In Datama Compare, you can activate a second comparison. This allows you to display, in the background of your waterfall chart, the variations of another comparison or, if the periods are successive (comparison of period A to B and B to C), it will be displayed as two successive waterfall charts. 🤓

Ideal for highlighting your current results by comparing them, for example, to the same period last year… 📊

Give context to your KPIs with Datama Calendar.

12 February 2026

When detecting anomalies and explaining variations, behind the data correlations that Datama helps you find, there are often more “qualitative” or “contextual” root causes for changes in performance. Holidays, campaigns, product launches, incidents, etc. all have an impact on indicators, but they are rarely taken into account in the analysis. 🗓️

With Datama Calendar, you can easily add business events (internal and external) to your dashboards and instantly visualize their impact on your KPIs. 📊

Check out our online demo ▶️

Connect your Metabase data to Datama

5 February 2026

Good news for all Datama clients!👋

You can now connect your Metabase data directly to Datama 🚀

  • Connect Metabase via API (see here to generate your API key in Metabase)
  • Select the project you want to connect
  • Copy the SQL query from Metabase and paste it into Datama Prep
  • Apply to instantly load your data into Datama

NEW GA4 Annotation available in Calendars

22 January 2026

Good news: a new calendar connector is now available in Datama! 💡

Google Analytics Annotations can now be retrieved automatically via Calendars.

All events added directly in GA4 are imported into Datama and can be used like any other calendar 🗓️

This allows you to cross-reference Google Analytics annotations and business performance in your workbooks without having to re-enter data 😉

Make the most of your calendars in Datama

15 January 2026

Calendars are coming to Datama and will become a key tool for better understanding your performance by integrating events 🎇🎆

You can now create or connect calendars from different sources (Google Sheets™, Google Calendar, BigQuery, Excel, etc.) and synchronize them automatically.

By connecting them to your workbooks, you can find your events in:

  • the Helpers 📊
  • the enhanced comments 📰
  • the Light extensions on Detect and Explore 📉

Bonus: from Tableau, Power BI, or Qlik, you can create an event with a simple right-click. Datama thus becomes your central repository for key events. 📅

AI-generated datasets 🤖

18 December 2025

You can now generate a synthetic dataset simply by describing your use case via a prompt. In a matter of seconds, a complete dataset is created… along with the associated market equation This breakthrough is ideal for prototyping and testing ideas 💡 without the need for real data. Simply select the block ✨ in Datama Prep, describe your needs, validate the equation, and then generate your use case 🎯 This saves time for brainstorming and experimenting! 🧪

Unlock dynamic insights with Datama Explore! 💡

11 December 2025

Good news for all Datama clients! We’ve launched—now in beta—the new Datama Explore (aka Helper), available on Datama Web and as an extension to anyone with a Datama licence. This extension streamlines your setup while enriching your analytical capabilities with:

  • Self-service flexibility ⚙️ Instantly select any dimension, metric (Market Equation), and visualization type—no need to pre-build complex parameters in your BI tool.
  • Instant variation analysis 📈 Define comparisons on the fly to automatically generate Δ and % Change metrics across all KPIs.
  • Advanced charts 📊 Leverage exclusive visuals such as Moves (to understand mix effects) and Mekko (to explore size and composition) for deeper insights.

Check out our dedicated webinar and documentationto learn more

NEW AI generates your market equation ✨

27 November 2025

With a single click from the output block in Prep, AI now suggests a market equation based solely on the names of your columns and any optional context you provide (to specify the currency, for example, or the analysis you want to perform).

  • No data from your dataset is shared—only metadata (column name and data type, e.g., string, float, date, etc.)—to ensure complete confidentiality 🔒
  • You can use your own OpenAI key to maintain control over the license 🔑

A first step towards integrating LLMs into data preparation and analysis…more to come soon 🚀

Ensure Accurate GA4 Data with Datama Prorate ⚖️

20 November 2025

If you regularly export data from GA4, you’ve probably noticed that some metrics can be double-counted when broken down by certain dimensions. For example, if you export your sessions by product type, any session that views multiple products will be counted more than once. With the Prorate feature in Datama Prep, this issue disappears💡 By enabling “Prorate metrics totals” before loading your GA4 data, you can safely pull metrics without inflating totals — whether overall or by dimension ✅ Give it a try and let us know what you think!

Save your customized settings in Datama Extension

30 October 2025

💡Good news for Premium users!

If you’re using Datama Extension in Looker Studio, Power BI or Qlik, you can now save your customized settings anytime with just a few clicks:

⚙️ Customize your settings → Click Save → the Config JSON is automatically copied → Paste it into the Config JSON field

For Tableau users, it’s even simpler — just click the Save button 💾

Next time you open this use case, it will automatically display your last saved configuration ✅.

New Dimension Helper

23 October 2025

New Dimension Helper is now available in Datama in Beta. You can access it by selecting the new version in the top-right panel of Filters or Comparisons. Here’s what’s new and improved:

  • Split any dimension by any other dimension, including Comparison dimensions ✨
  • View two metrics at once, across both market equation steps and original dataset metrics 📊
  • Smooth animations with seamless transitions help you intuitively understand what’s being visualized 💫
  • Table view that allows a quick access to a tabular version of your data and export to a spreadsheet with a single click (as CSV copy) 📝
  • Easily switch between views like Bar + Lines, Overlay, and Moves thanks to multiple preset charts 💡
  • Faster calculations and an improved legend compared to the previous helper ⚡

Dimension then Dimension in Datama Compare extension

16 October 2025

In the Datama Compare extension (on all visualization tools), you want to analyze a single metric with multiple dimensions (at least 3).

Datama allows you to automatically analyze your primary breakdown (e.g. Country), which will make up the stages of your Waterfall, and then the most relevant dimension (e.g. Channel) when you zoom in on a stage 🔍, all without any additional transformation 💡

Select your primary breakdown via the “Breakdown by” dropdown that appears at the top of the waterfall 🤓

Metric comparison in Datama Extension

9 October 2025

You can now directly compare two metrics (numeric columns) in Datama Extension!

For example, if you need to compare your Budget and Actual Revenue, it only takes a few clicks.

  • ✅ Make sure both metrics are added in the Setup panel of your BI tool.
  • ⚙️ Go to Settings → Comparison Definition → Compare by Metric, then select the metrics you want to compare, give this step a name, and click Apply.

New Cluster Method in Datama Prep

18 September 2025

To reduce the size of your data, Datama offers several methods in the “Clean” block in the “New clustering field” section. The “Top X based on Rank” method has just been added 🆕

With this method, you can now:

  • Keep only the best-performing segments of a dimension according to a given metric 🎯
  • Group all other segments into an “Other” bucket.

This approach reduces the size of your data and allows you to focus on the essentials while maintaining the relevance of the analysis 📊

Update on GA4 source filtering in Datama Prep

11 September 2025

Great news for Datama Prep users working with a GA4 source: you can now build more advanced filters by combining “AND” and “OR” clauses, up to 3 levels deep 🤓 This makes it easier to extract the exact number of users or sessions who performed at least two different types of actions/events💡 Reminder 📝: the GA4 source is still subject to API limitations. Always make sure your chosen metrics and dimensions can be queried together (both in the data you retrieve and in the filters you apply).

One workbook, multiple exports

14 August 2025

Want the same workbook to reach different teams in different ways? With Datama Export, schedule the same report via multiple channels, at different frequencies, times, and formats—all from one place. Before scheduling, you can:

  • Preview : see exactly what will be sent 📧
  • Test : send a test export that mirrors the scheduled run 🗓️

Make Datama work your way. 🚀

Datama Assess tells you how significant your KPI changes are

31 July 2025

When you’re tracking KPI variations between two periods (e.g., this week vs. last week), you usually know how much the KPI changed — but not how meaningful that change is compared to historical patterns.

That’s exactly what Datama Assess – Volatility helps with.

Let’s say your average basket dropped by x% from Week 45 to Week 46. With Assess, you can instantly compare this variation with previous week-to-week changes (Week 44 → 45, 43 → 44, etc.). This allows you to understand whether the drop is within the normal range — or whether it’s an outlier worth investigating.

🧠 In short: you stop reacting blindly to KPI movements and start knowing when they truly matter.

👉 Try it now on our website version or directly in the Datama extension (Looker studio, PowerBI, Tableau, and Qlik).

Enable anomaly detection on the last X points

24 July 2025

Until now, you had two options for anomaly detection on Datama Detect Light: either the entire dataset or only the last point. Not very granular, we admit 😓

Now you can choose how many points you want to monitor for anomalies! 🎯

Use case: do you send weekly reports? Set Detect to analyze only the last 7 days. Result: a prioritized list of anomalies over the last week, without unnecessary noise from past weeks.📅

Get precise GA4 data: no more sampling

17 July 2025

If you connect Google Analytics to Datama and work with large datasets, GA4 might sample your data — which can lead to inaccurate insights. Fortunately, the new “Avoid sampling” option in Datama Prep solves this! 💡 With one click, you can split your dataset into smaller chunks, so GA4 treats them as unsampled. You would get more accurate data, better decisions. 🎯 Try it now and see the difference in your analysis! 📊

Detect anomaly on segment of your data (available on Datama Light Extension)

19 June 2025

On Datama Light extension, a new feature is available to spot anomalies like never before! 🔎 Our latest update enables multi-dimensional outlier detection, giving you the power to uncover anomalies within any segment of your data dimension. Example 📊: Say you’re analyzing performance by device category. While the global average may look fine here on session, Datama can now detect an unexpected spike or drop in a specific segment (uplift on mobile compensated by a drop on desktop). Plus, each anomaly is scored for impact visible in the side table, so you focus on what truly matters first. ✨ Find an instructional video here 👈

New functions available for calculated fields in Datama Prep!

22 May 2025

Two new functions have been added to enhance your data transformation capabilities in Datama 🤓:

  • CASE(): Works like a CASE WHEN in SQL.
  • REGEX_CONTAINS(): Allows you to use regular expressions on strings and returns a Boolean ✅ These additions facilitate the segmentation, cleansing and manipulation of your data directly in Datama 🚀 Find all the functions available here 👈

New source block in Prep: Table Connect

23 April 2025

You can now link Datama directly to a full table in Prep—no need to write a specific SQL query. Just connect your table in BigQuery, Snowflake, or Redshift, and handle all your filtering, comparisons, and clustering directly in Datama with our NoCode feature.

⚡Datama pulls only the data you need, auto-aggregates dimensions, and keeps things light and fast—so you can focus on insights.

🗒️Please note that after a table connect block, data refinement blocks cannot be used for the moment (e.g. “Clean”, “Aggregate” …).

Smarter connections, faster insights. Try it out! 💡

Datama Prep «multiple date ranges» available for GA4 and Piano sources!

27 March 2025

🚀 New feature available in Datama Prep! It is now possible to define several date ranges in the same source block for GA4 and Piano connectors. 🎯

  • This avoids the need to create several separate blocks (e.g. one for last year and another for this year) and then merge them.
  • What’s more, you can add a «Date range» column to facilitate comparison, without having to use a date dimension. 🔥

New Journey Sankey visualization!

16 January 2025

Besides Sunburst for visual observation of user journey, the Sankey diagram is available as an alternative option for journey’s visualization 🌍

This is particularly useful to visalize “loops” of multiple iterations on the same touch point. 💡

As with Sunburst, Sankey is available in comparison mode to study behavioral differences on two different segments 🕵️

See how far the analysis of just one metric can take you with Datama auto unpivot function! 🌟

10 January 2025

Got a single summable metric in your table without an suggested market equation? Unlock its full potential with the Datama Unpivot function! 🌟

This tool suggests you unpivoting your unique metric on a dimension of the dataset and automatically create the market equation to match the sum of each segment of that dimension. 👇

You can then easily analyse by “Dimension then Dimension” in Datama Compare! 👇

How to use it: 🔧

  • Upload your data source with a single metric, and click “Apply” of the pop-up at the bottom right. ➕
  • Select Datama block then click “Define steps” to review the automatically summarized metric equations by dimension categories in the left panel. 📂
  • Click below “Open in Compare” to explore metric KPIs across dimension categories. ✅

📊 Make your limited data source tell more than expected!

Optimize your data with the Datama Aggregation block! 🌟

20 December 2024

Struggling with massive datasets? Want to reduce them without losing key insights? ✂️ Discover the Datama Aggregation block!

This tool in Datama Prep lets you group by one or more keys (dimensions) and apply aggregations like sum, mean, or max… to your metrics. ✨ The result? A lighter, more manageable dataset.

How to use it: 🔧

  • Click + at the top right of your source block. ➕
  • Select Aggregate and adjust the keys and aggregation settings in the left panel. 📂
  • Click Apply to instantly get a condensed output table! ✅

📊 Streamline your data—your way!

Take advantage of Smart Interval for more accurate anomaly detection 📈

3 October 2024

In Datama Detect, when using observed volatility to detect anomalies, the “Smart Interval” button is enabled by default (Settings > Detect methodology > Use smart interval). 😊

Smart Interval calculates a theoretical confidence interval using the Wilson method. This improves the accuracy of anomaly detection, especially for values close to 0 and/or for detecting hourly anomalies. 🧠

Try it out to optimize your ratio analysis! 🎯

Create Your Organization and Invite Your Team Members!

11 July 2024

By creating your own organization, you can now have a collaborative space where you can work and share your use cases with several users 🤝

In a few clicks:

  • Create your Organization 🏢
  • Invite your team members 📧
  • Manage all accesses 🔐

The feature is in beta for now, so ask for Beta access from your CSM and then click on “Organization > Information” to start creating your organization! 👥

Only flag anomalies above or below the confidence interval

23 May 2024

Using Datama Detect, you can send instant notifications for when your key metrics fall outside of the confidence interval 🔔 Now, you can decide to flag anomalies only above or below confidence interval using the appropriate input in the settings ⚙️ This allows to get notified only when a KPI goes down (aka “bad news” 😅) , for instance. Of course, you can also choose to only keep those above ⬆️, or keep the default of showing both ⬆️⬇️