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
- Applications in engineering, construction, and BIM
- Understanding Power BI architecture
Data Retrieval and Connectivity
- Establishing connections to diverse data sources (SQL, Excel, cloud)
- Importing 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
Developing Visual Reports
- Creating dashboards featuring charts, maps, and tables
- Implementing drill-through and filter-based interactions
- Custom visuals and design best practices
Leveraging AI Tools for Trend Analysis
- Applying Power BI AI visuals and smart narratives
- Identifying trends and time-based insights
- Forecasting using built-in analytics capabilities
BIM Data Integration
- Exporting data from BIM tools (e.g., Revit, Navisworks)
- Structuring BIM data for Power BI compatibility
- Visualizing BIM-related metrics and model attributes
Publishing and Sharing
- Deploying to Power BI Service
- Managing workspaces and access permissions
- Distributing reports internally and externally
Summary and Next Steps
Requirements
- Foundational understanding of data structures and visualization concepts
- Proficiency with Excel or similar data tools
- Knowledge of BIM processes is beneficial but not mandatory
Target Audience
- Managers in innovation and technology development
- Data analysts specializing in construction or engineering data
- BIM professionals aiming to enhance 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