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
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
Software Provider – From Foundation to Reporting
The Problem This client provides comprehensive software solutions and business automation tools to small business owners. This client has a customisable solution used internally across the organisation, where management reports are generated on a frequent and ad-hoc basis. These reports ensure client data reconciles across multiple data sources, such as Salesforce and Zuora. As a […]
Read More
Power BI Incremental Refresh for Faster Dataset Refreshes
Power BI Incremental Refresh for Faster Dataset Refreshes Author: Ralph Gonzales In today’s day and age, data is the new gold. Companies keep track of all the data they generate as it aids in understanding their strengths, weaknesses, opportunities, and efficiency. Many companies have adopted a data-driven approach in their strategies and decision-making to further […]
Read More
Our Top Picks, Insights and Key Learnings from the Power BI Summit 2023 – Part Three
Our Top Picks, Insights and Key Learnings from the Power BI Summit 2023 – Part Three Author: Willem Herbst With this being my first time attending the Power BI Summit, I was unsure what to expect exactly. The agenda was packed full of interesting sessions and discussions, and it quickly became apparent that I would […]
Read More
Our Top Picks, Insights and Key Learnings from the Power BI Summit 2023 – Part Two
Our Top Picks, Insights and Key Learnings from the Power BI Summit 2023 – Part Two Author: Rachael Potts The 2023 Power BI Summit, hosted by RADACAD, was packed with presentations by well-known and experienced presenters, including expose’s own Heidi Hasting who, held a session on Power BI Report Server – Things to know. With […]
Read More
Our Top Picks, Insights and Key Learnings from the Power BI Summit 2023 – Part One
Our Top Picks, Insights and Key Learnings from the Power BI Summit 2023 – Part One Author: Herika Medeiros The Power BI Summit is the biggest annual Power BI conference and is run virtually across five days. It brings the best and brightest from around the globe, including Microsoft’s Power BI product group, community experts […]
Read More
Capacity Planning Tool – our utility case study
Problem: One of our major utility customers identified that their current process for planning resources to meet the demand was not sustainable. Daily, there would be hundreds of customer calls requiring a myriad of different services, planned maintenance work as well as corporate demand. These calls often required crews of different levels of skills […]
Read More
Scenario Modelling – our Defence Client case study
We created a scenario modelling solution to enable informed business decisions for our Defence client. Read more on our case study here.
Read More
Staff Profile Reporting Solution – our Not-for-Profit case study
See how we implemented an end-to-end reporting solution to understand the client’s staffing profile here.
Read More
Time Zones and Daylight Savings in Power BI Service
One of the most important and often-overlooked aspects of Business Intelligence reporting (especially in the modern age of cloud systems) is latency of data. There are numerous examples of how this can be detrimental, the most common of which being the possibility of decisions being made with out of date information. For businesses where […]
Read More
Data Pipeline Design and Implementation – our State Government case study
See how we delivered a data pipeline, whilst minimising interruptions to critical business operations here.
Read More