Data modeling: designing for queries

How to model data so analytics stays fast over billions of rows: OLTP against OLAP, the star schema with facts, dimensions and grain, slowly changing dimensions and point-in-time accuracy, columnar formats, partitioning and Z-ordering, rollups and materialized views, the ETL load order, and the classic modeling mistakes.