Have you ever opened a report and felt completely lost, like you didn’t know where to look first or what the story was supposed to be? I’ve definitely been there. I could sense something was off with the layout, but…
It all began when I refreshed a Power BI report using the usual data export from Primavera P6 into Excel. As I scanned through the forecast dates, something made me stop in my tracks, a task scheduled for the year…
I can’t count the number of times I’ve been asked, “Why do we need a separate Date Table? Can’t we just use the date columns in our dataset?” And honestly, I get it. When you’re new to Power BI or…
Welcome back to the second part of our series on Tracking Project Benefit in Power BI! In the first part, we laid the foundation by structuring our data model and establishing the necessary relationships. We discussed the importance of this…
In my years reporting on project controls, I’ve often been asked to visualise financial benefits over time. Tracking realised vs expected benefits is crucial for decision-making, but finding the right way to present this data can be tricky. At first,…
If you’ve ever tried bringing a Primavera P6 export into Power BI, you know the struggle. I’ve been there too! Working in Project Controls and reporting on project schedules, I’ve lost count of how many P6 extracts I’ve had to…
Ah, the pie chart, the Marmite of the data visualisation world. You either love its simplicity or loathe its misleading nature. Just when you think you’ve got it figured out, along comes its sleeker sibling: the donut chart. But which…
In Part 1, we explored why the Risk Matrix is essential in project risk assessment and built its foundation in Power BI. We used Power Query and the M language to create a Risk Index, structured a Dimension Table with…
In my experience developing reporting solutions for PMOs and Project Controls, the Risk Matrix is an absolute must-have. It’s a brilliant visual tool that helps us assess and prioritise potential risks in a project. When I first designed a Risk…
Okay, let’s be honest, Power BI’s new card visual isn’t exactly new anymore. But, like that book you bought ages ago and finally decided to read, I recently gave it some well-deserved attention. And let me tell you, it did…
