Products
Services
Blogs
About
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.
Power BI
Power Automate
Data Literacy
Web Design
Data Ops
MongoDB
Microsoft
Optimal People
SAS
Oracle
Community
ODE
Open Source
Trifacta
Qlik Sense
Coaching
Open Data
AgileBI
CloudBI
YellowfinBI
Optimal Company
Business Intelligence
Managed Services
Data Integration
Analytics
Amazon Web Services
Training
Visualisation
General
Data Engineering
Data Insights
Category...
Select one...
Date (Desc)
Date (Asc)
Author
Title
Remove Filters
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Planning for the COVID-19 Pandemic at OptimalBI
By
Victoria Maclennan
2020-03-17
February 9, 2022
Community
We find ourselves in unprecedented times. All across the globe the impact of COVID-19 is being felt, it’s heart-breaking reading the stories of loss, the impact on societies, businesses and individuals as a result of measures put in place to restrict the momentum of...
Building Services and Applications for Generic Data
By
Tim Gray
2020-03-03
February 9, 2022
Business Intelligence
One of the things many developers love about MongoDB and other NoSQL databases is the ability to store flexible objects in their native format. When you walk around the office singing its praises, experienced developers chime in and tell you that this is a quick path...
What is data literacy and why should you care?
By
Bronwyn Scott
2020-02-27
February 9, 2022
Analytics
You might have heard this term thrown about a bit recently. Perhaps it's because you've heard politicians referring to it when discussing educational reform, or you've noticed how your job has you doing more with spreadsheets than you did five years ago. What ever...
What is algorithmic bias and why should you care?
By
Bronwyn Scott
2020-02-20
February 9, 2022
Analytics
What is algorithmic bias? A systematic error in computer algorithms which leads to unfair outcomes and giving privileges to one of the groups of users over all others. An algorithm is a set of instructions designed to perform a specific task. This can be a simple...
I tried the Qlik Data Literacy course
By
Bronwyn Scott
2020-02-18
February 9, 2022
Analytics
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...
Open Source Datasets
By
Alison Rowe
2019-11-21
February 9, 2022
Open Data
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...
Data Science Pioneers Movie
By
Kate Loguteva
2019-11-14
February 9, 2022
Analytics
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...
How To Intnx With SAS
By
Steven Morrison
2019-11-07
February 9, 2022
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
By
Alison Rowe
2019-11-05
February 9, 2022
Business Intelligence
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...
4 reasons why BEAM* is great for those who work with data
By
Alison Rowe
2019-10-31
February 9, 2022
Business Intelligence
I have used Business Event Analysis and Modelling (BEAM*) many times at work over that last five years. So, what makes it great and why do I use it time and again? First of all, I should explain what BEAM* is. What is BEAM*? BEAM* is a flexible methodology allowing...
Electric Garden: My First IoT Device
By
Kate Loguteva
2019-10-24
February 9, 2022
Community
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...
It’s Ada Lovelace day – and we should all know more about this amazing woman
By
Victoria Maclennan
2019-10-08
February 9, 2022
Community
Earlier this year in a Christchurch auditorium packed with girls, their mothers, fathers and brothers - I learned just what a big deal Ada Lovelace was from the live performance show ADA ADA ADA. And WOW what a show it was. Employing the power of a programmable LED...
Different image formats and their uses (PNG, SVG, TIFF, JPG).
By
Tim Gray
2019-10-01
February 9, 2022
Visualisation
If you have ever had to export pictures from any of the major image editing software (Photoshop etc) then you will know that there are quite a few image types you can use. What many people don't know is when to use each format, and what some formats can do that others...
Adobe equivalent Free Open Source Software
By
Steven Morrison
2019-08-20
February 9, 2022
Open Source
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...
Vi – get in, get out, get it done
By
Nick Borrell
2019-07-25
February 9, 2022
Data Ops
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
By
Alison Rowe
2019-07-23
February 9, 2022
Amazon Web Services
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
By
Nick Borrell
2019-07-18
February 9, 2022
Data Engineering
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
By
Kate Loguteva
2019-07-03
February 9, 2022
Optimal Company
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...
Previous
Next
Copyright © 2019 OptimalBI LTD.