Business Intelligence & Data Warehousing Simplified : : 500 Questions, Answers, & Tips / / Arshad Khan.

• VerfasserIn: Khan, Arshad,
• Place / Publishing House: Dulles, VA : : Mercury Learning and Information, , [2011]; ©2011
• Year of Publication: 2011
• Language: English
• Physical Description: 1 online resource (250 p.)

This book targets business and IT professionals who need an introduction to business intelligence and data warehousing through a simple question/answer format. Organized into 30 odd chapters, each on a different topic, the book contains approximately 500 questions with answers and tips. Topics include evolution and fundamentals, characteristics and process, architecture and objects, metadata, data conversion, ETL, data storage, infrastructure, data access, data marts, implementation approaches, planning, design, Inmon vs. Kimball, multi-dimensionality, OLAP, facts and dimensions, common mistakes and tips, etc. The book can also be used as a supplemental textbook, for various data warehousing/business intelligence courses.

Table of Contents

Frontmatter -- Contents -- Preface -- Chapter 1 Introduction -- Chapter 2 Business Intelligence Application and Future -- Chapter 3 Data Warehousing Evolution and Fundamentals -- Chapter 4 Data Warehouse Types and Design Objectives -- Chapter 5 Growth Contributors -- Chapter 6 Data Warehouse Characteristics -- Chapter 7 Star Schema -- Chapter 8 Data Warehouse Process -- Chapter 9 Architecture -- Chapter 10 Metadata -- Chapter 11 Source Data -- Chapter 12 Data Conversion and Migration -- Chapter 13 Data Quality -- Chapter 14 ETL Process -- Chapter 15 ETL Issues, Tools, and ELT -- Chapter 16 Data Storage -- Chapter 17 Data Modeling -- Chapter 18 Data Warehouse Engine and Operating System -- Chapter 19 Hardware -- Chapter 20 Data Access -- Chapter 21 Tool Selection and Data Mining -- Chapter 22 Features of Front- End Tools -- Chapter 23 Data Marts -- Chapter 24 Implementation Approaches -- Chapter 25 Inmon versus Kimball -- Chapter 26 Multidimensionality -- Chapter 27 Facts and Dimensions -- Chapter 28 OLAP -- Chapter 29 OLAP models -- Chapter 30 Multidimensional Database -- Chapter 31 OLAP: Comparisons, Tools, and Vendors -- Chapter 32 Planning for the Data Warehouse Initiative -- Chapter 33 Implementation Prerequisites and Approach -- Chapter 34 Common Mistakes and Risks -- Chapter 35 Project Resources -- Chapter 36 Project Definition and Initiation -- Chapter 37 Project Planning -- Chapter 38 Analysis -- Chapter 39 Analysis: Additional Topics -- Chapter 40 Design -- Chapter 41 Design: Data Modeling and OLAP Design -- Chapter 42 Design: Additional Topics -- Chapter 43 Documentation -- Chapter 44 Development -- Chapter 45 Testing and Training -- Chapter 46 Deployment and Operation -- Chapter 47 Trends -- Index