| |
| |
| About the Authors | |
| |
| |
| Foreword | |
| |
| |
| Preface | |
| |
| |
| The Purpose of This Book | |
| |
| |
| How This Book Is Organized | |
| |
| |
| How to Use This Book | |
| |
| |
| Who Should Read This Book | |
| |
| |
| Comments | |
| |
| |
| |
| Stages and Steps | |
| |
| |
| |
| Guide to the Development Steps | |
| |
| |
| Business Intelligence Definition | |
| |
| |
| BI Decision-Support Initiatives | |
| |
| |
| Development Approaches | |
| |
| |
| Engineering Stages and the Development Steps | |
| |
| |
| Parallel Development Tracks | |
| |
| |
| BI Project Team Structure | |
| |
| |
| Justification for Using This Project Lifecycle Guide | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 1: Business Case Assessment | |
| |
| |
| Business Justification | |
| |
| |
| Business Drivers | |
| |
| |
| Business Analysis Issues | |
| |
| |
| Cost-Benefit Analysis | |
| |
| |
| Risk Assessment | |
| |
| |
| Business Case Assessment Activities | |
| |
| |
| Deliverable Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 1 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 2: Enterprise Infrastructure Evaluation | |
| |
| |
| |
| Technical Infrastructure Evaluation | |
| |
| |
| The Hardware Platform | |
| |
| |
| The Middleware Platform | |
| |
| |
| The DBMS Platform | |
| |
| |
| Technical Infrastructure Evaluation Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 2, Section A | |
| |
| |
| |
| Nontechnical Infrastructure Evaluation | |
| |
| |
| The Effects of Stovepipe Development | |
| |
| |
| The Need for Nontechnical Infrastructure | |
| |
| |
| Enterprise Architecture | |
| |
| |
| Enterprise Standards | |
| |
| |
| Nontechnical Infrastructure Evaluation Activities | |
| |
| |
| Deliverable Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 2, Section B | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 3: Project Planning | |
| |
| |
| Managing the BI Project | |
| |
| |
| Defining the BI Project | |
| |
| |
| Planning the BI Project | |
| |
| |
| Project Planning Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 3 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 4: Project Requirements Definition | |
| |
| |
| General Business Requirements | |
| |
| |
| Project-Specific Requirements | |
| |
| |
| The Interviewing Process | |
| |
| |
| Project Requirements Definition Activities | |
| |
| |
| Deliverable Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 4 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 5: Data Analysis | |
| |
| |
| Business-Focused Data Analysis | |
| |
| |
| Top-Down Logical Data Modeling | |
| |
| |
| Bottom-Up Source Data Analysis | |
| |
| |
| Data Cleansing | |
| |
| |
| Data Analysis Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 5 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 6: Application Prototyping | |
| |
| |
| Purposes of Prototyping | |
| |
| |
| Best Practices for Prototyping | |
| |
| |
| Types of Prototypes | |
| |
| |
| Building Successful Prototypes | |
| |
| |
| Application Prototyping Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 6 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 7: Meta Data Repository Analysis | |
| |
| |
| The Importance of Meta Data | |
| |
| |
| Meta Data Repository as Navigation Tool | |
| |
| |
| Meta Data Classifications | |
| |
| |
| Meta Data Repository Challenges | |
| |
| |
| The Logical Meta Model | |
| |
| |
| Meta Data Repository Analysis Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 7 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 8: Database Design | |
| |
| |
| Differences in Database Design Philosophies | |
| |
| |
| Logical Database Design | |
| |
| |
| Physical Database Design | |
| |
| |
| Database Design Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 8 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 9: Extract/Transform/Load Design | |
| |
| |
| Implementation Strategies | |
| |
| |
| Preparing for the ETL Process | |
| |
| |
| Designing the Extract Programs | |
| |
| |
| Designing the Transformation Programs | |
| |
| |
| Designing the Load Programs | |
| |
| |
| Designing the ETL Process Flow | |
| |
| |
| Evaluating ETL Tools | |
| |
| |
| ETL Design Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 9 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 10: Meta Data Repository Design | |
| |
| |
| Meta Data Silos | |
| |
| |
| Meta Data Repository Solutions | |
| |
| |
| Designing a Meta Data Repository | |
| |
| |
| Licensing (Buying) a Meta Data Repository | |
| |
| |
| Meta Data Repository Design Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 10 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 11: Extract/Transform/Load Development | |
| |
| |
| Source Data Transformation | |
| |
| |
| Reconciliation | |
| |
| |
| Peer Reviews | |
| |
| |
| ETL Testing | |
| |
| |
| Formal Test Plan | |
| |
| |
| ETL Development Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 11 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 12: Application Development | |
| |
| |
| Online Analytical Processing Tools | |
| |
| |
| Multidimensional Analysis Factors | |
| |
| |
| Online Analytical Processing Architecture | |
| |
| |
| Development Environments | |
| |
| |
| Application Development Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 12 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 13: Data Mining | |
| |
| |
| Defining Data Mining | |
| |
| |
| Data Mining Techniques | |
| |
| |
| Data Mining Operations | |
| |
| |
| Applications of Data Mining | |
| |
| |
| Data Mining Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activites | |
| |
| |
| Risks of Not Performing Step 13 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 14: Meta Data Repository Development | |
| |
| |
| Populating the Meta Data Repository | |
| |
| |
| Meta Data Repository Interface Processes | |
| |
| |
| Meta Data Repository Testing | |
| |
| |
| Preparing for the Meta Data Repository Rollout | |
| |
| |
| Meta Data Repository Development Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 14 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 15: Implementation | |
| |
| |
| Incremental Rollout | |
| |
| |
| Security Management | |
| |
| |
| Data Backup and Recovery | |
| |
| |
| Monitoring the Utilization of Resources | |
| |
| |
| Growth Management | |
| |
| |
| Implementation Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 15 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| Step 16: Release Evaluation | |
| |
| |
| The Application Release Concept | |
| |
| |
| Post-Implementation Reviews | |
| |
| |
| Release Evaluation Activities | |
| |
| |
| Deliverables Resulting from These Activities | |
| |
| |
| Roles Involved in These Activities | |
| |
| |
| Risks of Not Performing Step 16 | |
| |
| |
| Bibliography and Additional Reading | |
| |
| |
| |
| At a Glance | |
| |
| |
| |
| Human Resource Allocation Matrix | |
| |
| |
| |
| Entry & Exit Criteria and Deliverables Matrix | |
| |
| |
| |
| Activity Dependency Matrix | |
| |
| |
| |
| Task/Subtask Matrix | |
| |
| |
| |
| Practical Guidelines Matrix | |
| |
| |
| |
| Work Breakdown Structure | |
| |
| |
| Index | |