Answer all four questions in attachment.

a. Whatâs the scope of what can be considered a data warehousing failure?

b. What generalizations apply across the cases?

c. What do you find most interesting in the failure stories?

d. Do they provide any insights about how a failure might be avoided?

Data Warehousing FailuresEight studies of data warehousing failures are presented.They were written based on interviewswith people who were associated with the projects.The extent of the failure varies with the organization,but in all cases, the project was at least a disappointment.Read the cases and prepare a one or two page discussion of the following:1.What’s the scope of what can be considered a data warehousing failure?Discuss.2.What generalizations apply across the cases?3.What do you find most interesting in the failure stories?4.Do they provide any insights about how a failure might be avoided?Case Studies of Data Warehousing FailuresAuto GuysAuto Guys initiated a data warehousing project four years ago but it never achieved full usage.Ainitial support for the project eroded, management revisited their motives for the warehouse anddecided to restart the project with a few changes.One reason for the restructuring, according to the projemanager, was the complexity of the model initially employed by Auto Guys.At first, the planner for the data warehouse wanted to use a dimensional model for tabularinformation.But political pressure forced the system’s early use.Consequently, mainframe data waslargely replicated and these tables did not work well with the managed query environment tools that wereacquired.The number of tables and joins, and subsequent catalog growth, prevented Auto Guys from usdata as it was intended in a concise and coherent business format.The project manager also indicated that the larger the data warehouse, the greater the need for higlevel management support – something Auto Guys lacked on their first attempt at setting up the warehouAnother problem mentioned by the project manager was that the technology Auto Guys chose for theproject was relatively new at the time, so it was not accepted and did not garner the confidence that a prousing proven technology would have received.This is a risk inherent in any “cutting edge” technologyadoption.The initial abandonment of the project was undoubtedly hastened by both corporate discomfowith this new technology and the lack of top management support.A short time after dropping the project, top management felt pressure to reestablish it.Because AGuys initially planned an enterprise-wide warehouse, they had considerable computer capacity.It was puto use on a much smaller project that focused exclusively on a single subject area.Other subject areas wedue to be added once the initial subject area project was completed.Auto Guys expects to grow thewarehouse to two terebytes within a year or two and eventually expand to their projected enterprise-widedata warehouse.The biggest difference between pre- and post-resurrection will be that the project willevolve incrementally.Given his experience with the warehouse, the project manager made the following summaryobservations: (1) the management of expectations is critical to any sizeable data warehousing project; (2)proven technology, although not essential, does make the project easier to explain and justify; and (3) thehttps://www.coursehero.com/file/7663758/TUN-DataWarehousingFailures/This study resource wasshared via CourseHero.com

• 1492955751-TUN_DataWarehousingFailures.pdf

ComputerScienceExpert

(11)

Status NEW Posted 23 Apr 2017 01:04 PM My Price 9.00

-----------

Attachments

file 1492955753-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer