Tips of the week !

Every week, Datama publishes a tip or a trick on how to best take advantage of the software

Tip of the week 144: New functions available for calculated fields in Datama Prep!

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

Tip of the week 143: New source block in Prep: Table Connect

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! 💡

Tip of the week 142: (Reminder) CTRL + F 🔍 in Datama

Having trouble quickly finding the right workbook, functionality, or tutorial in Datama? Just hit CTRL + F on any Datama page!
Your search results will be smartly grouped into:

Tip of the week 141: Datama Prep «multiple date ranges» available for GA4 and Piano sources!

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

🔔 [Reminder] Your opinion matters!

If you are Datama customer, you recently received an email with our NPS survey. In just 2 minutes, you can share your experience with our solution and help us improve our services.

A huge thank you to those who have already responded! Your feedback is invaluable.

And for the others, we’re eager to hear from you!

Take a moment to fill out the survey 📝 now!

💬 Tell all to Datama chat!

Hey there! Just a heads-up that Datama chat, your direct link to our support team, is here to answer all your questions, receive your feedback, and listen to your insights while you browse the Datama APP.

You can access the chat via the pop-up at the bottom right on the Home page, or by clicking into a use case, selecting Help at the top left, then “Chat with us” 💬—click it again to close it.

Can’t wait to hear from you! 😊

New article on blog: (Re)Discover the mix effect with Datama Compare!

Want to understand the mix effect on one of your KPIs ❓

It’s easy to discover with Datama Compare! ✨

In this article, one of our clients, whose business is sensitive to weather, wanted to understand the impact of outside temperature on their website’s performance. 🔍

This article helps understand how to:

👉 Read our article to learn more!

Tip of the week 137: New Views feature!

Available in Beta 🧪, “Views” allow you to save multiple versions of parameters in the same workbook. For example, you can save one “view” filtered on a specific country and another for all countries, or one with a complex market equation and another with a simplified market equation 🤓

In this way, you can:

Don’t hesitate to contact us to get access to this feature 😉

Tip of the week 136: Use the Datama What if block to test your hypotheses!

Want to see how changes in attributes affect KPIs ❓

Datama What if block in Datama Prep allows you to create scenarios based on your data by making assumptions about KPI variations within a given scope (for example, +10% on the mobile conversion rate compared to last month). ✨

The result? Find the levers that will contribute the most to your goals! ✨

Comment l’utiliser : 🔧

📊 Turn your analytical ideas into actionable insights !

Tip of the week 135: New Journey Sankey visualization!

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 🕵️

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

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: 🔧

📊 Make your limited data source tell more than expected!

Datama wishes you a happy new year 2025! 🎇🎊

As we reflect on 2024, we are proud to have reached here 133 tips shared with you 🌟 to help you maximize the value of our platform and personalize your data analysis experience. A heartfelt thank you to everyone who explored, engaged with, and incorporated these tips into their daily routine — your support inspires us every day! 💖

🎯 In 2025, we’ll be thrilled to bring you even more insights and updates about our solutions, enabling you to unlock the full potential of your data. Together, let’s continue to grow and explore the endless possibilities of data analysis. 🚀

Here’s to a new year filled with innovation, success, and collaboration!🥂✨

Tip of the week 133: Optimize your data with the Datama Aggregation block! 🌟

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: 🔧

📊 Streamline your data—your way!

Tip of the Week 132: Cluster dimensions your way!

Want to cluster certain values in your dataset before analysis? For instance:

🔧 3 Simple steps to get it done:

🎥 Check out our GIF guide for a step-by-step walkthrough.

📊 Refine your data preparation—your way!

Tip of the Week 131: Datama is now Power BI visualization certified!

Datama is continuing its efforts to integrate with your visualization tools (Tableau, Power BI, Looker Studio, Qlik), and this week we’re delighted to announce that we’ve been certified on the Power BI 🎊

What does this mean for you?

Tip of the Week 130: Customize comments in your Datama extension!

✨ Want to add your personal touch to comments while interpreting comparison analytics from the Datama extension in Looker Studio, PowerBI, or Tableau? 🤔 Yes, you can! 🌈 Say goodbye to default comments and hello to your custom insights below the waterfall chart ! 🎉

Only 4 steps to get it done:

  1. Right-click on the sentence you’d like to modify and select “Edit Sentence” to open the settings panel.
  2. 📝 Edit the relevant text in the left coding panel. Check out your changes with a 📺 live preview on the right!
  3. When ready, ✅ click “Apply” at the bottom right to save your changes and see the update instantly.
  4. Need to Reset? Click “Reset” (left of “Apply”) to return to the default style if you want to start over or if an error pops up.

Advanced customization: Click “+Available Variables” for even more options!

🎥 See below our GIF guide for a step-by-step walkthrough.

📊 Make your Datama Extension uniquely yours! Humanize your analytics tools and bring clarity to your data insights!

Tip of the Week 129: Retrieve your Datama license keys and extension for your visualization tools 🔓

Log in to Datama, go to My account > Extensions, and retrieve your license keys and/or extension to integrate Datama into your preferred tools (Tableau, PowerBI, Looker…) 🔑

2 integration options:

With Datama, combine flexibility and augmented analysis in a single solution! 🎯

Tip of the Week 128: Organisation shared credentials 🗝️

As an admin of your organization, you can now share the identifiers of the data sources you have connected with all other users in the organization. 🤝

What to do?

Tip of the Week 127: Detect anomalies faster than ever! 🌟

