Delivering Business Intelligence with Microsoft SQL Server 2005

Utilize Microsoft's Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.

SIGN UP TODAY


Date

January 23, 2006

Format

Paperback, 776 pages

ISBN

0072260904 / 9780072260908

$

Your Price

52.00



Overview


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


Table of contents

PART I: Business IntelligenceChapter 1: Equipping the Organization for Effective Decision MakingChapter 2: Making the Most of What You've Got -- Using Business IntelligenceChapter 3: Searching for the Source -- The Source of Business IntelligenceChapter 4: One-Stop Shopping -- The Unified Dimensional ModelChapter 5: First Steps -- Beginning the Development of Business IntelligencePART II: Defining Business Intelligence StructuresChapter 6: Building Foundations -- Creating and Populating Data MartsChapter 7: Fill 'er up -- Using Integration Services for Populating Data MartsPART III: Analyzing Cube ContentChapter 8: Cubism -- Measures and DimensionsChapter 9: Bells and Whistles -- Special Features of OLAP CubesChapter 10: Writing a New Script -- MDX ScriptingChapter 11: Pulling It Out and Building It Up -- MDX QueriesPART IV: MiningChapter 12: Panning for Gold -- Introduction to Data MiningChapter 13: Building the Mine -- Working with the Data Mining ModelChapter 14: Spelunking -- Exploration Using Data MiningPART V: DeliveringChapter 15: On Report -- Delivering Business Intelligence with Reporting ServicesChapter 16: Let's Get Together -- Integrating OLAP with Your ApplicationsChapter 17: Another Point of View -- Excel Pivot Tables and Pivot Charts


Author comments

Brian Larson is a Phi Beta Kappa graduate of Luther College in Decorah, Iowa, with degrees in Physics and Computer Science. He has 20 years of experience in the computer industry and 16 years of experience as a consultant creating custom database applications. Brian is currently Chief of Technology for Superior Consulting Services in Minneapolis, Minnesota, a Microsoft Consulting Partner for Reporting Services. He is a Microsoft Certified Solution Developer (MCSD) and a Microsoft Certified Database Administratior (MCDBA).

Brian served as a member of the Reporting Services development team as a consultant to Microsoft. In that role, he contributed to the original code base of Reporting Services.

Brian has presented seminars and provided training and mentoring on Reporting Services across the country. He is a contributor and columnist for SQL Server magazine and is currently writing the B.I. Powers column appearing on the SQL Server magazine website. In addition to this book, Brian is the author of Microsoft SQL Server 2005 Reporting Services, also from McGraw-Hill/Osborne.


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





Copyright 2014 McGraw-Hill Global Education Holdings, LLC

WELCOME!

Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.



Yes, I want to receive other special offer.