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 the 3 course 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 Looker Studio, and use the data-driven insights to improve your marketing campaigns.
Go to course lessonsThink you know it all? Take the quiz, win a badge!
Complete all 3 quizzes (70% accuracy required) to earn your DWH course completion badge.
Meet the speaker
Bartosz is a Principal Data Strategist. He's been helping companies make the most of their data since 2017. At Supermetrics, he works with businesses to turn their data into useful insights that drive smart decisions. Before joining Supermetrics, Bartosz worked at Idealo Internet GmbH as a Principal Data Analyst, where he helped teams and stakeholders use data to solve real business challenges. He's passionate about making data accessible and valuable for everyone, from analysts to decision-makers.
Watch course lessons
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 get access to the sources you want to get the 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.
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 the existing tables in BigQuery.
- Build a custom table group in your Supermetrics Hub for every data source: pick the metrics and dimensions you want to transfer to a data warehouse.
- Disable and delete the existing transfers, schedule and monitor the new transfers.
Lesson 3. Visualize your data in Looker Studio
In this lesson, we'll create a report in Looker Studio to visualize the data in the data warehouse:
- Connect the data tables from BigQuery to Looker Studio.
- Create the calculated metrics and charts in Looker Studio to finalize the report.
Sign up
Already have an account? Login
Ask questions from other Community members, comment on other people's posts and get access to exclusive Community content by logging in.
Log in with Facebook Login with LinkedInLog in to Supermetrics Community
No account yet? Create an account
Ask questions from other Community members, comment on other people's posts and get access to exclusive Community content by logging in.
Log in with Facebook Login with LinkedInEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.