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.
Fishing in an Azure Data Lake

Fishing in an Azure Data Lake

In my previous post about Azure Data Lake Store, I went over how to create one and what it can be used for.  So assuming that you've created one and started to stock it with data and information - just how do we go about fishing out what we want? Let's talk about...

Paying the Piper – Azure Pay-as-you-Go

Paying the Piper – Azure Pay-as-you-Go

So it got near the end of the month for my "free" Azure trial and I need to change it up to a pay-as-you-go subscription if I want to keep playing with it. Switching to a Pay-as-you-Go subscription Assuming that you want to continue enjoying the azure goodies you will...

Qlik Continuous Classroom – Worth it?

Qlik Continuous Classroom – Worth it?

Recently, I have been spending some time learning QlikSense. This time happened to coincide with a 3-day free trial Qlik was having for their Continuous Classroom. This created an opportunity to compare free and paid content. This is a quick rundown or whether or not...

Python 2 to Python 3: Why, and how hard can it be?

Python 2 to Python 3: Why, and how hard can it be?

The impending doom of python2 will shortly be upon us (for a dramatic countdown check out the Python clock), so it is time to update our python scripts to Python 3 (3.6 hopefully). Here are a few of the things that made this easier for me over here at OptimalBI. Let's...

Through the Azure Looking Glass

So in a previous post I outlined a large collection of the free stuff that Microsoft gives you when you sign up to Azure.  So enough talking lets get our feet wet.. The pull tab to get us started is located at https://azure.microsoft.com/en-us/free/ where there's a...

Who likes free stuff?? Who doesn't!

So after having been down at a client site where they were using Microsoft Azure to host their database servers, I was inspired to learn more about this Azure thingy (ooh shiny).  So I thought lets try and set up a collection of blogs about travels through the Azure...

How to Install MongoDB with AWS EC2

How to Install MongoDB with AWS EC2

Here at OptimalBI, we’ve recently switched from using DynamoDB to MongoDB. However, we still use Amazon’s EC2 service to manage our servers. Because MongoDB isn’t an Amazon Web Service like DynamoDB is, installing Mongo on one of these servers isn’t the most obvious...