by Brent Adcock | Jan 28, 2020 | Business Intelligence, Data Integration |
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. For...
by Steven Morrison | Jan 16, 2020 | AgileBI, Business Intelligence, Training |
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...
by Bronwyn Scott | Dec 18, 2019 | AgileBI, Analytics, Business Intelligence, Open Source, Training |
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 –...
by Thomas Evans | Dec 10, 2019 | Business Intelligence |
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...
by Steven Morrison | Dec 5, 2019 | Business Intelligence, SAS, Visualisation |
We like making life a little bit easier here at OptimalBI and one of the ways we have found to do that is by making quick how to guides. The standard text bullet point style guides isn’t what we do, we do cool sh!t. Below is a guide we have on the SAS function...
by Thomas Evans | Nov 28, 2019 | Analytics, Business Intelligence, Open Source |
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...
