Our Blogs


So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.

Graduating from a World of Orange

In my very first blog for OptimalBI I said that breaking from my comfort zone was something I would always strive to do. That blog was about me joining OptimalBI and the excitement that lay ahead. Now, one year and eight months down the track it is time for me to...

ODE – Migrating Configuration Data

ODE – Migrating Configuration Data

We have recently been discussing various ways we can promote our configuration data for Optimal Data Engine (ODE) from one environment to the next. Our config data is the heart and soul of ODE, it is the foundation for the entire engine.
The config in ODE is the relational data model we have built that holds all of the configuration required to make ODE run. It includes definitions for all source and targets, as well as any mappings.

Data Vault Certification: Day 2 and 3

Day 2 of the Data Vault Modeling certification course started at a far more reasonable hour compared to yesterdays red eye flight into Sydney, which you can read about here.  It gave me time to go for a quick run around the Opera House, under the Harbour Bridge and...

Data Vault Certification: Day 1

I woke up to the dreaded 4am alarm clock.  It was always going to be a long day.  Jonathan Sellar and I arrived at Wellington Airport at ridiculously early o’clock to catch the red-eye flight to Sydney.  We were on our way to Hans Hultgren’s 3 day certification course...

Data Vault Design: Hub Tables

When designing your Data Vault, you first start with defining the Hub tables.  The Data Vault is made up of many subject areas, and each Hub is the central piece to each core subject.  If you’re confused already, I recommend you have a read of my introductory Data...

Data Vault: Agile Data Warehousing for the Future

What happens when you take the best of 3rd Normal Form and the best of the Dimensional Star Schema, and mix them together?  You get Data Vault. Data Vault is a data warehousing modelling technique that makes designing a robust, agile, historical and future-proof data...