[{"id":"76889","title":"Course Introduction","description":"

This module introduces the course agenda.

","steps":[{"id":"530490","prompt":null,"isOptional":true,"activities":[{"id":"523339","href":"/paths/18/course_templates/865/video/523339?locale=de","isLocked":false,"duration":244000,"title":"Course Introduction","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"76890","title":"BigQuery for Data Analysts","description":"

In the first module, we look at analytics challenges faced by data analysts and compare big data on-premises versus on the Cloud. We then introduce BigQuery, which is Google Cloud’s enterprise data warehouse, and review its features that make BigQuery a great option for your data analytics needs. And finally, we’ll learn from real-world use cases of companies transformed through analytics on the Cloud.

","steps":[{"id":"530491","prompt":null,"isOptional":true,"activities":[{"id":"523340","href":"/paths/18/course_templates/865/video/523340?locale=de","isLocked":false,"duration":33000,"title":"Module overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530492","prompt":null,"isOptional":true,"activities":[{"id":"523341","href":"/paths/18/course_templates/865/video/523341?locale=de","isLocked":false,"duration":409000,"title":"Data analytics on Google Cloud","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530493","prompt":null,"isOptional":true,"activities":[{"id":"523342","href":"/paths/18/course_templates/865/video/523342?locale=de","isLocked":false,"duration":416000,"title":"From data to insights with BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530494","prompt":null,"isOptional":true,"activities":[{"id":"523343","href":"/paths/18/course_templates/865/video/523343?locale=de","isLocked":false,"duration":97000,"title":"BigQuery demo","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530495","prompt":null,"isOptional":true,"activities":[{"id":"523344","href":"/paths/18/course_templates/865/video/523344?locale=de","isLocked":false,"duration":215000,"title":"Real-world use cases of companies transformed through analytics on Google Cloud","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"76891","title":"Exploring and Preparing Your Data with BigQuery","description":"

This module is all about exploring your data with SQL, or structured query language. We go from very simple select statements to more complex queries that explore various datasets.

","steps":[{"id":"530496","prompt":null,"isOptional":true,"activities":[{"id":"523345","href":"/paths/18/course_templates/865/video/523345?locale=de","isLocked":false,"duration":48000,"title":"Module overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530497","prompt":null,"isOptional":true,"activities":[{"id":"523346","href":"/paths/18/course_templates/865/video/523346?locale=de","isLocked":false,"duration":167000,"title":"Common data exploration techniques","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530498","prompt":null,"isOptional":true,"activities":[{"id":"523347","href":"/paths/18/course_templates/865/video/523347?locale=de","isLocked":false,"duration":114000,"title":"Analyze large datasets with BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530499","prompt":null,"isOptional":true,"activities":[{"id":"523348","href":"/paths/18/course_templates/865/video/523348?locale=de","isLocked":false,"duration":663000,"title":"Query basics","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530500","prompt":null,"isOptional":true,"activities":[{"id":"523349","href":"/paths/18/course_templates/865/video/523349?locale=de","isLocked":false,"duration":36000,"title":"Lab intro: Exploring an Ecommerce Dataset using SQL in Google BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530501","prompt":null,"isOptional":false,"activities":[{"id":"523350","href":"/paths/18/course_templates/865/labs/523350?locale=de","isLocked":false,"duration":5400000,"title":"Exploring an Ecommerce Dataset using SQL in Google BigQuery","description":"In this lab, you learn to use BigQuery to find data, query the data-to-insights public dataset, and write and execute queries. ","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530502","prompt":null,"isOptional":true,"activities":[{"id":"523351","href":"/paths/18/course_templates/865/video/523351?locale=de","isLocked":false,"duration":484000,"title":"Working with functions","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530503","prompt":null,"isOptional":true,"activities":[{"id":"523352","href":"/paths/18/course_templates/865/video/523352?locale=de","isLocked":false,"duration":18000,"title":"Lab intro: Troubleshooting Common SQL Errors with BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530504","prompt":null,"isOptional":false,"activities":[{"id":"523353","href":"/paths/18/course_templates/865/labs/523353?locale=de","isLocked":false,"duration":3000000,"title":"Häufig auftretende SQL-Fehler mit BigQuery beheben","description":"In diesem Lab verwenden Sie den Abfrageeditor und die Abfragevalidierung von BigQuery, um gängige SQL-Syntaxfehler und logische Fehler zu beheben.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530505","prompt":null,"isOptional":true,"activities":[{"id":"523354","href":"/paths/18/course_templates/865/video/523354?locale=de","isLocked":false,"duration":625000,"title":"Enrich your queries with UNIONs and JOINs","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530506","prompt":null,"isOptional":true,"activities":[{"id":"523355","href":"/paths/18/course_templates/865/video/523355?locale=de","isLocked":false,"duration":25000,"title":"Lab intro: Troubleshooting and Solving Data Join Pitfalls","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530507","prompt":null,"isOptional":false,"activities":[{"id":"523356","href":"/paths/18/course_templates/865/labs/523356?locale=de","isLocked":false,"duration":3600000,"title":"Probleme beim Zusammenführen von Daten beheben","description":"In diesem Lab untersuchen Sie die Beziehungen zwischen Datentabellen und die Fallstricke, die bei der Verknüpfung dieser Tabellen zu vermeiden sind.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"76892","title":"Cleaning and Transforming your Data","description":"

In this module, we discuss principles about data integrity, and then we look at how to use SQL to clean, prepare, and transform your data. The last section of this module also briefly introduces other products like Dataprep, Cloud Data Fusion, Dataflow, Dataproc, and Dataform that can help with data preparation and transformation.

","steps":[{"id":"530508","prompt":null,"isOptional":true,"activities":[{"id":"523357","href":"/paths/18/course_templates/865/video/523357?locale=de","isLocked":false,"duration":62000,"title":"Module overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530509","prompt":null,"isOptional":true,"activities":[{"id":"523358","href":"/paths/18/course_templates/865/video/523358?locale=de","isLocked":false,"duration":658000,"title":"5 principles of dataset integrity","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530510","prompt":null,"isOptional":true,"activities":[{"id":"523359","href":"/paths/18/course_templates/865/video/523359?locale=de","isLocked":false,"duration":325000,"title":"Clean and transform data using SQL","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530511","prompt":null,"isOptional":true,"activities":[{"id":"523360","href":"/paths/18/course_templates/865/video/523360?locale=de","isLocked":false,"duration":581000,"title":"Clean and transform data: other options","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"76893","title":"Ingesting and Storing New BigQuery Datasets","description":"

This module talks about ingesting and storing data into BigQuery native storage. We discuss when to use Extract and Load, versus Extract, Load and Transform, versus Extract Transform and Load approaches for loading data into BigQuery.We also cover external data sources, where you can run your query in BigQuery, but the data is hosted outside of BigQuery.

","steps":[{"id":"530512","prompt":null,"isOptional":true,"activities":[{"id":"523361","href":"/paths/18/course_templates/865/video/523361?locale=de","isLocked":false,"duration":54000,"title":"Module overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530513","prompt":null,"isOptional":true,"activities":[{"id":"523362","href":"/paths/18/course_templates/865/video/523362?locale=de","isLocked":false,"duration":315000,"title":"Permanent versus temporary data tables","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530514","prompt":null,"isOptional":true,"activities":[{"id":"523363","href":"/paths/18/course_templates/865/video/523363?locale=de","isLocked":false,"duration":18000,"title":"Lab intro: Creating new Permanent Tables","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530515","prompt":null,"isOptional":false,"activities":[{"id":"523364","href":"/paths/18/course_templates/865/labs/523364?locale=de","isLocked":false,"duration":3600000,"title":"Creating Permanent Tables and Access-Controlled Views in BigQuery","description":"This lab focuses on how to create new permanent reporting tables and logical reviews from an existing ecommerce dataset.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530516","prompt":null,"isOptional":true,"activities":[{"id":"523365","href":"/paths/18/course_templates/865/video/523365?locale=de","isLocked":false,"duration":236000,"title":"Ingesting new datasets","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530517","prompt":null,"isOptional":true,"activities":[{"id":"523366","href":"/paths/18/course_templates/865/video/523366?locale=de","isLocked":false,"duration":316000,"title":"External data sources","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530518","prompt":null,"isOptional":true,"activities":[{"id":"523367","href":"/paths/18/course_templates/865/video/523367?locale=de","isLocked":false,"duration":20000,"title":"Lab intro: Ingesting and Querying New Datasets","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530519","prompt":null,"isOptional":false,"activities":[{"id":"523368","href":"/paths/18/course_templates/865/labs/523368?locale=de","isLocked":false,"duration":3600000,"title":"Ingesting New Datasets into BigQuery","description":"This lab focuses on how to ingest new datasets into tables inside of BigQuery.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"76894","title":"Visualizing Your Insights from BigQuery","description":"

This module is where all that hard work around ingesting, cleaning, preparing, and transforming your data comes to fruition as you get to visualize insights from your data by building insightful dashboards and reports. We start off with a little visualization theory and some best practices, and then look at tools, like Looker Studio and Connected Sheets, that can connect to BigQuery and help create impactful visualizations to capture and convey your insights. Although SQL is a powerful query language, programming languages such as Python, Java, or R provide syntaxes and a large array of built-in statistical functions that data analysts might find more expressive and easier to manipulate for certain types of data analysis. Such tools include open source web-based applications like Jupyter Notebooks, and so we discuss these as well.

","steps":[{"id":"530520","prompt":null,"isOptional":true,"activities":[{"id":"523369","href":"/paths/18/course_templates/865/video/523369?locale=de","isLocked":false,"duration":87000,"title":"Module overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530521","prompt":null,"isOptional":true,"activities":[{"id":"523370","href":"/paths/18/course_templates/865/video/523370?locale=de","isLocked":false,"duration":420000,"title":"Data visualization principles","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530522","prompt":null,"isOptional":true,"activities":[{"id":"523371","href":"/paths/18/course_templates/865/video/523371?locale=de","isLocked":false,"duration":290000,"title":"Connected Sheets","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530523","prompt":null,"isOptional":true,"activities":[{"id":"523372","href":"/paths/18/course_templates/865/video/523372?locale=de","isLocked":false,"duration":22000,"title":"Lab intro: Connected Sheets Qwik Start","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530524","prompt":null,"isOptional":false,"activities":[{"id":"523373","href":"/paths/18/course_templates/865/labs/523373?locale=de","isLocked":false,"duration":3600000,"title":"Connected Sheets: Qwik Start","description":"Connected Sheets, you can analyze billions of rows and petabytes of data in Google Sheets without specialized knowledge of computer languages like SQL. In this hands-on-lab, you will learn how to connect a BigQuery dataset to Google Sheets and analyze your data.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530525","prompt":null,"isOptional":true,"activities":[{"id":"523374","href":"/paths/18/course_templates/865/video/523374?locale=de","isLocked":false,"duration":182000,"title":"Common data visualization pitfalls","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530526","prompt":null,"isOptional":true,"activities":[{"id":"523375","href":"/paths/18/course_templates/865/video/523375?locale=de","isLocked":false,"duration":277000,"title":"Looker Studio","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530527","prompt":null,"isOptional":true,"activities":[{"id":"523376","href":"/paths/18/course_templates/865/video/523376?locale=de","isLocked":false,"duration":18000,"title":"Lab intro: Explore and Create Reports with Looker Studio","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530528","prompt":null,"isOptional":false,"activities":[{"id":"523377","href":"/paths/18/course_templates/865/labs/523377?locale=de","isLocked":false,"duration":2400000,"title":"Berichte mit Looker Studio erstellen und analysieren","description":"In diesem Lab erfahren Sie, wie Sie Looker Studio mit Datentabellen in Google BigQuery verknüpfen und Diagramme erstellen. Zusätzlich lernen Sie die Beziehungen zwischen Dimensionen und Messwerten kennen.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530529","prompt":null,"isOptional":true,"activities":[{"id":"523378","href":"/paths/18/course_templates/865/video/523378?locale=de","isLocked":false,"duration":363000,"title":"Analysis in a notebook","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"76895","title":"Developing scalable data transformations pipelines in BigQuery with Dataform","description":"

Creating, maintaining, and versioning SQL pipelines is a lot of hard work. And many times, data analysts have to use multiple tools to achieve this. So in this module, we introduce Dataform, a new product that offers a unified end-to-end experience to develop, version control, and orchestrate SQL pipelines in BigQuery.

","steps":[{"id":"530530","prompt":null,"isOptional":true,"activities":[{"id":"523379","href":"/paths/18/course_templates/865/video/523379?locale=de","isLocked":false,"duration":25000,"title":"Module overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530531","prompt":null,"isOptional":true,"activities":[{"id":"523380","href":"/paths/18/course_templates/865/video/523380?locale=de","isLocked":false,"duration":227000,"title":"What is Dataform ?","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530532","prompt":null,"isOptional":true,"activities":[{"id":"523381","href":"/paths/18/course_templates/865/video/523381?locale=de","isLocked":false,"duration":295000,"title":"Getting started with Dataform","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530533","prompt":null,"isOptional":true,"activities":[{"id":"523382","href":"/paths/18/course_templates/865/video/523382?locale=de","isLocked":false,"duration":408000,"title":"Demo","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530534","prompt":null,"isOptional":true,"activities":[{"id":"523383","href":"/paths/18/course_templates/865/video/523383?locale=de","isLocked":false,"duration":26000,"title":"Lab intro: Create and execute a SQL workflow in Dataform","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530535","prompt":null,"isOptional":false,"activities":[{"id":"523384","href":"/paths/18/course_templates/865/labs/523384?locale=de","isLocked":false,"duration":3600000,"title":"Create and execute a SQL workflow in Dataform","description":"This lab walks you through the process to create and execute a SQL workflow in Dataform to load data in BigQuery.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"76896","title":"BigQuery Studio","description":"

In this module, we will start off by talking about what BigQuery Studio is, and the reason we built it. Next, we describe in a little more detail all the great capabilities that come with BigQuery Studio. In the end, we wrap up the module with a demo to walk you through the cool features and show you how to use it.

","steps":[{"id":"530536","prompt":null,"isOptional":true,"activities":[{"id":"523385","href":"/paths/18/course_templates/865/video/523385?locale=de","isLocked":false,"duration":27000,"title":"Module overview","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530537","prompt":null,"isOptional":true,"activities":[{"id":"523386","href":"/paths/18/course_templates/865/video/523386?locale=de","isLocked":false,"duration":234000,"title":"What is BigQuery Studio ?","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530538","prompt":null,"isOptional":true,"activities":[{"id":"523387","href":"/paths/18/course_templates/865/video/523387?locale=de","isLocked":false,"duration":218000,"title":"Unified analytics","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530539","prompt":null,"isOptional":true,"activities":[{"id":"523388","href":"/paths/18/course_templates/865/video/523388?locale=de","isLocked":false,"duration":164000,"title":"Asset management","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530540","prompt":null,"isOptional":true,"activities":[{"id":"523389","href":"/paths/18/course_templates/865/video/523389?locale=de","isLocked":false,"duration":287000,"title":"Embedded assistance","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530541","prompt":null,"isOptional":true,"activities":[{"id":"523390","href":"/paths/18/course_templates/865/video/523390?locale=de","isLocked":false,"duration":393000,"title":"Demo","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530542","prompt":null,"isOptional":true,"activities":[{"id":"523391","href":"/paths/18/course_templates/865/video/523391?locale=de","isLocked":false,"duration":20000,"title":"Lab intro: Analyze Data with Duet AI Assistance","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530543","prompt":null,"isOptional":false,"activities":[{"id":"523392","href":"/paths/18/course_templates/865/labs/523392?locale=de","isLocked":false,"duration":4200000,"title":"Daten mit Unterstützung durch Gemini analysieren","description":"In diesem Lab analysieren Sie BigQuery-Daten mit Unterstützung durch Gemini.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"530544","prompt":null,"isOptional":true,"activities":[{"id":"523393","href":"/paths/18/course_templates/865/labs/523393?locale=de","isLocked":false,"duration":5400000,"title":"Generate Personalized Email Content with BigQuery Continuous Queries and Gemini","description":"In this lab, you learn how to generate personalized email content with BigQuery continuous queries, Gemini, Pub/Sub, and Application Integration triggers.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"76897","title":"Summary","description":"

This module recaps the key topics covered in the course.

","steps":[{"id":"530545","prompt":null,"isOptional":true,"activities":[{"id":"523394","href":"/paths/18/course_templates/865/video/523394?locale=de","isLocked":false,"duration":236000,"title":"Summary","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"next-steps","title":"Die nächsten Schritte","description":null,"steps":[{"id":"badge-step","prompt":null,"isOptional":true,"activities":[{"id":"badge","href":null,"isLocked":true,"duration":null,"title":"Kurslogo","description":null,"type":"badge","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":true}]

Google Cloud Skills Boost

03

BigQuery for Data Analysts