Question.4657 - M3: Data Warehouse Debate (In-House vs. Hosted?)Topic Discussion Objective: Apply data warehouse implementation concepts through a real-world scenario-based case-study exercise. Scenario:You are part of the executive team for a large, multi-state regional banking organization that is working to increase cross-selling of additional products and services to existing customers. An external marketing consultant has recommended that you pursue a BI strategy that will allow you to use existing customer data in conjunction with externally-purchased survey data to give your branch management more information about their customers. The first step in this overall BI strategy is to construct a data warehouse using a variety of data sources including your in-house banking ERP system and externally-purchased survey data. Your CEO has made this a key short-term strategy and asked for it to be in place within six months. Your team's challenge is to figure out the most cost and time efficient means of meeting that charge. Discussion challenge:Should you build the data warehouse as an in-house or should you contract with a cloud-based service? Your team leader has been with the bank for over 20 years and thinks that the best course of action is to build it as an in-house system. Others are challenging them and suggesting it will be better to go with an outsourced service.Your task in this discussion is to help the group come to a decision regarding this question of building an in-house or 'cloud-based' data warehouse. You can take either position, but you should provide a sound set of supporting discussion points that draw on a combination of readings in this module and any external information you can find. Be sure and address sources of data, cleansing of data, security, and business objectives.Actions to take: Part A:Do you agree with the team leader that an in-house solution is best, or do you agree with the challengers that that think it's better to go with an outsourced service? Pick one of the two and provide a sound argument that supports your support for that approach.Part B: Review posts in the thread taking the opposite position from yours. Find at least one and reflect on them in writing addressing such things as whether they have changed your opinion in some way or providing a constructive counter argument to their position.
Answer Below:
Considering xxxxx based xx in xxxxx data xxxxxxxxx within xxxxx of xxxxx and xxxxxxxx of xxxx required xxx a xxxxxxxxxxxxx BI xxxxxxxx a xxxxx based xxxx warehouse xxxxx be xx optimal xxxxxx in xxxxx to xxxx deeper xxxxxxxxxxx the xxxxxxxxxxx processing xxxxxxxxxx big xxxxxxx involving xxxxxxxxx require xxxxxx throughput xxxxxxxxxx for xxxx that xxx structured xxxx ERP xxxx and xxxxxx data xxxxxxx those xxxx are xxxxxxxxxxxx in xxxx scenarios xxxxx based xxxxxxxxx like xxx Redshift xxxxxxxxx or xxxx Google xxxxxxxx leverage xxxxxxxxxxx computing xxx elastic xxxxxxxxxxx that xxxxxxxxxxxx dynamic xxxxxxx needs xxxx effectively xxxxxxx On xxx other xxxx in-house xxxxxx is xxxxxxxxxxx by xxxx for xxxxxxxx infrastructure xxxxxxxxx capital xxxxxxxxx upgrades xx handle xxxxxx expansion xx term xxxx integration xxx cleaning x hybrid xxxxxxx that xxxxxxxxx of xxxxxxxx banking xxxxxxxxxxxx and xxxxxxxx survey xxxx necessitate xxxxxxx transform xxx load xxxxxxxxx with xxxxxx data xxxxxxxxx capabilities xxxxx cloud xxxxxxx will xxx in xxxxxxxxxx ETL xxxxx like xxx or xxxxx that xxxxxxxxx schema xxxxxxx deduplication xxx normalization xx contrast xx on-premise xxxxx demands xxxxxxxxxxx manual xxx customization xxxxxxxxxx development xxxx and xxxxxxxxxxx overhead xxxxxxx Within xxx scope xx security xxx compliance xx house xxxxxx will xxx in xxxxxxxxx localize xxxxxxx cloud xxxxxxxx adhere xx stringent xxx PCI-DSS xxx GDPR xxxxxxxxxx standards xxxx built-in xxxxxxxxxx MFA xxx AI xxxx threat xxxxxxxxxx tools xxxxxxx For xxxxxxxx in xxxxxxx datasets xxxxx breaches xxx frequent xxx to xxxxxxxxxxxxx on xxxxxxx access xxxxxxxx than xx hardened xxxxx environment xxxxxx considering xxx CEO x six xxxxx deadline xxxxxxxxxxx solutions xxxx to xxxxx pre-configured xxxx warehousing xx a xxxxxxx with xxxxxxxxxx integration xxxxx in xxxxx system xxxxxxx hardware xxxxxxxxxxxx network xxxxxxxxxxx and xxxxxxx optimization xxxxxxx ReferencesPraveen x V x Data xxxxxxxxxxx Concepts xxxx Basics xx Advance xxxxxxxxxx Addition xxxxxxxxxx HouseMore Articles From Business Intelligence UNIV 4708
.ico)
.ico)
.ico)
.ico)
