By host on
4/14/2011 4:12 PM
Ik durf te stellen dat nog steeds het fenomeen datawarehouse veel te ambachtelijk wordt opgebouwd. Met ambachtelijk bedoel ik ‘handmatig’.
Read More »
|
By host on
9/12/2010 12:00 AM
More and more applications will be dismantled into services. Services that only require part of the data to function properly. Thus the databases linked with the applications will also tend to become smaller. But where does the data stay?
Next to that we see that companies operate in an environment in which they communicate more and more near real-time with many parties. Partners, suppliers, customers, government etcetera. This triggers projects to set up bus architectures to exchange data based on a publish and subscribe mechanism.
And of course companies continue to set up a BI architecture to support decision making processes.
Read More »
|
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 »
|