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 aspects and design considerations
