Delivering Business Intelligence with Microsoft SQL Server 2005

Features

• Cover Type: Paperback with 776 pages
• Published by: McGraw-Hill Osborne Media
• Edition: 1st Edition January 23, 2006
• Written in: English
• ISBN 10 Number: 0072260904
• ISBN 13 Number: 978-0072260908
• Book Dimensions: 8.9 x 7.2 x 1.6 inches
• Weighs: 2.8 pounds

Product Description


Transform disparate enterprise data into actionable business intelligence

Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here--from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.

Back Cover Copy
Transform disparate enterprise data into actionable business intelligence

Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here -- from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS

• Understand the goals and benefits of business intelligence
• Manage Analysis Services databases using BI Development Studio
• Improve performance and decrease latency using proactive caching
• Create interactive reports using SQL Server 2005 Reporting Services
• Enable ad hoc reporting using Report Models and Report Builder
• Integrate with applications using ADOMD.NET and the Report Viewer Control
• Design and create relational data marts and OLAP cubes
• Perform powerful data analysis using MDX queries and scripts
• Perform complex operations with Integration Services
• Uncover behavior patterns and proclivities using data mining

Reader Reviews
This book is not going to make anyone a SQL Server 2005 expert. But for me it was perfect. I have been designing BI solutions for years, using Oracle or DB2 with Cognos or Hyperion. I have started using Microsoft now, and going through book helped a lot. I don't feel that I'm a MS expert after reading this, but I do feel comfortable with the SQL Server 2005 services. Think of it this way, it's a good beginner's book for SQL Server Database, Analysis services, Reporting Services, and Integration services - all in one book. Comment | | (Report this)