By host on
9/7/2009 8:22 AM
It is very hard to formulate a proper question when you don't really have an idea of what it is you want to know or hope to find.
We need some sort of 'lingua franca' within our organisation (where we might have multiple applications and even data warehouse environments) so we can ask our questions and get meaningful results – i.e. we need a collection of important terms, their semantics and how they are related.
Read More »
|
By host on
8/31/2009 11:04 AM
Some companies put an overkill of procedures in place making fast implementations almost impossible. Some companies hardly have any procedures and implement all the time during the day whenever they like. What is the right balance between serving the business and being in control?
Read More »
|
By host on
8/28/2009 12:08 PM
Everyday organizations, small and large, are faced with new challenges and decisions that need to be made. The questions asked might be slightly different, but in essence size doesn’t matter.
Read More »
|
By host on
8/17/2009 1:19 PM
What is your definition of BI? Does it encompass operational reporting or doesn't it? What is operational reporting anyway? I think the Data Vault is excellently suited to play the role of underlying model for operational reporting from your BI environment. And here is why.
Read More »
|
By admin on
3-7-2009 9:36
In a previous blog entry I started describing the benefits of the Data Vault especially for the business, as it is not always easy to explain why a data warehouse architecture is required to support reporting and planning processes. In this second entry I bring three other reasons to the table: data preservation, enhanced auditability and traceability and finally ease of integration of new mergers and acquisitions.
Read More »
|
By host on
6/10/2009 8:02 AM
In two blog entries I’ll explain why there are some good compelling reasons for the business to also want to understand more on data warehousing, and in particular the benefits of a Data Vault oriented data warehouse.
· shorter time to market of new reporting requirements
· more focus on the business requirements
· data preservation
· enhanced auditability and traceability of data
· ease of integration of new mergers and acquisitions
Read More »
|
By admin on
2-6-2009 12:57
A new trend has entered the Data Warehouse market place: the data warehouse appliance. The idea is to offer a complete solution for the data warehouse in a single purpose, dedicated box.
This is an interesting new proposition, that allows new data warehouse projects to hit the ground running. You need a green-field situation though, and be aware that most setting up the system for data warehousing is not by far the most costly aspect of building (and owning!) a data warehouse.
Read More »
|
By admin on
2-6-2009 12:51
Generally the industry recognizes three distinct categories of data in a BI environment:
- Transaction data
- Master data
-
Meta data
These different type are treated very differently by most data warehouse systems, in particular the ones that are built from fact tables and dimension tables. Close inspection learns that the distinction is not always clear, and depends on the analysis needs of the organisation. The data warehouse can be (and should be) oblivious of the differences between transaction, master and meta data.
This notion calls for a very generic and flexible data modeling technique. One that is still simple enough to quickly comprehend and scalable enough to be used in any data warehouse environment , from very small scale to multiple-petabytes. We believe such a modeling technique is the Data Vault, as designed and described by Dan Linstedt. Visit our dedicated sister-company www.qosqo.nl for details.
Read More »
|