Delivering Business Intelligence with Microsoft SQL Server 2008 |  | Author: Brian Larson
Publisher: McGraw-Hill Osborne Media
Category: Book
List Price: $49.99
Buy New: $23.00
as of 7/30/2010 03:39 CDT details
You Save: $26.99 (54%)
New (34) Used (16) from $23.00
Seller: CHRISTINA N.
Rating:  8 reviews
Sales Rank: 17940
Media: Paperback
Edition: 2
Pages: 792
Number Of Items: 1
Shipping Weight (lbs): 2.8
Dimensions (in): 9 x 7.3 x 1.6
ISBN: 0071549447
Dewey Decimal Number: 658.4038
EAN: 9780071549448
ASIN: 0071549447
Publication Date: November 19, 2008
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | Details | | • | Clear | | • | Easy to understand | | • | Help to develop and build own company commercial sites | | • | Run good businesses online |
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Overview
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.
|
| Customer Reviews:
Showing reviews 1-5 of 8
 Good book, errors in example code though April 20, 2010
schmintan (ireland)
3 out of 3 found this review helpful
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.
The best overall intro to the full breadth of SQL 2008 BI March 27, 2010
David Foley (Portsmouth, NH United States)
3 out of 3 found this review helpful
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.
Wow, GREAT book on SQL BI, DW, and Data Analytics and Mining March 16, 2010
Jaewoo Kim (Santa Monica, CA)
2 out of 3 found this review helpful
I have read many books on SQL BI (going back to SQL 2000 OLAP) . This one is by far the best book not only on SQL OLAP and BI, but also on Data Mining and Analytics and Data Warehousing that I have ever read. This book will offer all beginning to intermediate SQL 2008 BI administrators, developers, and managers one of the best explanations of the SQL BI 2008 features, best practices, and implementation processes. Even if you are a seasoned expert, this book will offer insights perhaps you never had.
The chapter 6 alone ranks as perhaps the best chapter on Data Mining and Analytics I have ever read. Chapter 6 ALONE is worth the price of this book.
In other to manage, develop, and utilize SQL 2008 BI, one needs to think differently about data than one thinks about OLTP databases. One needs to understand measures, dimensions, attributes, star schema, and snowflake schema rather than tables and 3 forms of normalizations. Furthermore, ETL and Data Warehousing are exceedingly important to SQL BI.
Data Mining and Analytics is not hard. It is just different and requires understanding of a completely different paradigm. This book very clearly explains that paradigm bette than any other book I know. I also recommend statistical analytics tools such as SAS to complement SQL BI.
Finally, do not neglect MDX. It is the industry standard BI language and I would hesitate to hire any SQL BI person who does not have even rudimentary understanding of MDX. This book covers the rudiments of MDX quite well.
This is the ideal first book on SQL 2008 BI and I highly recommend it.
Covers everything you need to know to get started February 5, 2010
Coder10 (Tijuana, BC, MX)
1 out of 2 found this review helpful
i had almost no clue what BI was and after reading this book i now see the light
New to SQL Server BI? Start here June 15, 2009
Henry Bell (Chicago)
9 out of 9 found this review helpful
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.
Showing reviews 1-5 of 8
|
|
|
