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 scenarios in engineering, construction, and BIM
- Architectural overview of Power BI
Data Retrieval and Connectivity
- Establishing connections to multiple data sources (SQL, Excel, cloud)
- Importing structured and semi-structured data formats
- Utilising scheduled and real-time refresh options
Data Preparation and Modelling
- Data transformation using Power Query
- Defining relationships between datasets
- Constructing reusable data models
Developing Visual Reports
- Creating dashboards with charts, maps, and tables
- Implementing drill-through and filter-based interactions
- Custom visuals and design best practices
Applying AI Tools for Trend Analysis
- Leveraging Power BI AI visuals and smart narratives
- Trend detection and time-based insights
- Forecasting using built-in analytics tools
Integrating with BIM Data
- 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 Sharing
- Publishing reports to Power BI Service
- Workspace and access management
- Sharing reports both internally and externally
Summary and Next Steps
Requirements
- A solid understanding of data structures and visualisation concepts
- Prior experience with Excel or comparable tools
- Familiarity with BIM processes is beneficial but not mandatory
Target Audience
- Managers in innovation and technology development
- Data analysts working with construction or engineering datasets
- BIM professionals aiming to enhance their data reporting capabilities
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.