3 reasons why I enjoy coding with Python, and what I use it for (beginner) I can’t be called a code monkey when compared to my colleagues, but recently I’ve found Python to be really helpful with some of my work tasks, so I signed up for a Udemy course to learn...
Our Blogs
WE LOVE TO SHARE
Free ETL tools in 2020
Traditionally business intelligence is an enterprise solution, as only big businesses have multiple sources that require integration and analysis. It is assumed that the rest are small fishes that could be able to analyse their data with simpler accessible tools or...
Adobe equivalent Free Open Source Software (Pt2)
In part two of my Adobe equivalent Free Open Source Software (FOSS) blog I thought I would look at the video editing pipeline and find some free alternatives for your video editing needs. You can read Part One which covers Photoshop, Illustrator and InDesign here....
Meri Kirihimete from OptimalBI
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,...
Learn and Earn – Kaggle
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!...
Adobe equivalent Free Open Source Software
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...
Vi – get in, get out, get it done
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...
Checking a Checksum (Cryptographic hash function) – with PowerShell and Bash shell
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...
MongoDB in Business Intelligence
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...
Privacy, why should you care???
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...