Designing an Analytical Data Warehouse

In the previous chapter, we discussed hands-on database design for structured data and design considerations. Then, we learned how to set up, configure, and create database objects, connect to the database, and access data programmatically. In this chapter, we will move on to designing for analytical data and start hands-on learning with a fully managed cloud data warehouse. In doing so, you will learn how to set up and configure databases, create datasets and objects, and query and perform sample analytics on data.

In this chapter, we’ll cover the following topics:

  • Understanding how data warehouses are different from databases
  • The significance of ETL in data warehouses
  • BigQuery hands-on
  • Summary of operational ...

Get Database Design and Modeling with Google Cloud now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.