Delivering Business Intelligence With Microsoft Sql Server(Tm) 2/E 2008

With help from this fully updated bestselling book, database professionals will be able to transform disparate enterprise data into actionable Business Intelligence. Covering all the new and improved BI features available in SQL Server 2008, the book shows you how to put timely, mission-critical information in the hands of employees across the organization.



Delivering Business Intelligence with Microsoft SQL Server 2008 begins with a discussion of BI, defining what it is and why it is important in today's business environment. After laying this foundation, the book works through the entire BI lifecycle: defining the analysis database; analyzing the data; mining the data; and delivering BI. Several analysis databases will be built and used for examples throughout the book.

About The Author:

Brian Larson, MCSD, served as a member of the Reporting Services development team and contributed to the code base. He is the chief of technology for Superior Consulting Services (SCS), a Microsoft Certified Partner.

Table of Contents
Part I: Business Intelligence

Chapter 1. Equipping the Organization for Effective Decision Making

Chapter 2. Making the Most of What You've Got--Using Business Intelligence

Chapter 3. Seeking the Source--The Source of Business Intelligence

Chapter 4. One-Stop Shopping--The Unified Dimensional Model

Chapter 5. First Steps--Beginning the Development of Business Intelligence

Part II: Defining Business Intelligence Structures

Chapter 6. Building Foundations--Creating Data Marts

Chapter 7. Transformers--Integration Services Structure and Components

Chapter 8. Fill'er Up - Using Integration Services for Populating Data Marts

Part III: Analyzing Cube Content

Chapter 9. Cubism--Measures and Dimensions

Chapter 10. Bells and Whistles--Special Features of OLAP Cubes

Chapter 11. Writing a New Script--MDX Scripting

Chapter 12. Pulling It Out and Building It Up--MDX Queries

Part IV: Mining

Chapter 13. Panning for Gold--Introduction to Data Mining

Chapter 14. Building the Mine--Working with the Data Mining Model

Chapter 15. Spelunking--Exploration Using Data Mining

Part V: Delivering

Chapter 16. On Report--Delivering Business Intelligence with Reporting Systems

Chapter 17. Falling into Place--Managing Reporting Systems Reports

Chapter 18. Let's Get Together--Excel Pivot Tables and Pivot Charts

Index