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
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.
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
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
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