Kia ora koutou and welcome to the last OptimalBI newsletter of 2019 - hasn't this year flown by! We have enjoyed supporting our customers to create amazing outcomes for their organisations this year with a range of really interesting projects - payment integration,...
Working in the Business Intelligence and Data Warehousing space I'm constantly keeping abreast of what's hot and what's not. Obviously Data Science, Machine Learning and Artificial Intelligence fall under the BI/DW banner, somewhere. So today I want to share Kaggle!...
I’m sure most people have used or at least heard about the Adobe product Photoshop. In this blog I’m going to be looking at some of the programs that are offered by Adobe (the makers of Photoshop) and find free software that will fill the same purpose. To get...
It seems to me that a lot of people dislike Vi. I thought a short blog on the essential commands might be helpful. If you just want to know how to either “save your changes and exit” or “exit and abandon your changes” just jump to here.I’ve collated a list of what I...
When is paranoia a good thing?When it comes to downloading files for sure. Using a cryptographic hash function to test the authenticity of a file is a good practice. Such a good practice, that I wanted to make it as easy as possible to perform.I've written two scripts...
Back in 2016 Victoria wrote a blog on open source or free to try data mining and analytics tools, and recently we received an email from the team over at Canva about including their ecomap tool in our list. The email got us thinking it was a good time to have a new...
We live in the age of big data, we produce and collect more data then ever. Surely, just hoarding it doesn't make much sense, but a lot of valuable information could be extracted from it and used, for example, in the decision making process. Every organisation I...
I had the privilege to listen to the Assistant Commissioner of Privacy, Jon Duffy during National Privacy Week. Jon started at the beginning by exploring what defines privacy simply put as, something that identifies a person. He then took us through a highlights real...
Kia ora koutou, This month we have a spotlight on Open Source, our team are passionate about open - Open Data, Open Standards and Open Source. I first worked on an Open Source Linux kernel back in 1989 (showing my age) so have enjoyed watching this space mature and...
Another one of the open source projects I readily follow is Apache Superset. Superset is part of innovative ecosystem surrounding PrestoDB. So to start with, let's cover off what Superset is and why it's so darn awesome... Superset (previously known as Panoramix and...