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 functionalities.
- Application scenarios in engineering, construction, and BIM.
- Understanding the underlying architecture of Power BI.
Data Retrieval and Connection
- Establishing connections to various data sources (SQL, Excel, cloud).
- Ingesting both structured and semi-structured data formats.
- Utilizing scheduled and real-time refresh mechanisms.
Data Preparation and Modeling
- Data transformation techniques using Power Query.
- Defining relationships between different datasets.
- Constructing reusable and robust data models.
Building Visual Reports
- Designing dashboards with charts, maps, and tabular views.
- Implementing drill-through and filter-based interactions.
- Applying custom visuals and adhering to design best practices.
Applying AI Tools for Trend Analysis
- Leveraging Power BI AI visuals and smart narratives.
- Identifying trends and extracting time-based insights.
- Performing forecasting using integrated analytics tools.
Integrating with BIM Data
- Exporting data from BIM applications (e.g., Revit, Navisworks).
- Organizing BIM data for optimal Power BI compatibility.
- Visualizing BIM-related metrics and model attributes.
Publishing and Sharing
- Deploying reports to the Power BI Service.
- Managing workspaces and user access controls.
- Distributing reports to internal teams and external stakeholders.
Summary and Next Steps
Requirements
- A foundational grasp of data structures and visualization principles.
- Practical experience with Excel or comparable data tools.
- Knowledge of BIM workflows is advantageous but not mandatory.
Target Audience
- Innovation and technology development managers.
- Data analysts specializing in construction or engineering datasets.
- BIM professionals aiming 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
