Woohoo we've got a new website! If you're reading this blog you're already on it and we reckon you should click a few extra buttons than you were planning to and go check it out... Data really does make anything possible, and we're here to help you harness data...
One of the things many developers love about MongoDB and other NoSQL databases is the ability to store flexible objects in their native format. When you walk around the office singing its praises, experienced developers chime in and tell you that this is a quick path...
You might have heard this term thrown about a bit recently. Perhaps it's because you've heard politicians referring to it when discussing educational reform, or you've noticed how your job has you doing more with spreadsheets than you did five years ago. What ever...
What is algorithmic bias? A systematic error in computer algorithms which leads to unfair outcomes and giving privileges to one of the groups of users over all others. An algorithm is a set of instructions designed to perform a specific task. This can be a simple...
After a bit of inventive adjective use the other day I found out that the way you create new database tables in Sparx Enterprise Architect database models has an impact on whether or not you can specify an Identity column for a SQL Server database table. ...
We first came across BEAM*, Lawrence Corr and Jim Stagnitto over seven years ago when we were scratching our heads trying to figure out a better way to design an agile data warehouse. Since then, we've convinced Lawrence to travel to Aotearoa many times...
Kia ora koutou and welcome to the last OptimalBI newsletter of 2019 - hasn't this year flown by! We have enjoyed supporting our customers to create amazing outcomes for their organisations this year with a range of really interesting projects - payment integration,...
One thing I've been thinking about lately is Single Source of Truth (SSOT), it's relationship with interpretation, and how that lands with data. We often consider the data warehouse, in at least it's traditional star schema sense to be a record of fact, obviously.....
Working in the Business Intelligence and Data Warehousing space I'm constantly keeping abreast of what's hot and what's not. Obviously Data Science, Machine Learning and Artificial Intelligence fall under the BI/DW banner, somewhere. So today I want to share Kaggle!...
Have you ever needed data for a work or academic project? If so, are there any good sites on the internet where you can easily access data? I have had to complete several projects at work where I had to build reports in various BI tool (Qlik and PowerBI). I needed to...