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 the Power BI Service.
- Application scenarios in engineering, construction, and BIM.
- Understanding the underlying architecture of Power BI.
Data Retrieval and Connectivity
- Establishing connections to various data sources (SQL, Excel, cloud-based).
- Ingesting structured and semi-structured data.
- Configuring scheduled and real-time refresh options.
Data Preparation and Modeling
- Transforming datasets using Power Query.
- Defining relationships between different data sets.
- Constructing reusable and efficient data models.
Developing Visual Reports
- Creating dashboards featuring charts, maps, and tables.
- Implementing drill-through and filter-based interactions.
- Utilizing custom visuals and adhering to design best practices.
Utilizing AI Tools for Trend Analysis
- Leveraging Power BI AI visuals and smart narratives.
- Identifying trends and gaining time-based insights.
- Generating forecasts using built-in analytics features.
BIM Data Integration
- Exporting data from BIM software (e.g., Revit, Navisworks).
- Structuring BIM data for compatibility with Power BI.
- Visualizing key BIM metrics and model attributes.
Publication and Collaboration
- Publishing content to the Power BI Service.
- Managing workspaces and user access permissions.
- Sharing reports with internal teams and external stakeholders.
Conclusion and Future Directions
Requirements
- Foundational understanding of data structures and visualization principles.
- Practical experience with Excel or comparable spreadsheet tools.
- Familiarity with BIM workflows is advantageous but not mandatory.
Target Audience
- Managers in innovation and technology development.
- Data analysts handling construction or engineering datasets.
- BIM professionals aiming 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
Method of training.
