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
- Practical applications in engineering, construction, and BIM
- Understanding the Power BI architecture
Data Retrieval and Connectivity
- Establishing connections to multiple data sources (SQL, Excel, cloud platforms)
- Importing both structured and semi-structured datasets
- Configuring scheduled and real-time data refresh options
Data Preparation and Modeling Strategies
- Transforming raw data using Power Query
- Defining relationships between different data sets
- Constructing scalable and reusable data models
Developing Visual Reports
- Building dashboards featuring charts, maps, and tabular data
- Implementing drill-through functionality 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 generating smart narratives
- Identifying trends and deriving time-based insights
- Performing forecasting using built-in analytical tools
Integration with BIM Data Ecosystems
- Extracting data from BIM tools (e.g., Revit, Navisworks)
- Structuring BIM data for optimal Power BI compatibility
- Visualizing key BIM metrics and model attributes
Publishing and Distribution
- Deploying content to the Power BI Service
- Managing workspaces and access permissions
- Sharing reports with internal teams and external stakeholders
Recap and Future Recommendations
Requirements
- Foundational knowledge of data structures and visualization principles
- Proficiency with Excel or comparable analytical tools
- Familiarity with BIM processes is beneficial but not mandatory
Target Audience
- Managers in innovation and technology development
- Data analysts handling construction or engineering datasets
- BIM specialists looking to refine their data reporting skills
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.
