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

  • 3h 7m
  • Arshad Khan
  • Mercury Learning
  • 2012

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.

About the Author

ARSHAD KHAN, who has over a dozen books to his credit, has consulted for major corporations on data warehousing and business intelligence). He has taught several university courses and currently teaches the business intelligence course at University of California, Santa Cruz. Mr. Khan has a graduate degree in chemical engineering as well as an MBA.

In this Book

  • Introduction
  • Business Intelligence Application and Future
  • Data Warehousing Evolution and Fundamentals
  • Data Warehouse Types and Design Objectives
  • Growth Contributors
  • Data Warehouse Characteristics
  • Star Schema
  • Data Warehouse Process
  • Architecture
  • Metadata
  • Source Data
  • Data Conversion and Migration
  • Data Quality
  • ETL Process
  • ETL Issues, Tools, and ELT
  • Data Storage
  • Data Modeling
  • Data Warehouse Engine and Operating System
  • Hardware
  • Data Access
  • Tool Selection and Data Mining
  • Features of Front-End Tools
  • Data Marts
  • Implementation Approaches
  • Inmon Versus Kimball
  • Multidimensionality
  • Facts and Dimensions
  • OLAP
  • OLAP Models
  • Multidimensional Database
  • OLAP: Comparisons, Tools, and Vendors
  • Planning for the Data Warehouse Initiative
  • Implementation Prerequisites and Approach
  • Common Mistakes and Risks
  • Project Resources
  • Project Definition and Initiation
  • Project Planning
  • Analysis
  • Analysis: Additional Topics
  • Design
  • Design: Data Modeling and OLAP Design
  • Design: Additional Topics
  • Documentation
  • Development
  • Testing and Training
  • Deployment and Operation
  • Trends
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Audiobook Fundamentals of Data Engineering: Plan and Build Robust Data Systems
Book The Technical-Business Equilibrium: Mastering the Art of Balancing Technical Expertise and Business Priorities
Book Emerging Technologies for Business Professionals: A Nontechnical Guide to the Governance and Management of Disruptive Technologies