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

XII Agile Data Warehouse Design Adding the First Event to the Matrix ......................................................................................... 106 ! Modeling the Next Event .......................................................................................................... 107 ! Role-Playing Dimensions ......................................................................................................... 108 ! Discovering Process Sequences ............................................................................................. 112 ! Using the Matrix to Find Missing Events .................................................................................. 115 ! Using the Matrix to Find Missing Event Details........................................................................ 116 ! P LAYING THE E VENT R ATING G AME ................................................................................................... 116 ! M ODELING THE N EXT D ETAILED E VENT .............................................................................................. 120 ! Reusing Conformed Dimensions and Examples...................................................................... 120 ! Using Abbreviations in Event Stories .................................................................................... 121 ! Adding New Examples to Conformed Dimensions ............................................................... 122 ! Modeling New Details and Dimensions.................................................................................... 122 ! Completing the Event............................................................................................................... 125 ! S UFFICIENT E VENTS ? ....................................................................................................................... 126 ! S UMMARY ........................................................................................................................................ 128 ! CHAPTER 5 MODELING STAR SCHEMAS............................................................................................................. 129 ! A GILE D ATA P ROFILING ..................................................................................................................... 130 ! Identifying Candidate Data Sources......................................................................................... 131 ! Data Profiling Techniques ........................................................................................................ 132 ! Missing Values ...................................................................................................................... 132 ! Unique Values and Frequency.............................................................................................. 133 ! Data Ranges and Lengths .................................................................................................... 133 ! Automating Your Own Data Profiling Checks ....................................................................... 134 ! No Source Yet: Proactive DW/BI Design ................................................................................. 134 ! Annotating the Model with Data Profiling Results .................................................................... 135 ! Data Sources and Data Types .............................................................................................. 135 ! Additional Data...................................................................................................................... 137 ! Unavailable Data................................................................................................................... 137 ! Nulls and Mismatched Attribute Descriptions........................................................................ 137 ! M ODEL R EVIEW AND S PRINT P LANNING ............................................................................................. 138 ! Team Estimating ...................................................................................................................... 138 ! Running a Model Review ......................................................................................................... 139 ! Sprint Planning......................................................................................................................... 140 ! S TAR S CHEMA D ESIGN ..................................................................................................................... 141 ! Adding Keys to a Dimensional Model ...................................................................................... 141 ! Choosing Primary Keys: Business Keys vs. Surrogate Keys................................................ 141 ! Benefits of Data Warehouse Surrogate Keys ....................................................................... 142 ! Insulate the Data Warehouse from Business Key Change ................................................... 143 ! Cope with Multiple Business Keys for a Dimension .............................................................. 143 ! Track Dimensional History Efficiently.................................................................................... 143 ! Handle Missing Dimensional Values..................................................................................... 143 ! Support Multi-Level Dimensions ........................................................................................... 144 ! Protect Sensitive Information ................................................................................................ 144 ! Reduce Fact Table Size........................................................................................................ 144 ! Improve Query Performance................................................................................................. 145 ! Enforce Referential Integrity Efficiently ................................................................................. 145 ! Slowly Changing Dimensions................................................................................................... 146 ! Overwriting History: Type 1 Slowly Changing Dimensions ................................................... 147 !

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