|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-bigquery-for-marketers-and-agencies/
课程评论：没有评论
**课程名称：** Google BigQuery for Marketers and Agencies **课程概述：** 本课程专为希望提升技术能力和专业知识的营销人员设计，旨在缩小数据分析与数字营销之间的差距，帮助您成为一名数据驱动的决策者。课程内容循序渐进，从介绍营销人员最常用的SQL查询、BigQuery和SQL在数据生态系统中的作用开始，然后通过两个实操项目，让您能够学以致用。 **课程亮点：** * **项目一：** 探索Google Analytics 360中的电子商务和CRM用户级别数据。 * **项目二：** 在Google Data Studio中可视化活动查询和数据表。 * **技能提升：** * 使用ARRAY\_AGG、UNNEST和STRUCT探索半结构化数据。 * 使用WHERE子句过滤值以识别洞察。 * 导入CSV文件并创建永久BigQuery表。 * 使用INNER、LEFT和RIGHT JOIN组合不同类型的数据表。 * 使用SUM、COUNT和GROUP BY聚合数据。 * 使用WITH子句创建嵌套查询。 **学员评价：** 学员们普遍认为本课程是学习Google BigQuery基础及其与Data Studio集成的绝佳选择。讲师的教学方式循序渐进且充满热情，使学习过程变得轻松易懂。尽管有SQL基础的学习者，也能从课程中获益，掌握在BigQuery中运用SQL的方法。课程帮助学员深入理解如何利用Google Analytics数据，并将其与其他数据源结合，进行更高级的数据可视化和分析。 **讲师介绍：** Lachezar Arabadzhiev是一位拥有4年以上绩效分析和数据可视化经验的数字营销技术专家。他曾在微软担任数字营销专员，后转型至衡量与分析领域，并服务过加拿大航空、RBC、金佰利、马自达和汇丰银行等知名品牌。Lachezar自2017年初便开始使用Data Studio和BigQuery，并构建了多种可视化和自动化流程，包括整合Google Marketing Platform（Google Analytics 360、Campaign Manager和Display & Video 360）的绩效仪表板，以及基于用户级别的电子商务数据的受众细分视图。他也是一位已获GMP认证的专家，并曾于2018年受邀在加拿大Google数据与分析峰会上发表演讲。
Welcome to Google BigQuery for Marketers and Agencies, the Google BigQuery course that focuses on growing the technical knowledge and expertise of the marketing professional! This course is designed to bridge the gap between data analysis and digital marketing, and help you become a data-driven decision-maker. The course curriculum is put together in a progressive fashion, starting with an introduction to the most useful SQL queries for marketers, the role of both BigQuery and SQL in the larger data ecosystem, and then diving into two hands-on projects, where you can use everything you have learned. By the end of the course, you will be able to:Explore eCommerce and CRM user-level data in Google Analytics 360 (Project #1)Visualize active queries and data tables in Google Data Studio (Project #2)Explore semi-structured data with ARRAY_AGG, UNNEST and STRUCTFilter values with the WHERE clause to identify insightsIngest.CSV files and create permanent BigQuery tables Combine multiple data tables with different types of JOINs - INNER, LEFT and RIGHTAggregate data with SUM, COUNT and GROUP BYCreate nested queries by using the WITH clauseWhat are the students who took the course saying?"Very good course that shows you the basics of Google Big Query and its integration with Data Studio. The teacher shows you, step by step, the most important things to know with passion. I recommend this course to anyone who wants to take the first steps in the Big Query World." - Massimo"Very good course! I am glad that I have chosen it. Materials are easy for understanding. I was familiar with SQL before, but never worked with it in BigQuery. Now I know how to do it. Thank you very much!" - Mariia"This course is brilliant! really! I have been collecting data with Google Analytics for a few years. But this course taught how to take that data to the next step and now I can speak to what can be done with this data, and how it can be combined with other data sources etc. I especially like the way Lachezar explains key concepts that helped me put together the puzzle of GA data to BigQuery and from there to data visulization. Thanks Lachezar." - MuhammadWho is the instructor?Lachezar Arabadzhiev is a digital markitech with 4+ years of experience in performance analytics and data visualization. Lachezar began his career as a digital marketer at Microsoft, but soon transitioned to the measurement and analytics world, where he has had the opportunity to work with major brands such as Air Canada, RBC, Kimberly-Clark, Mazda and HSBC.Lachezar has been working with Data Studio and BigQuery since early 2017 and has built a wide variety of visualizations and automation flows. From performance-based dashboards with joined GMP sources (Google Analytics 360, Campaign Manager and Display & Video 360) to audience-driven segmentation views with user-level eCommerce data.Lachezar is a certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.
