Expanded Library

Data Mining Algorithms in SSAS, Excel, and R

by Dejan Sarka

Don't use data mining as a black box. Get a deep understanding of how the data mining algorithms work. This knowledge is not only theoretical; it helps you developing better models in production.

What you'll learn

Data mining is gaining popularity as the most advanced data analysis technique. With modern data mining engines, products, and packages, like SQL Server Analysis Services (SSAS), Excel, and R, 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 SSAS, Excel, and R.

Table of contents

About the author

Dejan Sarka, MCT and SQL Server MVP, is an independent consultant, trainer, and developer focusing on database & business intelligence applications. His specialties are advanced topics like data modeling, data mining, and data quality. On these toughest topics, he works and researches together with SolidQ and The Data Quality Institute. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of eleven books about databases and SQL Server, wi... more

Ready to upskill? Get started