book

Microsoft Azure Machine Learning

Name: Microsoft Azure Machine Learning
Author: Sumit Mund
ISBN: 9781784390792

by Sumit Mund

June 2015

Intermediate to advanced

212 pages

4h 25m

English

Packt Publishing

Read now

Unlock full access

Microsoft Azure Machine Learning
Table of Contents
Microsoft Azure Machine Learning
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and moreWhy subscribe?Free access for Packt account holdersInstant updates on new Packt books
Preface
What this book covers
What you need for this book

Who this book is for
Conventions
Reader feedback
Customer support
Downloading the color images of this bookErrataPiracyQuestions
1. Introduction
Introduction to predictive analyticsProblem definition and scopingData collectionData exploration and preparationModel developmentModel deployment
Machine learning
Types of machine learning problemsClassificationRegressionClusteringCommon machine learning techniques/algorithmsLinear regressionLogistic regressionDecision tree-based ensemble modelsNeural networks and deep learning
Introduction to Azure Machine Learning
ML Studio
Summary
2. ML Studio Inside Out
Introduction to ML Studio
Getting started with Microsoft Azure
Microsoft account and subscriptionCreating and managing ML workspaces
Inside ML Studio
ExperimentsCreating and editing an experimentRunning an experimentCreating and running an experiment – do it yourself
Workspace as a collaborative environment
Summary
3. Data Exploration and Visualization
The basic conceptsThe meanThe medianStandard deviation and varianceUnderstanding a histogramThe box and whiskers plotThe outliersA scatter plot
Data exploration in ML Studio
Visualizing an automobile price datasetA histogramThe box and whiskers plotComparing featuresA snapshot
Do it yourself
Summary
4. Getting Data in and out of ML Studio
Getting data in ML StudioUploading data from a PCThe Enter Data moduleThe Data Reader moduleGetting data from the WebFetching a public dataset – do it yourselfGetting data from Azure
Data format conversion
Getting data from ML Studio
Saving a dataset on a PCSaving results in ML StudioThe Writer module
Summary
5. Data Preparation
Data manipulationClean Missing DataRemoving duplicate rowsProject columnsThe Metadata Editor moduleThe Add Columns moduleThe Add Rows moduleThe Join module
Splitting data
Do it yourself
The Apply SQL Transformation module
Advanced data preprocessing
Removing outliersData normalizationThe Apply Math Operation moduleFeature selectionThe Filter Based Feature Selection moduleThe Fisher Linear Discriminant Analysis moduleData preparation beyond ready-made modules
Summary
6. Regression Models
Understanding regression algorithms
Train, score, and evaluate
The test and train datasetEvaluatingThe mean absolute errorThe root mean squared errorThe relative absolute errorThe relative squared errorThe coefficient of determination
Linear regression
Optimizing parameters for a learner – the sweep parameters module
The decision forest regression
The train neural network regression – do it yourself
Comparing models with the evaluate model
Comparing models – the neural network and boosted decision tree
Other regression algorithms
No free lunch
Summary
7. Classification Models
Understanding classificationEvaluation metricsTrue positiveFalse positiveTrue negativeFalse negativeAccuracyPrecisionRecallThe F1 scoreThresholdUnderstanding ROC and AUCMotivation for the matrix to consider
Training, scoring, and evaluating modules
Classifying diabetes or not
Two-class bayes point machineTwo-class neural network with parameter sweeping
Predicting adult income with decision-tree-based models
Do it yourself – comparing models to choose the best
Multiclass classification
Evaluation metrics – multiclass classification
Multiclass classification with the Iris dataset
Multiclass decision forestComparing models – multiclass decision forest and logistic regression
Multiclass classification with the Wine dataset
Multiclass neural network with parameter sweepDo it yourself – multiclass decision jungle
Summary
8. Clustering
Understanding the K-means clustering algorithm
Creating a K-means clustering model using ML Studio
Do it yourself
Clustering versus classification
Summary
9. A Recommender System
The Matchbox recommenderTypes of recommendationsUnderstanding the recommender modulesThe Train Matchbox recommenderThe number of traitsThe number of recommendation algorithm iterationsThe Score Matchbox recommenderThe evaluate recommender
Building a recommendation system
Summary
10. Extensibility with R and Python
Introduction to R
Introduction to Python
Why should you extend through R/Python code?
Extending experiments using the Python language
Understanding the Execute Python Script moduleCreating visualizations using PythonA simple time series analysis with the Python scriptImporting the existing Python codeDo it yourself – Python
Extending experiments using the R language
Understanding the Execute R Script moduleA simple time series analysis with the R scriptImporting an existing R codeIncluding an R packageUnderstanding the Create R Model moduleDo it yourself – R
Summary
11. Publishing a Model as a Web Service
Preparing an experiment to be publishedSaving a trained model
Creating a scoring experiment
Specifying the input and output of the web service
Publishing a model as a web service
Visually testing a web service
Consuming a published web service
Web service configuration
Updating the web service
Summary
12. Case Study Exercise I
Problem definition and scope
The dataset
Data exploration and preparation
Feature selection
Model development
Model deployment
Summary
13. Case Study Exercise II
Problem definition and scope
The dataset
Data exploration and preparation
Model development
Model deployment
Summary
Index

Content preview from Microsoft Azure Machine Learning

The Apply SQL Transformation module

The Apply SQL Transformation module lets you run a SQL query on the input dataset(s) and get the desired result. You can find it under Data Transformation | Manipulation in the module palette. The module can take one, two, or three datasets as inputs. The dataset coming from input 1 can be referenced as t1. Similarly, you can refer to datasets from input 2 and input 3 as t2 and t3, respectively. On the properties of the module, the Apply SQL Transformation module takes only a parameter as a SQL query. The syntax of the SQL it supports is based on the SQLite standard.

In the following illustration, the module takes data from two datasets, joins them, and selects fewer columns. It also generates calculated columns ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Automated Machine Learning with Microsoft Azure

Publisher Resources

ISBN: 9781784390792

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft Azure Machine Learning

by Sumit Mund

The Apply SQL Transformation module

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.