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 components
- Use cases in engineering, construction, and BIM sectors
- Architectural overview of Power BI
Data Retrieval and Connectivity
- Establishing connections to multiple data sources (SQL, Excel, cloud)
- Importing structured and semi-structured data formats
- Utilizing scheduled and real-time refresh capabilities
Data Preparation and Modeling
- Data transformation using Power Query
- Defining relationships between different data sets
- Constructing reusable data models
Developing Visual Reports
- Designing dashboards incorporating charts, maps, and tables
- Implementing drill-through features 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
- Identifying trends and extracting time-based insights
- Performing forecasting using built-in analytics features
BIM Data Integration
- Exporting data from BIM tools (e.g., Revit, Navisworks)
- Structuring BIM data for Power BI compatibility
- Visualizing BIM-specific metrics and model attributes
Publishing and Collaboration
- Deploying reports to Power BI Service
- Managing workspaces and access permissions
- Sharing reports across internal and external stakeholders
Course Summary and Future Steps
Requirements
- Fundamental understanding of data structures and visualization principles
- Prior experience with Excel or similar analytical tools
- Familiarity with BIM processes is advantageous 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.