Want to stay ahead of the curve and catch anomalies the moment they happen? 🤔 Datama’s enhanced anomaly detect service now lets you monitor customer behavior and its impact on your KPIs on an hourly basis! ⏱️

🚨 What’s new?

You can now get notified 📩 within just a few hours of an anomaly occurring, rather than waiting days to discover it. Simply change the alert frequency to “Hourly” in the “Schedule” configuration 🕔 (located at the top-right of the “Anomaly Detect” page). This ensures you’re immediately informed when something goes wrong. ⚠️

🔧 How it works?

This feature is available for any dataset 📊 with hourly updates, making it ideal for users working with tools like GA4, ERP, CRM, CDP, DMP and more. 🖥️

For those who wanna test with GA4, click the link below to explore more: https://github.com/DataMa-Solutions/GA4-Hourly 🔗

📈 Stay proactive and empower your analysis with faster alerts! 🚀

Tip of the Week 126: Take advantage of Smart Interval for more accurate anomaly detection 📈

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! 🎯

Tip of the Week 125: A new Radar Chart!

The radar chart is available in Datama Pivot when analysing all stages of the market equation 🤓

At a glance 👀, you can see how each segment of a dimension is performing on each KPI in your market equation and compare that performance to other segments using a radar chart 🕸️ (aka ‘Spider Chart’). Just click on the second tab of the first Datama Pivot slide to try it out! 🧪

Make sure that no comparison is active, otherwise the slide will not appear. 😉

Tip of the Week 124: Leverage our tips to simplify your analysis🌟

Not familiar with Datama Solution? Looking to explore existing features or discover new ones? 🤔 Every week, Datama sends out a “tip of the week” to help you make the best out of the software.
Don’t hesitate to browse our “tip of the week” section to find valuable insights! Here’s how you can access them:

New article on blog: GA4 and BigQuery - Mind the Data Gaps!🚦

Noticed differences between your GA4 reports and BigQuery exports? ⏳

One of the reason might be that you are using incomplete intraday data, before it transitions to interday tables 📊

To get accurate Datama notifications, you might want to either postpone your schedules later in the day or switch to “fresh daily” tables ⏲

Need to check when your tables are fully updated?

Tip of the Week 122: Customise your exports 📨

Whether it’s Slack, Teams or email exports, you can customise each export with parameters that are independent of the use case backup.

Here are a few examples of what you can change:

Tip of the Week 121: 🛠️ Customize parameters once for all future workbooks 📊

Wanna set up your preferred parameters just once and have them apply to all new workbooks? Don’t forget to configure your “User Preferences”.🛠️

To get started, click on your name in the top-right corner of your homepage and head over to “User Preferences” ⚙️. Here, you can find all the parameters available for customization. For instance, if you prefer to set the “Confidence Interval” to 90% instead of the default 95%, simply click on “Detect Model” 📊 in the “User Preferences” list, adjust the percentage 📈, and save your changes by clicking on “Set As Default”. 💾

From now on, every new workbook you create will automatically apply the 90% confidence interval. 🔄

Make your workbooks work for you! 📝✨

Tip of the Week 120: New ‘Dimension’ menu in settings

When setting up a comparison or filters on a Use Case, you can now configure them in more detail 😀

To access this, when you’re on a Datama solution, go to the ‘Settings’ ⚙️ at the top right and then select the ‘Dimension’ section, you’ll then be able to configure three subsections:

Tip of the Week 119: Create Your Organization and Invite Your Team Members!

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:

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! 👥

Tip of the Week 118: Discover the New Ranking Functionality! 📊✨

In Datama Compare, you can easily see how different segments in one dimension affect your key metrics. By adding ‘Ranking’ and ‘Ranking Change’ to your table view, you can easily see the ranking of a segment on a KPI and the ranking change between the two values you are comparing.🥇🏆

For example, you can see for the dimension “device”, “mobile” changed from rank 2 in the previous period, to rank 1 in the current period. This is equivalent to a ‘Ranking Change’ of +1 ⬆️

To use this feature, click the “Table” tab, click the gear ⚙️ on the top right, and check the boxes for “Ranking” and “Ranking Change”. Try it out now and easily analyze performance trends! 🚀 Happy ranking! 🎉

Tip of the Week 117: New UI Comparison and filter

The latest release brings a host of new features, including a new approach to filters and comparison! 🎉 How does it work? 🤔

First access the comparison: click on “Comparison” then select the dimension you want to compare on (Optional: select “Secondary Comparison” to add an additional comparison).
Then select your segments: choose the segments for each of your comparisons to refine your analysis as much as possible.

What’s new?:

Tip of the Week 116: Reverse waterfall colors for 'negative' KPIs

When using Datama Compare, you can now use the “Reverse palette” toggle to switch the bar colors 📊 This is helpful in cases where you’re using a “negative” KPI where an increase is not good news, so it should be displayed in red instead of green (such as cost) 💸 The “Reverse palette” toggle is available in the Settings > Workbook Style > Language and colors section ⚙️

Tip of the Week 115: Quick set up of the market equation

If you have modified your market equation and you want to return to the basic one, a “Quick set up” shortcut ⏩ exists to recreate the basic market equation for your dataset 💡

In the menu for defining the market equation, whether in Datama Prep or in the advanced settings ⚙️ of the solutions, you have at the bottom of this table two quick set up options with:

Tip of the Week 114: Only flag anomalies above or below the confidence interval

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 ⬆️⬇️

Tip of the Week 113: Dig deeper into your segments analysis

