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 the Power BI Service.
- Practical applications in engineering, construction, and BIM.
- Understanding the underlying architecture of Power BI.
Data Retrieval and Connectivity
- Establishing connections with various data sources (SQL, Excel, cloud platforms).
- Ingesting both structured and semi-structured data formats.
- Configuring scheduled and real-time data refresh mechanisms.
Data Preparation and Modeling
- Utilizing Power Query for data transformation.
- Defining relationships between different datasets.
- Constructing reusable and efficient data models.
Creating Visual Reports
- Developing dashboards featuring charts, maps, and tables.
- Implementing drill-through capabilities and filter-based interactions.
- Applying custom visuals and design best practices.
Leveraging AI Tools for Trend Analysis
- Utilizing Power BI AI visuals and smart narrative features.
- Identifying trends and generating time-based insights.
- Performing forecasting using built-in analytical tools.
BIM Data Integration
- Exporting data from BIM applications (such as Revit and Navisworks).
- Structuring BIM data for compatibility with Power BI.
- Visualizing key BIM metrics and model attributes.
Publishing and Collaboration
- Distributing content to the Power BI Service.
- Managing workspaces and user access permissions.
- Sharing reports with internal and external stakeholders.
Conclusion and Future Directions
Requirements
- A solid grasp of data structures and visualization principles.
- Proficiency with Excel or comparable software tools.
- While familiarity with BIM workflows is advantageous, it is not a strict requirement.
Target Audience
- Managers focused on innovation and technology development.
- Data analysts specializing in construction or engineering datasets.
- BIM specialists looking to refine their data reporting capabilities.
Testimonials (2)
The most valuable takeaway was learning how to apply the concepts in real-world scenarios and understanding the tools and processes.
Marcel Tansae - DB Technology
Course - Microsoft Power Automate
How to use relationships in Power BIand the differences between columns and measurements
