BI tools
  • 28 Nov 2022
  • 2 Minutes to read
  • Dark
    Light

BI tools

  • Dark
    Light

Querying DataVault

DataVault is built on Redshift and has a query syntax similar to PostgreSQL. Most BI tools allow you to access databases through PostgreSQL. This should be sufficient to access your DataVault.


Business Intelligence (BI) Tools

Show more

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.

image.png

image.png

image.png

image.png

image.png

image.png

image.png


Get Started with SQL

Show more Learning to write SQL can be a daunting challenge. Nonetheless, all marketers will require this skill at some point.

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.


Learning SQL

Show more [This](https://www.w3schools.com/sql/sql_intro.asp){target="_blank"} is a good place to start learning the SQL syntax. Key sections include:
  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.


Tenjin's standard queries

Show more 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.



Was this article helpful?

What's Next