Slides:

https://docs.google.com/presentation/d/1a3ZoBAXFk8-EhUsd7rAZd-5p_HpltkzSeujjRGB2TAI/edit?usp=sharing

Data Warehouse

https://youtu.be/jrHljAoD6nM&list=PL3MmuxUbc_hJed7dXYoJw8DoCuVHhGEQb&index=34

OLAP vs OLTP

OLAP: Online Analytical Processing.

OLTP: Online Transaction Processing.

What is a Data Warehouse?

• OLAP solution
• Used for reporting and data analysis
• Can have many sources
• Can be transformed into data marts

BigQuery

• A Data Warehouse solution
• Serverless
• Provides a software and an infrastructure
• Built-in features: machine learning, geospatial analysis, business intelligence
• Separates the compute engine from the storage
  • Allows us to create external tables, meaning the storage can be CSV files in Cloud Storage