The Challenge
Apex Group faced significant operational friction managing both active construction developments and a large portfolio of commercial/residential properties under one roof.
- Construction Friction: Subcontractor billing, material procurement, and site budget variances were tracked on disconnected spreadsheets, resulting in delayed job-cost reporting and budget overruns.
- Property Management Friction: Tenant leases, maintenance requests, rent collections, and vacancy rates were managed on separate software, isolating property management from the central finance ledger.
- Executive Visibility: Corporate leadership lacked a real-time, consolidated view comparing construction project ROI against property portfolio yield.
The Solution: 3-Step Enterprise Architecture
Step 1: Core Operations Digitization via Odoo ERP
We consolidated Apex Group's dual business model into a unified Odoo ERP foundation:
- Construction & Job Costing: Digitized sub-contractor agreements, purchase orders, site inventory, and milestone-based project accounting to track real-time job-cost variances.
- Property Management & Accounting: Standardized tenant onboarding, lease tracking, automated rent collection invoicing, and maintenance ticket handling directly inside Odoo.
- Unified Financials: Consolidated construction assets and property rental revenue into a single multi-entity general ledger.
Step 2: Analytics & Data Unification via Microsoft Fabric & Power BI
We built automated data pipelines connecting Odoo ERP to Microsoft Fabric and Power BI, delivering specialized executive dashboards:
- Construction Project Health Dashboard: Track actual vs. budgeted costs, completion timelines, and contractor commitments across all active build sites.
- Property Portfolio Yield Dashboard: Monitor occupancy rates, NOI (Net Operating Income), rental yield per square foot, and upcoming lease renewals in real time.
Step 3: AI & Automation Deployment (Enterprise AI Agents)
We deployed custom AI models across Apex Group's unified data lakehouse to automate routine property and site workflows:
- Tenant & Maintenance AI Assistant: AI agents analyze incoming tenant maintenance requests, auto-categorize priority levels, and draft vendor work orders inside Odoo.
- Predictive Expense & Budget AI: Fine-tuned Claude/ChatGPT models flag material cost spikes on construction procurement orders before invoices are processed.
Key Metrics & Measurable ROI
- 100% Real-Time Visibility into construction job costs and property portfolio net operating income.
- 35% Reduction in tenant maintenance request resolution times.
- 18 Hours/Week Saved in manual financial reconciliation between development and leasing divisions.