As longtime data warehousing practitioners and former Microsoft insiders, authors Joy Mundy and Warren Thornthwaite have extensive experience in building and managing data warehouse (DW) and business intelligence (BI) systems. With this book, they share best practices for using SQL Server 2005 to build a successful DW/BI system. Covering the complete suite of data warehousing tools that accompanies SQL Server 2005, they focus on the full project lifecycle, including design, development, deployment, and maintenance.
You'll learn how and when to use BI tools such as Analysis Services, Integration Services, and the SQL Server database to accomplish various data warehousing tasks. A helpful case study used throughout the book provides examples of the techniques presented. You'll find practical guidance for every member of the data warehouse team and learn how to:
* Identify high-value business requirements and build organizational support for the project
* Design an information infrastructure for the enterprise using established dimensional design
* Design and build a flexible and powerful ETL system to clean, align, and restructure data for business use
* Provide decision makers with tools to analyze business problems and opportunities
* Use data mining to uncover data relationships and trends
* Build BI applications in Reporting Services
* Maintain, secure, and operate the DW/BI system
Visit the companion Web site at www.wiley.com/go/MsftDWToolkit
The companion Web site contains all the code samples, the sample database used throughout, sample templates, and other job aids.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 23.3 cm
Breite: 18.8 cm
Dicke: 4.2 cm
Gewicht
ISBN-13
978-0-471-26715-7 (9780471267157)
Schweitzer Klassifikation
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.
Warren Thornthwaite, a member of the Kimball Group, has been building decision support and data warehousing systems since 1980. Warren co-authored the best-selling Data Warehouse Lifecycle Toolkit (Wiley, 1998). Warren worked at Metaphor Computer Systems for eight years starting in 1983, where he managed the consulting organization and implemented many major data warehouse systems. After Metaphor, Warren managed the enterprise-wide data warehouse development at Stanford University. He then cofounded InfoDynamics LLC, a data warehouse consulting firm. Warren joined up with WebTV to help build a world-class, multi-terabyte customer-focused data warehouse before returning to consulting.
In addition to designing data warehouses for a range of industries, Warren has extensive experience helping clients develop scalable, practical information access architectures. Warren holds an MBA in Decision Sciences from the University of Pennsylvania's Wharton School, and a BA in Communications Studies from the University of Michigan.
Ralph Kimball, Ph.D., founder of the Kimball Group, has been designing information systems and data warehouses since 1972. Ralph wrote his Ph.D. dissertation in the Electrical Engineering department at Stanford University on the design of a man-machine system for tutoring mathematics students. In 1972 he joined the Xerox Palo Alto Research Center as a research scientist. Over the following ten years at Xerox, he became a development manager and the product marketing manager for the Xerox Star workstation, the first commercial product that used windows, icons, and the mouse. For this work at Xerox, he received the Alexander Williams Award from the IEEE Human Factors Society for user interface design. Following his years at Xerox, Ralph was a vice president and member of the founding team at Metaphor Computer Systems, the first data warehousing company. Between 1982 and 1986, Metaphor installed many client-server data warehouse systems. In 1986 Ralph founded Red Brick Systems, which developed the first high-performance relational database for decision support. Since 1993, Ralph has designed data warehouse systems, written bestselling data warehouse books, and taught data warehousing skills to more than 10,000 IT professionals.
Autor*in
Menlo Park, CA
Menlo Park, CA
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.