In Datama Compare, the waterfall will group segments with smaller effects into the ‘Remaining’ category to simplify the view 📊 However, you can easily examine these categories more closely by simply clicking to expand any bars labeled ‘Remaining’ 🔍

You can also customize how many segments appear per dimension before they are put in the ‘Remaining’ category in Settings ⚙️

Tip of the Week 112: Set automatic opening of waterfall steps

In Datama Compare, by default, the waterfall will open on the step and dimension most interesting to investigate 🕵🏽

If you want to have all the steps closed by default, there’s an option in the Waterfall settings: go to the settings icon ⚙️ at the top right of the Waterfall slide and uncheck the “Open biggest/focused element by default” option and that’s it 😉

Tip of the Week 111: New Products page

A new page is available on the Datama Home page 😀

By going to “My Account” and then “Products” in the left-hand menu, you will arrive on the page with all the integrations in the data visualization tools like Tableau, Power BI and Looker Studio 📊

Here you will find the following information:

Tip of the Week 110: Give your feedback

In Datama, you can give your feedback on a problem you have encountered or a potential improvement you have identified 💡

A “Feedback” banner is accessible by hovering your mouse over the right-hand side of the screen at half-height, or by clicking in the “Help”>”Feedback” menu. 📝

We’ll receive the message immediately, along with all the technical details needed to reproduce your environment and, if you like, a screenshot!

Tip of the Week 109: Display the exit in Journey

Would you like the answer to the question “How many sessions have left the site?” 🤔

Datama has created the option that allows you to have the answer in Journey, by activating “Display exits” in the settings ⚙️

This allows you to display the “output” of journeys on the sunburst ☀️, so you can hover your mouse over it and get the share of volume (in %) exiting your journeys for a given path.

Tip of the Week 108: Reverse sunburst

In Journey you can change the reading of your sunburst ☀️. By going to the options, you can tick “Reverse sunburst” 🔄️ , reversing the reading direction from external to the center of the sunburst.

This allows you to pose the problem in reverse by no longer answering the question “What does the user do after reaching a milestone?”, but elucidating “What led users to reach this milestone?” 😎

Tip of the Week 107: Display Main KPI trend

If you use Datama Detect 📈 to detect anomalies, you may have noticed some new features in the interface or in the email exports:

  1. Datama now shows the trend of the main KPI in dotted lines on the graphs, so you can see whether the variation in this indicator really influences your overall performance.
  2. In the event of an anomaly, a quantified overview of the impact on the main KPI is displayed, allowing you to quickly understand in what proportion a variation in a sub-indicator affects your main indicator. 🤓

These features are enabled by default. You can deactivate them in the ⚙️ settings by unchecking “Compute Main KPI impact” and/or clicking on the “f” icon in the top right-hand corner to remove them from the main chart.

Tip of the Week 106: Customise your decision tree

In Datama Compare, you can customise your decision tree 🌳 according to your needs, for example by highlighting the variation in % instead of the impact in value to simplify the discussion with the business 😉

You can make these adjustments by going to the parameter menu ⚙️ and then to the “Label” section:

Tip of the Week 105: Find the segments that explain the variation in a KPI

A question that often comes up is: which segments drive change among all the dimensions? 🕵️‍♀️ Change can be explained by several segments. It would therefore be interesting to have a ranking of these segments according to their impact on the KPI.

In DataMa Compare, thanks to the “Decision Tree” 🌳 that you will find on the first slide, it is possible to right-click to change the exploration method, which is by default in “hierarchical” order, to “Top X” drivers. The X can be selected from 1 to 50 😉

Useful when you want to find the Top 3, 5 or 10 segments that explain the variation 🤓

Tip of the Week 104: Change Waterfall colors for a specific workbook

When you carry out an analysis where a downward variation is seen as positive (e.g. analysis of purchasing costs), it is then possible to change the colours of the workbook in question to show increases in red 🔴 and decreases in green 🟩.

Go to Settings ➡️ Workbook Style ➡️ select Colors palet=custom ➡️ then define each of your colours for the Waterfall 🎨

Tip of the Week 103: New block Join in Datama Prep

A new block has appeared in Datama Prep: the ‘Join’ block, which lets you simply perform a join between two sources 🥳

Very simple to use, it will be configured in two steps:

  1. Choose the type of join you want to perform (Inner, Outer, Left, Right, Cross Join) 🔗
  2. Define the dimension(s) that will be used as join keys for each of the sources and apply 😉

Tip of the Week 102: Pivot Check All steps

The Datama team wishes you a happy new year 2024 🎉 Datama Pivot now lets you analyse all your KPIs at once! The “Check All steps” functionality is available as an option in the Datama Pivot menu:

Tip of the Week 101: New Clustering Tree in Pivot

The clustering tree is now available in the new interface on Datama Pivot, with improved visualisation 🌲->🎄 It helps you create clusters within your dataset across multiple dimensions using a “regression tree machine learning” algorithm 🚀

Tip of the Week 💯: Datama Prep Export

Want to easily export your favorite Datama graphs to your preferred channels? 🚀 You can automate exports from any Datama solution to Slack, email, or as a URL, directly in Datama Prep ⚡ Clicking on the corresponding bubble opens settings, where you can customize your export by frequency, time, and more ⚙️

Tip of the Week 99: Download your Prep data in Excel format

Want to check the data source you’ve created or imported into Datama Prep? ️🕵️ Here’s how to do it in two simple steps:

  1. Go to the Prep tab of the Use Case you are interested in
  2. Click on the Excel logo at the top right of the table 🖱️

Tip of the Week 98: Duplicate your source blocks in Datama Prep

