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...

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...

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...

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...

During our Data Vault journey, we found that having naming and coding standards is important when working in a team. Having a consistent environment improves collaboration. With consistent table and column names, it's easy to pick up objects to create a select...

So Dropbox got breached in 2012 and we all know about it now. Some of you may have noticed an email or some form of password reset request from dropbox to make sure that your account is secure, but this only helps if you had done the correct thing and used a different...

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...

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...

Watching #CensusFail unfold over the last couple of weeks was easily as gripping as some of the photo-finish Olympic events in Rio, August 9th arrived with great anticipation yet only a fraction of Australian's could complete their forms online on census day as...

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 goes...

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...

Welcome back to the great RESTful framework showdown! If you have not read the previous blogs they can be found here. Today we will be taking a look at the core functions we need our RESTapi to perform and how the frameworks measure up, as well as what our developers...

One of the tools I have recently started using for Data Warehousing is Attunity Replicate. I haven't dealt with data replication before as it always required some IT administration skills. Last month we had the Attunity Support Manager in New Zealand to run their...

To make the Sankey diagram I used in my Attrition in the Justice System infographic, I made use of this D3 Sankey plugin. You’ll notice if you follow the link and poke around, that the plugin is somewhat lean on the ol’ documentation. So, I resorted to googling in...

Pokemon Go has moved into its 3rd week of existence since its July 6th release and as crazes go seems to have surpassed any we have seen in recent times. The basic numbers (as I write this on the evening of July 18th) are astounding - google returns 118,000,000...

Welcome to Part 2 of the great RESTful framework showdown! You can read Part 1 here. I'm your host Tim Gray. Today our framework requirements. Then we will get to know the frameworks a little better. These frameworks run on the platforms so we'll have a look at those...

Following on from my previous post AWS TIPS AND TRICKS: Automatically create a cron job at Instance creation I mentioned I was uploading files from S3 using the AWS cli tools S3 sync command and I thought I would share how. The concept When launching an EC2 instance I...

Color awareness in UI design   Introduction Although user interfaces sometimes look simple and basic, this does not mean little thought goes into designing them. In fact, it is usually the exact opposite. It is very difficult to design something that is simple,...