{"product_id":"bigquery-for-data-analysts","title":"BigQuery for Data Analysts","description":"\u003cdiv\u003e\u003cp\u003eThis course is designed for data analysts who want to learn about using BigQuery for their data analysis needs. Through a combination of videos, labs, and demos, we cover various topics that discuss how to ingest, transform, and query your data in BigQuery to derive insights that can help in business decision-making.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eBigQuery for Data Analysts Benefits\u003c\/h3\u003e\n\u003cul\u003e\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn the purpose and value of BigQuery, Google Cloud’s enterprise data warehouse, and discuss its data analytics features.\u003c\/li\u003e\n\u003cli\u003eAnalyze large datasets in BigQuery with SQL.\u003c\/li\u003e\n\u003cli\u003eClean and transform your data in BigQuery with SQL.\u003c\/li\u003e\n\u003cli\u003eIngest new BigQuery datasets, and discuss options for external data sources.\u003c\/li\u003e\n\u003cli\u003eReview visualization principles, and use Connected Sheets and Looker Studio to visualize data insights from BigQuery.\u003c\/li\u003e\n\u003cli\u003eUse Dataform to develop scalable data transformation pipelines in BigQuery.\u003c\/li\u003e\n\u003cli\u003eUse new integrations and assistive capabilities introduced with BigQuery Studio\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eBigQuery Training for Analysts Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eModule 1) \u003c\/b\u003eBigQuery for data analysts\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIdentify analytics challenges faced by data analysts, and compare big data on-premises versus in the cloud.\u003c\/li\u003e\n\u003cli\u003eLearn the purpose and value of BigQuery, Google Cloud’s enterprise data warehouse, and discuss its data analytics features.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003e \u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 2) \u003c\/b\u003eExploring and preparing your data with BigQuery\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eList common data exploration techniques.\u003c\/li\u003e\n\u003cli\u003eReview SQL query basics.\u003c\/li\u003e\n\u003cli\u003eEnrich queries with functions, unions, and joins.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 3) \u003c\/b\u003eCleaning and transforming your data\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIdentify what makes a good dataset.\u003c\/li\u003e\n\u003cli\u003eClean and transform data using SQL.\u003c\/li\u003e\n\u003cli\u003eClean and transform data with other options\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003e \u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 4) \u003c\/b\u003eIngesting and storing new BigQuery datasets\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eReview differences between permanent and temporary data tables.\u003c\/li\u003e\n\u003cli\u003eIngest and store new BigQuery datasets.\u003c\/li\u003e\n\u003cli\u003eDiscuss options for external data sources\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 5) \u003c\/b\u003eVisualizing your insights from BigQuery\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eReview data visualization principles and common visualization pitfalls.\u003c\/li\u003e\n\u003cli\u003eUse Connected Sheets and Looker Studio to visualize data insights from BigQuery.\u003c\/li\u003e\n\u003cli\u003eDiscuss running analyses in a Jupyter Notebook\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003e \u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 6) \u003c\/b\u003eDeveloping scalable data transformation pipelines in BigQuery with Dataform\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse Dataform to develop scalable data transformation pipelines in BigQuery.\u003c\/li\u003e\n\u003cli\u003eLearn how to get started with Dataform by creating a repository and development workspace.\u003c\/li\u003e\n\u003cli\u003eCreate and execute a SQL workflow in Dataform.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003e \u003c\/b\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eModule 7) BigQuery Studio\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIntroduce BigQuery Studio.\u003c\/li\u003e\n\u003cli\u003eUse Duet AI in BigQuery to explain and generate SQL queries.\u003c\/li\u003e\n\u003cli\u003eLearn about new usability features and integrations with Dataform and Dataplex in the new BigQuery Studio interface.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267D97US \/ 2026-07-13T09:00:00 \/ Herndon, VA","offer_id":53182478549355,"sku":"US-1494-IL","price":1845.0,"currency_code":"USD","in_stock":true},{"title":"268B13CN \/ 2026-08-24T09:00:00 \/ Ottawa","offer_id":53182478582123,"sku":"US-1494-IL","price":1845.0,"currency_code":"USD","in_stock":true},{"title":"26AC39US \/ 2026-10-13T09:00:00 \/ Herndon, VA","offer_id":53182478614891,"sku":"US-1494-IL","price":1845.0,"currency_code":"USD","in_stock":true},{"title":"26BA69CN \/ 2026-11-23T09:00:00 \/ Ottawa","offer_id":53182478647659,"sku":"US-1494-IL","price":1845.0,"currency_code":"USD","in_stock":true},{"title":"271C85US \/ 2027-01-11T09:00:00 \/ Herndon, VA","offer_id":53182478680427,"sku":"US-1494-IL","price":1845.0,"currency_code":"USD","in_stock":true},{"title":"272A53CN \/ 2027-02-22T09:00:00 \/ Ottawa","offer_id":53182478713195,"sku":"US-1494-IL","price":1845.0,"currency_code":"USD","in_stock":true},{"title":"274C37US \/ 2027-04-12T09:00:00 \/ Herndon, VA","offer_id":53182478745963,"sku":"US-1494-IL","price":1845.0,"currency_code":"USD","in_stock":true},{"title":"275A57CN \/ 2027-05-25T09:00:00 \/ Ottawa","offer_id":53281826439531,"sku":"US-1494-IL","price":1845.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternationalnylife.myshopify.com\/products\/bigquery-for-data-analysts","provider":"Learning Tree International","version":"1.0","type":"link"}