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.
- Applications in engineering, construction, and BIM sectors.
- Understanding the architecture of Power BI.
Data Retrieval and Connectivity
- Establishing connections to multiple data sources such as SQL, Excel, and cloud services.
- Importing both structured and semi-structured datasets.
- Utilizing scheduled and real-time refresh mechanisms.
Data Preparation and Modeling
- Transforming data using Power Query.
- Defining relationships between different datasets.
- Constructing reusable data models.
Creating Visual Reports
- Building dashboards featuring charts, maps, and tables.
- Implementing drill-through and filter-based interactions.
- Incorporating custom visuals and adhering to design best practices.
Leveraging AI Tools for Trend Analysis
- Utilizing Power BI AI visuals and intelligent narratives.
- Identifying trends and deriving time-based insights.
- Performing forecasts using built-in analytical tools.
Integration with BIM Data
- Exporting data from BIM software such as Revit and Navisworks.
- Structuring BIM data to ensure compatibility with Power BI.
- Visualizing BIM-specific metrics and model attributes.
Publishing and Distribution
- Deploying reports to the Power BI Service.
- Managing workspaces and user access.
- Sharing reports with internal teams and external stakeholders.
Recap and Future Directions
Requirements
- A foundational understanding of data structures and visualization concepts.
- Practical experience with Excel or comparable analytical tools.
- Familiarity with BIM processes is beneficial but not mandatory.
Target Audience
- Innovation and technology development managers.
- Data analysts specializing in construction or engineering data.
- BIM professionals looking 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.
