Last month, I shared how to build a Living IAMP in Power BI. Since then, I’ve had many people ask about data connectivity. How Power BI connects to systems, and why this link is essential for keeping an AMP truly ‘living’. Today, I’m exploring those questions in more depth. At the heart of a Living AMP is the ability to reflect up-to-date, integrated data from across your organisation ensuring that decisions are made with confidence, relevance, and timeliness.
In this post, I explore how to build a living Infrastructure Asset Management Plan in Power BI. I’ll be using road assets (Road Surface, Road Pavement) as a working example. I’ll also walk through where asset data typically comes from, and how you can integrate it all into Power BI to tell a clear, visual story about the state of your network.
