Microsoft office | Data Mining | Microsoft

Microsoft office | Data Mining | Microsoft

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.