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.
Easier access to Mapping Data

Easier access to Mapping Data

My recent challenges have been getting spatial data in an open format. Statistics NZ was my source for information but on their official website the data I wanted was only available in ESRI and MapInfo formats. Open data in propriety formats seems counter intuitive....

Using Stats NZ Maps in Qlik

Using Stats NZ Maps in Qlik

As I mentioned in my last post we have loaded the KML into Qlik Sense but it's not that useful as the Name field is missing and being populated with an automatically generated value p<rownumber>. If you open the KML file in a text editor you will see that for...

Oracle Data Visualisation Desktop

Oracle Data Visualisation Desktop

Oracle have been catching up in the analytics space. One of the features they had been lacking was in regards to self-service analytics. Basically, the ability for a user to mashup their own data with corporate data. I believe it's the reason why they didn't feature...

A Qlik visit to the dentist

A Qlik visit to the dentist

One of life's necessary, but expected to be unpleasant experiences, is a visit to the dentist. For an SQL developer, pivoting or unpivoting data can be a similar experience. In my case, I needed to unpivot and then include the requirement for a dynamic number of...

Qlik – On demand app generation

Qlik – On demand app generation

    My colleague discussed in a recent post the different categorisations for visual exploration tools. Like most modern tools Qlik Sense does a bit of everything. These days the strength of the tools is not whether it can do something, more how hard is it...

First Steps with Qlik Sense

First Steps with Qlik Sense

Getting thrown in the deep end is a common occurrence for me at OptimalBI. My current challenge is QlikSense, go forth and learn something useful was the directive. Others at OptimalBI have already looked into different facets of Qlik. Coming into this with a...

Apache meet Python Flask

Apache meet Python Flask

This guide covers installing and configuring Flask to run on Apache on Ubuntu. Why would you want to do this? In a nutshell, you want to run Python code in a web environment. Prerequisites: AWS EC2 running Ubuntu Server 14 Instructions: Installing the software SSH...

SAML Proof of concept – Part 3

SAML Proof of concept – Part 3

This is the third blog of a series on SAML, these are the first and second blogs. Great, it's installed and securing the Apache URL, but it doesn't seem complete. One thing becomes clear at this point. SAML only performs authentication if you are building a custom...