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 ...
When you are new to Einstein Analytics and you for the first time have to build a dataset it may go alright, yes there are a few new concepts to understand especially the grain level (or root object) but you can manage. When it comes to making additional modifications in the dataflow afterward that’s where ...
This year Marketing Cloud made some changes to their authentication, the connector we had and still have in Einstein Analytics used the old authentication. Now if you have an installed packed from before summer of 2019 you are okay to use that with the connector we have in Einstein Analytics. But what if you do ...
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 last blog of this SAQL series, we saw how powerful SAQL really can be by joining datasets together using the cogroup statement. But we are not stopping there, we can do more powerful stuff. Another way of joining different streams is with the union statement, so in this blog, we will uncover that ...
If you were at Dreamforce 2019 or followed along at home you may have heard about the new Einstein Analytics Data Catalog. If not read along, it’s nothing less than amazing! Earlier this year I and the rest of the London DataTribe had the pleasure of welcoming Skip Sauls who is the product manager at ...
What we have covered so far in the SAQL series have been some basic features, however, it can be a lot more powerful. Let’s say you have two different datasets you want to use for a single query; it could be cases and opportunities for an account. Well, with SAQL we can leverage co-grouping to ...
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, ...
By now we have covered most of the basics in a SAQL query, but there is one more thing that you will see a lot when you are working with SAQL and it is filters. So in this third part, we will look closer at filters. Pre-projection Filters When you apply a filter to a ...