Walk-through Steps: I’m New to BI, Where to Start? – Part 6: Data Mining

Posted by on Apr 29, 2015 in Business Intelligence, Data Mining | One Comment


Data Scientist is a hot job nowadays in the market and there are lots of demand for it. Data Science origins from the BI field and sits under umbrella of Business Intelligence, because the data science and data mining helps decision makers in their decision making process. To have an idea about how data mining can solve real world issues, think about loyalty program of the super market that you usually use close to  your home. Loyalty program simply analyze your purchase history and based on that it comes up with some suggestion and prediction about your next purchases and will promote that through your cell phone text messages or email or even flyers directly addressed to your home address.

Fortunately technology has been quite powerful at this stage and there are number of tools that you can use for data mining. Data Mining consists of two types of analysis: Descriptive Analysis and Predictive Analysis. Descriptive Analysis is about analyzing data from the past, and Predictive analysis is predicting the future based on existing data and the model found in the data. Data Mining contains sophisticated mathematics algorithms that can understand the patterns in the data and analyze it. However don’t worry if you are not a mathematician, there are some good Data Mining tools in the market that do the hard job for you.

Book: Data Science for Business: What You Need to Know About Data Mining and Data-Analytic Thinking


9-1- SQL Server Analysis Services Data Mining

Microsoft offered two tools for Data Mining so far. The first and older tool is SQL Server Analysis Services which enables you to create mining models and structures in Business Intelligence Development Studio or SQL Server Data Tools, and then publish it on the server, so the model can be used for analysis. This technology has been released in 2000 with SQL Server product, but it has been improved significantly in 2005 version of this product. Data Mining still is part of SSAS and SQL Server product nowadays. There are heaps of blog posts and videos about SSAS data Mining. However there are not that much books that deeply discuss features of this service. The book that I suggest here might be old, but the technology of SSAS data mining didn’t changed a lot after that time, and still this counts as one of the best books in this field.

Video: Session Recording of SQL PASS Rally 2015 Nordic: Show Me Potential Customers; Data Mining Approach


This video gives you a brief understanding of data mining with SSAS. you will see practical examples of it through the video.

Book: Data Mining with Microsoft SQL Server 2008


This is one of the best books for SSAS Data mining, it has many examples with deep technical chapters. there is even a chapter for extending SSAS Data Mining if you want!


9-2- Azure Machine Learning

Microsoft recently released a new service as part of Microsoft Azure services named Azure Machine Learning or Azure ML. This is Microsoft new data mining technology which works cloud based, with great collaboration with data mining powerful engine of R, and is highly extensible. This technology is new, but there is a very good documentation on Azure website for that with bunch of tutorial videos, there also couple of books that I would like to mention below.

Azure website Videos:



Azure ML Documentation


Book: Predictive Analytics with Microsoft Azure Machine Learning


Book: Azure Machine Learning Essentials: Free eBook

This one is great free eBook that published recently.


Related Posts:

Walk-through Steps: I’m New to BI, Where to Start? – Part 0: Prerequisites

Walk-through Steps: I’m New to BI, Where to Start? – Part 1: Fundamentals, Data Warehouse and ETL

Walk-through Steps: I’m New to BI, Where to Start? – Part 2: Modelling with BISM

Walk-through Steps: I’m New to BI, Where to Start? – Part 3: Data Governance

Walk-through Steps: I’m New to BI, Where to Start? – Part 4: Data Visualization

Walk-through Steps: I’m New to BI, Where to Start? – Part 5: Power BI

Walk-through Steps: I’m New to BI, Where to Start? – Part 6: Data Mining

Walk-through Steps: I’m New to BI, Where to Start? – Part 7: Azure


Reza Rad
Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in Data Platform for seven continues years (from 2011 till now) for his dedication in Microsoft BI. He is author of some SQL Server and BI books, and also Power BI online book; from Rookie to Rock Star.

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">