Amazing uses of open data and the seven ways people try to kill them

How to export an Excel file to pipe delimited file rather than comma delimited file

Business Event Analysis and Modelling – to BEAM or not to BEAM

How to go from Java to Kotlin

How to go from Java to Kotlin

This blog follows my previous blog discussing what programming languages are suitable for writing cloud-focused code using Kotlin. We want to encourage our faithful Java developers (if we had any) to move from Java to Kotlin. So we need to show them how much of an...

GOVIS 2016 – It's all good

GOVIS 2016 – It's all good

My highlight from the GOVIS 2016 conference was the number of attendees who donated their conference bag to Wellington decile 1 and 2 schools, up until the moment a conference attendee told me that he had put a $2 coin in his conference bag before handing it over to...

The best conference stand … ever!

The best conference stand … ever!

This time last week the OptimalBI crew were down at GOVIS 2016 which had a theme of disruptive innovation. I even wrote a blog called, What's GOVIS all about?. You can read all our GOVIS blogs here. We did some good things at GOVIS. We made sure that conference bags...

Oracle Apex 5 on AWS Linux

Oracle Apex 5 on AWS Linux

It's always nice to dip your toes in the familiar with Oralce Apex 5 being out for over a year now I thought I'd validate an old blog I wrote about running Apex in the Cloud. Oracle do provide cloud options if you just want to try it out but like any tech geek I...

Ode to ODE

Ode to ODE

I started working at OptimalBI a few months ago. My area of expertise is Data Warehouse development, using Microsoft SQL Server. I was, therefore, a good candidate to test how difficult it is to start using ODE (Optimal Data Engine). ODE is an open source application...

AWS Tips and Tricks: Time Zone

AWS Tips and Tricks: Time Zone

I have mentioned in previous posts I am no way near an expert in OS’ especially Linux, although I have to use in some form or another on a regular basis. While attempting to configure one of our AWS Linux servers I needed to do a few things that I have not had to do...

Another Disaster Movie

Another Disaster Movie

OptimalBI is a diverse collection of experts in a range of Business Intelligence subjects from the esoteric through to the extremely technical. To spread some of what we know, we’ve undertaken to explain ‘a concept’ every month with each other, and now to you too. I...