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 #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 PowerBi, 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!