Power BI dashboards for facilities and real estate
A facilities dashboard shows what the estate costs, how much of the space is used, and where maintenance is falling behind. Three screens cover it. We build them on your own lease, facilities and cost data.
Request the sample pack
What it answers
Three questions every facilities team is asked
Each screen starts from a question. The figures show where space and money can be saved, and where service is slipping.
- What does our estate cost, and how full is it?Total occupancy cost, cost per square foot, space utilisation and work orders closed within SLA, with the highest-cost sites.
- Is space being used, and which sites are under-used?Leased floor area, average utilisation and under-used sites, with cost per square foot against utilisation by site type.
- Where is maintenance falling behind?Work orders, reactive share, work orders closed within SLA and the open backlog, by category and month, with the sites holding the most reactive work.
The screens
Power BI facilities and real estate screens
Three screens for the facilities team. Open one to see it full size. Each comes with filters and drill-through, and we adjust measures, filters and branding to your business.
3 dashboards
Every number on these screens is sample data from a fictional retailer. No client data is shown. Your own logo replaces the AscenWork mark at the top left of each report.
How we define the main facilities and real estate measures
A dashboard is only trusted if everyone reads the same number. We agree these definitions with you before we build, and write them down at handover.
| Measure | How we calculate it | What to agree first |
|---|---|---|
| Occupancy cost per square foot | Total occupancy cost divided by leased floor area. | Which costs are included, such as rent, service charge and utilities. |
| Space utilisation | Occupied hours divided by available hours, for each site or zone. | The opening hours and the zones counted as usable space. |
| Reactive share | Reactive work orders divided by all work orders. | How planned and reactive work are classified. |
| SLA closure | Work orders closed within the SLA divided by work orders closed. | The SLA time for each priority. |
| Open backlog | Work orders still open at the end of the period. | Whether on-hold work is counted as open. |
How it works
From these screens to your live dashboard
In a project, the dashboard connects to your lease and facilities data and refreshes on a schedule. You see working pages early, so you react to something real.
Connect
We link your systems and files, and check the data is complete.
Model
We clean and join the data, and agree each measure with you so everyone reads the same number.
Design
We apply your chosen look and your logo to every page, with a phone layout where it is needed.
Go live
The dashboard runs in Power BI with scheduled refresh, filters, drill-through and access by role.
What we connect
Where the data for these dashboards comes from
We confirm the sources on a short scoping call. These are the common ones for this dashboard.
Lease register
Leased floor area, rent and service charges, from your lease register or the sheet your team keeps.
Facilities management
Work orders, priorities and closure dates from your facilities or maintenance system.
Occupancy data
Space use from badge, booking or sensor data, where you have it.
Finance cost centres
Property and maintenance costs by cost centre, so the figures match the accounts.
Site register
Sites, site types and zones, so cost and use are compared fairly.
Access by role
Row-level security, so a site manager sees their own sites and the facilities head sees the estate.
Our Power BI work
These screens are one part of what we do on Power BI
The same team builds the data model behind the dashboard, designs the report and keeps it running. Pick the part you need.
Power BI development
Data connections, model, measures, row-level security and scheduled refresh, built in your Power BI.
Power BI consulting
A review of your current reports and data, and a plan before you build.
Power BI designing
Clear, fast report design with a consistent look across every page.
Copilot and AI for Power BI
Ask questions of your data in plain language, with the right guardrails.
Case studies
Power BI projects we have delivered
Power BI job life cycle, exception and debtors reports for a freight forwarder
A set of Power BI reports for a freight forwarding and customs clearing company with many branches. They follow every job from creation to closure and flag exceptions, pending billing, debtors and profit.
A freight forwarding and customs clearing company with many branches and a finance team at head office
Read the case study →Power BI · Energy and renewables
Power BI asset performance dashboards for a renewable energy portfolio
A Power BI report that follows generation, losses, breakdowns and module cleaning across every solar plant in a portfolio, from an executive summary down to the inverter.
A renewable energy company operating several solar plants
Read the case study →Power BI · Retail and consumer goods
Power BI sales dashboards for digital channels and prescription sales
Two Power BI reports that bring sales data from every channel into one view. Digital sales covers partners, marketplaces, website and products, and Rx sales covers prescribers, zones, brands and field teams.
A skincare company selling through digital partners, its own website and prescription channels
Read the case study →Trusted by teams at
Power BI facilities and real estate dashboard questions
What should a facilities dashboard show?
Occupancy cost, cost per square foot, space utilisation, and the maintenance backlog with SLA performance. Start with the decisions the facilities team takes each quarter, such as lease renewals and space changes.
What if we do not track space use?
The dashboard still works. Cost, lease and maintenance screens do not need occupancy data. The utilisation screen does, so we tell you what a booking or sensor feed would add.
Can it connect to our facilities system?
Usually yes. Power BI connects to common facilities systems, databases and Excel. We confirm each source on a scoping call.
Can a site manager see only their own sites?
Yes. With row-level security, a site manager sees their own sites, while the facilities head sees the whole estate.
Is the sample pack free?
Yes. The design pack is free, and we email it to you as a PDF. Building dashboards on your own data is a scoped, paid engagement, which we quote after a discovery call.
How do we get a price and a timeline?
Book a free call. We learn your data sources, users and questions, then send a proposal with the scope, the assumptions and the price. Timelines depend on the number of sources and dashboards.
Related
More from our Power BI work
All dashboard templates
Fifteen dashboards by function and industry
Procurement dashboards
Spend, contracts and suppliers
Finance dashboards
Cash, receivables and budget screens
Supply chain dashboards
Deliveries, suppliers and inventory
Power BI development
Build a dashboard on your own data
Power BI consulting
Review and plan before you build
Power BI designing
Clear, fast report design
Hire Power BI developers
Developers who join your team
Contact