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 scenarios in engineering, construction, and BIM
- Structural overview of the Power BI architecture
Data Retrieval and Connectivity
- Establishing connections to multiple sources (SQL, Excel, cloud platforms)
- Ingesting structured and semi-structured data
- Implementing scheduled and real-time data refresh mechanisms
Data Preparation and Modeling
- Transforming datasets using Power Query
- Defining relationships between various datasets
- Developing reusable data models
Creating Visual Reports
- Designing dashboards featuring charts, maps, and tables
- Implementing drill-through and filter-based interactions
- Utilizing custom visuals and adhering to design best practices
Leveraging AI Tools for Trend Analysis
- Applying Power BI AI visuals and smart narratives
- Detecting trends and extracting time-based insights
- Generating forecasts using integrated analytics features
Integration with BIM Data
- Exporting data from BIM software (e.g., Revit, Navisworks)
- Structuring BIM data for Power BI compatibility
- Visualizing BIM-specific metrics and model attributes
Publishing and Distribution
- Deploying content to Power BI Service
- Managing workspaces and access controls
- Sharing reports across internal and external stakeholders
Summary and Future Directions
Requirements
- A foundational understanding of data structures and visualization principles
- Practical experience with Excel or comparable analytical tools
- Knowledge of BIM workflows is beneficial but not mandatory
Target Audience
- Managers in innovation and technology development
- Data analysts handling construction or engineering datasets
- BIM specialists looking to improve 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.
