First page Back Continue Last page Overview Graphics
IV. Quick Conclusions
The Dimensional Model (a/k/a Star Schema)
- A powerful design pattern for slice-and-dice reporting
How to implement
- Build the Model: Entity, Dimension, Fact
- ETL:
- Extract or Parse
- Fact-Per-Row, Header-Trailer, Separate Sources
- Transform and Conform,
- Load into Python objects
- Analysis:
- Summarize on a dimension
- Pick subsets
- Pivot tables