The Business Challenge

Operating in the ultra-prime real estate market across Lisbon, Cascais, and Comporta, John Taylor Portugal required an uncompromised, unified analytics platform to monitor their entire commercial lifecycle.

The executive leadership faced critical operational and data challenges:

• Geographic Funnel Blind Spots: Inability to accurately attribute sales requests and buyer demand to specific territories when property references were unlinked in the CRM.

• Operational SLA Gaps: Lack of exact, audit-ready tracking for consultant response times from lead ingestion to initial client engagement.

• Complex Multi-Axis Reporting: The need for senior directors to seamlessly pivot between volume metrics (AUM, Properties, Active Leads) and non-additive ratios (Average AUM, Conversion rates) without mathematical distortions like summing averages across stacked visuals.

The Technical Solution

Sersight designed and deployed an end-to-end data architecture powered by Microsoft Fabric, PySpark, Spark SQL, and advanced Power BI DAX modeling:

• Bottom-Up Geographic Inheritance Engine (PySpark): Built a multi-tier data pipeline evaluating funnel requests dynamically. Requests automatically inherit territories from origin leads, apply regex pattern matching to client search queries, or fall back to branch metadata, ensuring 100% territorial accuracy.

• Operational SLA Reconciliation (Spark SQL): Engineered unified event models utilizing full outer joins to reconcile asynchronous CRM actions. Injected native decimal-hour time computations between lead creation and the exact timestamp of the first commercial action.

• Dual Field Parameters & Dynamic Modeling (DAX): Developed a tailored semantic layer allowing leadership to switch dynamically between volume metrics and non-additive ratios across multiple categorical dimensions.

• Advanced Visual Engineering (Ghost Lines): Formulated a bespoke DAX calculation framework to render stacked category breakdowns while enforcing mathematical precision on custom labels, eliminating native Power BI visual limitations when visualizing multi-million euro portfolios.

The Strategic Impact

The platform eliminated relational CRM inconsistencies and unified data across all branches into an executive command center:

• Total Funnel Visibility: Complete end-to-end traceability from lead entry to contract closing.

• Actionable SLA Tracking: Real-time visibility into consultant response times, accelerating lead-to-opportunity velocity.

• Executive Decision Speed: Immediate visibility over portfolio valuations and average price movements across prime market territories.