Wave Analytics - mixing two datasets

Question

Could Wave Analytics handle the following scenario?

1. I need to get all the Contracts and Accounts (some filtering here)
2. Get all the Cases pointing to Accounts
3. List all the Accounts with cases pointing on them, or even create some grouping like - how many accounts have any corresponding Case

I'm not very familiar with Wave Analytics, but there is some SAQL editor in Lenses that seems promising. Maybe mixing - somehow - two datasets in SAQL would do the trick?

Answer 1

This is possible, SAQL has a cogrouping function which allows you to join two or more datasets together. This allows for both inner and outer joins.

https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_statement_group.htm

Another option is to pull the data into Wave using a Dataflow, here you can use the Augment function however at the moment the types of join that can be done in the Dataflow are more limited, e.g. for multiple matches, the only option is the have the returned results in a comma separated list rather than multiple rows.

https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_admin_guide_data_integration_guide.pdf

Filtering is possible in both the Dataflow and SAQL.

I would use the dataflow to join the datasets to the required form as far as is possible, and then use SAQL to join where the Dataflow does not provide you with the required type of joins.