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

Contents Attribute Examples ..................................................................................................................... 67 ! Descriptive Attributes .............................................................................................................. 68 ! Mandatory Attributes ............................................................................................................... 69 ! Missing Values ........................................................................................................................ 69 ! Exclusive Attributes and Defining Characteristics...................................................................... 70 ! Using the 7Ws to Discover Attributes......................................................................................... 71 ! D IMENSIONAL H IERARCHIES ................................................................................................................ 73 ! Why Are Hierarchies Important? ................................................................................................ 73 ! Hierarchy Types ......................................................................................................................... 75 ! Balanced Hierarchies .............................................................................................................. 75 ! Ragged Hierarchies ................................................................................................................ 76 ! Variable Depth Hierarchies ..................................................................................................... 76 ! Multi-Parent Hierarchies.......................................................................................................... 77 ! Hierarchy Charts ........................................................................................................................ 77 ! Modeling Hierarchy Types ...................................................................................................... 78 ! Modeling Queries .................................................................................................................... 79 ! Discovering Hierarchical Attributes and Levels.......................................................................... 80 ! Hierarchy Attributes at the Same Level................................................................................... 82 ! Hierarchy Attributes that Don’t Belong .................................................................................... 82 ! Hierarchy Attributes at the Wrong Level ................................................................................. 82 ! Completing a Hierarchy.............................................................................................................. 83 ! D IMENSIONAL H ISTORY ....................................................................................................................... 84 ! Current Value Attributes............................................................................................................. 84 ! Corrections and Fixed Value Attributes...................................................................................... 85 ! Historic Value Attributes............................................................................................................. 86 ! Telling Change Stories............................................................................................................... 86 ! Documenting CV Change Stories ........................................................................................... 88 ! Documenting HV Change Stories ........................................................................................... 88 ! Business Keys and Change Stories........................................................................................ 89 ! Detecting Corrections: Group Change Rules.......................................................................... 89 ! Effective Dating ....................................................................................................................... 91 ! Documenting the Dimension Type ............................................................................................. 91 ! Minor Events .............................................................................................................................. 92 ! HV Attributes: Dimension-Only Minor Events ......................................................................... 92 ! Minor Events within Major Events ........................................................................................... 93 ! S UFFICIENT A TTRIBUTES ?................................................................................................................... 93 ! S UMMARY .......................................................................................................................................... 94 ! CHAPTER 4 MODELING BUSINESS PROCESSES.................................................................................................. 95 ! M ODELING M ULTIPLE E VENTS W ITH A GILITY ........................................................................................ 96 ! Conformed Dimensions.............................................................................................................. 97 ! The Data Warehouse Bus........................................................................................................ 100 ! The Event Matrix ...................................................................................................................... 102 ! Event Sequences ..................................................................................................................... 104 ! Time/Value Sequence........................................................................................................... 104 ! Process Sequence ................................................................................................................ 104 ! Modeling Process Sequences as Evolving Events ............................................................... 105 ! Using Process Sequences to Enrich Events......................................................................... 105 ! M ODELSTORMING WITH AN E VENT M ATRIX ......................................................................................... 105 ! XI

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