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
- Understanding Power BI Desktop and Service components
- Practical applications in engineering, construction, and BIM contexts
- Architectural overview of the Power BI ecosystem
Data Retrieval and Connectivity
- Establishing connections with diverse sources (SQL, Excel, cloud platforms)
- Ingesting both structured and semi-structured data formats
- Utilizing scheduled and real-time refresh mechanisms
Data Preparation and Modeling
- Data transformation processes via Power Query
- Defining relationships between distinct datasets
- Constructing scalable and reusable data models
Developing Visual Reports
- Building dashboards featuring charts, maps, and tabular data
- Implementing drill-through features and filter-based interactions
- Custom visuals and adherence to design best practices
Leveraging AI for Trend Analysis
- Employing Power BI AI visuals and intelligent narrative generation
- Detecting trends and deriving time-based insights
- Generating forecasts using native analytics capabilities
BIM Data Integration
- Extracting data from BIM software such as Revit and Navisworks
- Organizing BIM data structures for Power BI compatibility
- Visualizing key BIM metrics and model attributes
Publishing and Distribution
- Deploying assets to the Power BI Service
- Managing workspaces and user access rights
- Distributing reports to internal teams and external stakeholders
Concluding Summary and Future Directions
Requirements
- Solid grasp of data structures and visualization principles
- Proficiency with Excel or comparable spreadsheet applications
- Working knowledge of BIM procedures is advantageous, though not mandatory
Target Audience
- Leaders in innovation and technology development
- Data analysts handling construction or engineering datasets
- BIM specialists looking to refine their 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.
