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
- Review of Power BI Desktop and Service components
- Application scenarios in engineering, construction, and BIM
- Architectural overview of the Power BI ecosystem
Data Acquisition and Connectivity
- Establishing connections to varied data sources (SQL, Excel, cloud platforms)
- Ingesting both structured and semi-structured information
- Utilizing scheduled and live refresh mechanisms
Data Processing and Modeling
- Data transformation via Power Query
- Establishing links across different datasets
- Constructing scalable, reusable data models
Developing Visual Reports
- Building dashboards incorporating charts, maps, and tabular data
- Implementing drill-down capabilities and filter-driven interactions
- Custom visuals and adherence to design standards
Leveraging AI for Trend Analysis
- Utilizing Power BI’s AI visuals and intelligent narratives
- Identifying trends and extracting time-series insights
- Generating forecasts using integrated analytical tools
BIM Data Integration
- Exporting information from BIM applications (such as Revit and Navisworks)
- Organizing BIM data for compatibility with Power BI
- Visualizing key BIM metrics and model characteristics
Distribution and Collaboration
- Publishing content to the Power BI Service
- Managing workspaces and access permissions
- Distributing reports to internal and external stakeholders
Wrap-up and Future Directions
Requirements
- A foundational grasp of data structures and visualization principles
- Prior experience with Excel or comparable applications
- Knowledge of BIM workflows is advantageous but not mandatory
Target Audience
- Managers in innovation and technology development
- 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.