Everyone needs a community of interest – even analysts, consultants, data scientists (and business owners)

A brief and biased history of humanity, science, statistics and machine learning

Using ANSI Joins in Oracle Data Integrator (ODI)

10 big takeaways from one interview with the Lawrence Corr, the BEAM Man

Loading Tables using SQL*Loader and Batch Files

Kotlin, dragging Java into the modern world

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

Oracle Data Visualisation Desktop

Oracle Data Visualisation Desktop

Oracle have been catching up in the analytics space. One of the features they had been lacking was in regards to self-service analytics. Basically, the ability for a user to mashup their own data with corporate data. I believe it's the reason why they didn't feature...

Where’s my Chair Gone?

Where’s my Chair Gone?

A few of us were having a bit of a giggle in the office about stand-ups and someone suggested that it would make a good blog; so here goes: A standup is a daily ceremony, typically at the start of the working day when the Dev-team, Scrum Master and Product Owner get...

Excel – Using Text Filters

Excel – Using Text Filters

This week I was asked an Excel question that I don't believe I had ever considered before. The scenario being: if you have a list of information held in one column of an excel spreadsheet how do you filter the contents based on the structure of the information? For...

Just Be It!

Just Be It!

We’ve been talking a lot in the office recently about ‘being agile’. As opposed to ‘doing agile’. There’s a subtle, or maybe not so subtle difference between the two and we’ve been trying to put some indicators in place so that we can tell if we’re ‘doing’ instead of...