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
- Understanding Power BI Desktop and Service capabilities
- Practical applications in engineering, construction, and BIM contexts
- Foundational overview of Power BI architecture
Data Retrieval and Connectivity
- Establishing connections to diverse data sources (SQL, Excel, cloud platforms)
- Importing both structured and semi-structured data formats
- Configuring scheduled and real-time data refresh mechanisms
Data Preparation and Modeling
- Transforming raw data using Power Query
- Defining relationships between various datasets
- Constructing reusable and scalable data models
Constructing Visual Reports
- Designing dashboards featuring charts, maps, and tables
- Implementing drill-through features and filter-based interactions
- Applying custom visuals and adhering to design best practices
Leveraging AI for Trend Analysis
- Utilizing Power BI AI visuals and smart narrative features
- Identifying trends and extracting time-based insights
- Performing forecasting using built-in analytical tools
BIM Data Integration
- Extracting data from BIM tools (such as Revit and Navisworks)
- Structuring BIM data for optimal Power BI compatibility
- Visualizing BIM-specific metrics and model attributes
Publishing and Distribution
- Publishing content to Power BI Service
- Managing workspaces and user access controls
- Distributing reports for internal and external stakeholders
Recap and Future Directions
Requirements
- A solid understanding of data structures and visualization principles
- Proficiency with Excel or comparable spreadsheet tools
- Familiarity with BIM workflows is beneficial, though not mandatory
Target Audience
- Innovation and technology development managers
- Data analysts handling construction or engineering datasets
- BIM specialists aiming to elevate 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
Method of training.
