Before you start using Ravelin’s DWH you’ll need to know what data is available and where it’s stored. The entity relationship diagram below shows you which tables are available in DWH and which entities each table includes.

This maps relationships between tables (i.e ,the primary and foreign keys that you will need to take note of when joining tables). As we are a customer centric platform all tables can be joined on customerId.

As you get more familiar with DWH a lot of this will become second nature, but you can always refer back to this. Using the API logs is also a helpful way to find which informations is available under which table.