Load Data into BigQuery

This free project is part of the Build a Data Warehouse in the Multi Cloud bundle.

prerequisites: basics of cloud computing • basics of shell scripting
skills learned: setting up a Google Cloud Account • loading data into BigQuery • handling file formats

Mike Shakhomirov

1 week · 4-6 hours per week · INTERMEDIATE

filed under

placing your order...

Don't refresh or navigate away from the page.

liveProject

$19.99

liveProject This free project is part of the Build a Data Warehouse in the Multi Cloud bundle. liveProjects give you the opportunity to learn new skills by completing real-world challenges in your local development environment. Solve practical problems, write working code, and analyze real data—with liveProject, you learn by doing. explore series

This free project is part of the Build a Data Warehouse in the Multi Cloud bundle. explore series

Check your email for instructions on accessing Load Data into BigQuery (liveProject)

continue shopping

go to cart

Look inside

In this liveProject, you’ll use Google Cloud Platform’s BigQuery tool to transfer data from a legacy data lake to new cloud storage on GCP. You’ll start by setting up your Google Cloud developer account, then utilize Google Web Console to create a Cloud Storage bucket and load data into a BigQuery table. You’ll learn how to handle different file formats, and manage resources with Google Cloud Shell.

project author

Mike Shakhomirov

Mike Shakhomirov is a lead data engineer at The World's Online Festival. He has an MBA and MIT diploma in big data and social analytics and is a Google Cloud Certified Professional Data Engineer. He is a passionate and digitally focused individual with an abundance of drive and enthusiasm, loving the challenges the full mix of digital marketing can offer. He is also an official writer for publications such as Towards Data Science and The Startup, with more than 20 published articles on various topics. He writes about data engineering, machine learning and AI in digital marketing.

prerequisites

This liveProject is for complete beginners to data engineering, who have never worked with Google Cloud Platform before.

TECHNIQUES

Basics of cloud computing
Basics of shell scripting

you will learn

In this liveProject, you’ll learn how to utilize an effective cloud data warehouse as the heart of your data architecture.

Setting up a Google Cloud account
Loading data into BigQuery
Handling file formats

features

Self-paced: You choose the schedule and decide how much time to invest as you build your project.
Project roadmap: Each project is divided into several achievable steps.
Get Help: While within the liveProject platform, get help from other participants.
Compare with others: For each step, compare your deliverable to the solutions by the author and other participants.