October 2016 – Mathew Analytics

Statistical Reading Rainbow

October 17, 2016January 15, 2017No Comments

For those of us who received statistical training outside of statistics departments, it often emphasized procedures over principles. This entailed that we learned about various statistical techniques and how to perform analysis in a particular statistical software, but glossed over the mechanisms and mathematical statistics underlying these practices. While that training methodology (hereby referred to … Continue reading Statistical Reading Rainbow

SQL Cheat Sheet

October 11, 2016March 11, 2017No Comments

I’ve been putting together a basic SQL cheat sheet that could be used as a reference guide. Here are a series of common procedures that should be of use for anyone who uses SQL to extract data. No explanations are provided as they should largely be known to the end user.