|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/bigquery-for-data-analysts
课程评论：没有评论
课程名称：BigQuery为数据分析师服务 课程概述：本课程专为希望学习如何使用BigQuery进行数据分析的数据分析师设计。通过视频、实验室和演示的结合，我们探讨了如何在BigQuery中摄取、转换和查询数据，以获得有助于商业决策的洞察。 课程大纲： 1. 课程介绍：介绍课程议程。 2. BigQuery为数据分析师服务：探讨数据分析师面临的分析挑战，比较本地大数据与云端大数据的区别，介绍Google Cloud的企业数据仓库BigQuery及其特点，以及云分析如何改变公司的真实案例。 3. 使用BigQuery探索和准备数据：通过SQL（结构化查询语言）探索数据，从简单的选择语句到更复杂的查询。 4. 清理和转换数据：讨论数据完整性的原则，学习如何使用SQL清理、准备和转换数据，并介绍Dataprep、Cloud Data Fusion、Dataflow等其他数据准备和转换产品。 5. 摄取和存储新的BigQuery数据集：讲述如何将数据摄取到BigQuery的本地存储中，以及不同的数据加载方法，包括外部数据源的查询。 6. 从BigQuery可视化您的洞察：通过构建仪表板和报告可视化数据洞察，学习可视化理论和最佳实践，使用Looker Studio和Connected Sheets等工具创建有影响力的可视化。 7. 使用Dataform开发可扩展的数据转换管道：介绍Dataform，一个新产品，提供统一的端到端体验，以开发、版本控制和编排BigQuery中的SQL管道。 8. BigQuery Studio：讨论BigQuery Studio的功能和用途，以及相关演示。 9. 总结：回顾课程中涉及的关键主题。 此课程适合希望提升数据分析技能、深入了解BigQuery的专业人士。
Name:Course Introduction
Description:This module introduces the course agenda.
Name: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.
Name: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.
Name: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.
Name: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.
Name: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.
Name: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.
Name: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.
Name:Summary
Description:This module recaps the key topics covered in the course.
This 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.