🔥New this week: the “Duplicate this bloc” function is now available in Prep! Here’s how it works:

  1. Select the Source Block you want to duplicate.
  2. Click on the Three Small Dots “…” located on the Source Block.
  3. Choose “Duplicate this block” 📚: With one click, create an exact copy of your block, with all the parameters already configured.

✨ Why is this handy? Imagine: you have a GA4 block configured for last month. With duplication, easily create a version for last year. Time saving and efficiency guaranteed! Take advantage now and boost your productivity with Prep! 😉

Tip of the Week 97: Attach links to documentation to your workbooks

In Datama, you can add a link 🔗 pointing to internal documentation linked to your workbook (for example a Wiki page, a Readme, a Notion page, or a Gslide presentation presenting the use case). There are two ways of doing this:

Tip of the Week 96: Slideshow mode integrated into Datama

By clicking on the “Start presentation” icon in the top right-hand corner (or by using the keyboard shortcut Ctrl+F5 ⌨️), you enter slideshow mode, which allows you to display any slide in Datama full-screen, just as you do in PowerPoint. You can then present the different graphs by navigating from one page to another while continuing to interact normally with the solution 😉

Tip of the Week 95: New methods for Anomaly Detection

Datama Detect now offers you new methods for spotting anomalies in your data:

  1. Methods based on estimated confidence interval
    • Forecast (only available in “Analyse latest point only”)
    • Observed volatilty (method by default)
  2. Methods based on manually configured thresholds (the new ones 🥳)
    • Relative variation threshold: for example, if the threshold is set at 50% then any relative variation in excess of 50% will be considered an anomaly.
    • Absolute variation threshold: using the previous example, here we are not defining a percentage threshold but a fixed value (2k) and any absolute variation in excess of this value (-2.1k) will be considered an anomaly.
    • Absolute value threshold: for example, if the threshold is set at 50k and the baseline value is 40k, if the value considered is 60k, this will be considered an anomaly.

Tip of the Week 94: Merging Secondary Comparison

Last week we talked about secondary comparison. If you’re in the overlay mode when you do a Secondary Comparison, there are two types of visualisation:

Tip of the Week 93: New Secondary Comparison displays

You may be using secondary comparisons in Datama Compare - for example, to compare the variation of one country against another. Datama then displays 2 waterfalls: by default the display is superimposed with the first comparison in the foreground and the second in the background. Now you can change the display by separating the second comparison into a new Waterfall, which will appear either on the right or below. To access this, right-click on a block of the Waterfall, then Secondary Comparison and finally the display option you want from “Right”, “Above” or “Overlay” 😉

Tip of the Week 92: Datama Compare Tree Chart

Have you seen the tree chart view in Datama Compare? 🌳 By clicking on the Tree chart button in the top-right corner of your standard waterfall graph, you can visualize your data in a new way, showing the impact of all your dimensions at a glance 👀 Right click on a box to explore top contributing segments across all dimensions and change other settings 🔧 (in particular the exploration mode which, by switching to “Top X” mode, allows you to view the largest contributing segments across all dimensions)

Tip of the Week 91: Piano Analytics Connector

To prepare your data in Datama, you can plug in your data source and transform it in Datama Prep. Many connectors were already available, such as GA4, Facebook Ads, Bigquery… and now a new connector has joined them: Piano Analytics 🤩

Tip of the Week 90: Exploring in Compare from Pivot

In Datama Pivot, when you are on the “Importance Chart” graph, you can look to see what opportunities there are for optimising a KPI 🤔 This is now possible by right-clicking on one of the bubbles in the graph and selecting “Compare this”, you can easily switch to Datama Compare to explain the over-/under-performance of a given segment compared to others 🤩

Tip of the Week 89: User preferences

You already had the option of customising your preferences at workbook level to choose the language or colour scheme to apply to the graphics.🎨 Now, although this option is still available at workbook level, you can define the settings at user level, from Home. Select ‘User Preferences’ and the configuration will apply to all new workbooks you create. 😉

Tip of the Week 88: CTRL + F Search shortcut

A search shortcut has been introduced on all Datama pages by pressing CTRL + F. When you do a search 🔍 the results will be divided into the following sections:

Tip of the Week 87: New workbook view on the HomePage

A new view of your workbooks is available on the Datama Home page. By clicking on the list icon at the top right, you can switch from a “Grid” view with the workbooks in the form of a map to a “Detailed” view in the synthetic form of a table Your choice of view will be saved for future sessions 😉

Tip of the Week 86: Send exports only when there are alerts

You can set up your Slack or Mail exports so that they are only sent when there is an alert. To do this, click on the export button, select the export you want to modify, then activate the “Send on Alert only” toggle and save the export 😉

Tip of the Week 85: Redesign of the Settings menu

The new version of the settings menu is now available in Datama. To access it, click on the “Settings” button in the top bar. The new structure is as follows:

  1. “Solutions Model”: this groups together all the parameters specific to the solution (Compare, Detect, Journey, etc.)
  2. “Workbook Style” allows you to modify parameters which are global to the workbook whatever the solution, such as the colour palette 🎨, the language or the display characteristics of the numbers
  3. And finally you will find your market equation in the “KPIs & Market equation” menu.

Tip of the Week 84: A new version of Waterfall available

A new version of Waterfall is available as an experimental version 🧪, how it works is explained in this short youtube video where you’ll discover the new capabilities of the famous Datama waterfall, which can now be transformed into a decision tree to further simplify the explanation of variations to your customers, while comments are generated automatically. To activate it you need to access the Waterfall settings and, at the top right of the window that appears, activate the “New Waterfall” toggle. If this button is not available, contact Datama to be granted the experimental role 🥼 to discover the new features in advance 😉

