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.
Checking the File Path from Database in PowerShell

Checking the File Path from Database in PowerShell

On one of my recent projects I was analysing my customer's data for migration. Their legacy application could handle documents. They were stored on the organisation's shared folder, and the file path was recorded in the database with the rest of data. As a part of the...

The best lockdown baking recipes

The best lockdown baking recipes

The nation has been hit by a baking craze!  Lockdown gave some of us more time to do some of the simple things in life, like baking, and, if you were lucky enough to get flour and yeast you could create some delicious treats! I've always enjoyed baking, so loved...

Being social while social distancing

Being social while social distancing

The world has been social distancing for some time now, and will be for a bit longer, depending where you live. To help put off or at least mitigate going stir crazy I thought I would share what I have been doing to keep up some sort of social life.   Before the lock...

Our How To blogs

Our How To blogs

We do cool sh!t with data and over the years we have shared a lot of blogs to help you do cool sh!t with data too.  If you want to jump right in and see if we have something that piques your interest here are all our how to blogs.  If you...

SAS Utilities: cleanwork

SAS Utilities: cleanwork

When a user starts and runs code in a SAS session, a number of temporary folders and files are created in the SASWork and SASUtil locations.  If that session completed and exits normally these folders and files are removed, however some SAS sessions exit abnormally,...

1080 By The Numbers

1080 By The Numbers

If you have lived in New Zealand for long enough, I am sure you would have heard of the poison 1080, used by the Department of Conservation (DOC) as a form of pest control. 1080 can be used in bait stations or by airdrop, which is used for many of the remote and hard...

Keeping your brain busy while in lock down

Keeping your brain busy while in lock down

Many places all over the world are currently in self-isolation mode in response to the COVID-19 pandemic. In New Zealand, lock down started on Thursday March 26, which means that some people are able to work from home. At OptimalBI, we are working from home and on the...

I tried the Qlik Data Literacy course

I tried the Qlik Data Literacy course

I've spent the last 8 years of my life surrounded by data nerds, and while I've learned so many new things about data, I can not even pretend I'm a data nerd myself.  An enthusiast for sure, but a nerd... no way! I lack what my peers would consider the hammer and...