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
- An overview of Power BI Desktop and Service
- Application scenarios in engineering, construction, and BIM
- Overview of the Power BI architecture
Data Extraction and Connectivity
- Establishing connections to various data sources (SQL, Excel, cloud)
- Ingesting structured and semi-structured data
- Utilizing scheduled and real-time refresh features
Data Processing and Modeling
- Data transformation using Power Query
- Establishing relationships between datasets
- Developing reusable data models
Developing Visual Reports
- Constructing dashboards with charts, maps, and tables
- Interactions based on drill-through and filters
- Custom visuals and design best practices
Leveraging AI Tools for Trend Analysis
- Utilizing Power BI AI visuals and smart narratives
- Identifying trends and deriving time-based insights
- Performing forecasts with built-in analytics tools
Integrating BIM Data
- Exporting data from BIM tools (e.g., Revit, Navisworks)
- Organizing BIM data for compatibility with Power BI
- Visualizing BIM-related metrics and model attributes
Publishing and Distribution
- Publishing content to Power BI Service
- Managing workspaces and access permissions
- Distributing reports internally and externally
Conclusion and Subsequent Steps
Requirements
- A solid grasp of data structures and visualization concepts.
- Proficiency with Excel or comparable tools.
- Knowledge of BIM processes is advantageous but not mandatory.
Target Audience
- Innovation and technology development managers.
- Data analysts handling construction or engineering data.
- BIM specialists looking to improve 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
engagement with the attendees