Warehouse: analytical queries over historical data. OLAP vs OLTP: different access patterns. Star schema: fact tables (events) surrounded by dimension tables (users, products, time).
ETL pipelines load data from sources. Columnar storage (Parquet) for analytical queries. Query engines: Redshift, BigQuery, Snowflake. Partition by date for efficient scans. Pre-aggregate common queries into materialized views.