Prueba sql server

Predictive Analysis with SQL Server 2008
White Paper

Published: November 2007
Updated: July 2008

Summary: Microsoft SQL Server 2008 offers predictive analysis through a complete and intuitive set of data mining tools. Seamless integration with the Microsoft Business Intelligence platform provides rich insight at every step of the data lifecycle. Furthermore, the flexible platform empowersyou to extend prediction into any application.

For the latest information, see Microsoft SQL Server 2008.

Contents
Introduction 1
Predictive Analysis for All Users 2
Pervasive Delivery through Microsoft Office 2
Comprehensive Development Environment 4
Insight at Every Step of the Data Lifecycle 8
Native Reporting Integration 8
In-Flight Data Mining During Data Integration 10Insightful Analysis 12
Predictive KPIs 13
Data Mining Awareness in Every Application 14
Predictive Programming 14
Plug-In Algorithms and Custom Visualizations 14
Conclusion 15

Introduction
One of the most valuable assets of any company is the large volume of business data in various applications and systems throughout the organization. This data has the potential to providepreviously unimagined insights into the business and to form a reliable basis for effective decision-making and accurate forecasting that can drive a company forward to success. Unfortunately, all too often the data is collected by the various computer systems and left dormant in isolated data stores. Some organizations may generate historical reports from this data, and some may even measure thecompany’s performance against key performance indicators (KPIs); but surprisingly few organizations realize the benefits of mining their historical data to detect patterns and trends, and even fewer embed predictive analysis into their day-to-day business processes to make decisions and predictions and to improve the overall agility of the company.
Over the past few releases, Microsoft has refined thereporting and analytical capabilities in Microsoft® SQL Server® to create a comprehensive Business Intelligence (BI) platform that can be integrated into everyday business activity and used effectively by employees throughout the organization instead of only by a few specialized analysts. Many organizations that previously would have found BI solutions too expensive or complex to implement are nowtaking advantage of the comprehensive report authoring, rendering, and delivery capabilities of SQL Server Reporting Services and the powerful online analytical processing (OLAP) services provided by SQL Server Analysis Services. The close integration between these BI server products and the ubiquitous Microsoft Office system has brought business analysis to the masses and promoted the evolution ofa new kind of information worker who can gain a deeper insight into the business and operate more effectively.
While this proliferation of reporting and multidimensional analytics has greatly benefited many organizations of all sizes, the next step in promoting business agility and operational efficiency is to make the leap from retrospective analysis of historical data to proactive actions basedon predictive analysis of business data, and to embed intelligent, fact-based decision-making into business processes. The key to accomplishing this is to use powerful data mining algorithms to analyze data sets, compare new data to historical facts and behaviors, identify classifications and relationships between business entities and attributes, and to deliver accurate predictive insights toall of the systems and users who make business decisions. As with OLAP technologies, data mining was once considered a highly specialized field that required expensive software and rare expertise to implement. However, by including comprehensive data mining technologies in SQL Server Analysis Services, and through integration with the 2007 Microsoft Office system, Microsoft has delivered a...