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