| | |  | Secure Communications | Home » » Delivering Business Intelligence with Microsoft SQL Server 2008 | | | | | | | 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. | | | 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 | | 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 8 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
Write an online review and share your thoughts with other customers.
3 of 3 found the following review helpful:
 Good book, errors in example code thoughApr 20, 2010
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.
3 of 3 found the following review helpful:
The best overall intro to the full breadth of SQL 2008 BIMar 27, 2010
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.
2 of 3 found the following review helpful:
Wow, GREAT book on SQL BI, DW, and Data Analytics and MiningMar 16, 2010
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.
1 of 2 found the following review helpful:
Covers everything you need to know to get startedFeb 05, 2010
i had almost no clue what BI was and after reading this book i now see the light
9 of 9 found the following review helpful:
New to SQL Server BI? Start hereJun 15, 2009
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.
| | |
|
