Adi Wijaya - Data Engineering with Google Cloud Platform: A practical guide to operationalizing scalable data analytics systems on GCP

Build and deploy your own data pipelines on GCP, make key architectural decisions, and gain the confidence to boost your career as a data engineer

• Understand data engineering concepts, the role of a data engineer, and the benefits of using GCP for building your solution
• Learn how to use the various GCP products to ingest, consume, and transform data and orchestrate pipelines
• Discover tips to prepare for and pass the Professional Data Engineer exam

With this book, youll understand how the highly scalable Google Cloud Platform (GCP) enables data engineers to create end-to-end data pipelines right from storing and processing data and workflow orchestration to presenting data through visualization dashboards.

Starting with a quick overview of the fundamental concepts of data engineering, youll learn the various responsibilities of a data engineer and how GCP plays a vital role in fulfilling those responsibilities. As you progress through the chapters, youll be able to leverage GCP products to build a sample data warehouse using Cloud Storage and BigQuery and a data lake using Dataproc. The book gradually takes you through operations such as data ingestion, data cleansing, transformation, and integrating data with other sources. Youll learn how to design IAM for data governance, deploy ML pipelines with the Vertex AI, leverage pre-built GCP models as a service, and visualize data with Google Data Studio to build compelling reports. Finally, youll find tips on how to boost your career as a data engineer, take the Professional Data Engineer certification exam, and get ready to become an expert in data engineering with GCP.

By the end of this data engineering book, youll have developed the skills to perform core data engineering tasks and build efficient ETL data pipelines with GCP.

• Load data into BigQuery and materialize its output for downstream consumption
• Build data pipeline orchestration using Cloud Composer
• Develop Airflow jobs to orchestrate and automate a data warehouse
• Build a Hadoop data lake, create ephemeral clusters, and run jobs on the Dataproc cluster
• Leverage Pub/Sub for messaging and ingestion for event-driven systems
• Use Dataflow to perform ETL on streaming data
• Unlock the power of your data with Data Studio
• Calculate the GCP cost estimation for your end-to-end data solutions

This book is for data engineers, data analysts, and anyone looking to design and manage data processing pipelines using GCP. Youll find this book useful if you are preparing to take Googles Professional Data Engineer exam. Beginner-level understanding of data science, the Python programming language, and Linux commands is necessary. A basic understanding of data processing and cloud computing, in general, will help you make the most out of this book.

1. Fundamentals of Data Engineering
2. Big Data Capabilities on GCP
3. Building a Data Warehouse in BigQuery
4. Building Orchestration for Batch Data Loading Using Cloud Composer
5. Building a Data Lake Using Dataproc
6. Processing Streaming Data with Pub/Sub and Dataflow
7. Visualizing Data for Making Data-Driven Decisions with Data Studio
8. Building Machine Learning Solutions on Google Cloud Platform
9. User and Project Management in GCP
10. Cost Strategy in GCP
11. CI/CD on Google Cloud Platform for Data Engineers
12. Boosting Your Confidence as a Data Engineer