Four-Project Series

Build a Data Warehouse in the Multi Cloud you own this product

prerequisites
basics of Google BigQuery, Google Data Studio, and SQL
skills learned
loading data into BigQuery • connect a BigQuery table as a GDS data source • create a table chart in GDS
Mike Shakhomirov
4 weeks · 6-9 hours per week average · INTERMEDIATE

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more


In this series of liveProjects, you’ll build a complete data warehouse solution that can serve essential data to a wide team of data, finance, and marketing departments across your company. Your company’s data is growing faster than ever, so your solution needs to scale. You’ll also need to account for your hybrid stack, with data and resources spread across both AWS and Google Cloud Platform. Each liveProject in this series is standalone, covering another essential task of building and migrating to a cloud data platform.

These projects are designed for learning purposes and are not complete, production-ready applications or solutions.

Manning author Mike Shakhomirov shares what he likes about the Manning liveProject platform.

here's what's included

Project 1 Load Data into BigQuery
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 2 Extract Data from MySQL
In this liveProject, you’ll build an extraction pipeline to transfer data from a legacy server-side database in AWS MySQL into your new cloud platform. You’ll learn how to create an integration data layer, and develop a maintainable and flexible data intrastate that is both easy to work with and easy to scale.
Project 3 Build a Data Pipeline with BigQuery
In this liveProject, you’ll create a data pipeline that can enrich source data with currency exchange rates and converted totals. As this pipeline is updated daily, you’ll need to create a scheduled query to enrich your data. You’ll learn to load essential data into BigQuery from both CSVS and JSON, and use it to generate a daily business intelligence report for your colleagues.
Project 4 Business Intelligence with BigQuery
In this liveProject, you’ll create a Google Data Studio report that can visualise your datasets for the purpose of business intelligence. You’ll connect up numerous data sources using BigQuery to feed directly into your new BI dashboard. You’ll design and implement revenue and daily spend metrics and line graphs, and scorecards for top users.

book resources

When you start each of the projects in this series, you'll get full access to the following book for 90 days.

choose your plan

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Build a Data Warehouse in the Multi Cloud project for free

project author

Mike Shakhomirov

Mike Shakhomirov is the head of data engineering at The World's Online Festival. He has an MBA as well as a diploma in big data and social analytics from MIT, and he’s a Google Cloud Certified Professional Data Engineer. Passionate, enthusiastic, and digitally focused, he loves the challenges that the diverse gamut of digital marketing can offer. Mike is an official writer for publications including Towards Data Science and The Startup, and he’s the author of more than 50 published articles on topics such as data engineering, machine learning, and AI in digital marketing. You can find him on LinkedIn and Medium.

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

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 and our expert mentors.
Compare with others
For each step, compare your deliverable to the solutions by the author and other participants.
book resources
Get full access to select books for 90 days. Permanent access to excerpts from Manning products are also included, as well as references to other resources.