Exporting and Importing Trifacta Wrangler Recipes

Exporting and Importing Trifacta Wrangler Recipes

Question Time with QlikSense – Are the rises in Auckland House Prices out of Character?

Out of office

Out of office

I’ve had a week away from the office. Not away from work, just away from a fixed location. It’s always something I enjoy, but do too infrequently. Years ago I had a boss who frequently ‘worked from home.’ The speech marks are really necessary. Whenever working from...

How to maintain Data Vault standards

How to maintain Data Vault standards

During our Data Vault journey, we found that having naming and coding standards is important when working in a team. Having a consistent environment improves collaboration. With consistent table and column names, it's easy to pick up objects to create a select...

Dropbox security breach, how to protect yourself better

Dropbox security breach, how to protect yourself better

So Dropbox got breached in 2012 and we all know about it now. Some of you may have noticed an email or some form of password reset request from dropbox to make sure that your account is secure, but this only helps if you had done the correct thing and used a different...

SQL Server Series: What is an Index?

SQL Server Series: What is an Index?

Nic Cox used to be a Data Warehouse and ETL developer here at OptimalBI. Nic used to regularly battle it out whenever we did an exercise challenge. He has now spread his wings and is now living in London where is enjoying life on the Kiwi OE. You can read the original...

ODE Version 2: What's New

ODE Version 2: What's New

Optimal Data Engine Version 2 is now available for download from GitHub! Here's what it means for you. The biggest change with the most impact is a new flag for Data Vault retired objects. The general rule is, once something gets into the Data Vault, it never goes...

What’s The Best Restful Web API Framework – Part 3

What’s The Best Restful Web API Framework – Part 3

Welcome back to the great RESTful framework showdown! If you have not read the previous blogs they can be found here. Today we will be taking a look at the core functions we need our RESTapi to perform and how the frameworks measure up, as well as what our developers...