|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/gcp-creating-bigquery-datasets-visualizing-insights
课程评论:没有评论
课程名称:创建新的 BigQuery 数据集和可视化洞察 概述:这是“从数据到洞察”课程系列的第二门课程。在本课程中,我们将学习如何将新的外部数据集导入 BigQuery,并使用 Google Data Studio 进行可视化。此外,我们还将介绍中级 SQL 概念,如多表 JOIN 和 UNION,这将使您能够跨多个数据源分析数据。即使您具有 SQL 背景,也可能会遇到一些 BigQuery 特有的知识(如处理查询缓存和表通配符)。 完成本课程后,您可以注册“实现 BigQuery 的高级洞察”课程。 课程大纲: 1. 课程介绍 - 描述:课程学习内容概述 2. 数据存储与导出 - 描述:从查询结果创建新的永久表和临时表 3. 将新数据集导入 BigQuery - 描述:在 BigQuery 中加载和创建新数据集 4. 数据集的连接与合并 - 描述:理解 SQL JOIN 和 UNION 的区别及其使用场景 5. 数据可视化 - 描述:使用 Looker Studio 创建仪表板和可视化 6. 课程总结 - 描述:课程关键学习点的总结 注意:注册此专业课程即表示您同意 Qwiklabs 服务条款,详见 FAQ 和链接:https://qwiklabs.com/terms_of_service。
Name:Course Introduction
Description:Overview of what you will learn in this course
Name:Storing and Exporting Data
Description:Create new permanent and temporary tables from your query results
Name:Ingesting New Datasets into BigQuery
Description:Load and create new datasets inside BigQuery
Name:Joining and Merging Datasets
Description:Understand the differences between SQL JOINs and UNIONs and when to use each
Name:Data Visualization
Description:Create dashboards and visualizations with Looker Studio
Name:Course Summary
Description:Summary of the course ley learning points
This is the second course in the Data to Insights course series. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Google Data Studio. We will also cover intermediate SQL concepts like multi-table JOINs and UNIONs which will allow you to analyze data across multiple data sources. Note: Even if you have a background in SQL, there are BigQuery specifics (like handling query cache and table wildcards) that may be new to you. After completing this course, enroll in the Achieving Advanced Insights with BigQuery course. >>> By enrolling in this specialization you agree to the Qwiklabs Terms of Service as set out in the FAQ and located at: https://qwiklabs.com/terms_of_service <<<