BigQuery for Data Warehousing: Managed Data Analysis in the Google Cloud

© Mark Mucchetti 2020

M. MucchettiBigQuery for Data Warehousinghttps://doi.org/10.1007/978-1-4842-6186-6_2

2. Starting Your Warehouse Project

Mark Mucchetti¹ 

(1)

Santa Monica, CA, USA

 

Building a data warehouse in a new organization can be challenging. While we tend to conceive of technology initiatives as mostly the hard technical decisions, anything involving data becomes far more investigative. You will want to use a lot of different skills aside from your ability to rationalize and normalize data structures. We’ll talk extensively about how to frame that discovery and learn how to “right-size” your warehouse for the environment. You’ll also want to figure out where you can make trade-offs and where you will want to invest your time to improve ...