Tip of the week #83: Smart Dimension

In Datama Compare’s Waterfall, when you zoom in on a step you can see the variation in each segment of a dimension. But it can be interesting to focus on a combination of dimensions, so Datama offers you the Smart Dimension 🤓: which will, for each stage of the Waterfall, identify the pair of dimensions most relevant to explain the variation in performance. For example: Consider the scenario in which your performance is entirely explained by a drop in performance on mobile users with the Firefox browser. By enabling the Smart Dimension option, Datama Compare will identify the Device*Browser dimension as the most relevant dimension 🎯. However, if the Smart Dimension option is not enabled, Datama Compare will attribute the performance variation to the Device or Browser dimension. NB: there is a Combined Dimension which overlaps not 2 dimensions but all the dimensions available in the dataset. Tip 83

Tip of the week #82: Looker Studio extension “Save in Datama”

Datama is available on Looker Studio as an extension, if you’re not using it yet and you’re interested here is the link to the documentation to add it to your Dashboard and don’t hesitate to contact Datama Customer Services to get the licence key associated with your account 😉 You can now have your Use Case in both Looker Studio and Datama thanks to the “Save in Datama” option 💾 which you’ll find in the three little dots at the top right of the extension. This option will allow you to customise your Waterfall with all the parameters available in Datama in order to improve the visualisation in LookerStudio, you will be able to change, for example:

Tip of the week #81: Drill Down by Dimensions then Steps

Until now, Datama Compare analysed variation first by steps in the market equation, then by dimension within a step. You can now decide to reverse this pattern and breakdown the total variation by the segment with the greatest impact in any dimension, then by step within each segment. To activate this option, go to Settings, then choose one of the following three options:

Tip of the week #80: Compact Numbers

Here’s a little trick to lighten the visual of your graphs when you have large numbers. Go to “Settings” and select the “Compact Numbers” option to transform the labels into thousands, millions or more in increments of a thousand 😉 For example:

Tip of the week #79: Personalising the performance indication of a Waterfall segment

By default, Datama displays after the name of a segment its relative variation compared to the average variation (e.g. organic (x2.43)). You now have the option of modifying this additional text in the “Settings” by one of these three options:

Tip of the week #78: Comparison Table in Datama Journey

While performing a user journey analysis in Datama Journey, discover our new feature: The interactive table 😎 By hovering your mouse over the different stages of the Sunburst, this table will allow you to :

Tip of the week #77: Filtering with REGEXPs

In a dimension when you have many segments, it is time consuming to select/deselect the segments you want to filter, nevertheless you have the possibility in the “advance settings” to filter with a REGEXP (Regular Expression) to save time 😉 Here are some use cases:

Tip of the week #76: Dimension Helper

Do you know the “Dimension Helper”? 🤔 This will allow you to see in a synthetic way the value (in line) and the distribution (in bar) of the KPIs of your market equation on the segments of a dimension 🤩 To open it, just go to the “Filters” tab in the top bar, you will then be able to :

Tip of the week #75: Display waterfall in points

In Datama Compare, you can now display your waterfall in points (%) instead of the volume view of the total KPIs 🤩 To switch between the two views, simply right-click on the blue total bars and select “% Display impact in points” 😉 Tip 75

Tip of the week #74: Comparison date range available in Datama’s LookerStudio extension

Datama continues to improve its extensions in the visualisation tools. In Looker Studio you can now enable the “comparison date range” feature to compare B (the period you select in the filter) vs A (the comparison period you select in the dropdown menu: previous period, previous year,…), which will make it more dynamic to use 😃 Tip 74

Tip of the week #73: Secondary Comparison available in the Table

In Datama Compare you have the possibility to compare one variation with another variation, this is what is offered with the “Secondary Comparison”. This is useful when you compare for example one period to another and want to highlight this comparison with what happened in the same periods the year before. The last release added the “Secondary Comparison” to the Table, now when you activate it a line will be added under each segment corresponding to the variation on this second comparison 😉 Tip 73

Tip of the week #72: CSV Skip Raw

Small improvement in Datama Prep, now you have an option to skip a certain number of lines in your CSV. For example, if you have a title when you export the CSV, no need to delete the first few lines of the file before importing it into Datama, you can select the number of lines to skip 😉 Tip 72

Tip of the week #71:

On the new version of Datama in the Compare solution, the table available in the second slide under the Waterfall has been improved 🥳

Tip of the week #70

With the arrival of the new version of Datama, in addition to the graphic redesign, we have also improved the functioning of the “Use Cases” 💡

Tip of the week #69

You may have noticed that in the new version of Datama,the “Impact” solution no longer appears. It has been split into two separate solutions “Assess” and “Detect” in order to meet two needs:

Tip of the week #68

In the new version of Datama, the old left-hand menu, where the filters were defined, is now in the top bar. By clicking on the “filters” button, all filterable dimensions existing in your dataset will appear. The “Helper” 📊 is a graphical aid to see the distribution of the elements of your dimension on one of the steps. The applied filters will appear in the top bar next to the “Filter” button. You can then edit a filter by clicking on it or delete it by clicking on the small bin 😉 Tip 68

Tip of the week #67

In the new version of Datama, Flow Prep is an integral part of your use case. Therefore, you can navigate from it thanks to the left side bar to the solution(s) (Compare, Detect, Pivot …) you want to use. Moreover, a favorite icon ⭐, allows you to define the solution you want to open by default from the Home Page 😉 Tip 67

