Your database has been a hit. You have been called back to the customer’s headquarters and they want...

Question

Your database has been a hit. You have been called back to the customer’s headquarters and they want a detailed report and plan how to convert the mass amounts of data into profitable information. They have heard of data warehouses and data mining, but they want you to provide an executive overview and a plan with specifics on how they will take their environment to the next level with the implementation of a data warehouse and data mining infrastructure. Write a 6-8 page paper in which you:
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.
Discuss optimization techniques specific to data warehousing and data mining.
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.
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements: •& nbsp;Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
•Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
•Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams/charts must be imported into the Word document before the paper is submitted. The specific course learning outcomes associated with this assignment are:
•Demonstrate the basic mechanisms for accessing relational databases from various types of application development environments.

Robert · Accepted Answer

Data mining finds solutions to questions on your business that you simply haven't understood 
to rise. It determines info at intervals data warehouses that enquiries and reports cannot 
efficiently disclose. The possible payoffs from data processing, if you decide the proper tools 
and use them efficiently. These applications will become the inspiration of your 
administration's business strategies-determining loan risk, detection fraud, handling product 
guarantees, getting standard for trade supplies, and shaping new communications product and 
facilities.  
Multidimensional examination, usually known as on-line analytical processing (OLAP), lets 
users do way more advanced queries, like relate sales comparative to arrange by quarter and 
region for the previous 2 years. However in each cases, the results area unit simply mined 
values or an aggregation of values.  
Data mining spreads abundant profounder into databases. Data processing tools notice 
patterns within the knowledge and infer rubrics from them. Those patterns and rules are often 
wont to guide decision-making and prediction the impact of these choices. And data 
processing will speed analysis by concentrating devotion on the foremost necessary variables.  
Data mining is setting out for many reasons. Organizations area unit meeting a lot of 
knowledge concerning their businesses. The big come by storage costs has created it possible 
to stay vast amounts of information on-line. a number of this knowledge comes from ancient 
on-line group action process (OLTP) systems, however abundant of it's the results of systems 
place in situ in current ages that imprisonment all particulars of a group action to assist firms 
higher perceive what clienteles really need and do-as against what they are saying. 
Benefits of Data warehousing 
According to the information Warehouse Institute, an information warehouse is that the 
foundation for flourishing metal program. The idea of knowledge reposition is pretty simple to 
understand—to produce a central location and permanent space for storing for the varied data 
sources required to support a company’s analysis, news and alternative metal functions. 
And it’s really important for your business. 
But a knowledge warehouse conjointly prices cash — money. The matter is once money is 
concerned it’s powerful to justify defrayment it on any project, particularly after you can’t 
extremely quantify the advantages direct. Once it involves a knowledge warehouse, it’s difficult to 
understand what the advantages area unit till it’s up and running. In line with BI-Insider.com, 
here area unit the key edges of knowledge warehouse once it’s propelled. 
A Data Warehouse Delivers Enhanced Business Intelligence 
By inducing knowledge from varied sources, managers and executives can now not got to 
create business selections supported restricted knowledge or their gut. 
A Data Warehouse Saves Time 
Since business users will quickly access vital information from variety of sources—all in one 
place—they will quickly build enlightened choices on key enterprises. They won’t surplus 
valuable time recovering information from numerous foundations. 
Not solely that however the business execs will question the info themselves with very little 
or no support from IT—saving longer and more cash. Meaning the business users won’t need 
to wait till IT gets around to generating the reports and people tireless of us in IT will do what 
they are doing best—keep the commercial successively. 
A Data Warehouse Enhances Data Quality and Consistency 
A knowledge warehouse implementation includes the conversion of data from varied supply 
systems into a standard format. Since every knowledge from the assorted departments is 
standardized,

Your database has been a hit. You have been called back to the customer’s headquarters and they want a detailed report and plan how to convert the mass amounts of data into profitable information....

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment