Delivering Business Intelligence with Microsoft SQL Server 2008 / Edition 2

by Brian Larson

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008

Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.

• Understand the goals and benefits of business intelligence
  
• Design and create relational data marts and OLAP cubes
• Manage Analysis Services databases using BI Development Studio
• Cleanse data and populate data marts with SQL Server Integration Services
• Take advantage of the flexibility of the Unified Dimensional Model
  
• Manipulate and analyze data using MDX scripts and queries
• Use data mining to identify data patterns, correlations, and clustering
• Develop and distribute interactive reports with SQL Server 2008 Reporting Services
• Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control

Product Details

ISBN-13:	9780071549448
Publisher:	McGraw Hill LLC
Publication date:	11/19/2008
Pages:	792
Product dimensions:	7.30(w) x 9.00(h) x 1.70(d)

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