As part of Shape Advertising Data Infrastructure, each company is granted access to its own Google BigQuery Data Warehouse. We chose to utilize Google BigQuery for its speed and processing power but also for its wide array of connectors and integrations with third-party tools.
Listed below are four major Business Intelligence tools Shape's ADI & Google BigQuery data warehouse integrates with.
As we do not control these BI Tools-to-BigQuery integrations ourselves (and the configuration may change at any given time), we wanted to provide links to connect your BigQuery DWH to these tools directly when possible.
Tableau
Here are directions on how to set up a connection from Tableau to Google BigQuery.
Note: Your BigQuery project name will have the following naming convention "Shape-Warehouse-####"
Domo
Once in Domo, add a Data Source by clicking the "Data" in the menu.
Search for and connect "Google BigQuery Service Account."
If you have not already created a Service Account in Google BigQuery, please follow the directions in the "Prerequisite" section first.
Select the appropriate service account.
Configure the "Details" section as necessary. Note a Report type, SQL Dialect, and Query are mandatory fields.
Select the frequency with and time when you wish your query to run.
Name your data set. Save.
Power BI
Here are directions on how to set up a connection from Power BI Desktop to Google BigQuery.