Searching good book on Microsoft Business Intelligence Development Studio 2005

Question

Hi,

I'm looking for a good book that about Microsoft Business Intelligence Development Studio 2005. Most interest goes to SSIS, but SSAS and SSRS are also important.

The book explains in a fair, simple and as much hands on way how the Development Studio for BI works (solution, projects, do's and dont's) and all the transformations in SSIS one can use thoroughly explained (like for example how a Derived Columns works). I'm a BI consultant (10 years experience), but not in Microsoft solutions.

Who can suggest me a good book?

Answer 1

I don't think it will be easy to find one book covering AS, RS and IS as these three are quite different products.

Analysis services books:
- Professional SQL Server Analysis Services 2005 with MDX is a good hands-on book on Analysis Services covering most of the product.
- I'm very impressed with Kimball's original Data Warehouse Toolkit, so The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset should be worth a look. - You will find more resources on Analysis Services in replies to my question.

Integration Services: The Rational Guide to Extending SSIS 2005 with Script is a good hands-on Integration Services book.

Answer 2

I found Delverng Business Intelligence with Microsoft SQL Server 2005 to be a good book. It's a bit high level but goes across the whole product from SSIS, SSAS and SSRS with alot of theory on data warehousing.

Answer 3

The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset from Ralph Kimball seems to be a good starting point