Reporting and analytics computations are usually very resource-consuming, therefore they are never executed on the same server where the crucial business application is running. Instead, data is copied into dedicated servers to be dissected and studied for insights....
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!...