Our Blogs

WE LOVE TO SHARE

So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
Adobe equivalent Free Open Source Software

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

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

Team work makes the dream work

Team work makes the dream work

I like working at a small company for a couple of reasons: I'm a generalist, not a specialist, so small organisations suit my skill set better, which means I'm usually never bored. You know your colleagues better.  You know the name of their spouse, their kids, their...

Why is Snowflake special?

Why is Snowflake special?

The first I came across Snowflake was a few years ago when I was learning how to use Attunity Replicate, that time I established a data load into this cloud data warehouse. This time I have decided to explore what Snowflake is about. Terminology I watched some...

SUNZ – National Conference 2019 – Data and Beyond

SUNZ – National Conference 2019 – Data and Beyond

  The Planets and stars aligned; While visiting family near Wellington and our monthly team meeting was on the same week, I was fortunate enough to be able to attend the SUNZ National conference held at the Michael Fowler Centre in Wellington. For this short post...

The Hays 19/20 Salary Guide

The Hays 19/20 Salary Guide

When I was in Wellington last week, I headed along to the Hays Salary Guide launch for some insights on the labour force, career progression, and what both employers and employees are wanting out of their roles. If this is something that interests you, I highly...

Making Sense of Google Analytics Data

Making Sense of Google Analytics Data

Here at OptimalBI we love data, and we get upset when it's only piled and doesn't produce value. Like many others who have a website, we use Google Analytics to collect its statistics. This is valuable marketing data, so we want to make use of it and help our...

Open Source Data Tools Update.

Open Source Data Tools Update.

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

Database Testing Automation

It is hard to overstate the importance of the database testing, erroneous data costs a lot for a business. Yet, when you say testing, developers' noses crinkle as they think it's hard and boring. I have worked on a multiple data warehouse development projects, and I...

Privacy, why should you care???

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