WE LOVE TO SHARE
So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
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
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.
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...
Integrate AWS Lex Chatbot with Angular 7
As Chatbot is a part of our latest project Optimal Visualisation Engine I was working on the integrating chatbot with the angular application. I am using angular version 7 to do this.
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...
BimlFlex – Install Missing SSIS Components
I am currently working on a project that has chosen to use Varigence BimlFlex as the preferred tool to create and manage the data warehouse. BimlFlex is a data warehouse framework that allows you to model and build an end to end data warehouse solution using a...
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...
AWS Amplify Deploy – So easy you should be using it now.
Recently I have been a small part of a team at OptimalBI building a new Angular app. When we approached the point where we wanted to start deploying on AWS I did the standard thing I have always done; create a S3 bucket, setup the bucket for hosting static sites,...
The SAS Wellington conference – in case you missed it
For those that could not attend SUNZ this year, here is a taste of how my day went. My day of late starts with a plank, I do just one, for as long as I can each morning. Today was 1 minute 31 seconds. I then headed into my office at OptimalHQ to complete some...