Books

Reference & General Data warehousing Books

Articles

Open Source Software

Our Articles


Easy Excel Reporting - This article and the associated PDF detail a simple yet powerful approach to creating Excel Reports.


Unix Commands for the Data Professional - This article details many useful techniques and commands for a data professional. 


Reporting Tools


  1. JFreeReport


  1. Jaspersoft


Data Mining Tools


  1. Weka


  1. RapidMiner


  1. R Language

Industry Articles


The 10 Essential Rules of Dimensional Modeling - The 10 commandments of the Kimball methodology


The 10 mistakes to avoid when estimating ROI for Business Intelligence - Things to avoid when justifying your expenditure on data warehousing


Using Regular Expressions for Data Warehouse cleansing and standardization - Never underestimate the power of regular expressions


Maintaining Dimension Hierarchies - Understanding dimensionality and the relationships of data is the key to a successful data warehouse.


Should you use an ETL Tool - Discusses some of the pros and cons


An Architecture for Data Quality - Data quality is important but often left to the sidelines. This article sets about rectifying this issue.


Overcoming Obstacles When Gathering Business Requirements - The importance of the business can not be over stressed when capturing requirements. But how can you effectively overcome obstacles.




The Data Warehouse Toolkit by Ralph Kimball


The Data Warehouse Lifecycle Toolkit by Ralph Kimball


Covering

  1. Modeling

  2. Requirement

  3. Project Management

  4. Aggregations

  5. Checklists

The Microsoft Data Warehouse Toolkit


The Microsoft BI offerings have matured.


Covering

  1. Modeling (overview)

  2. ETL Design & Build

  3. OLAP cubes

  4. Reporting

Commercial Software

ETL Tools


  1. Informatica


  1. Ab Initio


  1. SSIS

Data Mining Tools


  1. SPSS


  1. DeltaMaster