Business Intelligence & Data Warehousing Simplified: 500 Questions, Answers, & Tips

Business Intelligence & Data Warehousing Simplified: 500 Questions, Answers, & Tips

This book targets business and IT professionals who need an introduction to business intelligence and data warehousing fundamentals through a simple question / answer format. Organized into 47 chapters, each on a different topic, the book contains 500 questions, 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, trends, etc. The book can also be used as a supplemental textbook for various data warehousing/business intelligence courses.<br /><br />FEATURES<br />•Includes 47 different subject areas with 500 questions and answers on key topics<br />•Shows common mistakes and risks, project resources, and project planning<br />•Provides review material for certification, interviews, and for use as a course supplement<br /><br />SELECTED TOPICS<br />Evolution and fundamentals, characteristics and process, architecture and objects, metadata, data conversion and migration, ETL, data storage, data quality, infrastructure, star schema, data access, data marts, data warehouse engine requirements, hardware, implementation approaches, planning, design, drill-across, drill-down, Inmon vs. Kimball, multi-dimensionality, OLAP, facts and dimensions, common mistakes and tips, testing and training.