Home
Videos uploaded by user “Mark Keith”
Azure ML Studio: Prediction with classification (see UPDATE in description)
 
07:03
I made this video a long time ago when I was still new to Azure ML Studio. More recently, I've put together a more in-depth playlist that covers all forms of classification models available in Azure ML Studio: https://www.youtube.com/playlist?list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 8724 Mark Keith
Azure Machine Learning Studio: Introduction and uploading data
 
08:01
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=RUhFGY7qhOU&index=2&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 6651 Mark Keith
Azure ML Studio: Introduction to prediction using regression (see UPDATE in description)
 
23:01
New video: https://www.youtube.com/playlist?list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j I made this video a long time ago when I was brand new to this stuff and there are a couple of mistakes. So I'd recommend switching to that playlist above. But if you still want to follow along with this video anyway, here's the datafile: http://www.ishelp.info/sites/yt/BikeBuyers.csv The link is already in CSV format; so you can skip the part of the video where I show how to save as CSV
Views: 22165 Mark Keith
Azure Machine Learning Studio: Tune Model Hyperparameters
 
07:59
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=3cNd_YRAsdk&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=30 Prior video: https://www.youtube.com/watch?v=XB6AKTqvTyo&index=28&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 1568 Mark Keith
Azure Machine Learning Studio: Cross Validate Model
 
09:37
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=1D2AB_kRmWU&index=29&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=ZQN6P_zcp5I&index=27&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 1439 Mark Keith
VBA basics - Hello World
 
02:34
This is one of several videos designed to reinforce the VBA content you are learning in class (IS 201)
Views: 4586 Mark Keith
Azure Machine Learning Studio: Using Azure ML prediction in Excel
 
15:34
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=B8RTiFgSux8&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=6 Prior video: https://www.youtube.com/watch?v=PAoYGEQPpG4&index=4&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 4695 Mark Keith
Azure Machine Learning Studio: Creating and using API w/Postman and C#
 
18:40
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=yHpMfpLaVvM&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=7 Prior video: https://www.youtube.com/watch?v=thyrg2AWyq0&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=5
Views: 4755 Mark Keith
Azure Machine Learning Studio: Filter Based Feature Selection
 
15:11
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=qTYA0snt-To&index=8&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=B8RTiFgSux8&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=6
Views: 2578 Mark Keith
Azure Machine Learning Studio: Permutation Feature Importance
 
10:15
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=u6A-rnsj8sg&index=9&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=yHpMfpLaVvM&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=7
Views: 1240 Mark Keith
Azure Machine Learning Studio: Summarize data, normalize data, clean missing data
 
16:46
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=NQjYfIhlPgk&index=3&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=ljHtItiZHho&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 4194 Mark Keith
Azure Machine Learning Studio: Principle Components Analysis
 
09:20
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=91BpTlADLEc&index=10&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=qTYA0snt-To&index=8&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 1324 Mark Keith
Azure Machine Learning Studio: Neural Network Regression
 
09:03
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=5eiE_X6Yr7s&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=15 Prior video: https://www.youtube.com/watch?v=Zvpn1olcHks&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=13
Views: 1028 Mark Keith
Azure Machine Learning Studio: Matchbox Recommender, Movies example
 
29:55
Data files already contained in Azure Machine Learning Studio Next video: https://www.youtube.com/watch?v=-UqCfc8nmOQ&index=31&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=1D2AB_kRmWU&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=29
Views: 2004 Mark Keith
Azure Machine Learning Studio: Introduction to prediction
 
18:21
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=PAoYGEQPpG4&index=4&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=RUhFGY7qhOU&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=2
Views: 4280 Mark Keith
Azure Machine Learning Studio: Detect Languages and Preprocess Text
 
10:09
Dataset: http://www.ishelp.info/sites/yt/twitter.csv Next video: https://www.youtube.com/watch?v=o0sF60wpks4&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=35 Prior video: https://www.youtube.com/watch?v=hl7YmvZN-lU&index=33&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 1041 Mark Keith
MS Excel Solver Examples
 
39:31
Views: 7197 Mark Keith
Azure Machine Learning Studio: One-v-all multiclass
 
08:13
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=ZQN6P_zcp5I&index=27&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=V3OLeGpmHfE&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=25
Views: 811 Mark Keith
Azure Machine Learning Studio: Publish to Gallery
 
02:26
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=thyrg2AWyq0&index=5&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=NQjYfIhlPgk&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=3
Views: 1535 Mark Keith
Azure Machine Learning Studio: Two-Class Logistic Regression
 
10:02
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=iVbBIAgTJ2M&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=18 Prior video: https://www.youtube.com/watch?v=mzcS_UT-UQ0&index=16&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 1260 Mark Keith
Azure Machine Learning Studio: Download Scored Data to CSV
 
03:08
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=fkr9RLDk9Yg&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=42 Prior video: https://www.youtube.com/watch?v=EVtCXqW6Ioc&index=40&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 524 Mark Keith
Azure Machine Learning Studio: Feature Hashing
 
