Ernst van Nierop closed issue #1: First attempt to set up Data Warehouse at GitLab.com / karu

Ernst van Nierop
2018-01-19T18:41:15Z

set up Karu's Biqquery account

select and set up tools to connect data and to visualize data

Fivetran

Looker or Redash

set up 1 "system" including 1 import and 1 graph. Use Zendesk if that seems easiest.

set up all supported "systems" Fivatran offers (i.e. one graph per system)

SFDC: https://www.fivetran.com/integrate/salesforce/bigquery

Marketo: https://www.fivetran.com/integrate/marketo/bigquery

Google Analytics: https://www.fivetran.com/integrate/google_analytics/bigquery

Zendesk: https://www.fivetran.com/integrate/zendesk/bigquery

Zuora: https://www.fivetran.com/integrate/zuora/bigquery

Mailchimp (do we use it?): https://www.fivetran.com/integrate/mailchimp/bigquery

set up 1 graph that combines multiple systems.

review tool selection, consider custom app or OS tool for visualization.

Probably next: start over, then add data from version.gitlab.com, then from GitLab.com