In this section, we will talk about the most attractive part of data mining, prediction. Microsoft provided a language to query and work with data mining algorithms and perform predictions: DMX. DMX is very similar to T-SQL in terms of the SELECT, FROM, and WHERE clauses. The process of prediction with mining algorithms is that the pattern fetched out of the training from a mining model will be joined to a case table. In other words, prediction is a result of applying this pattern with some DMX functions such as PredictProbability.

In this section, you will learn about the DMX language and how to use the Mining Model Prediction options to generate a prediction result set out of the mining model and case table.