09:05
Dataset: http://www.ishelp.info/sites/yt/twitter.csv Next video: https://www.youtube.com/watch?v=fSag6YJKe3w&index=37&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=o0sF60wpks4&index=35&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j
Views: 932 Mark Keith
Azure Machine Learning Studio: Principal Components with survey data
 
16:50
Data file: http://www.ishelp.info/sites/yt/SurveyDataCulturePersonality.csv Next video: https://www.youtube.com/watch?v=6EVFsEgHxU0&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=11 Prior video: https://www.youtube.com/watch?v=u6A-rnsj8sg&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=9
Views: 688 Mark Keith
Excel analytics: Correlation table
 
15:44
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.xlsx Next video: https://www.youtube.com/watch?v=DzEF5NIGlgE&list=PLe9UEU4oeAuV0qFjX9giiVwO9n_RxN54m&index=3 Prior video: https://www.youtube.com/watch?v=MNne-ebC7ow&index=13&list=PLe9UEU4oeAuV0qFjX9giiVwO9n_RxN54m&t=0s Topics: Excel, statistics, correlation, Pearson, coefficient
Views: 5278 Mark Keith
Flowcharting   decisions with more than two outcomes
 
11:34
Next video: https://www.youtube.com/watch?v=cDwZvZ365HU&index=4&list=PLe9UEU4oeAuXaCI2Dl_5WntP6mffMceBK Prior video: https://www.youtube.com/watch?v=iWUtdu4iyvo&index=2&list=PLe9UEU4oeAuXaCI2Dl_5WntP6mffMceBK
Views: 4577 Mark Keith
Learn SQL: Query 5: INNER JOIN table.primarykey = table.foriegnkey
 
06:30
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=VnvT2dvljXI&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g&index=5 Previous video: https://www.youtube.com/watch?v=3n8pTiJk_-s&index=3&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Topic: Learn Structured Query Language ( SQL ) keywords SELECT FROM WHERE ORDER BY topic Dates Inner Join
Views: 2416 Mark Keith
Flowcharts   Simple input, processing, output example
 
08:39
Next video: https://www.youtube.com/watch?v=iWUtdu4iyvo&index=2&list=PLe9UEU4oeAuXaCI2Dl_5WntP6mffMceBK Prior video: n/a Topics: basic flow chart
Views: 8502 Mark Keith
Learn SQL: Query 4: Working with DATES
 
02:01
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=adQR-EY6v2s&index=4&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Previous video: https://www.youtube.com/watch?v=Mztp1M5FUN4&index=2&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Topic: Learn Structured Query Language ( SQL ) keywords SELECT FROM WHERE topic DATES
Views: 2395 Mark Keith
Learn SQL: Query 2: WHERE
 
04:22
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=Mztp1M5FUN4&index=2&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Previous video: https://www.youtube.com/watch?v=FVuayZvPPtw&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g&index=0 Topic: Learn Structured Query Language ( SQL ) keywords SELECT FROM WHERE
Views: 2234 Mark Keith
Learn SQL: Query 3: Operators, numbers, text, ORDER BY
 
03:00
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=3n8pTiJk_-s&index=3&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Previous video: https://www.youtube.com/watch?v=NwvUotbuLLo&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g&index=1 Topic: Learn Structured Query Language ( SQL ) keywords SELECT FROM WHERE topics Operators numbers text
Views: 2726 Mark Keith
DB1: Relational Databases: Eliminating Data Redundancy
 
29:10
This video gives a novice/beginner example in Microsoft Excel about how relational databases eliminated data redundancy
Views: 4363 Mark Keith
Azure Machine Learning Studio: Ordinal Regression
 
06:39
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=ph9UDnOb-Cc&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=12 Prior video: https://www.youtube.com/watch?v=91BpTlADLEc&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=10
Views: 938 Mark Keith
Azure Machine Learning Studio: Extract N-Gram Features From Text
 
17:12
Dataset: http://www.ishelp.info/sites/yt/twitter.csv Next video: https://www.youtube.com/watch?v=bG90aIJs4DU&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=39 Prior video: https://www.youtube.com/watch?v=fSag6YJKe3w&index=37&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j This is a great technique for analyzing text. The "extract n-gram features from text" pill will automatically hash your corpus into features, analyze their effect on a dependent variable, and choose the top n features to include in a predictive model.
Views: 1434 Mark Keith
Learn SQL: Query 1: SELECT, FROM
 
06:07
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=NwvUotbuLLo&index=1&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Previous video: n/a Topic: Learn Structured Query Language ( SQL ) SELECT and FROM keywords
Views: 2801 Mark Keith
VBA basics - Storage locations (Dim and Range)
 
08:51
This video is part of a series that will introduce you to VBA basics.
Views: 4105 Mark Keith
Excel 2013 Multiple Linear Regression
 
17:33
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.xlsx
Views: 5000 Mark Keith
Tableau: cluster analysis example
 
20:07
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.xlsx Next video: n/a Prior video: https://www.youtube.com/watch?v=Duv3VhkLhlU
Views: 602 Mark Keith