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 the Power BI Service.
- Practical applications in engineering, construction, and BIM.
- Understanding the underlying architecture of Power BI.
Data Retrieval and Connectivity
- Establishing connections to diverse data sources (SQL, Excel, cloud platforms).
- Importing both structured and semi-structured data formats.
- Configuring scheduled refreshes and real-time data updates.
Data Preparation and Modelling
- Transforming raw data using Power Query.
- Defining relationships between disparate datasets.
- Constructing robust, reusable data models.
Developing Visual Reports
- Building interactive dashboards featuring charts, maps, and tables.
- Implementing drill-through capabilities and filter-based interactions.
- Applying custom visuals and adhering to design best practices.
Leveraging AI for Trend Analysis
- Utilising Power BI AI visuals and intelligent narrative features.
- Identifying trends and extracting time-based insights.
- Generating forecasts with integrated analytics tools.
BIM Data Integration
- Extracting data from BIM platforms (e.g., Revit, Navisworks).
- Structuring BIM data for optimal Power BI compatibility.
- Visualising key BIM metrics and model attributes.
Publishing and Distribution
- Deploying reports to the Power BI Service.
- Managing workspaces and user access permissions.
- Sharing reports with internal teams and external stakeholders.
Summary and Future Directions
Requirements
- A solid grasp of data structures and visualisation principles.
- Proficiency with Excel or comparable productivity tools.
- Knowledge of BIM processes is advantageous, though not mandatory.
Target Audience
- Innovation and technology development managers.
- Data analysts focused on construction or engineering datasets.
- BIM professionals 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
Method of training.
