Have you ever wondered how a business analyst can ask “show me total sales by product category and month, just for the last quarter,” and get an answer in seconds across billions of rows? This chapter reveals the secret. It introduces the design patterns and processing engines that make fast, flexible analysis possible: dimensional modeling and online analytical processing (OLAP).