by Nic Cox | Feb 5, 2019 | Business Intelligence, Visualisation |
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...
by Bronwyn Scott | Feb 1, 2019 | AgileBI, Business Intelligence, Training |
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...
by Kate Loguteva | Jan 24, 2019 | Business Intelligence, Microsoft |
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...
by Tim Gray | Dec 4, 2018 | Amazon Web Services, Business Intelligence, CloudBI |
AWS re:Invent has just happened, and with it a huge number of announcements across the whole AWS portfolio. As usual there were so many announcements that its a bit hard to keep track of them all, so I thought I would pull out most of the announcements related to BI...
by Kate Loguteva | Nov 13, 2018 | AgileBI, Business Intelligence, Data Integration |
When it comes to the data storage in Business Intelligence, you have options of having an Operational Data Store (ODS), a Persistent Stage (PSA) and a Data Warehouse (DW); all of them are just databases though. I have noticed that sometimes these terms are used...
by Bronwyn Scott | Nov 8, 2018 | AgileBI, Business Intelligence, Training |
Enterprise Integration Platforms, such as the Enterprise Data Warehouse, store integrated data in a common database. The features of this common target schema typically include: Enterprise-wide scope, Auditable data, Data sourced from several source systems, A...