Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsoft's Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A / Edition 1

Paperback (Print)
Rent from
(Save 59%)
Est. Return Date: 06/20/2015
Buy Used
Buy Used from
(Save 41%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
  • All (29) from $1.99   
  • New (7) from $1.99   
  • Used (22) from $1.99   


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.

Read More Show Less

Product Details

  • ISBN-13: 9780072260908
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 1/31/2006
  • Series: Essential Skills for Database Profession
  • Edition number: 1
  • Pages: 776
  • Product dimensions: 7.30 (w) x 9.00 (h) x 1.57 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

Ch. 1 Equipping the organization for effective decision making 3
Ch. 2 Making the most of what you've got - using business intelligence 13
Ch. 3 Searching for the source - the source of business intelligence 25
Ch. 4 One-stop shopping - the unified dimensional model 43
Ch. 5 First steps - beginning the development of business intelligence 61
Ch. 6 Building foundations - creating and populating data marts 95
Ch. 7 Fill 'er up - using integration services for populating data marts 141
Ch. 8 Cubism - measures and dimensions 273
Ch. 9 Bells and whistles - special features of OLAP cubes 321
Ch. 10 Writing a new script - MDX scripting 375
Ch. 11 Pulling it out and building it up - MDX queries 421
Ch. 12 Panning for gold - introduction to data mining 457
Ch. 13 Building the mine - working with the data mining model 483
Ch. 14 Spelunking - exploration using data mining 519
Ch. 15 On report - delivering business intelligence with reporting services 555
Ch. 16 Let's get together - integrating OLAP with your applications 673
Ch. 17 Another point of view - Excel pivot tables and pivot charts 717
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted February 24, 2009

    more from this reviewer

    Excellent text for learning the basis of BI, and then some.

    I highly recommend this text. Larson provides superior explanations and pertinent diagrams to illustrate key concepts and topics in Business Intelligence. I used a text published by a "well known software vendor"(wink-wink), and while I was able to get the basics, this book went way beyond and above. The hands-on exercises were very relevant and each step is thoroughly explained. The author brings you through the application life cycle, building an entire analysis services database, and in many instances using clever and sneaky methods to simulate a real life environment, while having you utilize various processing properties and options. The chapter on Reporting Services was a masterpiece as each component was explained in a much more concise manner, than it was in the "other book". This book was like having a private, one on one class with a skilled and knowledgeable instructor. It was a "page turner".

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)