Reporting and analytics computations are usually very resource-consuming, therefore they are never executed on the same server where the crucial business application is running. Instead, data is copied into dedicated servers to be dissected and studied for insights....
This month OptimalBI is hosting a Data Science Pioneers documentary screening. The first screening was crowded and the rest of the sessions are booking up very quickly, so you might have heard about it already. I'm guessing, the selling point (although it's completely...
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...
We complete daily health checks for our customers and in one specific case, there is a BI tool which notifies us in case of major error, but we also have to scan logs for small errors and unhealthy processes. We check log files for errors, depending on your luck there...
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...
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...
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...
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 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...
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...