Select Page

Hands-On Sessions

Experience the power of Qlik Sense with a free two-hour hands-on experience

Qlik for more ....

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

Please, Talk to Me

Living in New Zealand and following Formula 1 is hard work. For a start, I watch all the races live; generally, on a Sunday at midnight. This prevents me from hearing the result on the radio, which in a nation where no one else seems to care, it seems odd that it...
Read More

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

Using Stats NZ Maps in Qlik

As I mentioned in my last post we have loaded the KML into Qlik Sense but it’s not that useful as the Name field is missing and being populated with an automatically generated value p<rownumber>. If you open the KML file in a text editor you will see that...
Read More

Loading Stats NZ Maps into Qlik

One of the features of Qlik Sense is the ability to load your own mapping layers into the tool. This allows you to navigate your data spatially and provides another visualisation to display represented data that might have a geographic aspect. All Qlik needs is a...
Read More

All About Hans Hultgren and Data Vault

You might know Hans Hultgren is coming back to New Zealand because you read Shane Gibson’s blog or somebody told you about it. You can sign-up for Hans Hultgren’s three-day Data Vault Modeling and Certification starting on the 1st of August in Auckland...
Read More

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

Qlik Sense Desktop – Loading QVD

When using the Qlik Sense Desktop you can easily add Excel or CSV files to your new application by selecting them in the add data window. What I missed was the fact that this option also allows you to add a QVD easily as the source file.  Just select “All...
Read More

TEC: Flying the plane past our Meetup, as it’s still being built

Back in February, I headed along to SUNZ 2016 one of the best presentations was by Jan Sheppard, Manager of Business Information Services, TEC. Jan talked about ‘Building the plane in the air’, how she had transformed her team into an Agile unit mostly by...
Read More

Kotlin, dragging Java into the modern world

Even though we love our coffee here at OptimalBI, we have never had a place in our hearts for Java. Even so Java has a lot to offer for the modern cloud-driven world, but writing good, maintainable and human readable code has never been part of a Java developers life....
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