Archive for March, 2010

“future” approaches to BI/DW implementations

March 19, 2010 Leave a comment

Today I read a very interesting article about "future" approaches to BI/DW implementations which can be found at here.

These days I am working on an enterprise data warehouse for a major bank in Australia. My team has a lot of debate around using Generic Pattern / UDM (Len Silverston’s Universal Data Model) or Data Vault. One major advantage of UDM here is the larger deployment in industry. There are more case study and existing model template made available for quick deployment.

Currently, we adopt Agile methodology for the project. We use Test Driven Development (TDD). As the database platform is IBM DB2 9.7 and Oracle 11g, we use  Concordion automated unit testing framework. And recently I found on CodePlex, there is a free unit testing framework for Microsoft BI, which is called BI Quality, which is based on NUnit.

Categories: Data Modeling