Tip of the week #66

With the new version of Datama comes a new Home 😃 In addition to the existing features, you can now:

Tip of the week #65

When comparing two segments in the case of an AB test or when comparing two time periods, you can ask yourself the question: is the variation significant? :pensif: In Datama, all you have to do is activate the “Significance test” toggle in Settings, then you can choose

Tip of the week #64

In case you have some of your data that is “non-comparable” in your Datama Compare analysis (e.g. closing a market), but you still want it to appear separately in your Waterfall, to compare your KPIs only on comparable things (🍎 to 🍎):

Tip of the week #63

To facilitate the communication and sharing about augmented analysis, Datama is deploying a new Data Visualisation solution:

Tip of the week #62

The new Datama interface is coming soon! (Stay tuned 😃) Spoiler: it’s based on the Datama Prep interface you already have access to. This is your chance to test Datama Prep if you haven’t done so yet! 😉 On the HomePage, click on Data Flows then on the ➕ and you will be able to:

Tip of the week #61

In the Impact solution, Datama offers you the possibility to analyse the pre-post variation of an intervention on a test group. You will find use cases whenever you want to test:

Tip of the week #60

As in many countries, last weekend we switched to winter time ⌚ To avoid confusion in the schedulers on Datama (e.g. for Datama Prep, statics exports or by mail), the time displayed is the time in UTC +0, so it’s independent of your time zone. PS : stay informed of the latest information thanks to the notifications on the home page 😉 Tip 60

Tip of the week #59

Whether you’re on Compare, Pivot or Impact, you’ve probably seen a segment named “Other (<2% of the total)” which aggregates all the smaller segments into one to lighten the visualization and interpretation of results. Nevertheless, you can adjust this setting by going to “Settings” → “Aggregation in %”, you can then:

Tip of the week #58

Do you know the dynamic filter on the Waterfall? After zooming in on a step, right click on one of the displayed segments and select either :

Tip of the week #57

In Datama Compare, if you want to zoom in on several steps at the same time, you can force the open step to remain visually open on the selected dimension, either:

Tip of the week #56

In your waterfall, if you want to visualize the variations more finely, you can shift the Y axis so it doesn’t start at 0, for that you just need 3 clicks: Go to “Settings” → then “Display Options” → disable the toggle: “Y Axis Include 0” and press “Enter” 😉 Tip 56

Tip of the week #55

Don’t forget to save you workbook 💾 Did you know that all you had to do was press the “Ctrl + S” shortcut on your keyboard to save your workbook in Datama? Tip 55

Tip of the week #54

New connectors are available in Datama Prep 🥳

Tip of the week #53

Tip 53

Tip of the week #52

A little ad for a change, but that might interest you… Do you know the Datama sponsorship system? Because our customers are our best spokespersons, a little reminder for those who don’t remember:

Tip of the week #51

Little tip for Datama users, in Datama Compare when you want to do a breakdown of a Waterfall step, Datama will by default make you a split by the dimension with the highest “interest score”. However, you can choose a breakdown by another dimension by right-clicking on the step you choose and clicking “split by…” and you will see the available dimensions appear with the associated “interest score”. Higher is the latter, more relevant the variations of the segments will be. Tip 51

Tip of the week #50

You want to integrate Datama directly into your dashboards? Are you working on :

Tip of the week #49

A new Datama release includes a new connector! Test the GA4 connector in a very simple way, for example to check the consistency of your data with that of GA3, for this:

Tip of the week #48

You want the date range of your use case to evolve according to the update of your source, it’s very simple when creating your use case, select the desired period, then when saving, check that the “Dynamic saving of Start & End” box is checked ✅ If your source is updated daily 📅 and you want to do, for example, a weekly analysis compared to the same week last year, you need to create a Year-Week dimension and repeat the above operation by defining this new dimension in Start/End. This use case can be set up for analyses:

Tip of the week #47

Did you know ? You can download the source used by Datama, to do this go to the Source tab, then just below “Full Data Source” click on the Excel icon to download your source in Excel format. Useful when the source was created in Datama Prep or via the GA connector and you want to check its figures! Tip 47

Tip of the week #46

Datama Prep continues its expansion with the arrival of the Facebook Ads connector in addition to those existing 🥳 A little reminder for those who want to take into account the effect of the evolution of their market in their analyses, nothing could be simpler on Datama Prep, you can do it in a few clicks with the right Google Trend index, for more precision do not hesitate to consult this article Tip 46

Tip of the week #45

Did you know, you have the possibility to see your ratios or the value of your steps thanks to the “Ratio Definition Helper” available by clicking on the “chart” 📊 next to the Include Step in the Settings in Compare or the “division” ➗ next to KPI Denominator in Pivot. To have a vision with the two segments selected, consider activating the Compare mode in Pivot 😉 Tip 45

Tip of the week #44

To complete your analysis in Datama Compare, discover the “Comparison Definition Helper” available by clicking on the “chart” icon next to the Start/End Dimension. It allows you to follow the evolution over time of the chosen ratio (in curve) and its denominator (in bar 📊). An “Overview Overlay” is also available to compare the Start and End periods. Tip 44

Tip of the week #43

Today a little tip to go further in your analysis on Compare, it’s possible for you to activate the “Compare of Compare” option in the settings. This visualization will allow you to see in the background of your Waterfall the variations over another period So you can highlight the results you are analyzing by comparing it, for instance, to the same period of the previous year. Tip 43

Tip of the week #42

