Published on March 13, 2014
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
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...
Videos on SQL Server 2012, AWS, Google Cloud, Hadoop, MongoDB and more data technologies
Lernen Sie Azure Machine Learning kennen, einen leistungsfähigen cloudbasierten Dienst für Predictive Analytics in den Bereichen Big Data Mining ...
Learn about Azure Machine Learning, a powerful cloud-based predictive analytics service for big data mining, artificial intelligence, and more.
The Machine Learning Group at Microsoft Research Asia is focused on research and innovation in algorithms and technologies to discover knowledge from large ...
What is machine learning? Posted November 12, ... the Microsoft Azure Machine Learning team has just published a sort of “ML 101” guide.
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.
Twenty Years of Machine Learning at Microsoft. ... Microsoft has more than twenty years of experience in creating machine learning systems and applying ...
In head-to-head comparisons, see various machine learning tools and products that best integrate with the Microsoft Business Intelligence and Analytics stack.