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
- Application cases in engineering, construction, and BIM
- Understanding Power BI architecture
Data Retrieval and Connectivity
- Establishing connections to multiple data sources (SQL, Excel, cloud)
- Importing structured and semi-structured data
- Utilizing scheduled and real-time refresh options
Data Preparation and Modeling
- Transforming data using Power Query
- Defining relationships between datasets
- Constructing reusable data models
Creating Visual Reports
- Building dashboards with charts, maps, and tables
- Implementing drill-through and filter-based interactions
- Custom visuals and design best practices
Leveraging AI Tools for Trend Analysis
- Utilizing Power BI AI visuals and smart narratives
- Detecting trends and deriving time-based insights
- Forecasting using built-in analytics features
Integration with BIM Data
- 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
- Publishing to Power BI Service
- Managing workspaces and access controls
- Sharing reports both internally and externally
Summary and Next Steps
Requirements
- A solid grasp of data structures and visualization concepts
- Proficiency with Excel or comparable tools
- Familiarity with BIM processes is advantageous but not mandatory
Target Audience
- Innovation and technology development managers
- Data analysts handling construction or engineering data
- BIM professionals looking to enhance 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.
