We may earn an affiliate commission when you visit our partners.

Exploring and Preparing your Data with BigQuery 日本語版

"このコースでは、データアナリストが共通して直面する課題と、その課題を Google Cloud のビッグデータツールを使用して解決する方法を取り上げます。その過程で SQL を学習しながら、BigQuery と Dataprep を使用してデータセットを分析し、変換する方法について理解を深めます。

これは「From Data to Insights with Google Cloud」シリーズの最初のコースです。このコースを修了したら、「Creating New BigQuery Datasets and Visualizing Insights」コースを受講してください。"

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Two deals to help you save

We found two deals and offers that may be relevant to this course.

Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid for a limited time only

Future-proof your career

Access O'Reilly books, live events, courses, and more. Save with an annual subscription.

Take

15%

off

What's inside

Syllabus

「From Data to Insights with Google Cloud - Exploring and Preparing Your Data」へようこそ

このデータアナリストコースのシリーズに含まれるコース、コンテンツ、テクノロジーを紹介します

Google Cloud におけるデータの概要

Google Cloud の背後にある基本原則と、それをビッグデータ分析に活用する方法を理解する

ビッグデータツールの概要

データの分析、準備、可視化に使用する、Google Cloud の主要なビッグデータツールを確認する

SQL を使用したデータの探索

基本的な SQL（構造化クエリ言語）を使用してデータのクエリを行う方法を学習し、BigQuery でクエリを書き込む演習を行う

BigQuery の料金

BigQuery の料金体系と、クエリを最適化する方法を理解する

データのクリーニングと変換

高品質のデータセットを作成する重要性を理解し、データ変換に役立つツールについて学習する

コースのまとめ

主な学習ポイントの概要

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

তথ্যアナリストに関連する仕事をしており、ビッグデータを扱う Google Cloud のツールに興味のある方を対象としています。

SQL の基礎を学ぶため、データアナリストとしてのスキルを向上させたい方を対象としています。

Save this course

Save Exploring and Preparing your Data with BigQuery 日本語版 to your list so you can find it easily later:

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 Exploring and Preparing your Data with BigQuery 日本語版 with these activities:

復習 SQL の基礎

Show steps

SQL の基礎を復習することで、BigQuery のクエリ 작성の基盤を固めましょう。

Browse courses on SQL

Show steps

SQL チュートリアルを完了する
練習問題に取り組む

BigQuery チュートリアルを完了する

Show steps

BigQuery のチュートリアルを完了することで、このツールを使用してデータを分析する方法の基本的な知識を身に付けることができます。

Browse courses on BigQuery

Show steps

Google Cloud BigQuery チュートリアルのドキュメントを読む
提供されている練習問題を完了する

Show all two activities

Career center

Learners who complete Exploring and Preparing your Data with BigQuery 日本語版 will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts explore and prepare data using tools like Google Cloud's BigQuery and Dataprep. This course can help build a foundation in these tools and SQL, which are common components of a Data Analyst's toolkit. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Data Analyst.

See salaries and explore the career path for Data Analyst

Data Engineer

Data Engineers explore and prepare data using tools like Google Cloud's BigQuery and Dataprep. This course can help build a foundation in these tools and SQL, which are common components of a Data Engineer's toolkit. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Data Engineer.

See salaries and explore the career path for Data Engineer

Business Analyst

Business Analysts explore and prepare data to inform business decisions. This course can help build a foundation in data exploration and preparation tools, as well as SQL, which are common components of a Business Analyst's toolkit. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Business Analyst.

See salaries and explore the career path for Business Analyst

Data Architect

Data Architects explore and prepare data to design and build data systems. This course can help build a foundation in data exploration and preparation tools, as well as SQL, which are common components of a Data Architect's toolkit. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Data Architect.

See salaries and explore the career path for Data Architect

Data Scientist

Data Scientists explore and prepare data to build machine learning models. This course can help build a foundation in data exploration and preparation tools, as well as SQL, which are common components of a Data Scientist's toolkit. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Data Scientist.

See salaries and explore the career path for Data Scientist

Machine Learning Engineer

Machine Learning Engineers explore and prepare data to build machine learning models. This course can help build a foundation in data exploration and preparation tools, as well as SQL, which are common components of a Machine Learning Engineer's toolkit. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Machine Learning Engineer.

See salaries and explore the career path for Machine Learning Engineer

Database Administrator

Database Administrators explore and prepare data to maintain and optimize databases. This course can help build a foundation in data exploration and preparation tools, as well as SQL, which are common components of a Database Administrator's toolkit. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Database Administrator.

See salaries and explore the career path for Database Administrator

Information Security Analyst

Information Security Analysts explore and prepare data to identify and mitigate security risks. This course can help build a foundation in data exploration and preparation tools, as well as SQL, which are common components of an Information Security Analyst's toolkit. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as an Information Security Analyst.

See salaries and explore the career path for Information Security Analyst

Data Journalist

Data Journalists explore and prepare data to uncover and tell stories. This course may be useful for Data Journalists who want to build a foundation in data exploration and preparation tools, as well as SQL. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Data Journalist.

See salaries and explore the career path for Data Journalist

Operations Research Analyst

Operations Research Analysts explore and prepare data to model and optimize complex systems. This course may be useful for Operations Research Analysts who want to build a foundation in data exploration and preparation tools, as well as SQL. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as an Operations Research Analyst.

See salaries and explore the career path for Operations Research Analyst

Quantitative Analyst

Quantitative Analysts explore and prepare data to develop and implement quantitative models. This course may be useful for Quantitative Analysts who want to build a foundation in data exploration and preparation tools, as well as SQL. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Quantitative Analyst.

See salaries and explore the career path for Quantitative Analyst

Actuary

Actuaries explore and prepare data to assess and manage financial risks. This course may be useful for Actuaries who want to build a foundation in data exploration and preparation tools, as well as SQL. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as an Actuary.

See salaries and explore the career path for Actuary

Market Researcher

Market Researchers explore and prepare data to understand consumer behavior and trends. This course may be useful for Market Researchers who want to build a foundation in data exploration and preparation tools, as well as SQL. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Market Researcher.

See salaries and explore the career path for Market Researcher

Statistician

Statisticians explore and prepare data to design and conduct statistical studies. This course may be useful for Statisticians who want to build a foundation in data exploration and preparation tools, as well as SQL. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Statistician.

See salaries and explore the career path for Statistician

Software Engineer

Software Engineers explore and prepare data to design and build software systems. This course may be useful for Software Engineers who want to build a foundation in data exploration and preparation tools, as well as SQL. This course is part of a series which includes creating new BigQuery datasets and visualizing insights; completing this course will help you get started with the skills and knowledge you need to succeed as a Software Engineer.

See salaries and explore the career path for Software Engineer

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 Exploring and Preparing your Data with BigQuery 日本語版.

Data Science on the Google Cloud Platform

Save

この本は、BigQuery の詳細なリファレンスであり、その機能と使用方法を網羅しています。

Exploring ​and ​Preparing ​your ​Data with BigQuery 日本語版

Two deals to help you save

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses

Exploring and Preparing your Data with BigQuery 日本語版