Microsoft Machine Learning Smackdown

50 %
50 %
Information about Microsoft Machine Learning Smackdown

Published on March 13, 2014

Author: lynnlangit



comparison of Excel add-ins and other solutions for implementing data mining or machine learning solutions on the Microsoft stack - includes coverage of XLMiner, Analysis Services Data Mining and PredixionSoftware

Machine Learning Smackdown Lynn Langit May 7-9, 2014 | San Jose, CA

Agenda Goal: Survey ML tools/methods that you can actually use on the Microsoft stack • Definitions • Tools I – Understanding 3rd party Excel Machine Learning Add-ins • Tools II – Using the Microsoft SQL Server SSAS & Data Mining Add-ins • Tools III – Using Predixion Software • Recap and Call To Action 3

Terms Goal: Create common definitions of key terms • Business Analytics • Query • Aggregation • Predictive Analytics • Machine Learning • Statistics • Unsupervised Data Mining • Supervised Data Mining • Other 4

What does the market look like now? 5 Regular Analytics Unsupervised DM Supervised DM Machine Learning

CRISP DM Lifecycle applied to ML 6

Machine Learning – an Example 7

About 3rd party Excel Machine Learning Add-ins What are they? Toolbars in Excel – many different offerings • XLMiner • StatsMiner • XLStat • RExcel 8 Important: All of these tools assume expert statistical knowledge

An aside…about R Language 9

Viewing 3rd Party Add-ins XLMiner

About the Data Mining Add-ins For Excel What is it? Free add-ins which add menus to use SSAS Analysis Services Data Mining • Table Analysis Tools for Excel • Use mining models with Excel data or external data • Data Mining Client for Excel • Create/test/explore/manage Mining Models • Data Mining Templates for Visio • Render/share mining models as Visio Drawings 11 Important: Use requires connection to SQL Server 2012 SSAS

Using the Data Mining Add-ins for Excel DEMO

Checking Understanding… Data Mining Structures • Containers for cleansed source data Data Mining Models • Child containers for source data plus one mining algorithm • SSAS Algorithms - Clustering, Time Series Prediction, Market-Basket Analysis, Text Mining and Neural Networks Model Verification, Processing and Usage Tools • Model query, Model processing 13

About Predixion Software What is it? Suite of tools for predictive analytics • Insight Now • Use mining models with Excel data or external data • Insight Analytics • Create/test/explore/manage Mining Models • Insight Workbench • Prepare data for model creation • Web-based Viewers and Tools 14 Important: Runs as EITHER connected to SSAS on premise OR Connected to Predixion’s cloud-based servers

Using Predixion Software DEMO


Understanding options… 17 Add-in Server Required Complexity of install Other Cost of Add-in Cost of Solution XLMiner none easy Assumes stats expertise $$ $$ RExcel none easy Assumes R expertise $ $ Data Mining Add-ins SQL Server SSAS medium Designed for single user 0 $$$ Predixion on premise SQL Server SSAS hard Your data is stored locally 0 $$$$ Predixion cloud none easy Supports R Language 0 $$$$

18 Machine Learning Skills Data Scientist Store Clean Aggregate ML Engineers Selects Libraries Applies Algorithms Creates Solutions ML Researcher Creates Algorithms

Learning Paths – ML Developers Learn a language… DMX, PAX, R, Mahout, Julia Pick your IDE, tools… SSAS, Predixion, R-Studio, Wekka Pick a problem space… Marketing, Health, Financial Find (purchase)/gather/prepare some data… GO!  (Visualize results) 19

Call to Action – ML Decision Makers • Pick one or more solutions • Gather source data • Prepare source data • Try out some data mining algorithms Evaluate it Understand it • Understand tooling costs • Understand learning costs • Understand data gathering costs • Understand data preparation costs • Understand data cleansing costs • Understand value of results 20

JOIN US to stay ahead of the curve in the changing world of analytics with: • 70+ sessions by the world’s top BI and BA experts • 20 hours of networking opportunities with 1,000 professionals in the analytics community • Real-world insights into analytics strategies from leading companies Get $300 off using discount code: BACSV Calling All Data Professionals

Thank You SoCalDevGal on

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Microsoft Machine Learning Smackdown | lynnlangit

Videos on SQL Server 2012, AWS, Google Cloud, Hadoop, MongoDB and more data technologies
Read more

Machine Learning – Predictive Analytics | Microsoft Azure

Lernen Sie Azure Machine Learning kennen, einen leistungsfähigen cloudbasierten Dienst für Predictive Analytics in den Bereichen Big Data Mining ...
Read more

Machine Learning - Predictive analytics | Microsoft Azure

Learn about Azure Machine Learning, a powerful cloud-based predictive analytics service for big data mining, artificial intelligence, and more.
Read more

Machine Learning - Microsoft Research

The Machine Learning Group at Microsoft Research Asia is focused on research and innovation in algorithms and technologies to discover knowledge from large ...
Read more

What is machine learning? | Internet of Things

What is machine learning? Posted November 12, ... the Microsoft Azure Machine Learning team has just published a sort of “ML 101” guide.
Read more

What is Machine Learning? - Machine Learning - Site Home ...

What is Machine Learning? ML Blog Team. 1 Jul 2014 10:00 AM ... For 17 years now, I’ve been creating and using machine learning (ML) algorithms at Microsoft.
Read more

Twenty Years of Machine Learning at Microsoft - Machine ...

Twenty Years of Machine Learning at Microsoft. ... Microsoft has more than twenty years of experience in creating machine learning systems and applying ...
Read more

Machine Learning Smackdown - a session at Øredev 2014

In head-to-head comparisons, see various machine learning tools and products that best integrate with the Microsoft Business Intelligence and Analytics stack.
Read more