We may earn an affiliate commission when you visit our partners.
Google Cloud Training
これは「Data to Insights」コースシリーズの 2 つ目のコースです。ここでは、新しい外部データセットを BigQuery に取り込み、Looker Studio で可視化する方法について説明します。また、複数テーブルの JOIN と UNION など、中級者向けの SQL のコンセプトについても説明します。JOIN や UNION を使用すると、複数のデータソースのデータを分析できます。
注: すでに SQL に関する知識をお持ちの方も、BigQuery に固有の要素（クエリ キャッシュやテーブル ワイルドカードの処理など）について学ぶことができます。
このコースを修了したら、「Achieving Advanced Insights with BigQuery」コースに登録してください。
Register for this course and see more details by visiting:
OpenCourser.com/course/kd02gl/creating
What's inside
Syllabus
コース概要
本コースで学習する大まかな内容
データの保存とエクスポート
クエリ結果から新しい永続テーブルと一時テーブルを作成する
Read more
Syllabus
コース概要
本コースで学習する大まかな内容
データの保存とエクスポート
クエリ結果から新しい永続テーブルと一時テーブルを作成する
Read more
BigQuery に新しいデータセットを取り込む
BigQuery に新しいデータセットを読み込んで作成する
データセットの結合と統合
SQL の JOIN と UNION の違いと使い分けについて理解する
データの可視化
Looker Studio を使用して、ダッシュボードとビジュアリゼーションを作成する
コースのまとめ
主な学習ポイントの概要
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
コースは、BigQuery に固有の要素について説明します
講座タイトル：高度なインサイトをビッグクエリで実現する
コースの目標：学習者が、ビッグクエリで高度な洞察を得るために必要な知識とスキルを習得
コースは、SQL の JOIN と UNION について説明します
コースは、データの可視化について説明します
Save this course
Save Creating New BigQuery Datasets and Visualizing Insights 日本語版 to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Creating New BigQuery Datasets and Visualizing Insights 日本語版 with these
activities:
Review SQL fundamentals
Show steps
Reinforce your SQL basics before starting the course to ensure a solid foundation.
Browse courses on
SQL
Show steps
-
Review standard SQL operators and syntax
-
Practice writing basic SELECT, INSERT, UPDATE, and DELETE queries
-
Understand data types and type casting
-
Review basic aggregate functions (e.g., SUM, COUNT, AVG)
BigQuery に関するチュートリアルを完了する
Show steps
公式ドキュメントやオンラインチュートリアルを通じてBigQuery のスキルを向上させます。
Show steps
-
公式ドキュメントを閲覧する
-
オンラインコースやチュートリアルを受講する
-
チュートリアルに沿って作業する
Create a data model for a real-world scenario
Show steps
Apply your SQL skills to a practical project by designing a data model for a specific business use case.
Show steps
-
Identify a business scenario and define the data requirements
-
Design the data model using entities, relationships, and attributes
-
Create a physical implementation of the model in BigQuery
-
Write SQL queries to extract and analyze data from the model
Nine other activities
Expand to see all activities and additional details
Show all 12 activities
練習問題を解く
Show steps
定期的な練習により、SQLの基礎概念を強化することができます。
Show steps
-
練習問題をいくつか完了する
-
問題のソリューションを確認する
-
間違った箇所を特定して、その理由を理解する
Attend a local SQL meetup or conference
Show steps
Connect with other professionals in the SQL community, exchange ideas, and learn about industry trends at a local meetup or conference.
Show steps
-
Find and register for a relevant SQL event in your area
-
Attend the event and participate in discussions
-
Meet and network with other SQL enthusiasts
-
Follow up with new connections and explore potential collaborations
Explore advanced SQL concepts on Coursera
Show steps
Enhance your SQL skills by following guided tutorials on advanced topics, such as subqueries, window functions, and joins.
Show steps
-
Identify specific advanced SQL concepts you want to learn
-
Find relevant tutorials on Coursera or other reputable platforms
-
Follow the tutorials and complete the exercises
-
Practice implementing the concepts in your own SQL queries
BigQuery に関するブログ記事を書く
Show steps
自身の学習を整理し、理解を深めるために、学んだ概念についてブログ記事を書く。
Show steps
-
学んだ概念をリストにする
-
それぞれの概念について説明する段落を書く
-
ブログ記事を校正、編集する
Write a blog post explaining a complex SQL query
Show steps
Deepen your understanding by writing a blog post that explains a challenging SQL query, sharing your insights and thought process.
Show steps
-
Choose a complex SQL query that you have solved
-
Break down the query into smaller, manageable parts
-
Explain each part of the query in detail, including its purpose and implementation
-
Write and publish your blog post
Solve SQL challenges on LeetCode or HackerRank
Show steps
Test your SQL proficiency by solving challenging problems on platforms like LeetCode or HackerRank, pushing your skills to the next level.
Show steps
-
Register for an account on LeetCode or HackerRank
-
Select SQL problems that match your skill level
-
Solve the problems and submit your solutions
-
Review your solutions and identify areas for improvement
BigQuery ダッシュボードを作成する
Show steps
実用的なインサイトを生成するために、BigQuery のデータを使用してダッシュボードを作成します。
Show steps
-
ダッシュボードで表示したいデータセットを特定する
-
Looker Studio でダッシュボードを作成する
-
ダッシュボードをチームと共有する
Contribute to an open-source SQL project
Show steps
Enhance your SQL skills and gain practical experience by contributing to an open-source SQL project, such as a database engine or data analysis library.
Show steps
-
Identify an open-source SQL project that aligns with your interests
-
Review the project's documentation and contribution guidelines
-
Find an issue or feature that you can contribute to
-
Implement your solution and submit a pull request
-
Work with the project maintainers to refine and merge your contribution
企業データ分析プロジェクトを始める
Show steps
現実的なビジネス問題に取り組み、BigQuery のスキルと知識をテストします。
Show steps
-
プロジェクトのスコープを定義する
-
使用するデータセットを収集する
-
結果を分析してインサイトを生成する
Review SQL fundamentals
Show steps
Reinforce your SQL basics before starting the course to ensure a solid foundation.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review standard SQL operators and syntax
- Practice writing basic SELECT, INSERT, UPDATE, and DELETE queries
- Understand data types and type casting
- Review basic aggregate functions (e.g., SUM, COUNT, AVG)
BigQuery に関するチュートリアルを完了する
Show steps
公式ドキュメントやオンラインチュートリアルを通じてBigQuery のスキルを向上させます。
Show steps
Show steps
Show steps
- 公式ドキュメントを閲覧する
- オンラインコースやチュートリアルを受講する
- チュートリアルに沿って作業する
Create a data model for a real-world scenario
Show steps
Apply your SQL skills to a practical project by designing a data model for a specific business use case.
Show steps
Show steps
Show steps
- Identify a business scenario and define the data requirements
- Design the data model using entities, relationships, and attributes
- Create a physical implementation of the model in BigQuery
- Write SQL queries to extract and analyze data from the model
Nine other activities
Expand to see all activities and additional details
Show all 12 activities
練習問題を解く
Show steps
定期的な練習により、SQLの基礎概念を強化することができます。
Show steps
Show steps
Show steps
- 練習問題をいくつか完了する
- 問題のソリューションを確認する
- 間違った箇所を特定して、その理由を理解する
Attend a local SQL meetup or conference
Show steps
Connect with other professionals in the SQL community, exchange ideas, and learn about industry trends at a local meetup or conference.
Show steps
Show steps
Show steps
- Find and register for a relevant SQL event in your area
- Attend the event and participate in discussions
- Meet and network with other SQL enthusiasts
- Follow up with new connections and explore potential collaborations
Explore advanced SQL concepts on Coursera
Show steps
Enhance your SQL skills by following guided tutorials on advanced topics, such as subqueries, window functions, and joins.
Show steps
Show steps
Show steps
- Identify specific advanced SQL concepts you want to learn
- Find relevant tutorials on Coursera or other reputable platforms
- Follow the tutorials and complete the exercises
- Practice implementing the concepts in your own SQL queries
BigQuery に関するブログ記事を書く
Show steps
自身の学習を整理し、理解を深めるために、学んだ概念についてブログ記事を書く。
Show steps
Show steps
Show steps
- 学んだ概念をリストにする
- それぞれの概念について説明する段落を書く
- ブログ記事を校正、編集する
Write a blog post explaining a complex SQL query
Show steps
Deepen your understanding by writing a blog post that explains a challenging SQL query, sharing your insights and thought process.
Show steps
Show steps
Show steps
- Choose a complex SQL query that you have solved
- Break down the query into smaller, manageable parts
- Explain each part of the query in detail, including its purpose and implementation
- Write and publish your blog post
Solve SQL challenges on LeetCode or HackerRank
Show steps
Test your SQL proficiency by solving challenging problems on platforms like LeetCode or HackerRank, pushing your skills to the next level.
Show steps
Show steps
Show steps
- Register for an account on LeetCode or HackerRank
- Select SQL problems that match your skill level
- Solve the problems and submit your solutions
- Review your solutions and identify areas for improvement
BigQuery ダッシュボードを作成する
Show steps
実用的なインサイトを生成するために、BigQuery のデータを使用してダッシュボードを作成します。
Show steps
Show steps
Show steps
- ダッシュボードで表示したいデータセットを特定する
- Looker Studio でダッシュボードを作成する
- ダッシュボードをチームと共有する
Contribute to an open-source SQL project
Show steps
Enhance your SQL skills and gain practical experience by contributing to an open-source SQL project, such as a database engine or data analysis library.
Show steps
Show steps
Show steps
- Identify an open-source SQL project that aligns with your interests
- Review the project's documentation and contribution guidelines
- Find an issue or feature that you can contribute to
- Implement your solution and submit a pull request
- Work with the project maintainers to refine and merge your contribution
企業データ分析プロジェクトを始める
Show steps
現実的なビジネス問題に取り組み、BigQuery のスキルと知識をテストします。
Show steps
Show steps
Show steps
- プロジェクトのスコープを定義する
- 使用するデータセットを収集する
- 結果を分析してインサイトを生成する
Career center
Learners who complete Creating New BigQuery Datasets and Visualizing Insights 日本語版 will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
Data Analysts are responsible for collecting, cleaning, and analyzing data to help organizations make informed decisions. This course can help Data Analysts develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Data Analysts can gain a deeper understanding of data and how it can be used to solve business problems.
Data Scientist
Data Scientist
Data Scientists use scientific methods to extract knowledge and insights from data. This course can help Data Scientists develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Data Scientists can gain a deeper understanding of data and how it can be used to solve complex problems.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts help organizations make better decisions by providing them with data-driven insights. This course can help Business Intelligence Analysts develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Business Intelligence Analysts can gain a deeper understanding of data and how it can be used to improve business outcomes.
Data Engineer
Data Engineer
Data Engineers are responsible for designing, building, and maintaining data pipelines. This course can help Data Engineers develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Data Engineers can gain a deeper understanding of data and how it can be used to build scalable and reliable data pipelines.
Database Administrator
Database Administrator
Database Administrators are responsible for managing and maintaining databases. This course can help Database Administrators develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Database Administrators can gain a deeper understanding of data and how it can be used to improve database performance and reliability.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. This course can help Software Engineers develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Software Engineers can gain a deeper understanding of data and how it can be used to build data-driven applications.
Data Architect
Data Architect
Data Architects design and manage data systems. This course can help Data Architects develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Data Architects can gain a deeper understanding of data and how it can be used to build scalable and efficient data systems.
Statistician
Statistician
Statisticians collect, analyze, and interpret data to help organizations make informed decisions. This course can help Statisticians develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Statisticians can gain a deeper understanding of data and how it can be used to solve statistical problems.
Quantitative Analyst
Quantitative Analyst
Quantitative Analysts use mathematical and statistical models to analyze data and make predictions. This course can help Quantitative Analysts develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Quantitative Analysts can gain a deeper understanding of data and how it can be used to build predictive models.
Market Researcher
Market Researcher
Market Researchers collect, analyze, and interpret data to help organizations understand their customers and markets. This course can help Market Researchers develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Market Researchers can gain a deeper understanding of data and how it can be used to make better marketing decisions.
Product Manager
Product Manager
Product Managers are responsible for defining and managing the development of products. This course can help Product Managers develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Product Managers can gain a deeper understanding of data and how it can be used to build better products.
Financial Analyst
Financial Analyst
Financial Analysts use data to analyze and make recommendations on investments. This course can help Financial Analysts develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Financial Analysts can gain a deeper understanding of data and how it can be used to make better investment decisions.
Risk Analyst
Risk Analyst
Risk Analysts use data to identify and assess risks. This course can help Risk Analysts develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Risk Analysts can gain a deeper understanding of data and how it can be used to manage risk.
Fraud Analyst
Fraud Analyst
Fraud Analysts use data to detect and investigate fraud. This course can help Fraud Analysts develop the skills they need to work with BigQuery, a powerful data analysis tool. By learning how to create new datasets, visualize insights, and join and union multiple tables, Fraud Analysts can gain a deeper understanding of data and how it can be used to combat fraud.
For more career information including salaries, visit:
OpenCourser.com/course/kd02gl/creating
Reading list
We've selected eight books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Creating New BigQuery Datasets and Visualizing Insights 日本語版.
この本は、Looker Studioの包括的なガイドであり、ダッシュボードとビジュアリゼーションの作成に関する詳細な情報を提供します。このコースで学習する概念を補完するのに役立ちます。
Save
この本は、ビッグデータアナリティクスの包括的な入門書であり、ビッグデータの処理、分析、視覚化に関する詳細な情報を提供します。このコースで学習するビッグデータの概念を補完するのに役立ちます。
この本は、データウェアハウスの設計に関する包括的なガイドであり、データウェアハウスの設計、実装、管理に関する詳細な情報を提供します。このコースで学習するデータ管理の概念を補完するのに役立ちます。
Save
この本は、SQLの包括的なリファレンスであり、さまざまなデータソースからのデータのクエリに関する詳細な情報を提供します。このコースで学習するSQLの概念を補完するのに役立ちます。
この本は、SQLの包括的な入門書であり、データ分析のためのSQLの基本的な概念について説明しています。このコースで学習するSQLの概念を補完するのに役立ちます。
Save
この本は、データビジュアリゼーションの包括的なガイドであり、データを効果的に視覚化するための原則とテクニックについて説明しています。このコースで学習するデータビジュアリゼーションの概念を補完するのに役立ちます。
Save
この本は、SQLの簡潔な入門書であり、SQLの基本的な概念について説明しています。このコースで学習するSQLの概念を補完するのに役立ちます。
この本は、SQLの簡潔なガイドであり、SQLの基本的な概念について説明しています。このコースで学習するSQLの概念を補完するのに役立ちます。
For more information about how these books relate to this course, visit:
OpenCourser.com/course/kd02gl/creating
Share
Similar courses
Here are nine courses similar to
Creating New BigQuery Datasets and Visualizing Insights 日本語版.
Achieving Advanced Insights with BigQuery 日本語版
OpenCourser.com/course/s5z4js/achieving
Achieving Advanced Insights with BigQuery 日本語版
Most relevant
Google Sheets 日本語版
OpenCourser.com/course/13oqqf/google
Google Sheets 日本語版
Most relevant
Machine Learning in the Enterprise - 日本語版
OpenCourser.com/course/h2jm8l/machine
Machine Learning in the Enterprise - 日本語版
Most relevant
3. つなぎ、守る：ネットワークとネットワーク セキュリティ
OpenCourser.com/course/zh06ow/3
3. つなぎ、守る：ネットワークとネットワーク セキュリティ
Most relevant
Google Docs 日本語版
OpenCourser.com/course/3vuwsm/google
Google Docs 日本語版
Most relevant
Managing Google Workspace 日本語版
OpenCourser.com/course/8z4t5v/managing
Managing Google Workspace 日本語版
Most relevant
Introduction to Google Workspace 日本語版
OpenCourser.com/course/sahyh1/introduction
Introduction to Google Workspace 日本語版
Most relevant
Google Slides 日本語版
OpenCourser.com/course/jgulhv/google
Google Slides 日本語版
Most relevant
【教科書英語にさようなら!】 海外に行かずに2024年のリアル英会話をマスターするためのステップバイステップガイド
OpenCourser.com/course/65gg4m/[(Jiao
【教科書英語にさようなら!】 海外に行かずに2024年のリアル英会話をマスターするためのステップバイステップガイド
Most relevant
Effort
1 週間の学習（5～7 時間/週）
Level
Introductory
Via
Coursera
Institution
Google Cloud
Instructor
Google Cloud Training
Language
日本語
Transcript
English
This course belongs to a
collection
called
From Data to Insights with Google Cloud 日本語版. It's comprised of four courses:
- Applying Machine Learning to Your Data with GC - 日本語版
- Achieving Advanced Insights with BigQuery 日本語版
- Creating New BigQuery Datasets and Visualizing Insights 日本語版 (viewing)
- Exploring and Preparing your Data with BigQuery 日本語版
Good to know
コースは、BigQuery に固有の要素について説明します
講座タイトル：高度なインサイトをビッグクエリで実現する
コースの目標：学習者が、ビッグクエリで高度な洞察を得るために必要な知識とスキルを習得
コースは、SQL の JOIN と UNION について説明します
コースは、データの可視化について説明します
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser