Data Warehouse on Microsoft Fabric for a Real-Estate Company
A Fabric lakehouse and warehouse that unifies leasing, property, finance and CRM data into certified Power BI reporting.
Microsoft Fabric · OneLake
The challenge
Occupancy, rent roll, collections and project costs came from different systems, and every monthly pack meant days of spreadsheet reconciliation.
What we built
- A OneLake medallion lakehouse (Bronze, Silver, Gold) fed by Data Factory pipelines
- Conformed dimensions for property, unit, tenant, lease and project
- A Direct Lake semantic model with certified occupancy, rent roll, collections and arrears KPIs
- Row-level security by portfolio and Purview lineage for audit
Insights delivered
What the client receives every month
- Monthly portfolio pack: occupancy, rent roll and collections by asset
- Weekly arrears signal with tenants moving between aging buckets
- Lease expiry outlook for the next 12 months