---
title: "Mini-course: Build your own marketing data warehouse"
slug: "data-warehouse-mini-course"
description: "Build your marketing data warehouse in Google BigQuery with no coding required. Learn to visualize insights in Looker Studio to enhance your campaigns."
updated: 2026-05-06T11:34:20Z
published: 2026-05-06T13:26:01Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Mini-course: Build your own marketing data warehouse

This mini-course will equip you with the skills and knowledge needed to build your marketing data warehouse. No prior technical experience is required.

In these 3 lessons, you'll learn how to create a robust data warehouse in Google BigQuery without writing complex SQL, visualize your data from the data warehouse in Data Studio, and use the data-driven insights to improve your marketing campaigns.

## Lesson 1. Get started with Google BigQuery

In this lesson, we'll set everything up to build a data warehouse in Google BigQuery:

- Use Supermetrics Hub to access to the sources you want to pull data from (Facebook Ads, Google Ads, Google Analytics).
- Create a BigQuery dataset and a service account. Connect to BigQuery as a destination for your Supermetrics team.
- Set up a test transfer to ensure you can get your marketing data into BigQuery.

[Embedded content](https://www.youtube.com/embed/f_2J94mYiCI)

## Lesson 2. Transform your data in Google BigQuery

In this lesson, we'll learn how to pick the metrics and dimensions you want to transfer to your data warehouse and how to manage the data transfers:

- Delete existing tables in BigQuery.
- Build a custom table group in your Supermetrics Hub for each data source, selecting the metrics and dimensions you want to transfer to a data warehouse.
- Disable and delete existing transfers, schedule and monitor the new transfers.

[Embedded content](https://www.youtube.com/embed/IFgfhU7JFlg)

## Lesson 3. Visualize your data in Data Studio

In this lesson, we'll create a report in Data Studio to visualize the data in the data warehouse:

- Connect the data tables from BigQuery to Data Studio.
- Create the calculated metrics and charts in Data Studio to finalize the report.

[Embedded content](https://www.youtube.com/embed/61QBRdZr0OA)

## More resources

Now that you know the basics and much more about setting up a data warehouse, you may find the following articles useful:

- [How to backfill data](/v1/docs/how-to-backfill-data)
- [How to filter data in transfers](/v1/docs/how-to-filter-data-in-transfers)
- [About refresh settings in data warehouse transfers](/v1/docs/about-refresh-settings-in-data-warehouse-transfers)
- [About tables and table groups](/v1/docs/about-tables-and-table-groups)