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 Extraction and Connectivity
- Linking to various data sources (SQL, Excel, cloud)
- Ingesting structured and semi-structured data
- Utilizing scheduled and real-time refresh capabilities
Data Preparation and Modeling
- Manipulating data via Power Query
- Establishing relationships between datasets
- Constructing reusable data models
Creating Visual Reports
- Building dashboards featuring charts, maps, and tables
- Drill-through functionality and filter-driven interactions
- Custom visuals and design best practices
Leveraging AI Tools for Trend Analysis
- Employing Power BI AI visuals and intelligent narratives
- Pattern recognition and time-based insights
- Predictive analysis using integrated analytics tools
BIM Data Integration
- Exporting data from BIM tools (e.g., Revit, Navisworks)
- Organizing BIM data for Power BI compatibility
- Visualizing BIM-related metrics and model attributes
Publishing and Distribution
- Deploying to Power BI Service
- Workspace configuration and access control
- Sharing reports internally and externally
Recap and Future Directions
Requirements
- A solid grasp of data structures and visualization principles
- Proficiency with Excel or comparable 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
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.