Analysis Services Multidimensional Mode has an application for data mining with many algorithms. These include decision trees, clustering, neural networks and more. The predictive modeling functionality will be demonstrated through out the session. We will start by creating a project and a data source. Explanations of the best data structures will be shown, The source will be examined and explained.

Then the real fun starts. A decision tree will be built with a wizard. Then, additional models - Clustering and Naive Bayes - will be added for comparisons and finding the best model.
Once the best model is selected, the training data will be replaced with predicting data and results will be shown in SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS). Because we can use SSMS, end users do not need SSDT to see the results.