Parks Asset Condition Dashboard

Project Overview

This Power BI portfolio project demonstrates how parks asset condition information can be monitored and analysed in a clear, interactive dashboard. It focuses on condition data coverage, physical assessments, bulk-migrated records and assets requiring attention.

Tools Used

Power BI
DAX
Excel
SharePoint
Data Modelling
Interactive Slicers
Asset Management Analytics

What the Dashboard Does

The dashboard provides both a high-level management overview and a detailed asset-level view. Users can filter the data by park site, asset type and condition rating to investigate asset condition and assessment status.

Dashboard Overview

High-level overview showing total assets, condition data coverage, physically assessed assets, assets requiring attention, assessment method and recorded condition profile.

Asset Condition Details

Detailed asset register with filtering by park site, asset type and condition rating, together with analysis of assessment source by asset type.

Key Capabilities Demonstrated

Asset condition monitoring
Condition data coverage reporting
Physical assessment tracking
Identification of assets requiring attention
Comparison of physically assessed and bulk-migrated records
Interactive filtering by park site, asset type and condition rating
Detailed asset-level reporting
Power BI data modelling and DAX measures
Excel and SharePoint data integration

Solution Workflow

Excel → SharePoint → Power BI

Asset data is prepared in Excel, stored in SharePoint and connected to Power BI for modelling, analysis and interactive reporting.

Portfolio demonstration using sample data. No confidential or operational Council data is displayed.

Page updated

Google Sites

Report abuse