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.

Security for data warehouses

A data warehouse, by its very nature, creates a security conflict. On the one hand, the goal of every data warehouse is to make valuable data accessible. Most of the hard issues in data warehousing have to do with how to make the data more understandable, more...

Documentation Debt

We have come to value working software over comprehensive documentation. - Agile Manifesto At OptimalBI we consider documentation to be a necessary overhead. We will not do work without creating and recording a plan. We value planning and understand the need to record...

Dimensional Modelling Advice

All of my Business Intelligence clients have had intelligent and enthusiastic technical experts who were intimidated by dimensional modelling. I have to confess that I'm also still intimidated. I'm less intimidated than I used to be, but I know in my heart that I'm a...

PL/SQL Parameters

In Clean Code, Martin recommends that: The ideal number of arguments for a function is zero (niladic). Next comes one (monadic), followed closely by two (dyadic). Three arguments (triadic) should be avoided where possible. More than three (polyadic) requires very...