Archive for April 2012

More Working with MySQL   Leave a comment

In my previous post, I talked about setting up the SQL database based on Dennis Erny’s NFL play-by-play dataset. I spent some time generating a script that did the appropriate ALTER TABLE statements to ensure that the character encodings and collations are utf-8, not latin1_swedish_ci as in the last post. I started doing it manually […]

Posted April 8, 2012 by techstep in sports

Tagged with , ,

A Toe Dipped into Sports Analytics   1 comment

One of the things I’m trying to do is to write about my experiences learning about sports analytics. I am learning more about it because it’s at the intersection of sports, data analysis, and statistical methods, three things I’m interested in. Recently, I read Scorecasting┬áby Moskowitz and Wertheim, a rather interesting book about the “conventional […]

Posted April 3, 2012 by techstep in blather, sports, statistics

Tagged with , , , , ,