Section 6: Designing and Building the Data Warehouse

Presentation Transcript

Part 6: Designing and Building the Data Warehouse Modern Data Warehousing, Mining, and Visualization: Core Concepts by George M. Marakas © 2003, Prentice-Hall

6-1: The Enterprise Model Approach To DW Design The initial phase in arranging is to characterize the data prerequisites of the venture. Endeavor demonstrate – various separate models that, when appropriately coordinated, give an intelligent photo of the undertaking. One critical component of the EM is the corporate procedure demonstrate, a profoundly organized depiction of the basic procedures in the undertaking. Another is the corporate information display, which portrays the substances produced by or required by the procedures. © 2003, Prentice-Hall

Design Strategies Top-down DW plan – the information stockroom configuration depends on the undertaking model itself. It infers a vital, instead of operational, point of view of the information. Base up DW plan – concentrates more on making utilization of the information accessible in the present framework. This is less exertion than the top-down approach, yet may wind up with a DW that does not fulfill the greater part of the association's data needs. © 2003, Prentice-Hall

The Concept of Enterprise Integration must happen on three unmistakable levels: Horizontal combination: every application is completely incorporated inside its own particular limits Vertical joining: the application is in concordance with its expressed business prerequisites. Undertaking joining: the information and procedures all through the association, and all cooperations between them, will be institutionalized. © 2003, Prentice-Hall

Entity ID – what are the building pieces? ER graphing – how do substances identify with others? Prepare distinguishing proof – what is the work process? Element life cycle investigation – does work change elements? Occasion investigation – how do occasions group to forms? Affiliation charting – how do objects collaborate? Basic variable examination – what is required for achievement? SWOT investigation – what are qualities, shortcomings? Data needs examination – what information does every business zone require most? Frameworks assessment – are present frameworks adequate? Exercises Associated With EM Construction © 2003, Prentice-Hall

6-2: The Data Warehouse Project Plan First on the motivation is an availability appraisal. Preparation has five key elements: Strong administration sponsorship – maybe the most vital element Compelling business inspiration – the estimation of a DW is the thing that it accomplishes for the business Quality of the IS-business organization – the IS gathering should be a focal piece of the business © 2003, Prentice-Hall

6-2: The Data Warehouse Project Plan (cont.) First on the motivation is a status appraisal. Preparation has five key variables: Culture of the association – the association must place a high incentive on data and investigation DW plausibility – are the present information exact and sufficiently institutionalized to make incorporation doable? © 2003, Prentice-Hall

A Litmus Test for DW Readiness Kimball, et al built up a few tests that make it generally simple to decide availability. Table 12-2 contains full points of interest, yet a few tests are: For administration sponsorship: low-level status is motioned by not having the capacity to get to top executives or their absence of comprehension for what DW advancement involves. For the IS-business association: low-level preparation is motioned by a firm utilizing excessively numerous outside IS experts, or if the DW group was framed with no IS interest. © 2003, Prentice-Hall

Addressing DW Readiness Shortfall If the litmus test distinguishes just a couple of deficits, there are a few procedures that can be connected to address absence of availability. A business prerequisites examination performed at an abnormal state can recognize the zones to target. Another approach is to do a business prerequisites prioritization which will help us decide in what request to continue. We can do a pilot think about or separated rollout of innovation as a proof of idea . © 2003, Prentice-Hall

Example of a Project Prioritization Matrix Project 6 would be the main decision for usage, then Project 7. The two most reduced in rank are 1 and 8. © 2003, Prentice-Hall

Defining the DW Project Scope The extension sets up a limit for the venture and characterizes both what it is and what it is not . One of the main things to do is choose "what we are perusing". Close term? Three years? An unwritten decide is that the venture chief needs to make as few guarantees as could be expected under the circumstances. You need to keep away from "degree crawl", where the venture keeps on extending. © 2003, Prentice-Hall

Guidelines for Developing Initial Scope It ought to be a joint venture amongst IS and different business capacities. The underlying degree ought to be important and reasonable. The underlying spotlight ought to be on a solitary business necessity from a solitary procedure. The quantity of beginning clients ought to be constrained. Achievement criteria ought to be created toward the begin, alongside the degree. © 2003, Prentice-Hall

