Archives of the TeradataForum
Message Posted: Fri, 18 Mar 2005 @ 15:18:22 GMT
| Subj: || || Re: Combining Business Data with Performance Data? |
| From: || || Judge, James A |
IMO, to use fundamental reasoning in any DW project, what is the "business reason/necessity" for this? To accelerate DW growth, show DW ROI,
secure someone's job and/or bonus. Once you can express the business driver for this then you can define the requirements (expressed as KPI's,
whatever). If the DW is funded/viewed as a "corporate" asset, i.e. no chargeback methodology for DW usage to BU's, then I would think the
reason, and thus the funding, will be less achievable. This effort will have a cost in resources and can it show some type of ROI to the business
(e.g. at a BU level can this show an ROI to the IT department for the DW)?
Once you get past that, what is the association (as in data modeling) between DW performance (I'll assume usage and growth) and the "business
application(s)" (SLA's, BU-users, time-of-day)? Can you make a valid correlation between (company at a high level and BU application at a lower
level) KPI's and DW performance?
I think this is a noble idea but at the "end-of-the-day" is it providing business value to someone? That said, one area I have seen a lot of
discussion/writings on is the direct correlation between the "data-quality" in the DW and BU performance. So, if you can extend that concept, into
say "DW quality", then I think you have something.