Finding equivalent elements in SQL (regrouping)
16th January 2013
 |
Regrouping is something that I've had to do many times during my career in data analytics, unfortunately a lot of relationships aren't defined through a single unique identifier, at least not at first. This code snippet is designed to flush out the transitive relationships defined between pairs of elements and assign all elements in the graph a single unique identifier. Get ready for some SQL looping action...
Guerrilla tactics for data analytics
4th December 2012
Anybody who's had contact with software development will be familiar with at least some of the methodologies explored over the years, the spiral model, agile development, the waterfall. However useful as these are, applying their principles to Data Analytics is somewhat of a tricky endeavour.
What's your granularity?
21st October 2012
 |  |
When working with data, one thing gets me over and over again - granularity. Settling on the right level of granularity means striking a balance between detailed reporting and faster queries all while trying to maintain the elusive quality of simplicity and it's not an easy task.
Month of moustache
16th November 2011
 |  |  |
Whether you’re growing a mo’ or know a bro who’s got one on the go, you can’t escape Movember - the month of moustache. And we’re already half way through! As you might be able to tell from the pictures above I’m growing one myself this year and thus far have had curious glances, polite smiles and one “what is that on your lip! It’s even ginger!” in response.
The long commute
15th October 2011
 |  |  |
I’m writing this 30,000 feet in the air. Through the foggy porthole window I can see ships crossing the channel and sunlight reflecting red on the horizon. Shortly my flight will be descending into the London night-time and for a few minutes I will get to see London in a way that wasn’t possible over 100 years ago.
Keep track of new posts by subscribing to the latest posts RSS feed.
Blog Tags
View the whole tag cloud