cs 614 data warehousing

Question

Question

cs 614 data warehousing

Q 1.Data Gap Analysis is an important part of source system analysis.What should be

considered during Data Gap Analysis?Discuss at least three points.

engineering computer science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Before you begin a gap analysis, you should perform an in-depthvulnerability and risk assessment. Once the vulnerability and riskassessment iscomplete, perform a gap analysis within each sector.A gap analysis compares what is currently there to what isrequired.

The following are the things to be considered during data gapanalysis. Look for data that is not:

Located where it is needed

Needed

Available when needed

Created

Consumed

answered by: Tennyson

Add a comment

Answer 2

Similar Homework Help Questions

cs 614 data warehousing

Q 2.After completing source system analysis, a source-to-targetspecifications (orsource-to-target data map) can facilitatedevelopers to create a quality ETL logic.You arerequired to draw a source-to-target data map using Kimballmethodtemplate for any sampledata.
cs 614 data warehousing

Q 1.Describe points to be considered for implementing a web-enableddata warehouse.Q 2.Using the knowledge you have learned in this subject, describe thefollowingapproaches to develop a datawarehouse:•The top downapproach•The Bottom-UpApproach•FederatedapproachHybridApproach
cs 614 data warehousing

Q 1.Explain steps to be performed in decision tree classification? Alsoexplain theconditions where it needs to stop.Marks5Q 2.Briefly explain the properties of k-means algorithmMarks5Q 3.How a Self – Organizing Map (SOM) could be used to analyzedata in a datawarehouse? Explain briefly.Marks5

Data analysis in health care today includes two important elements: human and machine. Data analysts serve...

Data analysis in health care today includes two important elements: human and machine. Data analysts serve an important role by interpreting health care data and making recommendations to stakeholders for its potential impacts and uses. These highly-skilled individuals also rely on cutting-edge technology to aid in data collection, analysis, implementation, and assessment. Evaluation Title: Data Analytics Technology Pitch Part I: In one paragraph, discuss the role of data analytics in health care today. Assume the role of a performance improvement...
2. a) Discuss three requirements analysis strategies. [3marks] b) What is the purpose of developing use...

2. a) Discuss three requirements analysis strategies. [3marks] b) What is the purpose of developing use cases during system analysis? [2marks] c) Outline four factors that can influence the choice of a system acquisition strategy. [2 marks] d) Assuming you are part of a team tasked to develop a library management system for UENR, which system acquisition strategy would you recommend and why (give at least three reasons). [3marks]
The data below indicate the state gas tax in cents per gallon and the fuel use...

The data below indicate the state gas tax in cents per gallon and the fuel use per registered vehicle (in gallons). Tax (in cents) 31 1932 35 23 19 Usage (in gallons) 780.3 878.1 740.6 677.7 815.7 801.0 Source: American Petroleum Institute. Part 1 The correlation coefficient for the data is r = -0.875 and a = 0.05. Should regression analysis be done? The regression analysis should be done. Part 2 out of 3 Find the equation of the regression...

We have learned how important information technology is. What type of data is your organization collecting?...

We have learned how important information technology is. What type of data is your organization collecting? Is any of this considered big data? What are their processes and what tools are used for data mining and data analysis? Discuss specific examples and whether or not you feel there are more opportunities for tools or strategies to create even better knowledge and efficiency.
PART B: Five Short Answer Questions (25 marks) (Each question is worth 5 marks. Answer the...

PART B: Five Short Answer Questions (25 marks) (Each question is worth 5 marks. Answer the questions in the Answer booklet provided.) Why is chain of custody important? What happens when a chain of custody is broken? Outline the basic steps when planning a digital forensics investigation [1+1+3 Marks] 1. Discuss two acquisition methods in digital forensics. Your answer should include scenarios and tools used in each acquisition method. [2+3 marks] 2 Why is validation important? What is data hiding?...
Using What-If Analysis" Accountants are counted on to provide management with analyzing data to determine best-...

Using What-If Analysis" Accountants are counted on to provide management with analyzing data to determine best- and worst-case scenarios. As future planning becomes more complex, these what-if analyses can increase in complexity and usefulness. Identify and discuss at least three (3) types of what-if analyses that an accountant should be able to perform to measure a firm’s performance over a period. Be sure to include the type of data that will be needed to support this analysis. Justify your response.

Data Warehouse 1.3 Why would you drop indexes during the Load Operation of the ETL Phase...

Data Warehouse 1.3 Why would you drop indexes during the Load Operation of the ETL Phase of a Data Warehouse Project? Why would you disable foreign key constraint (referential integrity) before loading data during the Load Operation of an ETL Project Phase? What is the Staging Area that is used during the ETL phases of Data Warehouse Project? Name one type of Source Data System that is used to extract data during the ETL phases of a Data Warehouse Project....

cs 614 data warehousing

Homework Answers

Add Answer to:
cs 614 data warehousing

Post as a guest

Earn Coins