Posts

Showing posts from May, 2024

Wedding Bells are Ringing – MS Visio and Power BI Hand in Hand

Image
Microsoft Visio and Power BI can integrate, enabling users to visualize data in Power BI dashboards using Visio diagrams. This combination allows you to present data through charts, graphs, and visually detailed diagrams mapping processes, networks, and organizational structures. 1. Why Integrate Visio and Power BI? Integrating Visio with Power BI provides visual context to your data: Enrich dashboards with process flows, system architecture diagrams, or visual layouts. Provide interactive data-driven diagrams showing real-time performance or relationships. Create holistic visual reports combining data analysis with spatial or logical diagrams. 2. How Does It Work? a. Create Your Visio Diagram Create your Visio diagram, ensuring shapes are data-linked to sources like Excel, SharePoint, or SQL Server. b. Embed Visio into Power BI In Power BI, go to the Visualizations pane and click the Visio Visual icon...

Digital Twin – How to Make Things from Their Own Image

Image
Introduction During my contract at the MTA, I had the opportunity to transform how the department of subways managed its data. Instead of relying on the standard Extract, Transform, Load (ETL) methods, I introduced the concept of Digital Twins. This innovative approach enabled us to capture and digitize the tacit knowledge of team members, allowing us to convert hidden data into actionable insights for improved departmental management. What is a Digital Twin? A Digital Twin is a virtual representation of a physical entity, system, or process that mirrors its real-time conditions, behaviors, and attributes. It acts as a bridge between the physical and digital worlds, allowing for monitoring, simulation, and optimization of systems. The Process of Implementing Digital Twins at MTA Understanding the Current Landscape: Engaged with team members to understand existing processes, challenges, and hidden knowledge that was not capt...