The Datama Prep beta, which allows you to work on your sources directly in Datama, is evolving. A small overview of recent features:

Tip of the week #41

You are afraid of missing the abnormal evolution of one of your indicators, Datama allows you to automate anomaly detection. You will then benefit:

Tip of the week #40

We have improved our wonderfull Waterfall, a first step in our technological overhaul that will facilitate the creation of new uses in the future. You can now:

Tip of the week #39

Get inspired in your analysis with those new articles 📰 on our blog!

Do the same at home! Then send us your results 😉

Tip of the week #38

Latest release of Datama hapenned this weekend :slightly_smiling_face: Among others, Datama prep is now available in beta:test_tube: , which allows you to generate a dataset for Datama in a simple and visual way, conbining multiple sources No more time wasted with 25 worksheet in Gsheet :nerd_face:

Tip 38

Tip of the week #37

It’s hard to keep up with the frantic release pace of the product team :sweat_smile:

The latest release was a few weeks ago (see the release note)

On the menu is the anomaly detection in Datama Impact, which allows to quickly identify an abnormal point in the monitoring of a KPI, and then to understand its drivers.

Compatible with the classic Datama sources, you just need to activate the ‘anomaly detection’ toggle at the top left of Impact to see the results appear, which will soon be automatically exportable in a slack or an email :bell:

Read this article to learn more, and contact us for a demo!

Tip 37

Tip of the week #36

📢 Lots of new stuff on the platform this week! You have the full list here.

In particular, a great news for analysts whose beautiful graphs always end up in slides (we know some of them 😅 ): you can now download all Datama graphs and comments on PowerPoint in one click. Just click on the “ppt” icon on the top right of the graph.

Boom 💥

Tip 36

Tip of the week #34

Whether in Tableau or Power BI, transparently display your Datama graphs 🤓

Find more information on our online documentation ! 📕

Tip 34

Tip of the week #33

Again, another release this week 🎉 !

Within the news, the ability to visualize ratios of your ‘market equation’ side by side.

For instance, the click through rate of each page of a funnel on the same bar chart
📊

Named ‘Ratio helper’, this visualisation is useful to know which ratio is under/ over performing even before trying to understand the drivers in Pivot.

You can see it by clicking on the ➗ in the settings.

To learn more, click here.

Tip 33

Tip of the week #32

🤔 We often try to improve what drives its performance downwards rather than showing what is already going well … and that’s why we have implemented the functionality: Negative drivers first: ↘️ !!

Tip 32

Tip of the week #30

🚒 Following the events at OVH, here is some information on the situation of Datama hosting:

Tip 31

Tip of the week #29

🆕 Multiple news on Datama this week, including some great features. Within them, “right click” 🖱 on Datama Compare waterfall is now available. You can easily decide to:

Your turn to test it!

Tip 29

Tip of the week #28

Afraid of explaining what’s a mix effect in that meeting with the Datama Waterfall 😨 ?

Good news, you don’t need to show it. Just de-activate the split between mix and perf in the settings. Datama will then group the two effects and just show negative and positive total variations instead.

Tip 28

Tip of the week #27

Datama Pivot now has its own smart comment 📝! You can find your insights in bullet points under each chart of Datama Pivot, as if an analyst would have work to get what you need!

This new feature is part of a set of releases from this week that you can see on https://Datama-solutions.github.io/docs/#/news

Enjoy 😄

Tip 27

Tip of the week #26

The Datama team wish you a happy new year 🎉 ! In case you want to filter out and forget this 2020 year 😷 from your analysis, we have what you need… with the new filter interface you can, in 2 clics:

The launch the calculations by hitting the button at bottom left (‘Enter’ shortcut on your keyboard)

Tip 26

Tip of the week #25

At Datama, it’s Christmas every day. 🎅

Why? Because you don’t need to wait for December the 25th, to write a wish list to Santa.

Why? Because you don’t need to wait for December the 25th, to write a wish list to Santa. You just need to send us your ideas for features/ improvements by chat, directly in the app or through this channel, and it will go straight in the product pipeline. And pipeline sprint is typically less than 2 weeks for prod… ⏩

Now you’re turn ✏️ and merry Christmas 🎁!

Tip 25

Tip of the week #24

As annouced, new UI of Datama is now in production on solutions.Datama.io 🎉

You can find everything that’s new in the release note here

Within the news, we introduce a home page 🏠, which shows all your workbooks.

Each ‘Card’ is a use case.

From the home, you can easily:

Learn more on the Home here !

Tip 24

Tip of the week #23

Datama is getting a new look! Christmas comes early this year 🎁

In a few days, you will discover the new Datama interface, including:

And a multitude of small improvements which are the fruit of your constant feedback… Thank you for your feedback and keep sending us your improvements wishes! 🙏

Tip 23

Tip of the week #22

A quick - yet not dirty - analysis from a spreadsheet into Datama?

✂️ Just copy the cell range (Ctrl+C) and paste it straight in Datama (Ctrl + V).

Easy enough?

Tip 22

Tip of the week #21

When you save an analysis in Datama, and if that analysis is linked to a “live” source (e.g. a Gsheet), Datama suggests to save the “Start” and “End” settings as dynamic.

Although that might look a little technical 🤓, this feature is quite useful for recurring analysis, because it allows to automatically adjust the time window 🗓.

For instance:

➡️ Therefore your analysis keeps up to date in a automated way, without having to change the settings 🤙!

Tip 21

Tip of the week #20

Because September has just passed and we’ve been working hard all summer, the new backtoschool version 🎒 of Datama is available in production!

