"If you are looking for a complete treatment of business intelligence, then go no further than this book. Larissa T. Moss and Shaku Atre have covered all the bases in a cohesive and logical order, making it easy for the reader to follow their line of thought. From early design to ETL to physical database design, the book ties together all the components of business intelligence." --Bill Inmon, Inmon Enterprises is a visual guide to developing an effective business intelligence (BI) decision-support application. This book outlines a methodology that takes into account the complexity of developing applications in an integrated BI environment. The authors walk readers through every step of the process--from strategic planning to the selection of new technologies and the evaluation of application releases. The book also serves as a single-source guide to the best practices of BI projects. Business Intelligence Roadmap Part I steers readers through the six stages of a BI project: justification, planning, business analysis, design, construction, and deployment. Each chapter describes one of sixteen development steps and the major activities, deliverables, roles, and responsibilities. All technical material is clearly expressed in tables, graphs, and diagrams. Part II provides five matrices that serve as references for the development process charted in Part I. Management tools, such as graphs illustrating the timing and coordination of activities, are included throughout the book. The authors conclude by crystallizing their many years of experience in a list of dos, don'ts, tips, and rules of thumb. The accompanying CD-ROM includes a complete, customizable work breakdown structure. Both the book and the methodology it describes are designed to adapt to the specific needs of individual stakeholders and organizations. The book directs business representatives, business sponsors, project managers, and technicians to the chapters that address their distinct responsibilities. The framework of the book allows organizations to begin at any step and enables projects to be scheduled and managed in a variety of ways. is a clear and comprehensive guide to negotiating the complexities inherent in the development of valuable business intelligence decision-support applications Business Intelligence Roadmap

This IBM Redbooks publication deals with exploiting DB2 UDB’s materialized views (also known as ASTs/MQTs), statistics, analytic, and OLAP functions in e-business applications to achieve superior performance and scalability. This book is aimed at a target audience of DB2 UDB application developers, database administrators (DBAs), and independent software vendors (ISVs). We provide an overview of DB2 UDB’s materialized views implementation, as well as guidelines for creating and tuning them for optimal performance. We introduce key statistics, analytic, and OLAP functions, and describe their corresponding implementation in DB2 UDB with usage examples. Finally, we describe typical business level queries that can be answered using DB2 UDB’s statistics, analytic, and OLAP functions. These business queries are categorized by industry, and describe the steps involved in resolving the query, with sample SQL and visualization of results.

Link business intelligence to the Web! Technologies, integration, and applications. Internet-enabled business intelligence: from planning to profit In-depth coverage of integration and key enabling technologies, including Java and XML Advanced analysis and profiling: understand customers better, and respond faster Clickstrean analysis: understanding how customers use your site Linking data warehouses to CRM and other enterprise/value chain systems This is the first start-to-finish guide to planning, deploying, and profiting from Internet-enabled data warehouses. Leading business intelligence specialist William Giovinazzo covers every enabling technology, every analysis approach, and every key challenge you'll face in linking business intelligence to the Web. From infrastructure integration to state-of-the-art profiling and wireless applications, Giovinazzo shows how everything fits together—and exactly how to use Web-enabled data warehouses to deliver powerful ROI in your business. How the Internet enhances your business intelligence infrastructure Leveraging key enabling technologies: Java, XML, XSL, and more Breakthrough analysis techniques: understand customers better, and respond faster! Integrating data warehouses with CRM and other enterprise and inter-enterprise systems Establishing common warehouse metadata Drawing on the clickstreams generated by your Web and e-commerce sites Personalization techniques that work

You go online to buy a digital camera. Soon, you realize you've bought a more expensive camera than intended, along with extra batteries, charger, and graphics software-all at the prompting of the retailer. Happy with your purchases? The retailer certainly is, and if you are too, you both can be said to be the beneficiaries of "customer intimacy" achieved through the transformation of data collected during this visit or stored from previous visits into real business intelligence that can be exercised in real time. Data Warehousing and Business Intelligence for e-Commerce is a practical exploration of the technological innovations through which traditional data warehousing is brought to bear on this and other less modest e-commerce applications, such as those at work in B2B, G2C, B2G, and B2E models. The authors examine the core technologies and commercial products in use today, providing a nuts-and-bolts understanding of how you can deploy customer and product data in ways that meet the unique requirements of the online marketplace-particularly if you are part of a brick-and-mortar company with specific online aspirations. In so doing, they build a powerful case for investment in and aggressive development of these approaches, which are likely to separate winners from losers as e-commerce grows and matures. * Includes the latest from successful data warehousing consultants whose work has encouraged the field's new focus on e-commerce. * Presents information that is written for both consultants and practitioners in companies of all sizes. * Emphasizes the special needs and opportunities of traditional brick-and-mortar businesses that are going online or participating in B2B supply chains or e-marketplaces. * Explains how long-standing assumptions about data warehousing have to be rethought in light of emerging business models that depend on customer intimacy. * Provides advice on maintaining data quality and integrity in environments marked by extensive customer self-input. * Advocates careful planning that will help both old economy and new economy companies develop long-lived and successful e-commerce strategies. * Focuses on data warehousing for emerging e-commerce areas such as e-government and B2E environments.