BEAM me up: requirements gathering for Agile Data Warehouses

Data Vault: Agile Data Warehousing for the Future

AWS Elasticsearch vs AWS CloudSearch

AWS Elasticsearch vs AWS CloudSearch

 vs. When you are in the AWS console you may have noticed that there are two options for search, ElasticSearch Service and CloudSearch. Both of these are in different sections of the console and both seem to offer search, but which should you use? As we are in need of...

To Docker or Not To Docker on AWS

To Docker or Not To Docker on AWS

When talking about deploying an application to the cloud (especially SaaS or similar hardware independent applications) Docker always seems to come up in conversation. With that and the new(ish) Docker Elastic Container Service offering from Amazon we decided that now...

Converting Trifacta Recipes to Python

Converting Trifacta Recipes to Python

So we have been trundling along with Trifacta and now have exported our recipe, and now we want to do cool stuff with it. One of the cool things that we can do now is use the logic from Trifacta and produce our own little mini parsing engine that we have complete...

Our How To blogs

On Wednesday we usually bring you an Agile blog by Geoff Hunt. However, this week Geoff is on holiday. So, I have decided to put all of our How To blogs in the one place. OptimalBI's How To blog collection. Obviously they cover a lot of topics, but included are guides...

Graduating from a World of Orange

In my very first blog for OptimalBI I said that breaking from my comfort zone was something I would always strive to do. That blog was about me joining OptimalBI and the excitement that lay ahead. Now, one year and eight months down the track it is time for me to...

Oracle Apex Dynamic Page Item Help

Oracle Apex Dynamic Page Item Help

I'm Ben Lee I'm into report development, data integration and data modelling. In this blog I explain how I helped a customer manage their own help text. Recently I had the scenario where a customer wanted to be able to manage their own help text for a page in an...