第二章 数据仓库

Google Trends例子

Metadata 给之后的人管理使用

hardest part- how to design a database

Retail Case Study
如何设计促销?
步骤:

  1. Business process商业-》 Sales
  2. Grain of business process-> an line in receipt
  3. dimension: product, time, store, promotions
  4. facts: total sales, total cost, gross margin