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
- Practical applications in engineering, construction, and BIM
- Understanding the Power BI architecture
Data Retrieval and Connection
- Establishing connections to diverse data sources (SQL, Excel, cloud)
- Importing both structured and semi-structured data
- Utilizing scheduled and real-time refresh mechanisms
Data Preparation and Modeling
- Data transformation using Power Query
- Defining relationships among different datasets
- Constructing reusable data models
Building Visual Reports
- Developing dashboards featuring charts, maps, and tables
- Implementing drill-through and filter-based interactions
- Custom visuals and design best practices
Applying AI Tools for Trend Analysis
- Leveraging Power BI AI visuals and smart narratives
- Detecting trends and deriving time-based insights
- Forecasting using built-in analytics features
Integrating with BIM Data
- Exporting data from BIM tools (e.g., Revit, Navisworks)
- Structuring BIM data for compatibility with Power BI
- Visualizing BIM-specific metrics and model attributes
Publishing and Sharing
- Deploying to Power BI Service
- Managing workspaces and access controls
- Sharing reports internally and externally
Summary and Next Steps
Requirements
- A foundational grasp of data structures and visualization principles
- Proficiency with Excel or comparable software
- Knowledge of BIM processes is advantageous but not mandatory
Target Audience
- Managers in innovation and technology development
- Data analysts handling construction or engineering datasets
- BIM specialists aiming 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.
