BI tools

Here are a few BI tools that are known to work well with DataVault. We also have partnerships with some of these companies. Please reach out to info@tenjin.io for any questions about the partnerships.

Tenjin has many resources that can help you get started with SQL and using it with DataVault. And as you get more comfortable with SQL, you can modify your queries and continue to optimize! Contact us at support@tenjin.com to get access to our resources.

1. SELECT
2. SELECT DISTINCT
3. WHERE
4. AND/OR/NOT
5. ORDER BY
6. JOIN, INNER JOIN

Using the above basics you can pull data tables that exist in DataVault and with joins, bridge the data across tables.

Paired with the below examples from Tenjin, you should have enough to start the optimizations you'll need for marketing.

All queries are written for DataVault and can be modified for your specific purposes.

Below is a sample query.

/* This is a query on how to calculate DAU keying off of advertising_id for your individual users.
@DATE => refers to to the date that you want to see DAU for.
@BUNDLEID => bundle_id for your app
@PLATFORM => platform of your app
*/

SELECT COUNT(DISTINCT coalesce(advertising_id, developer_device_id)) as dau
FROM events
WHERE created_at :: DATE = '@DATE'
  AND bundle_id = '@BUNDLEID'
  AND platform = '@PLATFORM';

The query calculates the daily active users (DAU) for a certain date. Without even knowing SQL you can sort of read what it is doing. But ignore the exact context for now - just know that it calculates DAU for a certain day.

As a beginner, you can just change all the variables with the @ symbol to get what you need.

In this case change the @DATE to the date you want to analyze, the @BUNDLEID to the bundle_id you are using, and @PLATFORM to the platform that you are looking at.

In the end you might modify the query to look something like this:

/* This is a query on how to calculate DAU keying off of advertising_id for your individual users.
@DATE => refers to to the date that you want to see DAU for.
@BUNDLEID => bundle_id for your app
@PLATFORM => platform of your app
*/

SELECT COUNT(DISTINCT coalesce(advertising_id, developer_device_id)) as dau
FROM events
WHERE created_at :: DATE = '2018-02-01'
  AND bundle_id = 'com.tenjin.wordfinder'
  AND platform = 'ios';

This will automatically calculate the DAU for an app on ios.