WE LOVE TO SHARE
So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
Adobe equivalent Free Open Source Software
I’m sure most people have used or at least heard about the Adobe product Photoshop. In this blog I’m going to be looking at some of the programs that are offered by Adobe (the makers of Photoshop) and find free software that will fill the same purpose. To get started...
How to CountC with SAS
We like making life a little bit easier here at OptimalBI and one of the ways we have found to do that is by making quick how to guides. The standard text bullet point style guides isn’t what we do, we do cool sh!t. Below is a guide we have on the SAS function...
How to CountW with SAS
We like making life a little bit easier here at OptimalBI and one of the ways we have found to do that is by making quick how to guides. The standard text bullet point style guides isn't what we do, we do cool sh!t. Below is a guide we have on the SAS function...
Vi – get in, get out, get it done
It seems to me that a lot of people dislike Vi. I thought a short blog on the essential commands might be helpful. If you just want to know how to either “save your changes and exit” or “exit and abandon your changes” just jump to here.I’ve collated a list of what I...
Amazon QuickSight: A beginner’s guide
Importing data At OptimalBI we love to do cool sh!t with data. In my role in data analytics, I like to investigate new data presentation software and had the opportunity to use Amazon QuickSight to see what its data presentation capability was like. What is Amazon...
Checking a Checksum (Cryptographic hash function) – with PowerShell and Bash shell
When is paranoia a good thing?When it comes to downloading files for sure. Using a cryptographic hash function to test the authenticity of a file is a good practice. Such a good practice, that I wanted to make it as easy as possible to perform.I've written two scripts...
Command Line Interface: Still the Best for Administrative Tasks
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...
Team work makes the dream work
I like working at a small company for a couple of reasons: I'm a generalist, not a specialist, so small organisations suit my skill set better, which means I'm usually never bored. You know your colleagues better. You know the name of their spouse, their kids, their...
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...
SUNZ – National Conference 2019 – Data and Beyond
The Planets and stars aligned; While visiting family near Wellington and our monthly team meeting was on the same week, I was fortunate enough to be able to attend the SUNZ National conference held at the Michael Fowler Centre in Wellington. For this short post...