{"id":1283,"date":"2024-12-05T00:20:51","date_gmt":"2024-12-05T00:20:51","guid":{"rendered":"https:\/\/ghafari.co.uk\/?p=1283"},"modified":"2024-12-05T00:33:10","modified_gmt":"2024-12-05T00:33:10","slug":"plugin-for-power-bi","status":"publish","type":"post","link":"https:\/\/ghafari.co.uk\/index.php\/2024\/12\/05\/plugin-for-power-bi\/","title":{"rendered":"Plugin for Power Bi"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1283\" class=\"elementor elementor-1283\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a0d3fcb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a0d3fcb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-extended\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1d3dc06 sc_layouts_column_icons_position_left\" data-id=\"1d3dc06\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dc10853 elementor-widget elementor-widget-text-editor\" data-id=\"dc10853\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3>Integrating 3D GIS into Power BI for Transport for NSW<\/h3><p>While working at <strong>Aurecon<\/strong>, the <strong>Asset Management Team<\/strong> was approached by <strong>Transport for NSW<\/strong> to create a better way to integrate <strong>GIS data<\/strong> and <strong>3D visualizations<\/strong> into <strong>Power BI reports<\/strong>. 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.<\/p><p>To achieve this, I developed a <strong>custom plugin for Microsoft Power BI<\/strong> using <strong>React<\/strong> and <strong>TypeScript<\/strong>. This innovative solution introduced <strong>3D capabilities<\/strong> 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.<\/p><p>The plugin integrated seamlessly with <strong>Microsoft Azure containers<\/strong>, enabling the efficient streaming and rendering of <strong>large-scale 3D GIS data<\/strong>. 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.<\/p><p>This groundbreaking solution not only improved data visualization but also enhanced the ability of teams to engage with complex datasets. The integration of <strong>3D GIS into Power BI<\/strong> provided a new dimension to business intelligence, enabling better insights, stronger collaboration, and more informed decision-making.<\/p><p>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 <strong>React<\/strong>, <strong>TypeScript<\/strong>, and <strong>Azure<\/strong>, this project not only delivered immediate value to <strong>Transport for NSW<\/strong> but also set a benchmark for the future of integrated data visualization in enterprise tools.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0fe5031 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0fe5031\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-extended\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7bb85b5 sc_layouts_column_icons_position_left\" data-id=\"7bb85b5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a8146ec elementor-widget elementor-widget-spacer\" data-id=\"a8146ec\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6ccebae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6ccebae\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-extended\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-639e7f4 sc_layouts_column_icons_position_left\" data-id=\"639e7f4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3663043 elementor-widget elementor-widget-video\" data-id=\"3663043\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=JbDkImK7bzQ&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c3d134c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c3d134c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-extended\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-40cdd1d sc_layouts_column_icons_position_left\" data-id=\"40cdd1d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>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&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[],"class_list":["post-1283","post","type-post","status-publish","format-standard","hentry","category-web"],"_links":{"self":[{"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/1283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=1283"}],"version-history":[{"count":10,"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/1283\/revisions"}],"predecessor-version":[{"id":1294,"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/1283\/revisions\/1294"}],"wp:attachment":[{"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=1283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=1283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ghafari.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=1283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}