BigQuery for Marketing Analysts

BigQuery for Marketing Analysts

Google BDL-BQMA

GBP 79.20
Want to turn your marketing data into insights and build dashboards? Bring all of your data into one place for large-scale analysis and model building. Get repeatable, scalable, and valuable insights into your data by learning how to query it and using BigQuery. BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage or needing a database administrator. BigQuery uses SQL and can take advantage of the pay-as-you-go model. BigQuery allows you to focus on analyzing data to find meaningful insights.
 
Write Your Own Review

Only registered users can write reviews. Please Sign in or create an account

GBP 79.20

Exploring Your Ecommerce Dataset with SQL in Google BigQuery

Module 1

Exploring Your Ecommerce Dataset with SQL in Google BigQuery

Exploring Your Ecommerce Dataset with SQL in Google BigQuery

Google LIS-GOOGLE-2222
GBP 9.90
Google
Google Cloud Self-Paced Labs
English
30 days

BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage or needing a database administrator. BigQuery uses SQL and can take advantage of the pay-as-you-go model. BigQuery allows you to focus on analyzing data to find meaningful insights.

We have a newly available ecommerce dataset that has millions of Google Analytics records for the Google Merchandise Store loaded into a table in BigQuery. In this lab, you use a copy of that dataset. Sample scenarios are provided, from which you look at the data and ways to remove duplicate information. The lab then steps you through further analysis the data.

To follow and experiment with the BigQuery queries provided to analyze the data, see Standard SQL Query Syntax.

See more See less
Explore and Create Reports with Data Studio

Module 2

Explore and Create Reports with Data Studio

Explore and Create Reports with Data Studio

Google LIS-GOOGLE-2221
GBP 9.90
Google
Google Cloud Self-Paced Labs
English
30 days

Google Data Studio turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable. Dashboarding allows you to tell great data stories to support better business decisions.

BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage or needing a database administrator. BigQuery uses SQL and can take advantage of the pay-as-you-go model. BigQuery allows you to focus on analyzing data to find meaningful insights.

The dataset used in this lab is an ecommerce dataset that has millions of Google Analytics records for the Google Merchandise Store loaded into BigQuery. You will explore the available fields and row of the dataset for insights.

This lab focuses on how to create new reports and explore your ecommerce dataset visually for insights.

See more See less
Creating Permanent Tables and Access-Controlled Views in BigQuery

Module 3

Creating Permanent Tables and Access-Controlled Views in BigQuery

Creating Permanent Tables and Access-Controlled Views in BigQuery

Google LIS-GOOGLE-2246
GBP 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
This lab focuses on how to create new permanent reporting tables and logical reviews from an existing ecommerce dataset.
See more See less
Ingesting New Datasets into BigQuery

Module 4

Ingesting New Datasets into BigQuery

Ingesting New Datasets into BigQuery

Google LIS-GOOGLE-2234
GBP 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
This lab focuses on how to ingest new datasets into tables inside of BigQuery.
See more See less
How to Build a BI Dashboard Using Google Data Studio and BigQuery

Module 5

How to Build a BI Dashboard Using Google Data Studio and BigQuery

How to Build a BI Dashboard Using Google Data Studio and BigQuery

Google LIS-GOOGLE-2264
GBP 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
Learn how to build a BI dashboard with Data Studio as the front end, powered by BigQuery on the back end
See more See less
Data Catalog: Qwik Start

Module 6

Data Catalog: Qwik Start

Data Catalog: Qwik Start

Google LIS-GOOGLE-2349
GBP 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
In this lab you will explore existing datasets with Data Catalog and mine the table and column metadata for insights.
See more See less
Exploring Dataset Metadata Between Projects with Data Catalog

Module 7

Exploring Dataset Metadata Between Projects with Data Catalog

Exploring Dataset Metadata Between Projects with Data Catalog

Google LIS-GOOGLE-2355
GBP 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
In this lab, you will explore existing datasets with Data Catalog and mine the table and column metadata for insights.
See more See less
Build and Execute MySQL, PostgreSQL, and SQLServer to Data Catalog Connectors

Module 8

Build and Execute MySQL, PostgreSQL, and SQLServer to Data Catalog Connectors

Build and Execute MySQL, PostgreSQL, and SQLServer to Data Catalog Connectors

Google LIS-GOOGLE-2356
GBP 9.90
Google
Google Cloud Self-Paced Labs
English
30 days
In this lab you will explore existing datasets with Data Catalog and mine the table and column metadata for insights.
See more See less

* Required Fields