Data Warehouse - bobbae/gcp GitHub Wiki

A data warehouse is an enterprise system used for the analysis and reporting of structured and semi-structured data from multiple sources, such as point-of-sale transactions, marketing automation, customer relationship management, and more.

Secure data warehouse blueprint

https://cloud.google.com/blog/products/identity-security/best-practices-for-secure-data-warehouse-in-google-cloud

Data modeling

https://www.guru99.com/database-design.html

https://www.guru99.com/data-modeling-tools-design-database.html

ELT vs ETL

https://www.guru99.com/etl-vs-elt.html

OLAP vs OLTP

https://www.guru99.com/oltp-vs-olap.html

Fact table vs Dimension table

https://www.guru99.com/fact-table-vs-dimension-table.html

Dimensional modeling

https://www.guru99.com/dimensional-model-data-warehouse.html

https://www.advancinganalytics.co.uk/blog/2019/6/17/is-kimball-still-relevant-in-the-modern-data-warehouse

Star and Snowflake

https://www.guru99.com/star-snowflake-data-warehousing.html

Inmon or Kimball

https://www.computerweekly.com/tip/Inmon-or-Kimball-Which-approach-is-suitable-for-your-data-warehouse

BigQuery

Learn about BigQuery, Google Cloud’s modern and serverless data warehousing solution.

Data lake

A data lake is a centralized repository designed to store, process, and secure large amounts of structured, semistructured, and unstructured data. It can store data in its native format and process any variety of it, ignoring size limits.

https://www.guru99.com/data-lake-architecture.html

Data warehousing tools

https://www.guru99.com/top-20-etl-database-warehousing-tools.html

ETL Tools

https://www.guru99.com/best-etl-tools.html

https://www.guru99.com/etl-testing-tools.html

Data integration tools

https://www.guru99.com/data-integration-tools.html