Defence Industries – Workforce Planning Tool
The Problem Our Defence Industries Client had previously forecast project resource requirements over the life of their projects. However, the process was manually intensive and did not integrate and utilise a number of relevant data sources. Defence Industries often involve having large-scale projects with extended timeframes. The scale of these projects often has a noticeable impact on the labour market as […]
Read More
State Government – Enterprise Data Model
The Problem This state government client is a statutory body that provides risk management and insurance to government departments and authorities. The client recently implemented a new core insurance system and reporting platform. However, the reporting platform could not fully utilise the data from the new system due to a mismatch of design, terminology, and […]
Read More
Power BI: Make a table 10 times smaller (and 10 times faster) by adding more data
Author: Lynton Mack Know your column store indexing! These are not databases! Recently, I had a case from one of our Financial Institute clients where a Power BI dataset containing daily account balances was over 1GB in size and not refreshing in the service, and I was tasked to reduce its size. I managed to […]
Read More