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.
Electric Garden: My First IoT Device

Electric Garden: My First IoT Device

Probably you know that our boss Victoria supports many digital initiatives across New Zealand. One day she has shared with us one of the latest Digital Future Aotearoa initiative called Electric Garden. This is an Internet of Things solution for garden monitoring...

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

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

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

MongoDB Graphic Interface Apps: Honest Review

MongoDB Graphic Interface Apps: Honest Review

I found it misleading that there are so many graphic interface tools to query and update the data in MongoDB. The hardest bit is to find an honest opinion if it's any good to use. I had to try as many of them as I could find, and below is what I think about them. Note...

Advanced Data Vault Course

Advanced Data Vault Course

Recently I went to the Advanced Data Vault Modeling course run by Hans Hultgren to take my knowledge to the next level. It was held in Melbourne, and this was my first time in Australia as well. It was hilarious to find out that the most attendees were from New...