THE PROJECT STORY
Integrating 3D GIS into Power BI for Transport for NSW
While working at Aurecon, the Asset Management Team was approached by Transport for NSW to create a better way to integrate GIS data and 3D visualizations into Power BI reports. The goal was to empower engineers and stakeholders to visualize spatial data alongside critical metrics within a single, familiar platform, enhancing data engagement and decision making.
To achieve this, I developed a custom plugin for Microsoft Power BI using React and TypeScript. This innovative solution introduced 3D capabilities and interactive visualizations directly into the Power BI ecosystem. By leveraging these modern web technologies, I was able to create a responsive, scalable, and user friendly tool that transformed how data was consumed and analyzed.
The plugin integrated seamlessly with Microsoft Azure containers, enabling the efficient streaming and rendering of large scale 3D GIS data. This cloud based approach ensured the plugin could handle massive datasets with exceptional performance, allowing users to explore and manipulate 3D models and geospatial data in real time. Engineers could now interact with detailed 3D visualizations of infrastructure projects, layered with essential statistics and reports, all within a unified Power BI report.
This groundbreaking solution not only improved data visualization but also enhanced the ability of teams to engage with complex datasets. The integration of 3D GIS into Power BI provided a new dimension to business intelligence, enabling better insights, stronger collaboration, and more informed decision making.
The 3D capabilities introduced by this plugin have immense potential. They are ideal for applications such as urban planning, predictive maintenance, and infrastructure design. By pushing the limits of Power BI with cutting edge technologies like React, TypeScript, and Azure, this project not only delivered immediate value to Transport for NSW but also set a benchmark for the future of integrated data visualization in enterprise tools.
