My first Publication Agile-Data-Warehouse-Design-eBook

X Agile Data Warehouse Design Recurring Events..................................................................................................................... 29 ! Events and Fact Tables .......................................................................................................... 30 ! The 7Ws..................................................................................................................................... 31 ! Thinking Dimensionally ........................................................................................................... 31 ! Using the 7Ws: BEAM✲ Sequence ........................................................................................ 32 ! BEAM✲ IN A CTION : T ELLING S TORIES ................................................................................................ 33 ! 1. Discover an Event: Ask “Who Does What?” .......................................................................... 33 ! Focus on One Event at a Time ............................................................................................... 34 ! Identifying the Responsible Subject ........................................................................................ 34 ! 2. Document the Event: BEAM✲ Table ..................................................................................... 35 ! 3. Describe the Event: Using the 7Ws ....................................................................................... 37 ! When?..................................................................................................................................... 37 ! Collecting Event Stories .......................................................................................................... 38 ! Event Story Themes................................................................................................................ 39 ! Typical Stories......................................................................................................................... 40 ! Different Stories ...................................................................................................................... 40 ! Repeat Stories ........................................................................................................................ 40 ! Missing Stories........................................................................................................................ 41 ! Group Stories .......................................................................................................................... 42 ! Additional When Details? ........................................................................................................ 43 ! Determining the Story Type .................................................................................................... 44 ! Recurring Event ...................................................................................................................... 44 ! Evolving Event ........................................................................................................................ 44 ! Discrete Event......................................................................................................................... 45 ! Who?....................................................................................................................................... 45 ! What?...................................................................................................................................... 46 ! Where?.................................................................................................................................... 46 ! How Many? ............................................................................................................................. 50 ! Unit of Measure....................................................................................................................... 51 ! Durations................................................................................................................................. 51 ! Derived Quantities................................................................................................................... 52 ! Why? ....................................................................................................................................... 52 ! How? ....................................................................................................................................... 53 ! Event Granularity .................................................................................................................... 54 ! Sufficient Detail ....................................................................................................................... 55 ! Naming the Event.................................................................................................................... 55 ! Completing the Event Documentation..................................................................................... 56 ! T HE N EXT E VENT ? ............................................................................................................................. 57 ! S UMMARY .......................................................................................................................................... 58 ! CHAPTER 3 MODELING BUSINESS DIMENSIONS ................................................................................................. 59 ! D IMENSIONS ....................................................................................................................................... 60 ! Dimension Stories ...................................................................................................................... 60 ! Discovering Dimensions............................................................................................................. 61 ! D OCUMENTING D IMENSIONS ................................................................................................................ 62 ! Dimension Subject ..................................................................................................................... 62 ! Dimension Granularity and Business Keys ................................................................................ 63 ! D IMENSIONAL A TTRIBUTES .................................................................................................................. 64 ! Attribute Scope........................................................................................................................... 64 !

My first Publication Agile-Data-Warehouse-Design-eBook | Page 9