Different image formats and their uses (PNG, SVG, TIFF, JPG).

Different image formats and their uses (PNG, SVG, TIFF, JPG).

Checking a Checksum (Cryptographic hash function) – with PowerShell and Bash shell

Checking a Checksum (Cryptographic hash function) – with PowerShell and Bash shell

Open Source Datasets

Open Source Datasets

Have you ever needed data for a work or academic project? If so, are there any good sites on the internet where you can easily access data? I have had to complete several projects at work where I had to build reports in various BI tool (Qlik and PowerBI). I needed to...

How To Intnx With SAS

How To Intnx 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 INTNX....

Power BI Learning Resources

Power BI Learning Resources

Are you new to Power BI? If the answer is yes, where do you start to learn how to use it? There is a lot of useful information on the Internet, but how do you know if it is any good? Look no further, I have compiled a list of useful resources that I have used over the...

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

Qlik Sense Training – building a demonstration app

Qlik Sense Training – building a demonstration app

In recent weeks I have been writing training material for an introductory course for Qlik Sense Cloud. The training course is aimed at business users. It teaches the basic data discovery capabilities available in the Qlik Sense Cloud application. It also gets users...