Tools and Techniques
If you're new to machine learning, definitely check out this slide deck by Jason Mayes at Google. It's a fun and well-organized approach to learning and you decide how deep to go. Do you want the green pill or the blue pill..?
SQL Window Functions offer a lot of flexibility in cases where you might otherwise be tempted to write hack-ish workarounds. Window functions are readable, performant, and are easy to debug. This tutorial describes what they are and shows how to use them.
The typical analytics stack is moving away from monolithic solutions that try to do everything. This post on Mode's blog explores a better approach.
Even if you don't work with it everyday, Excel is a widely used data tool that's worth being familiar with. This tutorial shows how to extract the data from Excel files into pandas so you can work with it; and how to write data back to Excel files so your boss can understand it. Covers a variety of Excel topics like multiple sheets, headers, how to skip records, how to read a subset of columns, pivot tables, etc.