| About the Authors | vii |
| Foreword | ix |
| Introduction | xiii |
| Our Assumptions About You | xiii |
| Organization of the Book | xiv |
| Acknowledgments | xiv |
| PART I BUSINESS INTELLIGENCE FOUNDATIONS | 1 |
| PROLOGUE: The Mystery on Lovesick Lake | 3 |
| 1 Understanding Business Intelligence | 13 |
| Describing Business Intelligence | 13 |
| Defining the BI Cycle | 17 |
| Enabling Business Intelligence | 23 |
| Summary | 27 |
| 2 Bridging the Analysis Gap | 29 |
| Multidimensional Analysis | 29 |
| Operational Systems | 31 |
| Business Intelligence Systems | 34 |
| Summary | 47 |
| 3 Defining BI Technologies | 49 |
| The High-Level View | 49 |
| Reporting and Analysis | 53 |
| The Data Warehouse | 60 |
| Summary | 63 |
| PART II BUSINESS INTELLIGENCE CASE STUDIES | 65 |
| 4 Improving Operational EfficiencyAudi AG | 67 |
| Company Background | 67 |
| Business Requirements | 68 |
| The Solution | 70 |
| Solution Benefits | 71 |
| Future Plans | 110 |
| Summary | 110 |
| PART III A BUSINESS INTELLIGENCE ROADMAP | 111 |
| 9 Identifying BI Opportunities | 113 |
| Doing Your Homework | 113 |
| Sharing and Collecting Ideas | 122 |
| Evaluating Alternatives | 128 |
| Summary | 142 |
| 10 Implementing a BI Solution | 145 |
| An Implementation Strategy | 145 |
| The Fundamental Decisions | 151 |
| Summary | 174 |
| CONCLUSION | 175 |
| APPENDIX A Microsoft Data Warehousing Framework | 177 |
| SQL Server | 177 |
| Data Analyzer | 181 |
| Microsoft Business Intelligence Accelerator | 182 |
| Data Warehousing Alliance | 184 |
| GLOSSARY | 185 |
| BIBLIOGRAPHY | 193 |
| INDEX | 195 |