Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Power BI
- Overview of Power BI Desktop and Service
- Application use cases in engineering, construction, and BIM
- Understanding the architecture of Power BI
Data Retrieval and Connectivity
- Establishing connections to multiple data sources (SQL, Excel, cloud)
- Ingesting structured and semi-structured data
- Utilising scheduled and real-time refresh mechanisms
Data Preparation and Modelling
- Transforming data using Power Query
- Establishing relationships between different datasets
- Constructing reusable data models
Creating Visual Reports
- Building dashboards featuring charts, maps, and tables
- Implementing drill-through and filter-based interactions
- Utilising custom visuals and adhering to design best practices
Leveraging AI Tools for Trend Analysis
- Using Power BI AI visuals and intelligent narratives
- Identifying trends and extracting time-based insights
- Applying built-in analytics tools for forecasting
BIM Data Integration
- Exporting data from BIM tools (e.g., Revit, Navisworks)
- Structuring BIM data for compatibility with Power BI
- Visualising BIM-related metrics and model attributes
Publishing and Collaboration
- Publishing content to the Power BI Service
- Managing workspaces and user access
- Sharing reports with internal and external stakeholders
Summary and Future Directions
Requirements
- A foundational understanding of data structures and visualisation concepts.
- Proficiency with Excel or comparable spreadsheet tools.
- Familiarity with BIM processes is beneficial but not mandatory.
Target Audience
- Innovation and technology development managers.
- Data analysts handling construction or engineering data.
- BIM specialists looking to enhance their data reporting skills.
21 Hours
Testimonials (2)
How to use relationships in Power BIand the differences between columns and measurements
LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Method of training.