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
- Applications in engineering, construction, and BIM contexts
- Architectural overview of the Power BI ecosystem
Data Retrieval and Connectivity
- Establishing connections to various data sources (SQL, Excel, cloud services)
- Ingesting both structured and semi-structured data formats
- Utilizing scheduled and real-time refresh mechanisms
Data Preparation and Modeling
- Data transformation workflows using Power Query
- Defining relationships between disparate datasets
- Constructing reusable data models
Developing Visual Reports
- Building dashboards incorporating charts, maps, and tabular data
- Implementing drill-through and filter-based interactivity
- Employing custom visuals and adhering to design best practices
Leveraging AI for Trend Analysis
- Utilizing Power BI AI visuals and intelligent narrative features
- Identifying trends and extracting time-based insights
- Performing forecasting using integrated analytics tools
BIM Data Integration
- Extracting data from BIM applications (e.g., Revit, Navisworks)
- Organizing BIM data for optimal Power BI compatibility
- Visualizing key BIM metrics and model attributes
Publishing and Collaboration
- Deploying reports to Power BI Service
- Managing workspaces and user access controls
- Sharing reports with internal teams and external stakeholders
Conclusion and Future Directions
Requirements
- Foundational knowledge of data structures and visualization principles
- Proficiency with Excel or comparable data analysis tools
- Prior exposure to BIM processes is advantageous but not mandatory
Target Audience
- Managers in innovation and technology development
- Data analysts specializing in construction or engineering sectors
- BIM specialists aiming to refine their 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
The basic structure of Power BI, its main functions, as well as some advanced functions
