Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsoft's Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A (DATABASE & ERP - OMG) - Softcover

Larson, Brian

Softcover

ISBN 10: 0072260904 ISBN 13: 9780072260908

Publisher: McGraw Hill, 2006

Synopsis

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.

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.

About this title

About the Author

Brian Larson (Arden Hills, MN) served as a contract member of the Reporting Services development team and contributed to the code base. He has contributed to SQL Server Magazine and is the Chief of Technology for Superior Consulting Services. With over 18 years of experience in the computer industry, and 14 years as a software development consultant, Brian is an MCSD as well as an MCDBA, and has authored and delivered training curriculum for SQL Server 2000 and C#.NET as well as numerous custom applications.

From the Back Cover

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.
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

Edition details

• Publisher: McGraw Hill
• Publication date: 2006
• Language: English
• ISBN 10: 0072260904
• ISBN 13: 9780072260908
• Binding: Paperback
• Number of pages: 776