SAS Admin The Basics – Part 1

Hi, all you new and budding SAS administrators. I thought I would share a few things I have picked up over the years that you may what to add to your tool bag. Firstly, make yourself a daily checklist.  This will vary depending on your site but here are some basic...

Gathering data requirements, easy, right? Part 2

Last time I wrote a short blog on the type of person who should be at the forefront of gathering data requirements and intimated that there is a particular technique that should be used. I should say from the outset that for a large chunk of my career I gathered...

Gathering data requirements, easy, right?

Gathering data requirements, easy, right?

Gathering any form of requirements is hard work. I know, I’ve been there. But gathering data requirements takes a special person and, as I’ve learnt, a particular technique. Mostly this job gets foisted onto a Business Analyst, but maybe you’re a Developer, Data...

Data Replication: SSIS or Attunity?

I was working with MS SSIS for almost four years before I bumped into Attunity Replicate. At first glance it looks like the two products can do the same job, they both are able to copy the data across different environments. Let's have a closer look. Attunity...

What’s The Best Restful Web API Framework? – Part 4

What’s The Best Restful Web API Framework? – Part 4

Welcome back to Part 4 of the great RESTful framework showdown! If you have not read the previous blogs they can be found here. Today we will be addressing the all-important issue of securing our RESTapi and how the frameworks interact with our current security...

What is Agile BI and Data Warehousing? It's what I do.

What is Agile BI and Data Warehousing? It's what I do.

When the question gets posed I often shift uneasily, or umm and err a little, or possibly just make something up…a while back I was often introduced as an airline pilot because my ‘real’ job was so incomprehensible. The answer I hate is someone’s job title. It might...

Your Agile data warehouse starts with: Who does what?

Your Agile data warehouse starts with: Who does what?

Where do you start a data project? Often we want to 'get into the data'. After all, we are data people; we got into this space because we like data.  That isn't what Shaun did while working for a customer last year on a project that needed him to make sense of 13...