Intermediate into Machine Learning in R, SQL Server 2017 and Microsoft ML Server
He has been a popular speaker at major IT conferences since 1998, and he had the honor of sharing keynote platforms with Bill Gates and Neil Armstrong. A natural educator, he explains complex concepts in simple terms in his enjoyably energetic style
Trainer Rafal Lukawiecki
Course focuses on the newest technologies of Microsoft Machine Learning Server and SQL Server 2017. By popular demand, second part (3 days) of this course teaches programming in R, however most of the course is also applicable to Python programmers, as the key libraries are the same.
This course has two parts: 2-day part A: Fundamentals of Machine Learning followed by 3-day Part B: Immersion into Machine Learning in R, SQL Server 2017, and Microsoft ML Server. The first part introduces the most important concepts and tools, while the second part teaches you R and how to use it for machine learning on the Microsoft platform.
Because of Rafal's 10+ years of real-world machine learning experience.
You will not only learn all the concepts and tools that you need to know from a great teacher who has trained almost 500 data scientists world-wide, a highly-respected presenter, capable of holding your attention, but, above all, from a practitioner of machine learning. Rafal Lukawiecki has been delivering ML, data mining, and data science projects for customers in retail, banking, entertainment, healthcare, manufacturing, education, and government sectors for over ten years. Because of that, you will learn:
• how to avoid common pitfalls,
• how to get ahead of your competition by working faster,
• what is really useful and practical,
• what is more theoretical but still important,
• what hype you should be wary of.
You will be able to ask any questions related to your industry and you will get relevant, pragmatic, no-nonsense answers, helping you get ahead with your own projects.
Learn from Rafal who has done it all, not from those who just teach it—this is why it is called Practical Machine Learning.
There is a large number of tools that you can use with R, and we begin the day focusing on the essential ones. You will also learn how to organise your workflow. Topics include:
• RStudio vs. R Tools for Visual Studio
• Microsoft Machine Learning Server vs SQL Server Machine Learning Services
• Projects, files, scripts, history, version control
Notebooks and RMarkdown
R uses data frames, data tables, and tibbles, amongst others, while ML Server adds XDFs and the ability to work with data stored natively in Hadoop, Spark, and SQL Server. While most data preparation should be done as close to source, preferably using SQL, you will need to learn how to perform some transformations in R. Topics include:
• Data frames, tables, tibbles
• Reading files and ODBC data
• XDFs and connecting to data in ML Server
One of the strengths of R is the ease of creating accurate (and good looking!) plots. As a bare minimum you need to understand how to use the most popular visualisation package, ggplot2, and some of the built-in base functions. Topics include:
• Summarising data
• Base boxplots, histograms, scatter plots
• ggplot2: grammar of graphics
• Combining visualisations into layers
• Density plots
• Surfacing R graphics in Power BI and SQL Server
Clustering, Segmentation, Anomaly Detection
Segmentation is the main application of unsupervised learning using clustering algorithms. You will also learn how to apply this technique for anomaly (outlier) detection and data preprocessing. Topics include:
• Introduction to segmentation
• Clustering algorithms (k-means, EM, hierarchical, and others)
• Interpreting clusters
• Anomaly detection with clustering, PCA and SVMs
Without doubt, classifiers are the most important, and the most often used category of machine learning algorithms, and the foundation of algorithmic data science, and of most of today's Artificial Intelligence. We will focus on several variants of the most important classification algorithm—decision tree—while progressively interpreting the results, and improving its performance. After introducing neural networks and logistic regression we will also compare the performance of all of these classifiers on our test dataset. Topics include:
• Introduction to classifiers
• Two-class (binary) vs multi-class
• Decision trees, forests, and boosting
• Neural networks and logistic regression
• Overfitting (overtraining) concerns
Validation of classifiers will be your key concern, because classifiers are used so often, and because their accuracy is not easy to balance with business requirements, such as restricted resources, or a required level of business performance. Building on your understanding of model validity (introduced in Part A of this course), you will learn how to balance an acceptable number of false positives with false negatives by using classification (confusion) matrices, metrics of precision and recall, by plotting ROC (Receiver Operating Characteristic) curves, and by measuring their business impact using profit and cost charts. Attendees have commented in the past that this is the most important module of the entire course. Topics include:
• Testing classifiers
• Charting precision-recall and sensitivity-specificity
• ROC curves and lift charts in detail
• Other measures of accuracy, including AUC, and F1 scores
• What exactly does cross-validation tell us?
• Measuring quality of cross-validation
• Optimising binary classifier prediction probability thresholds for a given business target
• Refining models to improve accuracy and reliability
• Hyperparameter tuning
• Class imbalance problem (fraud analytics and rare event prediction)
Considered by some as the numerical equivalent of classifiers, regression is a large subject of its own. We will introduce its simple but a very popular form, linear regression, and the more precise, but also prone-to-overfitting, decision tree variants. Topics include:
• Introduction to simple regressions in R
• Linear regression (classic)
• Regression decision trees and other ensemble regression algorithms
• Regression as a building block of other algorithms
Unlike classifiers, regressions are easier to asses. You will learn about basic tests of classical linear regressions that are easy to perform in R, and about measuring quality of machine learning, non-linear regressions. Topics include:
• Measuring linear regression quality
• Homoscedasticity, multicollinearity and other concerns
• Measuring machine learning regression quality
• R-squared (Coefficient of Determination), RMSE, MAE, RAE, RSE
If you plan on using your models for prediction, rather than just for the exploration of data, or if you want to embed them as Artificial Intelligence in your applications, you need to deploy your models to production and maintain them on an on-going basis. Since we focus on the Microsoft ML Server and SQL Server ML Services, you will learn about the PREDICT T-SQL statement, and other supported mechanisms for deploying your models. We will also discuss how to deploy models as a web service, using these, and other Microsoft and non-Microsoft techniques. Topics include:
• What needs to be deployed, and when?
• PREDICT T-SQL statement
• Using sp_execute_external_script
• Web service deployment with and without Azure ML
• On-going maintenance and model updates
Please note: we reserve the right to amend the order of the modules to best suit the dynamic character of the class and to answer questions as they arise. Some subjects will only be covered if time allows, but your satisfaction is guaranteed.
Analysts, budding data scientists, database and BI developers, programmers, power users, DBAs, predictive modellers, forecasters, consultants.
If you have attended a prior course on Machine Learning, like Rafal's week-long class Practical Data Science that was offered in 2015–2017, and if you are versed in model validity, accuracy, and reliability, consider attending 3-day course only. Ask yourself these questions: can I explain the difference between cross-validation and hold-out testing, do I know which business metrics correspond to precision and which to recall, is model accuracy more important than reliability, and how does a boosted decision tree work. If in doubt, please attend both 2-day and 3-day course.
As Data Scientist at Project Botticelli Ltd, Rafal focuses on making advanced analytics and artiﬁcial intelligence easy and useful for his clients.
He can help you ﬁnd valuable, meaningful patterns and statistically valid correlations using data mining and machine learning in data sets both big and small. Rafal is also known for his work in business intelligence, data protection, enterprise architecture, and solution delivery. While majority of his clients come from consumer and corporate ﬁnance, entertainment, healthcare, IT, retail, and the public sectors, Rafal has worked in almost all industries.
He has been a popular speaker at major IT conferences since 1998, and he had the honour of sharing keynote platforms with Bill Gates and Neil Armstrong. A natural educator, he explains complex concepts in simple terms in his enjoyably energetic style.
Rafal was born in Poland. He left it in 1990 to study computing in United Kingdom, where he earned BEng in Computing Science, followed by MSc in Foundations of Advanced Information Technology, at Imperial College, University of London. His studies were sponsored by Oxford Computer Group Ltd, where he later worked as a developer, trainer, and a consultant. Since 2000 he has worked for Project Botticelli Ltd.
Outside of IT, Rafal spends a quarter of every year ﬁnding abstractions in natural landscapes, expressing them through traditional, black-and-white, large-format ﬁlm photography, making silver-gelatin prints by hand—see rafal.net. You can also follow Rafal on TwitterTwitter,, or connect with him on LinkedIn.