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.
Duration 21 hours
Course Outline
Introduction to Power BI
- Overview of Power BI Desktop and Service
- Applications in engineering, construction, and BIM
- Architectural overview of Power BI
Data Retrieval and Connectivity
- Establishing connections to diverse data sources (SQL, Excel, cloud)
- Ingesting structured and semi-structured data
- Utilizing scheduled and real-time refresh mechanisms
Data Preparation and Modeling
- Data transformation using Power Query
- Establishing relationships between datasets
- Constructing reusable data models
Constructing Visual Reports
- Developing dashboards featuring charts, maps, and tables
- Implementing drill-through and filter-based interactions
- Incorporating custom visuals and adhering to design best practices
Leveraging AI Tools for Trend Analysis
- Utilizing Power BI AI visuals and intelligent narratives
- Detecting trends and deriving time-based insights
- Performing forecasting using built-in analytical tools
BIM Data Integration
- Exporting data from BIM tools (e.g., Revit, Navisworks)
- Structuring BIM data for Power BI compatibility
- Visualizing BIM-specific metrics and model attributes
Publishing and Distribution
- Publishing content to the Power BI Service
- Managing workspaces and access controls
- Sharing reports with internal and external stakeholders
Summary and Future Steps
Requirements
- Foundational knowledge of data structures and visualization principles
- Proficiency with Excel or comparable tools
- Familiarity with BIM workflows is beneficial but not mandatory
Target Audience
- Innovation and technology development managers
- Data analysts handling construction or engineering datasets
- BIM specialists aiming to refine data reporting capabilities
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.