| | |  | Software Engineering | Home » » » Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 (PRO-Developer) | | | | | | | Product Promotions: | | | | | Description: | | Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you’ll master the concepts, tools, and techniques for building solutions that deliver intelligenceand business valueexactly where users want it. Discover how to: - Manage the development life cycle and build a BI team
- Dig into SQL Server Analysis Services, Integration Services, and Reporting Services
- Navigate the Business Intelligence Development Studio (BIDS)
- Write queries that rank, sort, and drill down on sales data
- Develop extract, transform, and load (ETL) solutions
- Add a source code control system
- Help secure packages for deployment via encryption and credentials
- Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models
- Create and implement custom objects using .NET code
- View reports in Microsoft Office Excel® and Office SharePoint® Serverook
| | | Product Details: | | | Author:
| Lynn Langit | | Paperback:
| 624 pages | | Publisher:
| Microsoft Press | | Publication Date:
| February 04, 2009 | | Language:
| English | | ISBN:
| 0735625808 | | Product Length:
| 9.0 inches | | Product Width:
| 7.4 inches | | Product Height:
| 2.0 inches | | Product Weight:
| 3.45 pounds | | Package Length:
| 9.0 inches | | Package Width:
| 7.4 inches | | Package Height:
| 2.1 inches | | Package Weight:
| 3.35 pounds | | Average Customer Rating:
|  based on 10 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 10 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
18 of 18 found the following review helpful:
 Explanations could be more lucidMar 22, 2010
By Jaewoo Kim
"OB-Wan"
First, explaining many of the concepts related to Data Warehousing, data mining, and business intelligence would be one of the most difficult challenges to any technical writer. That's why many SQL BI books (dating back to SQL 2000) are so poorly written and lacks crystal clarity of many of the key concepts. Once I was done reading this book, I asked myself one question, "Am I a better BI architect because I have read this book?". From a technical knowledge perspective, yes. From a BI process (plan, design, implement, debug, verify, performance tune) perspective, I felt I did not gain much from this book.
This book would be a good manual if you do not understand some of the key concepts (Dimension vs Measure, Star schema vs Snowflake etc). If you want to actually implement a Snowflake schema, SSIS, and customize the results, the book was lacking. In other words, the book does not focus on the nuts and bolts of SQL 2008 BI. It gives you more of a 5000 ft overview.
It doesn't help that the book has a writing style similar to a college math textbook. You may need to read many paragraphs more than once to obtain the golden nuggets of information. In books such as this, you want writers to be blunt and forthright and not meander using sophisticated prose. The book certainly could be shorter than the 700+ pages.
The writers seem to possess strong technical knowledge of SQL 2008 BI. They have much to offer in terms of key knowledge and concepts. To put it into an analogy, this is like a book that describes how a car battery works but lacks information on how to properly change the car battery.
14 of 15 found the following review helpful:
 Good overview of the technologiesMar 22, 2009
By Aussie
"Ben"
I think it is a decent book to get a start on SSAS, SSIS, and SSRS. Maybe not for the most experienced MS BI developers, but certainly for those with less experience.
In some areas it goes into a fair bit of detail, in others it doesn't. The authors push quite heavily on the Data Mining bits.
Overall I felt it is a bit too much 'marketing talk' in favour of Microsoft - could probably have shortened the book by 50 pages if they had left that out.
10 of 11 found the following review helpful:
 Practical Guidance for Developing A Successful, Real-World Business Intellegence SolutionOct 21, 2009
By Cal Zant
I recently completed a business intelligence project at my company that included things like aggregating data from various sources into a centralized data warehouse, and then processing that so it could be accessed through both an OLAP cube and a relatively simple relationship database. I believe the project was a complete success, and am very happy with the both the functionality we provide to our end-users (who are regular business people, and not just analysts) as well as how easy to maintain and robust the end-solution is. I think that last part is what probably gets most companies. They develop some type of data warehouse for business intelligence, but it is a house of cards that just continually sucks their time because it is so fragile or always needs to be updated to allow a business analyst to slice or view the data in a new way. I can definitely see how you could end up there, and I believe this book was the primary contributor to the success of our project.
I work for a small business (currently ~65 employees), and right now our IT Team has three members: 1 system admin, 1 full-time developer, and me (my time is split half and half between software and business management). None of us had any experience with OLAP, SQL Server Integration Services (SSIS), or SQL Server Analysis Services (SSAS) ... although I had sat through a few sessions/workshops over these topics at conferences. Although it is counter-intuitive (especially to someone who is a developer at heart), I have come to believe in the notion that the sooner you start coding the longer it will take. So, I knew I needed to get some more in-depth expertise in these areas before we started the project, which is why I ordered this book.
Before I even created the first prototype, I forced myself to sit down away from the computer and read the first two parts of the book (~400 pages). It it was eerie how much the content seemed custom-tailored to my current situation. It was targeted at a more technical audience, so the detail and depth used was spot on, and it assumed you had some working knowledge of OLTP relational databases so it didn't have to go over all the basics.
The book covers a ton of best practices that the authors have learned "the hard way" while implementing a ton of business intelligence solutions on the SQL Server framework, and most of them were not entirely obvious. The whole business intelligence area is still in its early phases, and there are a lot of gotchas. SQL Server 2008 has made some significant improvements over past implementations to help guide you to best practices, but there are still a lot of gotchas. The authors also demostrate an in-depth knowlegde on the new features SQL Server 2008 offers, plus then explain when/how you might use them.
At 624 pages, this book may seem a little overwhelming ... but I think it is worth its weight in gold. It is almost like you have an experienced consultant sitting beside you. If you are considering implementing a business intelligence solution, there are tips in this book will save you time, effort, and you will end up with a better solution for your business in the end.
To view the full review or see more reviews on technical books like this, visit: [...]
2 of 2 found the following review helpful:
Just an overview of BIDec 20, 2010
By Rajkumar Ramasamy
"Rajkumar Ramasamy"
This book is a good overview for BI solutions such as SSIS and SSRS. For an experienced BI developer, this book is not a right pick. There is a very good overview on all the BI terminologies and covers information required to design, develop and deploy SSIS, SSRS and SSAS solutions.
For a beginner BI developer, this is a good book to start with. There is some help on BIDS which will help for a new BIDs user, connecting to source control, design, develop, secure and deploy BI solutions. There is a step by step help to create and manage ETL. The book helps to understand MDX core functions and few extended functions and a little bit about DMX (Data mining). More data mining samples might help a beginner.
Was expecting little bit more on Excel reporting (which is commonly used) and SharePoint reporting (which is more likely a future common reporting tool). Overall, this is a good startup book for beginners not a reference guide for an experienced developer.
 You need to have worked before with Microsoft BI to understand the bookApr 08, 2012
By mictalem
I have worked with BI solutions, but not with Microsoft, so I bought the book sure that wont be much trouble.
have to say, the theory is great, and help to picture what things can be achived, it smoothly says what can be done, but when the time comes to actually build a solution, it's confusing. Makes me feel the author said, "ok, let's move on, they will figure out the details, it's part of the fun", but not too much fun (for me) to be honest. bottom line, I bought another book, and this one is not in the shelf...
See all 10 customer reviews on Amazon.com
| | |
|
