Introduction to Data Analytics on Google CloudIDAGCGOGoogleGO-IDAGC1.0<ul>
<li>Describe the data analytics workflow on Google Cloud and summarize the different types of analytics.</li><li>Identify Google Cloud data analytics products and describe how each is used to work with data.</li><li>Describe data sources, data structures, and data storage options in Google Cloud.</li><li>Use BigQuery, Looker, and Looker Studio to answer data questions and influence business decisions.</li></ul><ul>
<li>Basic familiarity with SQL</li><li>Basic understanding of data concepts such as data types (relational, non-relational) and storage (data lakes, data warehouses)</li></ul><p>Data analysts</p><h4>Module 1 - Understand the Data Analytics Lifecycle on Google Cloud</h4><p>
<strong>Topics:</strong>
</p>
<ul>
<li>Data analytics workflow</li><li>Data sources</li><li>Storage methods</li><li>Google Cloud data analytics products</li><li>Data types</li></ul><p><strong>Objectives:</strong>
</p>
<ul>
<li>Detail and describe the data analytics workflow on Google Cloud.</li><li>Compare and contrast data sources and storage methods available in Google Cloud.</li><li>Compare how different data types can be used for data analytics.</li></ul><p><strong>Activities:</strong>
</p>
<ul>
<li>Quiz</li></ul><h4>Module 2 - Explore Data and Extract Insights by Using BigQuery</h4><p>
<strong>Topics:</strong>
</p>
<ul>
<li>BigQuery services, capabilities, and organization</li><li>Data storage</li><li>Basic SQL</li><li>Answering data-driven questions</li></ul><p><strong>Objectives:</strong>
</p>
<ul>
<li>Describe BigQuery and the BigQuery solution architecture.</li><li>Derive insights from data by using BigQuery.</li><li>Use the BigQuery user interface to run basic queries</li></ul><p><strong>Activities:</strong>
</p>
<ul>
<li>Lab 1: BigQuery Qwik Start: Console</li><li>Lab 2: Introduction to SQL for BigQuery and Cloud SQL</li><li>Lab 3: BigLake: Qwik Start</li><li>Lab 4: Analyze data with Gemini Assistance</li><li>Quiz</li></ul><h4>Module 3 - Make Data-Driven Decisions by Using Looker</h4><p>
<strong>Topics:</strong>
</p>
<ul>
<li>Looker data exploration terms and concepts</li><li>Looks and dashboards</li><li>Visualizations</li><li>Report sharing</li><li>Looker Studio</li></ul><p><strong>Objectives:</strong>
</p>
<ul>
<li>Manipulate a Looker Explore to answer data-driven questions.</li><li>Create a situation-appropriate visualization to highlight the answer for a datadriven question.</li><li>Choose between Looker and Looker Studio for data visualization and sharing.</li><li>Share visualizations with others.</li></ul>
<p><strong>Activities:</strong>
</p>
<ul>
<li>Lab 1: Looker Data Explorer—Qwik Start</li><li>Lab 2: Looker Data Studio—Qwik Start</li><li>Quiz</li></ul><h4>Module 4 - Course Summary</h4><p>
<strong>Topics:</strong>
</p>
<ul>
<li>Topic review</li><li>Slides</li></ul><p><strong>Objectives:</strong>
</p>
<ul>
<li>Find resources for additional learning and support.</li></ul>- Describe the data analytics workflow on Google Cloud and summarize the different types of analytics.
- Identify Google Cloud data analytics products and describe how each is used to work with data.
- Describe data sources, data structures, and data storage options in Google Cloud.
- Use BigQuery, Looker, and Looker Studio to answer data questions and influence business decisions.- Basic familiarity with SQL
- Basic understanding of data concepts such as data types (relational, non-relational) and storage (data lakes, data warehouses)Data analystsModule 1 - Understand the Data Analytics Lifecycle on Google Cloud
Topics:
- Data analytics workflow
- Data sources
- Storage methods
- Google Cloud data analytics products
- Data types
Objectives:
- Detail and describe the data analytics workflow on Google Cloud.
- Compare and contrast data sources and storage methods available in Google Cloud.
- Compare how different data types can be used for data analytics.
Activities:
- Quiz
Module 2 - Explore Data and Extract Insights by Using BigQuery
Topics:
- BigQuery services, capabilities, and organization
- Data storage
- Basic SQL
- Answering data-driven questions
Objectives:
- Describe BigQuery and the BigQuery solution architecture.
- Derive insights from data by using BigQuery.
- Use the BigQuery user interface to run basic queries
Activities:
- Lab 1: BigQuery Qwik Start: Console
- Lab 2: Introduction to SQL for BigQuery and Cloud SQL
- Lab 3: BigLake: Qwik Start
- Lab 4: Analyze data with Gemini Assistance
- Quiz
Module 3 - Make Data-Driven Decisions by Using Looker
Topics:
- Looker data exploration terms and concepts
- Looks and dashboards
- Visualizations
- Report sharing
- Looker Studio
Objectives:
- Manipulate a Looker Explore to answer data-driven questions.
- Create a situation-appropriate visualization to highlight the answer for a datadriven question.
- Choose between Looker and Looker Studio for data visualization and sharing.
- Share visualizations with others.
Activities:
- Lab 1: Looker Data Explorer—Qwik Start
- Lab 2: Looker Data Studio—Qwik Start
- Quiz
Module 4 - Course Summary
Topics:
- Topic review
- Slides
Objectives:
- Find resources for additional learning and support.1 day595.00650.00660.00820.00950.00950.00950.00790.00950.00