Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Data Warehouse 1.2 List three Critical Success Factors related to the evaluation

ID: 3716617 • Letter: D

Question

Data Warehouse 1.2

List three Critical Success Factors related to the evaluation of a Data Warehouse Project.

List some ways that you can resolve the issues that arise during the ETL Processes of a Data Warehouse Project.

List three issues that may occur during the ETL Processes of a Data Warehouse Project.

List one activity that occurs in the Construction Phase of a Data Warehouse Project.

List one activity that occurs in the Design Phase of a Data Warehouse Project.

List one activity that occurs in the Planning Phase of a Data Warehouse Project.

List one activity that occurs in the Requirements Definition Phase of a Data Warehouse Project.

List one activity that occurs in the Maintenance Phase of a Data Warehouse Project.

List one activity that occurs in the Deployment Phase of a Data Warehouse Project.

In which Data Warehouse project phase do the ETL processes occur?

What is a Logical Data Map and what is its purpose during the ETL Planning Phase of a Data Warehouse Project.

Data Warehouse 1.2

List three Critical Success Factors related to the evaluation of a Data Warehouse Project.

List some ways that you can resolve the issues that arise during the ETL Processes of a Data Warehouse Project.

List three issues that may occur during the ETL Processes of a Data Warehouse Project.

List one activity that occurs in the Construction Phase of a Data Warehouse Project.

List one activity that occurs in the Design Phase of a Data Warehouse Project.

List one activity that occurs in the Planning Phase of a Data Warehouse Project.

List one activity that occurs in the Requirements Definition Phase of a Data Warehouse Project.

List one activity that occurs in the Maintenance Phase of a Data Warehouse Project.

List one activity that occurs in the Deployment Phase of a Data Warehouse Project.

In which Data Warehouse project phase do the ETL processes occur?

What is a Logical Data Map and what is its purpose during the ETL Planning Phase of a Data Warehouse Project.

Explanation / Answer

Answer 1:

1. Expectations are communicated to the clients

IT is frequently unwilling or afraid to tell the clients what they will get and when. Clients ought to be told about the accompanying:

- Performance - what to expect for reaction time

- Availability - booked hours and days

- Function - the data that will be accessible and what pre-characterized questions and reports are available. The level of detail data, as well as how the data is integrated and aggregated

- Historical data

- The expectations of accuracy for both the cleanliness of the data and an understanding of what the data means

- Timeliness - when the data will be available and how much of the time the data is loaded/updated/revived

- Schedule expectations include when the framework is expected for conveyance

2. Client contribution is guaranteed

There are three levels of client contribution, as takes after:

- Build it; they will utilize it

- Solicit prerequisites from the clients

- Have the clients included all the way through the task

The last level is by a wide margin the best approach, while the main almost always brings about failure.

3. The undertaking has a decent support

The best support is from the business side, not from IT. Most importantly, the support ought to be in genuine need of the data warehouse's capabilities to tackle a particular issue or gain some advantage for his or her department.

DEAR DUE TO COMPANY NORMS , WE ARE RESTRICTED TO ANSWER MORE THAN ONE QUESTION. KINDLY POST SEPARATELY.

RATE IT IF HELPS ELSE LET ME KNOW YOUR DOUBT.

THANK YOU!!