Select Page

AgileBI Experts

We have spent the last few years perfecting how we use Agile methods to successfully deliver business intelligence projects.

Find out more about AgileBI

Agile Requirements

The BEAM* method helps close the gap between business user requirements and data warehouse design

Find out more about BEAM

We do the things

Our customers need to help them succeed

Find out more about what we do

Creating a Product Backlog

It’s that time of year again. If truth we know, it’s actually earlier than ‘that’ time of year; I’m just a little more organised this time around. Maybe a little inspired by a few Olympic displays! Spring will soon be upon us, at least if you’re in the Southern...
Read More

ODE Version 2: What’s New

Optimal Data Engine Version 2 is now available for download from GitHub! Here’s what it means for you. The biggest change with the most impact is a new flag for Data Vault retired objects. The general rule is, once something gets into the Data Vault, it never...
Read More

SQL Server Series: What are Isolation Levels?

Nic Cox used to be a Data Warehouse and ETL developer here at OptimalBI. Nic used to regularly battle it out whenever we did an exercise challenge. He has now spread his wings and is now living in London where is enjoying life on the Kiwi OE. You can read the original...
Read More

Selecting a SAS Hotfix Strategy?

In my previous post To SAS hotfix or to not SAS hotfix that is the question, I wrote about the different approaches an organisation can take when looking at creating a SAS Hotfix Strategy. In this post, I will take you through what an organisation should take into...
Read More

Lessons Learned v Agile Retrospective

We all like to learn from things that go well in our lives, and also from those that maybe don’t go as planned. Both waterfall and agile have methods to pick these up; ‘lessons learned’ and ‘review and retrospective’ respectively. But they differ significantly. For a...
Read More

Gartner Data Integration Magic Quadrant 2016 – Behind with the times

Gartner has released their Magic Quadrant (MQ) for Data Integration for 2016 and my opinion is that Gartner is behind the times and have missed the boat with this one.   A bold statement but here is why I am saying this. Have a look at the MQ: As I mentioned in my...
Read More

An Unexpected Journey

I’m from Denmark Greetings. My name is Lasse and I am 23 years old. Born and raised in Denmark where I grew up on a pig farm outside a small village called Hunderup. I lived with my parents and one of my two brothers back home on the farm my dad bought from his dad,...
Read More

Hans Hultgren’s Data Vault Course in New Zealand

This week I had an amazing opportunity to learn Data Vault modelling from the DV guru Hans Hultgren here in New Zealand, and I didn’t miss it! The Data Vault (DV) methodology is based on the idea of Data Warehouse ensemble modelling. Ensemble modelling has only three...
Read More

To SAS Hotfix or to not SAS Hotfix, that is the question.

As a SAS Administrator, I have been responsible for a number of SAS sites either for the organisation I have worked for at the time or through OptimalBI’s managed SAS Admin service. Every site required, be it a formal or informal, strategy to implement SAS Hot...
Read More

A little bit more

Since our inception in 2008 we have been blown away at how far we have come, in both the customers we work with and the things we deliver.

To say change is constant in the world of OptimalBI is an understatement.  Today we describe ourself like this.  Tomorrow?  Well that depends on what you will need us to deliver.


We teach your team to deliver like we do


We coach your team to deliver like we do


We deliver what you need

Get in touch