Microsoft office | Data Mining | Microsoft

Asked By 10 points N/A Posted on -
qa-featured

How does microsoft office help in using the data mining & data warehouse & what queries used in the data warehouse ?

SHARE
Answered By 0 points N/A #86682

Microsoft office | Data Mining | Microsoft

qa-featured

The MS Data Mining Add-ins for MS office 2007 and 2010 can help you derive patterns and trends that exist in complex data, visualize those patterns in charts and interactive viewers, and generate rich, colorful summaries which can be used for presentation and for business analytics. These add-ins uses the predictive analytics of SQL Server in MS Excel and MS Office Visio.

The role of a data warehouse is to collect and organize business data so it can be analyzed to assist management in making business decisions. Until recently, access to data warehouses was limited to database experts who could create the complicated queries necessary to retrieve, summarize, and format information for use by analysts and executive decision makers. As data warehouses become more common, and businesses involve lower levels of management in the decision-making process, the need has become greater for direct end user access to data warehouse data by people with minimal database expertise.  Queries such as SQL queries and English query (where you use english word and phrases for querying data) are used in data warehouse.

 

Login/Register to Answer

Related Questions