Defining the Business Justification Once the extension is set up, the following stride is to build up the business case. This is truly no secret, only an ID of venture (1) foreseen advantages and (2) likely expenses. In the event that a venture can't be advocated before it starts, no such defense will come after cash and time are put resources into it. © 2003, Prentice-Hall

Issues in Making the Business Case The most ideal approach to see the DW venture is as a noteworthy capital speculation by the enterprise. There are three viewpoints from which to contend for the venture: actualities, confidence and dread. Amid the 1980s, when organizations made overwhelming IS ventures, there truly was no expansion in efficiency. Then again, contemplates have demonstrated that IS staff members were the organization's generally beneficial. This profitability mystery is maybe because of the way that many IS speculations were not reasonable in any case. © 2003, Prentice-Hall

Three bases of venture Justification "The information distribution center venture will have a net present estimation of $753,000." "The information stockroom will yield a base diminishment in working expense of $193,000 every year." "The evaluated increment in piece of the overall industry is 14.7 percent inside the initial 24 months of operation." "An information stockroom is a piece of the framework, we can't cost legitimize it like another armada of trucks." "It appears to be sensible to expect that this information distribution center will lessen our expenses of overhauling this market section." "Trust me. This is the reason you contracted me as IT executive." "Our rivals are doing this even right now." "Our shareholders will see us as mechanically behind on the off chance that we don't do this now." "We have a little window of chance here and we are squandering valuable time attempting to choose." Facts Faith Fear © 2003, Prentice-Hall

Economic Feasibility Analysis This action is a kind of money saving advantage examination, entangled by the way that many advantages are elusive and difficult to gauge. Unmistakable advantages are either taken a toll decreases or income increments. Immaterial advantages incorporate enhanced confidence, expanded item quality, diminish so as to market, lessening in turnover, expanded upper hand and all the more convenient data. © 2003, Prentice-Hall

Tangible and Intangible Costs Tangible advancement costs incorporate pay rates, advisor charges, equipment and programming buys and information change. Substantial working expenses incorporate yearly licenses, updates, repairs, client preparing and devaluation. Immaterial expenses incorporate disturbance to condition, loss of goodwill, lessening in spirit and preoccupation of thoughtfulness regarding day by day duties. © 2003, Prentice-Hall

An Example of Measuring Intangibles Suppose we trust that there is around a 60 percent chance that one out of each 10 specialists will be upset amid the underlying execution. Our typical benefits are $2,000,000, and we trust they would be zero if the whole workforce was upset . Benefit decrease is: (.1)(2000000) = $200,000 and it has a 60% possibility of happening, so we assess the "trouble" cost at (.6)(200000) = $120,000 Is this privilege? Most likely not! Yet, would it say it isn't ideal to have a gauge in light of sensible presumption than making no gauge by any means? © 2003, Prentice-Hall

Economic Feasibility Measures Assessment of possibility needs to perceive the time estimation of cash since many expenses happen quickly while benefits collect more than quite a long while. On the following two slides we demonstrate a venture that profits a net present estimation of $890,806 more than five years. The inner rate of return is 38% and breakeven is assessed at 2 years and 7 months. © 2003, Prentice-Hall

Spreadsheet Model of NPV Analysis © 2003, Prentice-Hall

Example of Graphical Breakeven Analysis © 2003, Prentice-Hall

Developing the DW Project Plan Staffing issues: Table 12-8 records 14 diverse staffing parts in a commonplace DW extend. Some key parts are venture administrator, business frameworks investigator, database director, application engineer and quality affirmation examiner. © 2003, Prentice-Hall

Developing the DW Project Plan (cont.) The Formal Plan: two key qualities of a very much composed DW extend plan are high coordination and high detail. Albeit every one is distinctive, the arrangement ought to contain a rundown of required assets, a gauge of venture timetable, evaluated begin and end dates, an unmistakable rundown of assignment conditions and an arrangement of banners that will be signs that the venture is late. © 2003, Prentice-Hall

6-3: Specifying the Analysis and Design Tools While an element relationship demonstrating come closer from social database configuration could be utilized, the dimensional displaying way to deal with sensible outline is m