≡ Menu

Open Source BI – Pentaho Business Intelligence Books

Pentaho BI is one of the popular toolset amongst open source BI area and is widely used due to robust features and capabilities. Learning open source BI tools can be sometime very difficult due to lack of help or resources available. However, for Pentaho there are number of books available and these books serves a building blocks in building the Pentaho BI skills.

Following are some of the good books to get started on Pentaho BI.

If you are absolute begginer and want to learn the pentaho and various tools offered by Pentaho this books serves the purpose. This books covers Pentao BI in good details and lets you understand the Pentaho BI tools in great depth. This book focuses on Pentaho Data Integration (Kettle) and covers topics from beginner level to advanced topics like tuning and optmization

Books To Learn Microsoft Business Intelligence – Beginner To Advanced Level

Amongst commercial Business Intelligence softwares. MS BI toolset (Microsoft Business Intelligence) toolset is gaining a popularity due to its features, Inbuilt integration with MS SQL Server and use friendlyness.

Microsoft Business Intelligence toolset consists of folloing tools.

SSRS (Reporting Services): Its an tool used for en user reporting. It can connect to analysis services or can use stored procedure or SQL as data source.

SSIS (Integration Services): Its a ETL tool.

SSAS (Analysis Services): Its very popular tool due to its analytical capabilities.

If you want to learn MS BI , you can start with following books which takes you from basic concepts to advanced level.

This is not realy a book but you can say its a personal BI trainer. Its combinition of book and a DVD. Its an ideal for anyone who wants to start learning MS BI step by steo

 

Knight's Microsoft Business Intelligence 24-Hour Trainer (Book & DVD)
Its an training kit by Microsoft itself and recommended for 70-448 certification. It also have an DVD package which contains step by step videos of how to’s

 

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance: MCTS Exam 70-448 (Microsoft Press Training Kit)
If you want to learn data warehousing and BI concepts and also want to learn MS BI, this is the book fo you. It teaches MS BI with a case study
The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

Books To Learn SQL Server Integration Services – SSIS

ETL is the onoe of the most complex area of data warehousing poject due to unreliable data sources containing unchecked data. If you are using MS BI SSIS tool as an ETL tool in your datawaehousing you need to know the tool very thouroghly as SSIS provides multiple ways to do same this and you would really need to know which one is the best way to accomplish the task.

Following are the SSIS books which would take you from simmple SSIS concepts to the advanced concepts like handling SCD efficiently, performance tuning etc.

Its a great book to learn SSIS from beginner to advanced level. Its a big book and you might want to keep you around as a reference book while working on SSIS project If you are working on 2012 SSIS then this book would come to your rescue. It covers almost every topic of SSIS 2012

Good Books For Learning SSRS From Basics to Advanced

SSRS is reporting tool provided by Microsoft and it comes as a part of MS BI toolset. SSRS can be connected to SSAS as well as can be used to do reporting using stored procedures as well as SQL. It can also be integrated with .net application.

Following books are the recommended books on SSRS.

This is one of the most poprualr books amongst MS BI professional. This book covers basics topics of SSRS as well as advanced topics in detail. Written by top SSRS developer, this book is more practical and teaches SSRS in practical way using real life examples

Books To Learn SSAS From Basics To Advanced Level

SSAS is the most popular product amonst MS BI toolset due to its cube technology. Its OLAP Server, MDX capabilities makes mutidimensional analysis easy and effective. Due to capabilities of SSAS it has become top choice for many data warehousing projects.

Following books are the recommonded books to learn SSAS (SQL Server Analysis Services).

This book is best choce of SSAS professional as it covers almost all he topics of SSAS from beginner level to advanced. This is training kit book and contains step by step tutorials on complex topics. This book is good for those who want to learn SSAS and looking for tutorials on SSAS