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
- An overview of Power BI Desktop and Power BI Service.
- Key use cases within engineering, construction, and BIM sectors.
- A look at the underlying architecture of Power BI.
Data Retrieval and Connectivity
- Establishing connections to diverse data sources, including SQL, Excel, and cloud services.
- Ingesting both structured and semi-structured data formats.
- Configuring scheduled and real-time data refresh capabilities.
Data Preparation and Modeling
- Manipulating and transforming data using Power Query.
- Defining logical relationships across different 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.
- Utilizing custom visuals and adhering to design best practices.
Leveraging AI for Trend Analysis
- Harnessing Power BI’s AI visuals and intelligent narrative features.
- Identifying trends and gaining time-based insights.
- Applying built-in analytics tools for accurate forecasting.
BIM Data Integration
- Exporting data from common BIM tools such as Revit and Navisworks.
- Organizing BIM data to ensure compatibility with Power BI.
- Visualizing key BIM metrics and model attributes effectively.
Publishing and Distribution
- Publishing reports to the Power BI Service.
- Managing workspaces and controlling user access.
- Sharing reports with both internal teams and external stakeholders.
Conclusion and Path Forward
Requirements
- A solid grasp of data structures and visualization principles.
- Practical experience with Excel or comparable spreadsheet applications.
- While familiarity with BIM workflows is advantageous, it is not a strict requirement.
Target Audience
- Managers in innovation and technology development.
- Data analysts specializing in construction or engineering datasets.
- BIM experts aiming to refine their data reporting capabilities.
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.
