Tag archive for ‘Data mart’
-
Build vs Buy the Allure of Out of the box business intelligence
The big software vendors claim they can sell you an "out of the box" data warehouse including reporting that installs onto your Oracle, Microsoft or SAP ERP package. Are these things really that easy? Is it actually cheaper to build it yourself? How do you determine if a given product is a good [...]
-
A Cost comparision between Data Marts and a Data Warehouse
I've noticed a fair bit of search traffic focusing on cost questions, particularly which is cheaper; a series of data marts or a single enterprise data warehouse. I think it's a bit like the question of lease vs buy. Starting off building a single departmental data mart will represent a much smaller cash flow out. [...]
-
Data Warehouse vs Data Mart
Very often, the question is asked- what's the difference between a data mart and a data warehouse- which of them do I need?
Data warehouse or Data Mart?Data Warehouse:
Holds multiple subject areas
Holds very detailed information
Works to integrate all data sources
Does not necessarily use a dimensional model but feeds dimensional models.Data Mart
Often holds only one subject [...]
