Home
Videos uploaded by user “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: 12716 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: 10874 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: 3156 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: 5964 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: 4906 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: 27002 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: 3007 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: 6401 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: 8653 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: 3925 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: 8142 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: 6669 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: 2792 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: 8126 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: 2201 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: 2678 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: 2012 Mark Keith
Learn SQL: Query 11: BETWEEN two DATES
 
02:09
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=oZ4IHX0aKok&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g&index=11 Previous video: https://www.youtube.com/watch?v=alDNlslgsjU&index=9&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Topic: Learn Structured Query Language ( SQL ) keywords BETWEEN topics selecting records that are between two dates
Views: 3300 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: 2611 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: 1601 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: 7337 Mark Keith
Excel analytics: Simple scatterplot with trendline and R squared
 
04:58
Data set: http://www.ishelp.info/sites/yt/bikebuyers.xlsx Next video: https://www.youtube.com/watch?v=0zr-Gf9a6x0&list=PLe9UEU4oeAuV0qFjX9giiVwO9n_RxN54m&index=2 Prior video: n/a Topics: excel statistics, scatter plot, statistical relationship, trendline, line of best fit, line of regression, R squared
Views: 1594 Mark Keith
MS Excel Solver Examples
 
39:31
Views: 11044 Mark Keith
Azure Machine Learning Studio: Compare Models
 
06:02
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=XB6AKTqvTyo&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=28 Prior video: https://www.youtube.com/watch?v=-Lf-zS7l8HI&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=26
Views: 957 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: 5070 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: 1124 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: 1624 Mark Keith
Excel 2013 Multiple Linear Regression
 
17:33
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.xlsx
Views: 5769 Mark Keith
Learn SQL: Query 24: Table calculations CALCULATED FIELD
 
02:29
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=KwMtqviBc7c&index=24&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Previous video: https://www.youtube.com/watch?v=Nt5u1CiDlXs&index=22&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Topic: Learn Structured Query Language ( SQL ) with calculated fields
Views: 3445 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: 1469 Mark Keith
Azure Machine Learning Studio: Matchbox Recommender Restaurant Example
 
15:37
Data files already contained in Azure Machine Learning Studio Next video: https://www.youtube.com/watch?v=6syhDFR1jhg&index=32&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=3cNd_YRAsdk&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=30
Views: 2076 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: 2822 Mark Keith
Learn SQL: Query 12: Using parentheses
 
05:34
Dataset: http://www.ishelp.info/sites/yt/gsdb.accdb Next video: https://www.youtube.com/watch?v=OqUlekEmLYE&index=12&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Previous video: https://www.youtube.com/watch?v=4D23bdXnUJ0&index=10&list=PLe9UEU4oeAuVIarKPBffh4qWv31lX391g Topic: Learn Structured Query Language ( SQL ) topics Tricky difficult parentheses with multiple joins
Views: 3460 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: 3023 Mark Keith
Azure Machine Learning Studio: Two-class Boosted Decision Tree
 
01:47
Dataset: http://www.ishelp.info/sites/yt/bikebuyers.csv Next video: https://www.youtube.com/watch?v=8i1ZqVC-SHQ&index=22&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=ErVC1Tuj4IQ&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=21
Views: 1480 Mark Keith
Azure Machine Learning Studio: Named Entity Recognition
 
10:05
Dataset: http://www.ishelp.info/sites/yt/twitter.csv Next video: https://www.youtube.com/watch?v=bufK2urtkv8&index=36&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j Prior video: https://www.youtube.com/watch?v=DbDE2P1gVbo&list=PLe9UEU4oeAuXMUWqhhJQrGVWzUWY6pS9j&index=34
Views: 2241 Mark Keith