On the agenda:

Thanks to all contributors for their ideas and your constant feedback on the tool!

Stay tune, there’s a lot more to come… 🚀

Tip 20

Tip of the week #19

When we analyze a variation via Datama COMPARE, we sometimes need to check its significance 🧐

To find this combination of amplitude and power analysis you can of course use Datama IMPACT, but also within Datama COMPARE, where you also find the Significance Test functionality. A very useful feature when you want to ensure the interest of the variation that you observe! 💥

Tip 19

Tip of the week #18

In case you’re getting bored at the beach 🏖, we have what you need: Datama documentation 📖 …

➡️ 🔗 here is you’re best summer read!

And as we acknowledge that we sometimes don’t manage to keep up with the crazy pace of releases in the product, we’ve made you able to contribute on each page and suggest your own modifications by clicking on the “Edit document” link at the top of the page ✍️ ! #communitycontribution #thanksforyourhelp!

Tip of the week #17

As an analyst, we often try to analyse the performance of a segment compared to the rest (for example the performance of the Mobile compared to other devices) … Datama has just implemented a new feature that does just that! 🤓

Very practical when you don’t want to open 2 windows on your computer to compare variations between them 😉

Tip 17

Tip of the week #16

You don’t have time to open the Datama interface … receive your analyses directly in your mailbox or on a Slack channel 📨

Tip 16

Tip of the week #15

➡️ Want to find new ideas to leverage Datama 💡?

Here is a set of ideas and corresponding dataset examples:

Feel free to reach out if you have new ideas that you want to share or build together!

Tip of the week #14

In the new features released during the containment, we find the functionality: Export graph as public URL :bar_chart:

All graphs from Datama solutions can now be exported to your Tableau, Data Studio dashboards… or to your web browser!

This allows you to enrich your usual reporting with Datama charts:

The data in this new widget is constantly updated with the data loaded into Datama.

Note: This feature is enabled on demand, contact us if you want to enable this feature.

Tip of the week #13

When you want to use Datama, you often wonder about the data… 💻

How do I connect my data into Datama? How do I get my data (and therefore my charts) updated as I go? One of the solutions…is Google spreadsheet! 💡

You can also use other extensions such as “OWOX BI BigQuery” for your BigQuery queries or the “Supermetrics” add-on for connection to all other applications on the market!

Tip 13

Tip of the week #12

🆕 New header has been released on the platform !

Not only it makes admin functions (new data source, export etc) easier and more intuitive to access, but it also adds some cool features:

Happy to have your feedbacks while testing it!

Note: this new header replaces the “Admin” menu that used to be at bottom left of the page

Tip 12

Tip of the week #11

In these troubled times 😷, you have some of your data that is “non-comparable” in your Datama Compare analysis (like a distribution channel… that no longer exists 😕!), but you still want it to appear separately in your Waterfall, to only compare your KPIs on comparable things (🍎 to 🍎)?

➢ Create a ‘Scope’ column with ‘In’ for what you want to keep or ‘Out’ for what you want to exclude

➢ Datama will automatically exclude the “Out” from the analysis and make it appear in a separate block of the waterfall, in light blue “Out of Scope”

See a concrete example ici !

Prepared with ❤️ from home, we think of you and accompany you on all your subjects from a distance!

Tip 11

Tip of the week #10

When using Datama COMPARE to compare two time periods. You can set up the solution so that your analyses in Datama are always up-to-date with your latest data. 🏃♀️

All you need to do is:

  1. Load a new source (“Change source” menu) via a “Google Sheet”.
  2. Then select the option “Keep Live connection with Gsheet”.
  3. Once the analysis is in place, you must save the use case by leaving the option “Dynamic saving of Start & End” selected. Be careful that the dates used as Start and End exist in the dataset!
  4. From the interval used for Start and End (1st week compared to the 4th week of the dataset for example), Datama will reproduce this same interval according to the last existing data…

Once your data updates itself, all you have to do is set up a regular send to your mailbox or a Slack channel and you’re done!

Tip 10

Tip of the week #9

To speed up your analysis we have accelerated the loading of your data. 🚀

In Datama, you can now:

Datama recognizes the source directly and offers you to launch the analysis directly!

Tip of the week #8

You can now use Datama as a Tableau extension ➕ !

You drag and drop the extension provided by Datama into your Tableau dashboard, and you access from Datama the data viewed in a Tableau worksheet.

Not only is your data up-to-date with what you already have in Tableau, but your filters and other actions in Tableau are then active in Datama! 🔄

Tip 8

For more information: https://www.docs.Datama.fr/docs/extensions/tableau-extension/

Tip of the week #7

Tip 7

Tip of the week #6

Lost in Datama :question:

In addition to the documentation, there is now a tutorial that interactively guides you through your first steps on the app 👣

Tip 6

Tip of the week #5

You can easily filter your analyses in Datama on a part of your source dataset.

Tip of the week #4

As you know, in order to explain your overall performance variation, Datama independently analyses for each stage each of your dimensions to bring up those that best explain the variation in that stage. But the tool also analyses combinations of dimensions. Either all dimensions combined together (Combined Dimensions) or all pairs of dimensions (Smart Dimension). 👨🔬

Tip of the week #3

In all Datama solutions, you have the possibility to group together elements of a dimension that represents almost nothing on your performance. 🧐

Useful especially when your data has dimensions with hundreds of different values.

Tip of the week #2

In Datama Compare and Impact, you can preview the definition of “Start” and “End” using “Overview chart”

Useful in particular if you are not sure of what you want to compare!