> > SQDM

Data Mining Algorithms in SSAS, Excel, R, and Azure ML (SQDM)

Kursbeschreibung Kurstermine


Don't just use data mining and machine learning without understanding how it works. Get the insights in the most popular algorithms.


Data mining as the most advanced data analysis technique is gaining popularity. With modern data mining engines, products and packages, like SQL Server Analysis Services (SSAS), Excel, R, and Azure ML, data mining has become a black box. It is possible to use data mining without knowing how it works. However, not knowing how the algorithms work might lead to many problems, including using the wrong algorithm for a task, misinterpretation of the results, and more. This course explains how the most popular data mining algorithms work, when to use which algorithm, and advantages and drawbacks of each algorithm as well. Demonstrations show the algorithms usage in SQL Server Analysis Services, Excel 2013 using the SQL Server algorithms, R, Azure ML native algorithms, and using the R algorithms in Azure ML. You will also learn how to evaluate different predictive models.

Algorithms explained include Naïve Bayes, Decision Trees, Neural Networks, Logistic Regression, Perceptron Model, Linear Regression, Regression Trees, Ordinal Regression, Poisson Regression, Principal Component Analysis, Support Vector Machines, Hierarchical Clustering, K-Means Clustering, Expectation-Maximization Clustering, Association Rules, Sequence Clustering, Auto-Regressive Trees with Cross-Prediction (ARTXP), Auto-Regressive Integrated Moving Average (ARIMA), and Time Series. Algorithms usage is explained through real life use case as well, on a fraud detection example.


  1. Introduction to data mining and / or machine learning
  2. Classification, prediction and estimation algorithms
  3. Forecasting and unsupervised algorithms
  4. Data mining project: fraud detection

Classroom Training
Modality: C

Dauer 1 Tag

Preis (exkl. MwSt.)
  • Österreich: 650,- €
inkl. Verpflegung
Verpflegung umfasst:

  • Nespresso Kaffee, Tee, Säfte und Mineral
  • Kuchen, frisches Obst und Snacks
  • Mittagessen in einem der direkt erreichbaren Partnerrestaurants

Gilt nur bei Durchführung durch iTLS. Termine, die von unseren Partnern durchgeführt werden, beinhalten ggf. ein abweichendes Verpflegungsangebot.

Digitale Kursunterlagen Termine und Buchen

Derzeit gibt es keine Trainingstermine für diesen Kurs.  Termin anfragen