EOEfe Peter Oroh
← All work

Property Management Dashboard

A single-page Power BI view of property sales, channels, clients and countries from a practice dataset.

Power BI · Practice project
Property Management Dashboard
Role
Practice project
Stack
Power BI, DAX
Data
Sample property sales dataset, 2022 to 2024
Context

Why it mattered

A practice project from my analytics training: a sample dataset of property sales from 2022 to 2024, with buyers, sale channels, property types and payment status.

The aim was a clean, one-page executive view that answers the obvious questions in a few seconds.

The question
How is revenue tracking by year, channel, property type and country, and who are the best clients?
Approach

How I solved it

01 · Model

A small star schema.

One sales fact with property, client, date and location dimensions.

dim_datedim_propertydim_clientdim_locationfact_salesprice, expense, status
02 · Measure

The numbers that matter.

Revenue, expense, income and year-over-year change, plus a ranking of top clients.

Revenueand expenseIncomerevenue lessexpenseYoY changevs prior yearRankingstop clients
03 · Serve

One page, cross-filtering.

Year tabs, channel and property-type bars, a country map and a best-clients table that all filter each other. These are the 2024 values.

PROPERTY MANAGEMENT DASHBOARDREVENUE26M-37.5% vs 2023EXPENSE9MINCOME17MSOLD44
Outcome

What it delivers

3 yearstoggle between 2022, 2023 and 2024
1 pagerevenue, channels, types, countries and clients
Cross-filteringclick any country or client to filter everything
Demo

See it for yourself

A short screen recording of the finished work. It only plays when you press the button.

Property Management Dashboard preview