Where's your data from?

25th November 2014

Database surrounded by travel stickers for London, Paris, New York
Provenance is an increasingly popular topic in the food industry as quality scandals and ethical sourcing of produce push their way to their way to the front pages of the press but have you considered how tracking the provenance of your data can add value to your data analytics?

Finding equivalent elements in SQL (regrouping)

16th January 2013

Graph of equivalent elements

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

Jeans image by Muffet on FlickrJean fibre image by Aeyoun on Flickr

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

Day 2Day 8Day 16

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.

Make a donation to the Movember fund

About Me

I’m Niall Napier. I’ve worked in the field of Financial Services Data Analytics since I graduated and so this website plays host to both personal and data/programming related topics as and when I find the time to write. More.

Keep track of new posts by subscribing to the latest posts RSS feed.