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.
SAS Functions Book

SAS Functions Book

Over the years, we've been building up our comic-style SAS function one-page guides, drip-feeding them to you.  Well, guess what?!  We put them all together and made a book so they're all in the one place, to make referencing them easier for you. Thank you...

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

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

Qlik NPrinting – What is it?

Qlik NPrinting – What is it?

A lot of Qlik Sense customers I interact with have heard of NPrinting, yet never had the opportunity to see it in action so I thought it would be great to put together a blog on what NPrinting is, and how it can help! What is NPrinting? NPrinting is an add-on which...

WordPress vs Drupal – Learning Curve

WordPress vs Drupal – Learning Curve

WordPress and Drupal are two of the most popular Content Management Systems in the market now. It is a common question how WordPress and Drupal are different from each other, there are a lot of articles about this and you might have done some research about it...

Vi – get in, get out, get it done

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

Apache Superset on Linux

Apache Superset on Linux

Another one of the open source projects I readily follow is Apache Superset. Superset is part of innovative ecosystem surrounding PrestoDB. So to start with, let's cover off what Superset is and why it's so darn awesome... Superset (previously known as Panoramix and...

How SVG ViewBox Works

How SVG ViewBox Works

  <SVG viewBox="W T F ?"></SVG> Recently I have been involved with a project that is pretty much centered around SVG's. Almost unavoidably I encountered the viewBox attribute for SVG's and even more unavoidably encountered problems with it. Min-x,...

Now Featuring!

Now Featuring!

Recently I was asked during an interview how I would approach adopting new features in Oracle as part of an upgrade. At the time I feel I gave a pretty cursory reply and I just explained how I’d performed an upgrade (migration) across platforms and had implemented new...

Why is Unix still around?

Why is Unix still around?

You might think that Unix is some old school way of using computers that is slowly fading away, but having come back to computing (after living in the highlands of Scotland with no particular reason to use a computer for nearly three years), I'd have to say Unix's...