金融软件系统建设资料

2002 by John Wiley and Sons

CONTENTS

Foreword . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii

Part One: Evolution of Financial Business Intelligence . . . . . . . . . . . . . . 1

1 History and Future of Business Intelligence . . . . . . . . . . . . . . . . 3
History of BI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Trends . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
2 Leveraging the Power of Business Intelligence Tools . . . . . . . . . . 31
New Breed of Business Intelligence Tools. . . . . . . . . . . . . . . . 32
3 Why Consider a Financial BI Tool in Your Organization? .  .  .  .  .  .  .  47
Defining the Financial Datawarehouse. . . . . . . . . . . . . . . . . . 48
What Is Your Company’s Business Intelligence Readiness? .  .  .  .  .  .  66

Part Two: BI Technology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67

4 Platforms and Differences in Technology. . . . . . . . . . . . . . . . . 69
Financial and Nonfinancially Focused Tools . . . . . . . . . . . . . . 70
Who Are the Players? . . . . . . . . . . . . . . . . . . . . . . . . . . 71
Unix versus Microsoft as a Platform Choice . . . . . . . . . . . . . . . 72
5 Performance: Getting Information on Time . . . . . . . . . . . . . . . 75
Fast Enough for Your Business . . . . . . . . . . . . . . . . . . . . . 75
Periodicity Considerations . . . . . . . . . . . . . . . . . . . . . . . . 77
Data Storage Methodology (ROLAP, MOLAP, or HOLAP?) .  .  .  .  .  .  79
6 Building the Datawarehouse/Mart . . . . . . . . . . . . . . . . . . . . 83
Important Success Factors . . . . . . . . . . . . . . . . . . . . . . . . 83
Using Financial Data Sources . . . . . . . . . . . . . . . . . . . . . . 86
Staging Data for Financial Analysis . . . . . . . . . . . . . . . . . . . 88
7 Front-end Analytic Tools . . . . . . . . . . . . . . . . . . . . . . . . . 91
Specialized BI Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . 91
Real-Time Analysis: Myth or Reality (Technology Perspective) .  .  .  .  96
Excel Add-Ins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98
Traditional Report Writer versus OLAP-Based Analysis Tools .  .  .  .  .  98
8 Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101
Role-Based Access . . . . . . . . . . . . . . . . . . . . . . . . . . . 101
Internet Security: Only as Good as Your Barriers . . . . . . . . . . . 102
9 The Internet’s Impact on Business Intelligence. . . . . . . . . . . . . 103
Everyone’s a Player . . . . . . . . . . . . . . . . . . . . . . . . . . . 103
What Is a Portal? . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104
How Do I Deliver BI Information for the Internet?. . . . . . . . . . . 105

Part Three: Software Evaluation and Selection . . . . . . . . . . . . . . . . . 107

10 Selecting a Business Intelligence Solution . . . . . . . . . . . . . . . . 109
Create a Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109
Using a Software Selection Company . . . . . . . . . . . . . . . . . 117
11 Software Evaluation: Factors to Consider . . . . . . . . . . . . . . . 119
Expected Use Now and in the Future . . . . . . . . . . . . . . . . . . 119
Getting the Rest of the Company to Buy in to the Process .  .  .  .  .  .  .  120
Cost/Benefit Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . 121
Return on Investment Analysis . . . . . . . . . . . . . . . . . . . . . 123
Features and Flexibility . . . . . . . . . . . . . . . . . . . . . . . . . 124
Compatibility with Existing Software . . . . . . . . . . . . . . . . . 124
Ease of Use . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125
Software Stability . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126
Vendor-Related Items . . . . . . . . . . . . . . . . . . . . . . . . . . 127
Working with an Implementation Partner. . . . . . . . . . . . . . . . 127
How to Select: Summary . . . . . . . . . . . . . . . . . . . . . . . . 128
12 Outsourcing: The New Alternative . . . . . . . . . . . . . . . . . . . 129
How It Works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130
When You Should Consider an Application Service Provider .  .  .  .  .  131
Selection Criteria for an Application Service Provider . . . . . . . . . 132
Ensuring Continuous Success . . . . . . . . . . . . . . . . . . . . . . 134
13 Buyer’s Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135
Query and Reporting Systems . . . . . . . . . . . . . . . . . . . . . 136
Decision Support Systems . . . . . . . . . . . . . . . . . . . . . . . 138
OLAP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 138
Enterprise Information Portals . . . . . . . . . . . . . . . . . . . . . 139
Datawarehouse Software . . . . . . . . . . . . . . . . . . . . . . . . 140
Extraction, Transformation, and Loading Tools Vendors . . . . . . . 141
eLearning Tools Vendors . . . . . . . . . . . . . . . . . . . . . . . . 142

Part Four: Implementing a Business Intelligence System . . . . . . . . . . . . 145

14 Project Planning. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147
Business Intelligence Project Dos. . . . . . . . . . . . . . . . . . . . 147
Business Intelligence Project Don’ts . . . . . . . . . . . . . . . . . . 152
Drafting and Executing the Project Plan . . . . . . . . . . . . . . . . 153
Sample Project Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . 154
15 Datawarehouse or Data Mart?. . . . . . . . . . . . . . . . . . . . . . 157
16 Multidimensional Model Definition . . . . . . . . . . . . . . . . . . . 161
Defining Dimension Hierarchies and Dimension Types . . . . . . . . 164
Multidimensional Schemas: Star and Snowflake . . . . . . . . . . . . 168
17 Model Maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173
Periodicity Considerations . . . . . . . . . . . . . . . . . . . . . . . 173
Slowly Changing Dimensions. . . . . . . . . . . . . . . . . . . . . . 174
More Help in Maintaining Dimensions . . . . . . . . . . . . . . . . . 176
18 Financial Data Modeling . . . . . . . . . . . . . . . . . . . . . . . . . 177
Data Collection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178
Extending Your Financial Vision! . . . . . . . . . . . . . . . . . . . 183
Balance Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185
19 Survey of Datawarehouse Users . . . . . . . . . . . . . . . . . . . . . 191
The Survey . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191
Analysis of Responses . . . . . . . . . . . . . . . . . . . . . . . . . 192

Appendix A: Sample RFP . . . . . . . . . . . . . . . . . . . . . . . . . . . 199
Appendix B: Software Candidate Evaluation and Rating Sheet .  .  .  .  .  .  221
Appendix C: Sample License Agreement . . . . . . . . . . . . . . . . . . 223
Appendix D: Sample Confidentiality and Nondisclosure Agreement (Sales/Demo Process) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 229
Appendix E: Sample Support Plan/Agreement . . . . . . . . . . . . . . . 233
Appendix F: Sample Project Plan . . . . . . . . . . . . . . . . . . . . . . 235
Appendix G: Sample Consulting Agreement . . . . . . . . . . . . . . . . 237
Appendix H: Vendor Addresses . . . . . . . . . . . . . . . . . . . . . . . 241
Appendix I: References and Further Reading . . . . . . . . . . . . . . . . 249
Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 251
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279

[此贴子已经被作者于2008-6-17 23:47:16编辑过]