How far away from here is the most distant bit of the UK?

I like visualisations, particularly map-based ones.  Done well, it’s as if they give you superpowers or a microscope or telescope – you can see something that normally is hidden from you.  They help you to understand something, and in business that often means they help you to make a decision.  Below is a visualisation that … Continue reading How far away from here is the most distant bit of the UK?

From Excel to SSIS, Part 4: Grouping and calculating

This article is part of a series: From Excel to SSIS Getting started File Save As (a kind of Hello, World! program for SSIS) Filtering rows Grouping and calculating Joining streams of data 0. Introduction Over the articles in the series, we have been gradually working our way towards useful and interesting SSIS code.  So far we … Continue reading From Excel to SSIS, Part 4: Grouping and calculating

An introduction to integers and floating point numbers

Integers on a computer are simple and behave in predictable ways.  Floating point numbers are not and don’t always respectively –  I’ll explain what they are and why below.  Working with floating point numbers is also slightly like cleaning up after my dogs, which I will also explain below. Integers Integers are a bit like … Continue reading An introduction to integers and floating point numbers