Tag archive for ‘Data warehouse’

• 

  Making rapid prototypes for data warehouse ETL jobs

  Data warehouses and even data marts can be expensive, complex projects. They are not projects to start lightly, and they are not projects that you want to launch without doing some solid planning.
  But there is a way to get a handle on the tricky parts of your data warehouse scope, and to reduce your [...]

  9/14/09 • (0)

• 

  6 Tips for making a business intelligence project budget

  Sometimes it seems like going over budget on a data warehouse project is an unwritten rule. But very often, there are some simple ways to help avoid making a budget that is doomed to be overrun. By budgeting correctly at the start, and managing cost, the project manager can deliver the benefits that the [...]

  6/15/09 • (1)

• 

  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. [...]

  1/18/09 • (0)

• 

  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 [...]

  12/02/08 • (0)