Every month we copy revenue data in our from their original objects (complex normalized tree of related objects) into something we call a snapshot. A denormalized flat table (Custom object) that makes reporting easier.
We then do something quite complex on it - a custom form of Variance Analysis (https://www.accountingtools.com/articles/what-is-variance-analysis.html).
We now think of moving this into Einstein Analytics (EA). Not only because storing all the denormalized data in custom objects is expensive, but also because Apex and Force.com seems a bad reporting platform compared to Wave/Einstein Analytics.
The idea is to store those snapshot directly as datasets inside of EA. And then
- use Salesforce Analytics Query Language (SAQL) or..
- use the Apex Analytics SDK (https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_sdk.meta/bi_dev_guide_sdk/bi_sdk_apex.htm)
to do ALL of the Variance Analytics. Have you build something complex like this in EA? Or can you point me to more elaborate examples of SAQL usage?