United States Change | All Microsoft Sites
Microsoft Home | Servers and Tools
Create an easy-to-use, extensible, accessible, and flexible business intelligence platform and take the next step in business intelligence with SQL Server data-mining capabilities. Discover patterns and uncover business data to reveal the hidden trends about your products, customer, market, and employees, and better analyze those components that are critical to your organization's success.
Inform decisions with intuitive and comprehensive data mining tools available to all users. Watch the Webcast.
Introduce prediction into every step of the data lifecycle to discover hidden insight on-the-fly. Watch the Webcast.
Embed prediction to create intelligent applications, and extend data mining functionality to meet specific business needs. Watch the Webcast.
SQL Server data mining is part of a family of business intelligence technologies that can be used together to enhance and develop a new breed of intelligent applications. These technologies include the following:
SQL Server 2005 Integration Services. Create a more powerful data pipeline by working with SQL Server 2005 Integration Services, allowing your organization to flag outliers, separate data, and fill in missing values based on the predictive analytics of the data-mining algorithms.
SQL Server 2005 Analysis Services. Create a richer Unified Dimensional Model by adding data-mining dimensions that slice your data by the hidden patterns within.
SQL Server Reporting Services. Create smarter, insightful reports based on data-mining queries that present the right information to the right audiences.
Providing data mining to organizations of any size introduces new challenges. Deployment, scalability, manageability, and security all become important factors. SQL Server data mining is part of SQL Server Analysis Services, which provides all the enterprise-class server features you would expect:
Deployment. SQL Server data mining is based on a client-server architecture, enabling you to access models from your local area network (LAN), wide area network (WAN), or the Internet. Standard application programming interfaces (APIs) provide access to your models regardless of location or client platform.
Scalability. SQL Server data mining was designed from the ground up with a parallel architecture to scale to enterprise-class data sets and thousands of concurrent users, and can respond to millions of queries per day.
Manageability. SQL Server data mining is integrated into the new SQL Server Management Studio, providing a one-stop tool for managing all your SQL Server family properties.
Security. SQL Server data mining provides fine-grained, role-based security to ensure that your intellectual property is further protected.
Using the built-in Data Mining Wizard and Designer, you can build sophisticated models with only a few mouse clicks.
Integrated directly into Microsoft Visual Studio, the SQL Server data mining toolset lets you explore and manipulate data, as well as design and edit your models. SQL Server data mining provides more than a dozen interactive visualizations to help you understand the patterns that data mining can discover. Additionally, lift and profit charts are provided so you can compare and contrast the quality of your models before you commit to deployment.
When it comes to applying models, SQL Server opens a new chapter in data mining. Data Mining eXtensions (DMX) for SQL make it easy for developers and database administrators to create data mining-aware applications. For the first time, those responsible for creating applications and handling data are empowered to use data-mining technology by using tools they already understand.
SQL Server data mining is fully extensible through Microsoft .NET-stored procedures and plug-in algorithms and viewers that embed seamlessly to take advantage of all the platform abilities and integration. Adopting SQL Server data mining as your platform means that you will never be limited by the inherent functionality of your data-mining system because it can always be extended to meet your needs.
Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007 is a set of easy to use data mining capabilities that enable predictive analysis at every desktop. Being able to harness the highly sophisticated data mining algorithms of Microsoft SQL Server 2005 Analysis Services within the familiar environment of Office, business users can easily gain valuable insight into complex sets of data with just a few mouse clicks. Designed with the end users in mind, the Data Mining Add-Ins for Office 2007 empowers end users to perform advanced analysis directly in Microsoft Excel and Microsoft Visio.
Overview of Data Mining Add-Ins for Office 2007
The Microsoft SQL Server 2005 Data Mining Add-Ins for Microsoft Office 2007 contain three add-ins. Two for Microsoft Office Excel 2007 and one for Microsoft Office Visio 2007.
Table Analysis Tools for Excel: Provides an easy-to-use add-in that leverage SQL Server 2005 Data Mining behind the scenes to perform powerful end user analysis on spreadsheet data.
Data Mining Client for Excel: Offers a full data mining model development lifecycle directly within Excel 2007.
Data Mining Templates for Visio: Enable powerful rendering and sharing of mining models as annotatable Visio 2007 drawings.
Download Add-ins
Tutorials
The Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007 video tutorials has been created to help you to quickly get started using the Data Mining Add-Ins for Office 2007. The series consist of a small selection of short videos focusing on illustrating how to use the various features and allowing you to benefit from the powerful add-ins in a matter of minutes.
Watch this video to learn how to use the Server Configuration Utility to prepare the Analysis Services Server for use with the Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007.
Table Analysis Tools Tutorials
Watch this video to learn how to get started using the Table Analysis Tools.
Watch this video to learn how to use the Analyze Key Influencers tool, which is designed to help users detect the key characteristics of a data set that influence a certain outcome.
Watch this video to learn how to use the Detect Categories tool, which will help users automatically create more manageable data sets across large data volumes by detecting categories data based on common properties.
Watch this video to learn how to use the Forecast tool, which is designed to help users identify patterns in a dataset to predict how it will extend in the future.
Data Mining Client Tutorials
Watch this video to learn how to get started using the Data Mining Client for Excel 2007.
Watch this video to learn how to use the Explore Data tool, which is designed to help users identify and resolve imperfections in a data set.
Webcast
Microsoft SQL Server 2005 Analysis Services contains data mining and predictive analytical functionality that makes advanced analytics accessible to a much wider audience than ever before. Now, thanks to a set of add-ins for the 2007 Microsoft Office system, any information worker can take advantage of the power of SQL Server data mining. In this webcast, learn about the Data Mining Add-ins for the 2007 Office system, and see exciting demonstrations that highlight these enhancements to Microsoft Office Excel 2007 functionality that is accessible by any user.
Screencast
This screencast is the first in a series BI Developer screencasts recorded as part of a workshop built on SQL Server 2005 that have been delivered around the globe by Microsoft and Microsoft Partners. This training event introduces the student to the Table Analysis Tools for Excel 2007. These powerful tools hide the complexity of data mining technologies behind intuitive and automated tasks, delivering rich and innovative insight at the desktop.
Microsoft delivers full range of personal, team and organizational BI tools, tightly integrated, with a focus on making the right decisions to drive a business forward.
"...having looked at the data mining services in Microsoft SQL Server, I am very impressed!... this is fully-fledged corporate data mining, ...everything scales, and operation is fast and reliable ...simply building a model will now become available to everyone who uses SQL Server and Office, with speed and precision." David Norris, Associate Analyst, Bloor Research, November 2006
"Many analytical tools integrate with Microsoft Excel, and for a simple reason: People who crunch numbers for a living spend a lot of time with spreadsheets. SQL Server 2005's data-mining algorithms offer powerful capabilities for analyzing data, ...Let's walk through the installation and configuration of the Data Mining Add-ins and look at a comprehensive sample." Tyler Chessman, From the May 2007 edition of SQL Server Magazine
"One of the design principles of SQL Server 2005 data mining is not only to support analysts who are setting up, training, and deploying the model but also to make it easy for business users to consistently, repeatedly consume the results of a data mining model without any special knowledge of the underlying data-mining technology." Matt Nunn, From the October 2005 edition of SQL Server Magazine
Take the next step in BI with Symphic Technology’s one-day, hands-on SQL Server Data Mining Workshop, where you’ll learn how to use the sophisticated data mining technology of SQL Server to gain insight into your data, make predictions, and develop intelligent applications.
Symphic Technology invites you to learn to design and build a complete BI solution using the comprehensive, integrated SQL Server BI platform, including how to use Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS), and how to perform Data Mining--all in a compact, 5-day, hands-on class.
This site has been designed by the SQL Server data mining team to provide the SQL Server community with access to and information about our exciting data mining features.
SQL Server data mining newsletter
Take advantage of the opportunity to talk directly with your peers as well as with Microsoft developers about SQL Server data mining.
Bogdan Crivat is a senior developer for SQL Server data mining.
Jamie MacLennan is a principal development manager leading the development of SQL Server data mining
Donald Farmer is a principal program manager for SQL Server data mining.
This book shows you how to create and implement data mining applications that will find the hidden patterns in your historical datasets.
SQL Server 2005 provides different environments and tools that you can use for data mining. This article outlines a typical process for creating a data mining solution, and identifies the resources to use for each step.
Data Mining Extensions (DMX) is a language that you can use to create and work with data mining models in Microsoft SQL Server 2005 Analysis Services (SSAS). You can use DMX to create the structure of new data mining models, to train these models, and to browse, manage, and predict against them. DMX is composed of data definition language (DDL) statements, data manipulation language (DML) statements, and functions and operators.
Data Mining
