WE LOVE TO SHARE
So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
Using API Gateway Private Endpoints: Cost and Considerations
API Gateway is a fantastic tool in the AWS Cloud toolkit. If you're building serverless applications, creating functions that you don't want to manage the servers for, or integrating many different services (AWS or otherwise) API Gateway chips in with a...
AWS Lex Code Hooks Guide
There is an official Amazon blog on how to do dialog hooks and code is available on GitHub. Documentation fully describes syntax of JSON objects that Lex and Lambda exchange. But it took me some time to try this code and experiment to understand what each of the...
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,...
Amazon Lex first steps
And now for something completely different. Chat bots are a technology that I have not had the opportunity to use in the past. Recently I was given a opportunity to get one working for a proof of concept. There are a few different options in this space, but we chose...
How to Feed AWS Lex with Values from Database
On our latest project we have added a chat bot to a website for an alternative way to get input parameters from user in natural language. We've got a library of objects we can visualise based on user's parameters, and it's stored in the database. When new...
Getting Started with Unreal Engine
To start the year, some of the team here at OptimalBI decided to get together and have our own little hackathon. The aim was to brainstorm an idea that would enable us to all learn something a bit different from our usual day to day work. Our idea was to build a...
LAWRENCE CORR IS BACK TO BEAM* IN WELLINGTON THIS MARCH 4 – 6, 2019
That's right; for 3 days only, Lawrence himself will be in Wellington delivering his Agile Data Warehouse Design course! It's been over two whole years since Lawrence visited last time so this is your perfect opportunity to learn from the pro about the BEAM* method...
Why use Blender when you’re new to 3D modelling?
The best way to start learning a new tool is to install and start using it. I previously had no experience using any of the 3D modelling tools, until I started using Blender to create 3D objects for the POC of our latest internal project. I loved it when I...
Square pegs in round holes (or how Sparx EA handles database structures)
Recently down on a client site I had the opportunity to work with Sparx Enterprise Architect on a project. For those of you not familar with the product the easiest way to describe it would be to imagine a coffee drinker used to simple old joe walking into a...
Chaining Permissions between Databases in SQL Server
It's typical in Business Intelligence that users are not getting data from the Data Warehouse database directly. Although the table structure should speak to them, one should be careful when querying Slowly changing dimension type 2 tables to get only point in time...