Smart Business Intelligence Solutions with Microsoft SQL Server 2008

Description

Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008 - whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you’ll master the concepts, tools, and techniques for building solutions that deliver intelligence - and business value - exactly where users want it.

Discover how to:

* Manage the development life cycle and build a BI team
* Dig into SQL Server Analysis Services, Integration Services, and Reporting Services
* Navigate the Business Intelligence Development Studio (BIDS)
* Write queries that rank, sort, and drill down on sales data
* Develop extract, transform, and load (ETL) solutions
* Add a source code control system
* Help secure packages for deployment via encryption and credentials
* Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models
* Create and implement custom objects using .NET code
* View reports in Microsoft Office Excel(R) and Office SharePoint(R) Serverook

CONTENTS:

ForewordAcknowledgmentsIntroductionPart I: Business Intelligence for Business Decision Makers and Architects
* Chapter 1: Business Intelligence Basics
* Chapter 2: Visualizing Business Intelligence Results
* Chapter 3: Building Effective Business Intelligence Processes
* Chapter 4: Physical Architecture in Business Intelligence Solutions
* Chapter 5: Logical OLAP Design Concepts for ArchitectsPart II: Microsoft SQL Server 2008 Analysis Services for Developers
* Chapter 6: Understanding SSAS in SSMS and SQL Server Profiler
* Chapter 7: Designing OLAP Cubes Using BIDS
* Chapter 8: Refining Cubes and Dimensions
* Chapter 9: Processing Cubes and Dimensions
* Chapter 10: Introduction to MDX
* Chapter 11: Advanced MDX
* Chapter 12: Understanding Data Mining Structures
* Chapter 13: Implementing Data Mining StructuresPart III: Microsoft SQL Server 2008 Integration Services for Developers
* Chapter 14: Architectural Components of Microsoft SQL Server 2008 Integration Services
* Chapter 15: Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development Studio
* Chapter 16: Advanced Features in Microsoft SQL Server 2008 Integration Services
* Chapter 17: Microsoft SQL Server 2008 Integration Services Packages in Business Intelligence Solutions
* Chapter 18: Deploying and Managing Solutions in Microsoft SQL Server 2008 Integration Services
* Chapter 19: Extending and Integrating SQL Server 2008 Integration ServicesPart IV: Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence
* Chapter 20: Creating Reports in SQL Server 2008 Reporting Services
* Chapter 21: Building Reports for SQL Server 2008 Reporting Services
* Chapter 22: Advanced SQL Server 2008 Reporting Services
* Chapter 23: Using Microsoft Excel 2007 as an OLAP Cube Client
* Chapter 24: Microsoft Office 2007 as a Data Mining Client
* Chapter 25: SQL Server Business Intelligence and Microsoft Office SharePoint Server 2007About the Authors