Search
Go

Shop by category
 
Delivering Business Intelligence with Microsoft SQL Server 2008
Email a friendView larger image

Delivering Business Intelligence with Microsoft SQL Server 2008

List Price: $49.99
Our Price: $31.38
You Save: $18.61 (37%)
Shipping: This item ships for FREE with Super Saver Shipping.
SKU:

0071549447

In Stock
Usually ships in 1 business days

Note: Item may be sold and shipped by another company. Learn more.
Product Promotions:
  • Buy $50 in qualifying physical textbooks, get $2 in Amazon MP3 Credit.  Here's how (restrictions apply)
Description:

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008

Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.

  • Understand the goals and benefits of business intelligence
  • Design and create relational data marts and OLAP cubes
  • Manage Analysis Services databases using BI Development Studio
  • Cleanse data and populate data marts with SQL Server Integration Services
  • Take advantage of the flexibility of the Unified Dimensional Model
  • Manipulate and analyze data using MDX scripts and queries
  • Use data mining to identify data patterns, correlations, and clustering
  • Develop and distribute interactive reports with SQL Server 2008 Reporting Services
  • Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control

Features:

Details


Clear


Easy to understand


Help to develop and build own company commercial sites


Run good businesses online


Product Details:
Author: Brian Larson
Paperback: 792 pages
Publisher: McGraw-Hill Osborne Media
Publication Date: November 19, 2008
Language: English
ISBN: 0071549447
Product Length: 9.0 inches
Product Width: 7.2 inches
Product Height: 1.6 inches
Product Weight: 2.77 pounds
Package Length: 9.0 inches
Package Width: 7.3 inches
Package Height: 1.6 inches
Package Weight: 2.75 pounds
Average Customer Rating: based on 18 reviews
Customer Reviews:
Average Customer Review: 5.0 ( 18 customer reviews )
Write an online review and share your thoughts with other customers.


Most Helpful Customer Reviews

24 of 25 found the following review helpful:

5Great overview of a huge subjectFeb 03, 2009
By Ron Davis "USMC 67-71 OOHRAH!"
This author sets out to walk you through a huge subject, which is Microsoft's BI stack, in a single volume and does an admiral job of introducing the key concepts and components that a Microsoft implementation requires. It should be considered a starting point from which much is to be gained. Experienced BI developers will learn about the new features in SQL 2008. He also spends an entire chapter on Transformers or Microsoft SSIS explaining each of the components and going into detail where required. His explanation of the Unified Data Model is quite good.
The only thing I didn't like about this book was that you need the custom database that is free and is downloadable and that he refers to throughout the book. What's not to like about that? You cannot find any link on the publisher's site, the reference to the page in the book doesn't work and searching for the code on the publisher's site returns empty. I finally contacted customer service who sent me over to technical services that finally sent me the link. Not the author's problem but maybe technical books should come out of the technical press.

15 of 15 found the following review helpful:

5New to SQL Server BI? Start hereJun 15, 2009
By Henry Bell
This book is a perfect choice for people who are generally familiar with relational databases and business intelligence concepts who want to learn how to build them in MS SQL Server. The book covers the database engine, SSIS, SSAS, and SSRS. The outline of the book starts with setting up the environment then proceeds thru getting the data, analyzing it, and finally reporting it. This is the right order to cover these topics. There is not enough here to make you an expert on any topic, but there is a good introduction to the many topics in the area. The book is well written, edited, and illustrated.

It includes complete coverage of "what SQL Server 2008 BI can do" but is short on "how to do it". There is a good mix of theory, examples, and practice with many "Learn-by-doing" exercises. These are very valuable. The book does include enough detail to answer most beginners' questions.

9 of 9 found the following review helpful:

5Great book for a newbie to SSIS and SSASMay 04, 2009
By Harsh Sood "NJ Man"
Kudos to the author and his style of writing. He explains each and every step on SSIS and SSAS so eloquently that he makes the topic understanding a breeze. This is one of the very few books i have read that gets you hooked on to it and finish it as soon as possible with all the exploration you want to do in SSIS and SSAS.

In short - an excellent book for starters.

8 of 8 found the following review helpful:

5The best overall intro to the full breadth of SQL 2008 BIMar 27, 2010
By David Foley
Well-written book tackling an enormous topic. In addition to providing good conceptual overviews, actually goes into a fair bit of practical detail on each of the three main components (SSIS, SSAS, SSRS). Author uses his own database rather than the AdventureWorks sample used by most other books. This is a big plus, the database is very small and the number of tables/entities to contend with is easy to conceptualize. Plus it gets you more involved with the exercises - less chance of 'sleepwalking' through a topic because AdventureWorks sometimes makes things seem deceptively familiar.

Maybe surprisingly, the SSAS section is the best part of the book - in particular, the MDX and Data Mining chapters. MDX is a quirky #if incredibly powerful# language, and the examples and diagrams in Chapters 11 and 12 are VERY well thought out and presented. You'll have to go to other sources to truly master either MDX or Data Mining, but this book contains a fine foundation. I dived straight into both these topics previously, using more 'advanced' books, and regretted it.

The final section is around SSRS, to my mind the dullest, most vanilla, part of the MS BI stack. Ploughing through plumbing/security/drudgery is not something I ever find interesting, but even SSRS was made interesting here through examples consuming OLAP and DM. Finally, a cool little bonus hidden away in Chapter 18 showing an example of programming through [...].

I'd highly recommend the book - it's a comprehensive and practical overview.

11 of 12 found the following review helpful:

3Good book, errors in example code thoughApr 20, 2010
By schmintan "schmintan"
Content is great, well laid out, explains topics in easy to understand language for the most part.
Big problem with the examples though.

There is a cube project called MaxMinSalesDM. This is created by one VS2010 project. It is populated by another. Problem is the column names in one of the tables are incorrect (in the analysis services project, a table is called SalesPerson, but in the SSIS projects that populate the cube, the table is referenced as Sales_Person. When populating the Slowly changing dimension, this causes an error.

For a beginner, i need to learn by example of these projects, and dont have the knowledge to fix these errors. This has caused me hours of trouble and for this reason, i might just skip this book if you are going to rely on the projects.

See all 18 customer reviews on Amazon.com
About Us   Contact Us
Privacy Policy Copyright © , Security Books. All rights reserved.
Web business powered by Amazon WebStore