Advanced Analytics with Azure Machine Learning, SQL Data Mining, and R

Actions Panel

Advanced Analytics with Azure Machine Learning, SQL Data Mining, and R

By SQL Server Ireland User Group

Date and time

Mon, 27 Apr 2015 09:00 - 17:30 GMT+1

Location

Citywest Hotel, Conference & Event Centre

Saggart Ireland

Refund Policy

Contact the organiser to request a refund.

Description

Data mining and machine learning are having their renaissance: after more than 40 years of academic research those powerful, algorithmic techniques are finally within the reach of anyone who can understand data. They are fast, inexpensive and, best of all, they find patterns and they can generate insight that business people are asking for!

Rafal Lukawiecki Rafal Lukawiecki (https://projectbotticelli.com) will share his decade of hands-on data mining experience during this intensive, full-day seminar as he teaches you about the newest, cloud-based Microsoft analytical toolkit: Azure Machine Learning (Azure ML) and its very useful on-prem companion, the SQL Server Data Mining engine contained in SSAS, supplemented with gentle "I am really not a statistician" use of the open source R software.

He also tweets at https://twitter.com/rafaldotnet

While you might catch a glimpse of Excel this day will not focus on it, as we will spend 90% of our time in SSDT, SSMS, R, and, of course, in ML Studio. However, before we can have fun exploring patterns and making predictions, you must understand how a somewhat unusual (for a relational guy or a girl) form of data preparation leads to finding interesting, potentially great predictive results.

We will cover:

  • Introduction to predictive analytics, data mining, machine learning, and rudimentary descriptive statistics, as well as data and content types used in the process (this will be at level 200)
  • Data preparation, model building, and it’s very important validation, on-premise, using SQL Server Data Mining (level 300)
  • Model building and testing in the cloud, using Azure ML (level 250)
  • Use and deployment of both on-premise models (using T-SQL and DMX) and cloud-based models (using REST web services API) at level 300
  • A level 300-400+ look into the specifics of a few interesting and useful algorithms, including Regression and Classification Decision Trees, Random Forests and Jungles, Association Rules, Neural Networks and Logistic Regression, and a brief, level 400+ look at balancing model performance to user requirements by selecting the correct sensitivity vs specificity thresholds

At the end of the day you will have learned the entire process of machine learning and data mining, focusing on the often missed out part of correct data preparation, which should enable you to start experimenting with your own data straight away. Although we cannot promise that, we will also do our best to make sure you are tired, as this will be a very intensive day, so please sign up if you like the idea of learning lots in a short span of time.

Organised by

The SQL Server Ireland User Group was founded in 2006 to foster & grow the Irish SQL Server community while providing networking opportunities & sharing experiences using SQL Server.

This group is a local chapter of PASS - The Professional Assosciation for SQL Server (www.sqlpass.org)

Meetings are held most months, usually in the evening of the first Tuesday of the month. We do collaborate with others to support larger conference events from time to time; including the highly successful SQL Saturdays.

Sales Ended