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 Power BI Service
- Use cases within engineering, construction, and BIM sectors
- Understanding the Power BI architecture
Data Retrieval and Connectivity
- Connecting to various data sources (SQL, Excel, cloud)
- Importing both structured and semi-structured data
- Utilizing scheduled and real-time refresh capabilities
Data Preparation and Modelling
- Transforming data using Power Query
- Establishing relationships between different datasets
- Constructing reusable data models
Developing Visual Reports
- Building dashboards featuring charts, maps, and tables
- Implementing drill-through and filter-based interactions
- Applying custom visuals and design best practices
Utilizing AI Tools for Trend Analysis
- Leveraging Power BI AI visuals and smart narratives
- Detecting trends and extracting time-based insights
- Performing forecasts with built-in analytics tools
BIM Data Integration
- Exporting data from BIM tools (e.g., Revit, Navisworks)
- Structuring BIM data for Power BI compatibility
- Visualizing BIM-related metrics and model attributes
Publishing and Collaboration
- Publishing reports to the Power BI Service
- Managing workspaces and access permissions
- Sharing reports with internal and external stakeholders
Summary and Recommended Next Steps
Requirements
- A solid grasp of data structures and visualisation concepts
- Practical experience with Excel or comparable tools
- Familiarity with BIM processes is beneficial but not mandatory
Target Audience
- Innovation and technology development managers
- Data analysts working with construction or engineering data
- BIM professionals aiming to enhance 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
engagement with the attendees