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.
Duration 21 hours
Course Outline
Introduction to Power BI
- Overview of Power BI Desktop and Service
- Applications in engineering, construction, and BIM
- Architectural overview of Power BI
Data Retrieval and Connectivity
- Establishing connections to multiple sources (SQL, Excel, cloud)
- Importing both structured and semi-structured datasets
- Utilizing scheduled and real-time refresh capabilities
Data Preparation and Modeling
- Transforming data using Power Query
- Defining relationships between various datasets
- Constructing reusable data models
Creating Visual Reports
- Designing dashboards featuring charts, maps, and tables
- Implementing drill-through and filter-based interactions
- Best practices for custom visuals and design
Leveraging AI for Trend Analysis
- Utilizing Power BI AI visuals and intelligent narratives
- Detecting trends and generating time-based insights
- Forecasting using integrated analytics tools
BIM Data Integration
- Exporting data from BIM software (e.g., Revit, Navisworks)
- Structuring BIM data for compatibility with Power BI
- Visualizing BIM-specific metrics and model attributes
Publishing and Sharing
- Deploying content to the Power BI Service
- Managing workspaces and user access
- Distributing reports internally and externally
Summary and Future Steps
Requirements
- A solid grasp of data structures and visualization principles.
- Proficiency with Excel or comparable tools.
- Knowledge of BIM processes is beneficial, though not mandatory.
Target Audience
- Managers in innovation and technology development.
- Data analysts handling construction or engineering data.
- BIM specialists looking to improve their data reporting workflows.
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.