Cloud and Microsoft technologies enthusiast architect in Switzerland RSS 2.0
# Tuesday, March 04, 2014


Speaker : Rafal Lukawiecki

Data mining is about exploring and finding correlations between data. It also can be used to do predictions and to find patterns. But, predictions does not mean predicting the future. Predicting the future means making strong assumptions that nothing will change around you.

Predictive analytics is understanding the customers and building effective marketing campaigns.

In order to do data mining, the data must have some structure, having attributes, flags, etc. But, you have to flatten the data or de-normalize the data structures, which means potentially a lot of data with a lot of different columns.

As an output, there are analysis, such as a risk of fraud or happiness. Another output can be just clusters or groups.

3 steps are necessary, defining the model (input and output), train the model, and validating the results that is likely the most important.

From the data, the data mining engine feeds a mining model.

On the backend, SQL Server with Analysis Services are required, starting with the version 2008. Starting 2012, SSAS comes in two flavor : multidimensional and tabular. But for data mining, no cube is needed.

On the frontend, only Excel is needed plus the free Data Mining add-Ins. The data for the Data Mining Add-Ins must reside in the Excel sheet. SQL Server Data Tool might be used to manage data mining projects. Additionally, SQL Server Management Studio may be helpful as well.

For model validation and statistics, R is the reference (, bringing additional statistics tools no available in Excel or SQL.

An excellent presentation with an excellent enthusiastic speaker !


Tuesday, March 04, 2014 8:57:17 AM (GMT Standard Time, UTC+00:00)  #    Comments [0] -
SP2013 | SPC14
All comments require the approval of the site owner before being displayed.
Please login with either your OpenID above, or your details below.
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):

Live Comment Preview
Google Cloud Platform Certified Professional Cloud Architect
Ranked #1 as
French-speaking SharePoint
Community Influencer 2013
Currently Reading :
I was there :
I was there :
I was exhibiting at :
I was there :
I was a speaker at :
I was a speaker at :
I was a speaker at
(January 2013 session):
I was a speaker at :
I was a speaker at :
United Nations (UN) SharePoint Event 2011
I was a speaker at :
I was there !
I was there !
I was there !
I was there !
<October 2021>
About the author/Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2021
Yves Peneveyre
Sign In
Total Posts: 290
This Year: 0
This Month: 0
This Week: 0
Comments: 20
Pick a theme:
All Content © 2021, Yves Peneveyre
DasBlog theme 'Business' created by Christoph De Baene (delarou)