Overview

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 and Office SharePoint Serverook

Full Product Details

Author:   Lynn Langit ,  Kevin S. Goff ,  Sahil Malik ,  Davide Mauri
Publisher:   Microsoft Press,U.S.
Imprint:   Microsoft Press,U.S.
Dimensions:   Width: 18.70cm , Height: 5.10cm , Length: 22.90cm
Weight:   1.562kg
ISBN:  

9780735625808

ISBN 10:   0735625808
Pages:   800
Publication Date:   04 February 2009
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   Awaiting stock  

Table of Contents

Foreword Acknowledgments Introduction Part 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 Architects Part 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 Structures Part 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 Services Part 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 2007 About the Authors

Reviews

Author Information

Davide Mauri, MCP, MCAD, MCDBA, MCT, is a Microsoft MVP who has worked with SQL Server since version 6.5.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions