Relative Year SQL

I wrote this SQL code recently and wanted to share it here (in a modified form to simplify). This isn’t a “typical” SQL SELECT statement, because of how each row is checking the rest of the table relative to its own fiscal year value.

Data Visualization Project

You may have seen me tweeting about some research I did on “Data Visualization for Exploratory Data Analysis” for my Cognitive Systems Engineering course. My presentation went really well! I’m less satisfied with the paper since it was done in a hurry to complete the project deliverables, but i’m including it because it explains some… Continue reading Data Visualization Project

Data Science Practice – Classifying Heart Disease

This post details a casual exploratory project I did over a few days to teach myself more about classifiers. I downloaded the Heart Disease dataset from the UCI Machine Learning respository and thought of a few different ways to approach classifying the provided data. ——————————————- “MANUAL” APPROACH USING EXCEL So first I started out by… Continue reading Data Science Practice – Classifying Heart Disease

Doing Data Science (Review)

I just finished reading Doing Data Science: Straight Talk from the Frontline, an O’Reilly book by Cathy O’Neil (@mathbabedotorg) and Rachel Schutt (Columbia Data Science blog). First let me say, I really enjoyed this book! I thought it gave a great overview of Data Science, which is very valuable at this early stage in my… Continue reading Doing Data Science (Review)

Machine Learning Project 4

So immediately after I turned in project 3, I started on Project 4, our final project in Machine Learning grad class. We had a few options that the professor gave us, but could also propose our own. One of the options was learning how to implement Random Forest (an ensemble learning method using many decision trees) and analyzing a given data set, so I proposed using Random Forest on University Advancement (Development/Fundraising) data I got from my “day job”. The professor approved it, so I started learning about Random Forest Classification.

Wolfram Language

Stephen Wolfram recently announced that he is releasing a programming language that appears to include a quick development approach for mathematical and data science projects (and more), utilizing everything that Wolfram Alpha and Mathematica are capable of, and taking them to another level completely. The demonstration in the video is very impressive, and I’m excited to try this out!