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

C ONTENTS INTRODUCTION ................................................................................................................................. XVII ! PART I: MODELSTORMING ................................................................................................................... 1 ! CHAPTER 1 HOW TO MODEL A DATA WAREHOUSE.............................................................................................. 3 ! OLTP VS . DW/BI: T WO D IFFERENT W ORLDS ......................................................................................... 4 ! The Case Against Entity-Relationship Modeling .......................................................................... 5 ! Advantages of ER Modeling for OLTP ...................................................................................... 6 ! Disadvantages of ER Modeling for Data Warehousing............................................................. 6 ! The Case For Dimensional Modeling........................................................................................... 7 ! Star Schemas............................................................................................................................ 8 ! Fact and Dimension Tables ...................................................................................................... 8 ! Advantages of Dimensional Modeling for Data Warehousing................................................... 9 ! D ATA W AREHOUSE A NALYSIS AND D ESIGN .......................................................................................... 11 ! Data-Driven Analysis.................................................................................................................. 11 ! Reporting-Driven Analysis.......................................................................................................... 12 ! Proactive DW/BI Analysis and Design ....................................................................................... 13 ! Benefits of Proactive Design for Data Warehousing ............................................................... 14 ! Challenges of Proactive Analysis for Data Warehousing........................................................ 15 ! Proactive Reporting-Driven Analysis Challenges.................................................................... 15 ! Proactive Data-Driven Analysis Challenges............................................................................ 15 ! Data then Requirements: a ‘Chicken or the egg’ Conundrum................................................. 15 ! Agile Data Warehouse Design ................................................................................................... 16 ! Agile Data Modeling ................................................................................................................... 17 ! Agile Dimensional Modeling....................................................................................................... 18 ! Agile Dimensional Modeling and Traditional DW/BI Analysis ................................................. 19 ! Agile Data-Driven Analysis...................................................................................................... 19 ! Agile Reporting-Driven Analysis.............................................................................................. 19 ! Requirements for Agile Dimensional Modeling ....................................................................... 19 ! BEAM✲ ............................................................................................................................................ 21 ! Data Stories and the 7Ws Framework ....................................................................................... 21 ! Diagrams and Notation .............................................................................................................. 21 ! BEAM✲ (Example Data) Tables ............................................................................................. 21 ! BEAM✲ Short Codes.............................................................................................................. 22 ! Comparing BEAM✲ and Entity-Relationship Diagrams.......................................................... 22 ! Data Model Types ................................................................................................................... 23 ! BEAM✲ Diagram Types ......................................................................................................... 24 ! S UMMARY .......................................................................................................................................... 26 ! CHAPTER 2 MODELING BUSINESS EVENTS.......................................................................................................... 27 ! D ATA S TORIES ................................................................................................................................... 28 ! Story Types ................................................................................................................................ 28 ! Discrete Events ....................................................................................................................... 29 ! Evolving Events....................................................................................................................... 29 !

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