Register :: Login 
sql server  |  data mining  
 February 9, 2016  

Microsoft Data Mining Books

User Statistics
Membership Membership:
Latest New User Latest: raja200k
New Today New Today: 0
New Yesterday New Yesterday: 1
User Count Overall: 27099

People Online People Online:
Visitors Visitors: 0
Members Members: 0
Total Total: 0

Welcome to


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 in-database data mining and analytics features.  SQL Server 2000 was the first major database release to put analytics at the database.  Catch up with the latest SQL Server Data Mining news in our newsletter.

Now Available
SQL Server 2012 SP1 Data Mining Add-ins for Office (with 32-bit or 64-bit Support)
The Data Mining Add-ins allow you to harness the power of SQL Server 2012 predictive analytics in Excel and Visio and they have been updated to include 32-bit or 64-bit support for Office 2010 or Office 2013. Use Table Analysis Tools to get insight with a couple of clicks. Use the Data Mining tab for full-lifecycle data mining, and build models which can be exported to a production server.  Visualize your models in Visio.
SQL Server 2012 Data Mining
Microsoft expert Rafal Lukawiecki provides free and paid videos on data mining for SQL Server 2012 at Project Botticelli. The website has other Microsoft BI topics too from leading Microsoft experts. [Check out these videos]
SQL Server DM with Excel 2010 and PowerPivot
Microsoft MVP Mark Tabladillo shows you how to unleash SQL Server 2008 Data Mining with Excel 2010 and SQL Server PowerPivot for Excel, Microsoft's new self-service BI offering. [Check out his videos]
Predixion Software Offers Third-Party Tools for SQL Server Data Mining 
Our friends at Predixion Software have released Predixion Insight, their predictive analytics offering that builds on the SQL Server Data Mining platform. They have added some cool visualization and collaboration features that are surfaced in Excel Services as well. [Watch their videos]
Data Mining Tip
Explore filtered models in SQL Server 2008
This articles explores how you can work with filtered models, a powerful new feature introduced in SQL Server 2008 that allows you build models on slices of a mining structure.
[More Tips]
Featured on
How to get the number of clusters discovered by Microsoft_Clustering
This tip shows you how to programmatically fetch the number of clusters discovered by the Microsoft_Clustering algorithm when you request auto-detection.
[More Tips]

This sample shows how to use SQL Server Data Mining as a suggestion engine behind an online video store

[More Samples]
  • Incorporating Data Mining into the Integration, Analysis and Reporting Component of BI (Webcast)
  • SQL Server Data Mining: Plug-In Algorithms (Whitepaper)
  • Detect Anomalies in Excel Spreadsheets (Article)
  • Explore Time Series enhancements in SQL Server 2008 (Tutorial)
  • Print  
    Recent Data Mining Forum Posts
    Query Getting too many results 08 Feb 2016
    Incorrect syntax near ',' on Create statement table statement 04 Feb 2016
    Possible to speed up the decision tree by Clustering the Server 2003 24 Aug 2007
    Group By issue in a 20 Jan 2016
    STDEV of amount of previous 10 orders by customer at each order point in time 21 Jan 2016
    I can't create Data mining structure as dimension using existing Database. 23 Jul 2014
    Export Sql server data to Excel in .xlsx format with powershell 20 Jan 2016
    TSQL to retrieve a number based on a number in a result 12 Jan 2016
    Cannot resolve the collation conflict between <> and <> in the EXCEPT operation. 18 Jan 2016
    data mining client for excel 2016 01 Dec 2015
    SQL server 2012 Data Mining addin for Excel 2013 12 Jan 2016
    How to implement 1R & Mean imputation algorithm in C# 07 Jan 2016
    Adventure works Vs other Data set (Want to combine the two and visualize using Power BI) 23 Dec 2015
    Query rows to columns 22 Dec 2015
    Reprocess SSAS project - SQL Server 2008 R2 17 Dec 2015
    Data Mining seminar suggestion 16 Dec 2015
    How to automatically generate HTML Visualizations of Mining Models using Visio? 25 Jul 2007
    In a view, I want to add a column that isn't in the table I'm selecting from that I name and has 1 set value for each record in the view 15 Dec 2015
    SQL Server 2012 Data Mining add-in SP2 for Excel 2013 64 bit (I am using office professional plus) on Windows 7 64 bit) 14 Dec 2015
    error message: "object reference not set to an instance of an object" 24 Jul 2015
    Related Sites
    SQL Server 2012 Downloads
    SQL Server 2008 Downloads
    Ask the Data Mining Community

    Disclaimer: is currently managed by members of the SQL Server Data Mining development team at Microsoft Corporation. It does not represent Microsoft’s official position on its products or technologies. All content is provided “AS-IS” with no warranties, and confers no rights.


     Copyright 2014 by Data Mining Team   Terms Of Use  Privacy Statement