It is probably the most ambitious infrastructure project in the world. A futuristic city being built in the Middle East, with budgets of extraordinary magnitude and multicultural teams distributed globally. As a consultant there, my work touched several areas of the Microsoft ecosystem, each with its own scaling challenges.
The challenge of scattered data: when each team has its own truth
In a project of this magnitude, data comes from everywhere: engineering teams with their own tracking systems, compliance departments with their regulatory databases, project management with diverse tools, and finance with SAP. Leadership needed a consolidated vision — not fragments of information in multiple formats that someone had to manually consolidate.
I helped implement Microsoft Fabric as a consolidation layer. Scattered data sources were centralized in OneLake, creating a unified analytics lake with traceable data lineage. This means when the CEO sees a number in a report, you can trace exactly what system it came from, when it was updated, and who owns the data.
Automated reporting for the CEO: Report Builder, not dashboards
A specific need was generating periodic reports for executive leadership. And there's an important nuance here: leadership didn't want interactive dashboards — they wanted paginated PDF documents, with corporate formatting, that could be printed, annotated, and distributed in board meetings. Report Builder (Paginated Reports in Power BI) was the right tool for this.
I set up automatic generation of these reports: data is extracted from Fabric, processed according to defined business rules, formatted according to the corporate template, and automatically distributed to the corresponding recipients. No manual intervention, no risk of human error in preparation, and the guarantee that everyone sees the same numbers.
Boards Relationship Management Portal
I also developed Power Platform solutions for specific needs. One example is the board relationship management portal: a Power App with corporate authentication, member profile management, interaction history, commitment tracking, and access to relevant documentation. All integrated with the organization's security model — in a project of this magnitude, information security is non-negotiable.
Working at global scale: what changes
This project taught me that technology is the easy part. The hard part is coordination between teams working in different time zones, with strict enterprise security and compliance requirements, multi-layer approval processes, and extremely high quality expectations. Every solution has to work not just technically, but within the project's governance and culture.