Explain the process of consolidating data from operational systems with other organizational data

What will be an ideal response?


A crucial process for consolidating data from operational systems with other organizational data-to facilitate the use of data mining techniques to gain the greatest and broadest understanding from the data-is extraction, transformation, and loading.

First, the data need to be extracted from different systems. In the transformation stage, data are being cleansed and manipulated to fit the needs of the analysis. Data cleansing refers to the process of detecting, correcting (e.g., standardizing the format), or removing corrupt or inaccurate data retrieved from different systems. Finally, the transformed data are loaded into the data warehouse and are ready for being used for complex analyses.

Business

You might also like to view...

Which of the following is not a behavior of a leader who executes?   

A. Reward the doers. B. Insist on realism. C. Follow through. D. Know yourself. E. Respect others' limitations.

Business

Under the indirect method, if a current liability account increases from the beginning of the year to the end of the year, what is the impact of the change on the statement of cash flows?

a. Cash inflow from financing activities is increased; b. Cash inflow from financing activities is decreased; c. Cash inflow from operating activities is increased; d. Cash inflow from operating activities is decreased; e. none of these.

Business

In a linear relationship formula, the variable being predicted is x

Indicate whether the statement is true or false

Business

In 2014, Kelly writes Like the Wind, a novel about marathoners and ultramarathoners. Kelly does not register the work with the appropriate government office. Under federal copyright law, Kelly's work is protected

a. for ten years. b. for twenty years. c. for the life of the author plus seventy years. d. forever.

Business