Introduction to Data Analytics on Google Cloud
This course is an introduction to data analytics on Google Cloud. It is designed for learners who have no prior experience with data analytics or Google Cloud. The course covers the basics of data analysis, including collection, storage, exploration, visualization, and sharing. It also introduces learners to Google Cloud's data analytics tools and services. Through video lectures, demos, quizzes, and hands-on labs, the course demonstrates how to go from raw data to impactful visualizations and dashboards.
- Duration: 1 day
- Languages: English, German
- Level: Introductory
- Group size: Up to 16
What you'll learn
- 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.
Prerequisites
- Basic familiarity with SQL
- Basic understanding of data concepts such as data types (relational, non-relational) and storage (data lakes, data warehouses)
Course outline
Understand the Data Analytics Lifecycle on Google Cloud
- Data analytics workflow
- Data sources
- Storage methods
- Google Cloud data analytics products
- Data types
Explore Data and Extract Insights by Using BigQuery
- BigQuery services, capabilities, and organization
- Data storage
- Basic SQL
- Answering data-driven questions
Make Data-Driven Decisions by Using Looker
- Looker data exploration terms and concepts
- Looks and dashboards
- Visualizations
- Report sharing
- Looker Studio
Course Summary
- Topic review
- Slides
Related courses
Analyzing and Visualizing Data in Looker
In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. You learn to leverage Looker's modern analytics platform to find and explore relevant content in your organization’s Looker instance. You also discover how to ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision-making.
Introduction to Data Engineering on Google Cloud
In this course, you learn about data engineering on Google Cloud, the roles and responsibilities of data engineers, and how those map to offerings provided by Google Cloud. You also learn about ways to address data engineering challenges.
AlloyDB Essentials
This course explores the benefits of AlloyDB, especially compared to PostgreSQL on Cloud SQL. It will walk you through AlloyDB’s unique architecture, and explain how to configure deployments on Google Cloud.The course is divided into two parts: AlloyDB Administration Essentials (architecture and configuration) and AlloyDB Optimization Essentials (performance tuning).
Not sure which course fits?
Book a 30-minute call. We'll look at where your team is, what they need to be able to do, and put together either a specific course date or a tailored learning plan.