It was four years ago that I wrote about a complete rewrite of the Query Engine powering dashboards and insights at the speed of light for all CRM Analytics customers. Every time a CRM Analytics customer loads a dashboard or explores a dataset, our in-memory engine, powered by our proprietary columnar store, retrieves the answer at sub-second ...
Many asked us to introduce SQL support in Tableau CRM (TCRM), and we heard you. We’re very happy to announce that TCRM now supports SQL in dashboards and lenses. Now you have the option to create powerful visualizations using SAQL(Salesforce Analytics Query Language) and/or SQL in TCRM. You might be wondering why SQL when we ...
In Einstein Analytics we build our dashboards with datasets that we have constructed and run in the Data Manager. We do this because we want to denormalize our data to improve the performance of our queries. This does, of course, come with a price that we do not have real-time data, though we can schedule ...
Not long ago I took you through co-grouping in my SAQL series, while SAQL is good to know especially when you want to do really advanced stuff, there is no reason why it has to be complicated and in Spring 20 it isn’t (I guess Safe Habour still applies). With clicks instead of manually writing ...
In the latest release, Winter 20, we got a lot of help in creating static steps – or as we will be calling them from now on, custom queries – but it can perhaps be a little hard to navigate how it works. So let’s have a look at these custom queries. First of all, ...
In Winter 19 I did a two-part blog series on the (at that time) new SAQL timeseries statement. Yesterday I got an email requesting a 3rd part to the blog series looking at what you can do with timeseries directly in the UI, since this has been enabled after the original blogs were written. I ...
So who doesn’t love conditional formatting? Amazing how such a “simple” feature can generate so much excitement. Summer 18 has been out for a few weeks now, so I assume as an Einstein Analytics user you have already played around with the functionality. Of course, it’s great that you can modify the colors in all your ...
As most of you know I am a fan of Einstein Analytics’ compare tables, which is why this is not the first blog on the topic. In all honesty they really are powerful as you do not need to know SAQL or touch JSON in order to utilize their power; there are even out of ...
I love when my clients inspire me to write blogs. I mean they have real challenges and questions that other companies might very well also have, so why not write down the solutions for more people’s benefit. This time I was asked, “how do I compare year to date (YTD) with the same period last ...
When you start with Einstein Analytics the first time is spent learning how lenses and dashboards work and how to explore your data further maybe even how to get your data sets into Einstein Analytics. But there are more to the tool than just pretty graphs that facet with each other. Soon you will get ...
