Data Mining Plugin for Excel 2013

  • Article

Data mining option is a plugin for Excel 2013. You can build powerful mining models and even work with a range of data in excel sheet to exploit the power of mining in a simple and intuitive way.

Download the data mining plugin for office 2013 from the link below.

https://www.microsoft.com/en-us/download/details.aspx?id=35578

Once installed, you can see the ribbon with various choices as shown below.

 

The ribbon has

1. Data Preparation

2. Data Modeling

3. Accuracy and Validation

4. Model Usage

5. Management

6. Connection

We start with Connection. Go through the wizard to connect to Analysis Services.

For people familiar with mining, the wizards are a breeze. It gives description of what the model does.

DATA PREPARATION

Explore Data allows you to choose a single column of data and will allow bucketing. You can choose the number of buckets. You can also add a new column back to your data range defying the group into which data belongs .i.e. you start with one column and end up having another column with ranges defined.

Clean data will help in removing the outliers by either deleting it or changing value of outlier to a minimum / maximum specified.

Sample data helps create a sample dataset from the bigger sample. You can input either a percentage or a fixed number of rows. It will then split data into “selected data” and “unselected data” tabs.

DATA MODELING

When you start creating a data model, the dataset is automatically split into a training set and a testing set. Wizard provides option to enable for browsing and drill through.

Classify and estimate provides values of another column based on column selected

Clustering gives mean, standard deviation, probability for the population and a feature to compare between clusters.

Similarly Associate and Forecast provides data for unknown time periods.

Advanced wizard helps you create a mining model or add a model to a structure.

It is easy to use data mining features in Excel. You will have to do some prep work to understand what is mining and the uses of mining models.

Comments

  • Anonymous
    June 19, 2013
    Check out a practical example of Forecasting here - blogs.msdn.com/.../forecasting-sales-data-with-excel-mining-step-by-step-guide.aspx

  • Anonymous
    October 25, 2013
    I have installed it yet and set up my sql yet it wont work

  • Anonymous
    December 07, 2013
    I'm running this with SQL Server 2012 Developer Edition with Excel 2013.  Let's see...Power Pivot, Power Query, Power View, Power Map, and Data Mining...Excel and SQL Server have become a very powerful combination.  If you're a Data Analyst this is as good as it's ever been.

  • Anonymous
    December 14, 2013
    The comment has been removed

  • Anonymous
    January 12, 2014
    Is it a must to have Sql Server 2012 installed before the add-in can work in excel?

  • Anonymous
    January 20, 2014
    Hi, I have sql 2012 and office 2013 pro plus,. when i try run this, i get an error: needs 32 bit version of office 2010. any idea why?

  • Anonymous
    January 22, 2014
    Hello everyone, My name is Zach, and i represent videotrainingpro.com and we specialize in MS Office training videos. Kirt Kershaw President of Dream Force LLC. is a Microsoft Certified Trainer who gives entertaining but very informative and helpful trainings for all of your MS Office needs. Project and Excel 2013 have just been released with the rest of 2013 Software on its way. Go check out videotrainingpro.com and get the great deals today! Thanks, videotrainingpro.com

  • Anonymous
    February 06, 2014
    Yeah, unfortunately this sounds great until you actually try to use it on something practical. Extremely tiny data sets are all it can do. You either have it churning forever only to have it burp out a message object not found or it completely disappears from your screen while attempting to train a model. MS SQL 2012 Enterprise MS Office x64 12 Core Extreme 64GB These stats mean absolutely nothing because Office x64 does not even attempt to utilize the memory available. At best it works off a single processor. No, it is not an installation problem. There is only one way to install it. Normally I would not have wasted my time even responding to this thread but I thought it beneficial for others to read before they drop a lot of pennies on SQL and Office. 15 plus years since data mining has been available for MS SQL and I must say – this product is useless!

  • Anonymous
    February 10, 2014
    Ian, This link should fix your problem. There are two version of the add-ins. Use the larger in bytes download. blogs.msdn.com/.../sql-2012-data-mining-add-in-for-office-2013-prerequisites-error.aspx

  • Anonymous
    July 17, 2014
    I appreciate this help very much. I installed the data mining plug in for Excel 2013 but it does not show up on my Add-Ins under Options nor on the ribbon. Any idea what I might be doing wrong? Thanks - Neil

  • Anonymous
    July 17, 2014
    Oops. Do I need to be connected to a SQL Server Analysis Services database to use the data mining plug in?

  • Anonymous
    September 22, 2014
    Hi Neil, no the DM Add-in should show up in the ribbon when you open an Excel file. At least, that is what I saw after the Installation of the x32 version of the Add-in.

  • Anonymous
    January 04, 2015
    Is there a blog/document that explains in detail how the prediction calculator actually works and the calculations behind the various numbers? For example: Suggested Threshold to maximize profit is based on the VLOOKUP on the table. However, how are the various numbers in the table (false positive, false negatives, etc.) calculated?

  • Anonymous
    February 08, 2015
    I guess We can use the Data Mining table as  linked table to power pivot dynamically

  • Anonymous
    March 06, 2015
    only work in excel sheet,it is valuable or not

  • Anonymous
    March 06, 2015
    only the work is mining the data ,maintain in excel sheet,no queris using,it is valuable or not

  • Anonymous
    May 13, 2015
    Excel stopped working .what to do ?

  • Anonymous
    June 25, 2015
    Is this excel data mining addin works with SQL express server 2014. i downloaded both . But unable to connect excel with SQL express 2014.

  • Anonymous
    June 26, 2015
    The comment has been removed

  • Anonymous
    July 22, 2015
    Does SQL server 2012 Data mining  add-in for Excel works for SQL 2014?