This is a must book for any one going for a BW interview. This is a consolidated book containing most frequently asked questions.

The author of the book is a SAP Certified BW Consultant with many years of BW teaching, consulting and interviewing candidates. He has trained many BW consultants and placed them all over the world; his BW articles have been accepted by leading technical publications like BW Experts.

The book contains questions for Technical Consultants, Functional Consultants and Report Writers. Most of the answers contain a real life example.
The book has contains questions on the following sections:

• - BW Administration and Design

• - BW Reporting (Bex)

• - Extraction

• - BW Functional 

• - Advanced concepts like Open Hub, Process chains, etc

• - Examples of user exits and step by step instructions

• - Business Content

From data modeling to optimizing data collection to maximizing reporting capabilities, this book delivers all the information that is integral to understanding and leveraging the full potential of SAP Business Information Warehouse (SAP BW). Vital concepts are clearly explained with the help of practical examples, sample solutions, and highly detailed graphics. You’ll quickly learn about the many capabilities of SAP BW as you "walk through" expert, step-by-step instruction designed to enable you to efficiently set up an SAP BW application with a user-specific data source, customized InfoCubes, data collection, and all of the necessary reporting components.

SAP and BW Data Warehousing: How to Plan and Implement is an introductory book for professionals and end-users associated with SAP and BW. It addresses their need to obtain an overview of SAP and BW features and functionality as well as project planning and implementation. SAP and BW Data Warehousing: How to Plan and Implement will be beneficial to a broad audience including those planning an SAP or BW project, senior executives, directors, functional managers and analysts, power users, end-users, project managers and project implementation team members (including technical staff, configurators, developers, and trainers). It can also be used as a supplemental text in IT courses that cover the subjects of ERP and data warehousing.

Business Information Warehouse for SAP

by Naeem Hashmi

Business Information Warehouse is the core information hub of all modules in SAP. This book shows you how to implement a data warehouse that can support reporting and analysis needs across diverse organizations and business functions. The author, Naeem Hashmi, was a member of the BW development team at SAP and covers just what you need to know to get to the core of the system and to the top of your field.

Mastering the SAP Business Information Warehouse
by Kevin McDonald, Andreas Wilmsmeier, David C. Dixon, W. H. Inmon

Written by the leading experts in the field, this comprehensive guide shows you how to implement the SAP Business Information Warehouse (BW) and create useful applications for business analysis of company-wide data. You’ll quickly learn how to design, build, analyze, and administer the data and information in the SAP BW component. The authors present the material in a way that reflects the process an organization goes through during a software implementation. They begin with an introduction to the fundamentals of data warehousing and business intelligence, helping you determine if SAP BW is right for your organization. The book then focuses on the business content and options available when trying to deliver value from the data stored in the SAP BW. And it includes a methodology for implementing the BW, such as data modeling and techniques for capturing and transforming data.