. Provide an executive overview that addresses the following: Explain the benefi
ID: 3537398 • Letter: #
Question
. Provide an executive overview that addresses the following:
Explain the benefits and current trends of data warehousing and data mining.
Provide two (2) examples of quality companies successfully using a data warehouse to support your answer.
Outline the architecture, models and views used in the data warehouse.
2. Discuss optimization techniques specific to data warehousing and data mining.
3. Assume that the company has accumulated 20TB of data and that 20% per year growth is expected in the size of the Data Warehouse. Recommend a solution for this scenario with respect to software, hardware and network requirements.
Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the conceptual data feeds into and out of the data warehouse. Note: The graphically depicted solution is not included in the required page length.
Explanation / Answer
1)Explain the benefits and current trends of data warehousing and data mining.
A Data Warehouse Delivers Enhanced Business Intelligence
By providing data from various sources, managers and executives will no longer need to make business decisions based on limited data or their gut. In addition, %u201Cdata warehouses and related BI can be applied directly to business processes including marketing segmentation, inventory management, financial management, and sales.%u201D
A Data Warehouse Saves Time
Since business users can quickly access critical data from a number of sources%u2014all in one place%u2014they can rapidly make informed decisions on key initiatives. They won%u2019t waste precious time retrieving data from multiple sources.
Not only that but the business execs can query the data themselves with little or no support from IT%u2014saving more time and more money. That means the business users won%u2019t have to wait until IT gets around to generating the reports, and those hardworking folks in IT can do what they do best%u2014keep the business running.
A Data Warehouse Enhances Data Quality and Consistency
A data warehouse implementation includes the conversion of data from numerous source systems into a common format. Since each data from the various departments is standardized, each department will produce results that are in line with all the other departments. So you can have more confidence in the accuracy of your data. And accurate data is the basis for strong business decisions.
A Data Warehouse Provides Historical Intelligence
A data warehouse stores large amounts of historical data so you can analyze different time periods and trends in order to make future predictions. Such data typically cannot be stored in a transactional database or used to generate reports from a transactional system.
2)Turnkey integrated analytical solutions
3).
Neural Artificial Networks: Models which you learn through training materials are normally used with neural network structures based on OLAP or cube technology in general.
Genetic Algorithms: This process is used as an optimization techniques that include combination, natural and mutation algorithms which are based on natural evolution.
Decision Trees: This data warehouse level is based on tree shaped structures that represents a set of important decisions.
Rule Induction: This data is based on significant statistical methods that is used in data extraction from the data warehouse.
Data Visualization: Data visualization is the interpretation of complex data which involves graphic tools that are used to illustrate relationship data.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.