数据仓库与SQL服务器 2003：及微软商务智能工具包 The Microsoft Data Warehouse Toolkit
点此进入淘宝搜索页搜索分類: 图书,进口原版书,科学与技术 Science & Techology ,
作者： Joy Mundy著
出 版 社： 吉林长白山
出版时间： 2007-8-1字数：版次： 1页数： 746印刷时间： 2006/02/01开本：印次：纸张： 胶版纸I S B N ： 9780471267157包装： 平装编辑推荐
作者简介：
Joy Mundy, a member of the Kimball Group, has been developing, consulting on, and speaking and writing about business intelligence systems and technology since 1992. Joy began her career as a business analyst in banking and finance as one of the power users we talk about in business intelligence. In 1992 she joined the data warehouse team at Stanford University, an effort that was both educational and character building. She next co-founded InfoDynamics LLC, a data warehouse consulting firm, and then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged business intelligence system. From 2000 to 2004, Joy worked with the Microsoft SQL Server Business Intelligence product development team. She managed a team that developed the best practices for building business intelligence systems on the Microsoft platform. Joy graduated from Tufts University with a B.A. in Economics, and from Stanford with an M.S. in Engineering Economic Systems.
内容简介
This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business value.
Building a data warehousing and business intelligence system is a complex business and engineering effort. While there are significant technical challenges to overcome in successfully deploying a data warehouse, the authors find that the most common reason for data warehouse project failure is insufficient focus on the business users and business problems. In an effort to help people gain success, this book takes the proven Business Dimensional Lifecycle approach first described in best selling The Data Warehouse Lifecycle Toolkit and applies it to the Microsoft SQL Server 2005 tool set.
Beginning with a thorough description of how to gather business requirements, the book then works through the details of creating the target dimensional model, setting up the data warehouse infrastructure, creating the relational atomic database, creating the analysis services databases, designing and building the standard report set, implementing security, dealing with metadata, managing ongoing maintenance and growing the DW/BI system. All of these steps tie back to the business requirements. Each chapter describes the practical steps in the context of the SQL Server 2005 platform.
目录
Contents.
Foreword.
Preface.
Acknowledgments.
Introduction.
PART I: REQUIREMENTS, REALITIES, AND ARCHITECTURE.
1. Defining Business Requirements.
2. Designing the Business Process Dimensional Model.
3. The Toolset.
PART II: DEVELOPING AND POPULATING THE DATABASES.
4. Setup and Physical Design.
5. Designing the ETL System.
6. Developing the ETL System.
7. Designing the Aanalysis Services OLAP Database.
PART III: DEVELOPING THE BI APPLICATIONS.
8. Business Intelligence Applications.
9. Building the BI Application in Reporting Services.
10. Incorporating Data Mining.
PART IV: DEPLOYING AND MANAGING THE DW/BI SYSTEM.
11. Working with an Existing Data Warehouse.
12. Security.
13. Metadata.
14. Deploying the BI System.
15. Operations and Maintenance.
PART V: EXTENDING THE DW/BI SYSTEM.
16. Managing Growth.
17. Real-Time Business Intelligence.
18. Present Imperatives and Future Outlook.
Index.
