Mark Keith

Entity-Relationship Diagrams: Simple student registration system example

How to place a live Tableau dashboard on a web page

Python: univariate statistics

MS Excel Solver Examples

Entity-Relationship Diagrams: Simple Order Processing Example

Convert ERD to MS Access: Student Registration Example

Azure ML Studio: Introduction to prediction using regression (see UPDATE in description)

Azure Machine Learning Studio: Introduction and uploading data

Tableau JavaScript API: Getting Started

Learn SQL: Query 11: BETWEEN two DATES

VBA loops, nested loops basic

Python: Correlation and P-value in Numpy, Pandas, and Scipy

CSS: Style states onhover and visited

Python: Intro to MLR / OLS in statmodels.api

Excel 2016 box and whisker plot

SQL 15: Calculated fields

Tableau: Geography map

HTML: a, anchor, link, href, title

Tableau: Forecasting

How to setup your Azure for Students Account

Azure Machine Learning: Sign up for Azure Student Starter Account

New Azure ML Studio: Upload and summarize data

Python: Functions without parameters

Azure ML Studio: Recommender Example: User-Item-Rating Triple

Flowcharting loops, loop counters, kill switches (updated)

SQL 10: SUM()

New Azure ML Sudio: Math Operation After Modeling

SQL 6: LIKE, wildcard character %

Tableau: Line and Area Charts (data over time)

Python: Break, Continue, Else (in loops)

Twitter Intro: Introduction to the Twitter dataset

Azure ML Studio: Feature Engineering

Python: Declaring and calling functions

Python: Scatterplots, Linear Regression, Heteroscedasticity

Azure Machine Learning Studio: Feature Hashing

New Azure ML Studio: Tune Model Hyperparameters

Python Data Science: Automating EDA: Bivariate Relationships: Part 4: Including group comparisons

Excel: Multiple Linear Regression Example

Azure Machine Learning Studio: Neural Network Regression

Python: write to sqlite database from pandas dataframe

Python: Installing and importing packages

CSS: Positioning with z-index and float

Python: Collections: Lists

Python: Read CSV from mounted Google Drive

Tableau: Connecting to Excel Data

HTML: html, head, body, title, h1

Azure ML Studio: Integrate Data

Excel Correlation Tables

Learn SQL: Query 5: INNER JOIN table.primarykey = table.foriegnkey

Connect to Azure SQL Server DB in Tableau: Checkpoint Instructions

Learn SQL: Query 9: Functions COUNT() GROUP BY

Learn SQL: Query 28: Select DISTINCT() values

Python: f-strings, string format mini language, number forma

Excel analytics: Correlation table

Excel stats: categorical variables in regression calculator

API with headers in Python: Polygon.io stock market data

How to set up the AdventureWorks DB in SQL Server Azure

Python: Errors: Syntax and Runtime Examples