Q: What is an effective way of recouping the running costs of the data warehouse (DW) from the business users, without impacting usage of the DW? I'm picturing a situation where a DW has already been delivered and major releases (projects) are funded by lines of business (probably through a budget allocated to IT supported by a business case). But for non-project scenarios, how do I recoup the cost of day-to-day maintenance/support, which will probably be going up if the DW is increasing in popularity/usage, thus improving the business processes and decision-making?

Interesting dilemma - You're right. If you charge for day-to-day DW activity, managers will suggest to their people to only use the DW when they absolutely need to. This will significantly reduce usage and now the fixed cost of the DW would be allocated to fewer and fewer queries and reports, raising the cost per query which would reduce usage even further. A technique that doesn't penalize usage is to charge the owner of the data for both the amount of data and the frequency of update/load. The owner, in turn, could decide to charge other departments which use the data.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access