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.
- Application cases in engineering, construction, and BIM.
- Overview of Power BI architecture.
Data Retrieval and Connectivity
- Connecting to various data sources (SQL, Excel, cloud).
- Importing structured and semi-structured data.
- Utilizing scheduled and real-time refresh options.
Data Preparation and Modeling
- Transforming data using Power Query.
- Establishing relationships between datasets.
- Constructing reusable data models.
Creating Visual Reports
- Building dashboards with charts, maps, and tables.
- Implementing drill-through and filter-based interactions.
- Custom visuals and design best practices.
Leveraging AI Tools for Trend Analysis
- Utilizing Power BI AI visuals and smart narratives.
- Detecting trends and gaining time-based insights.
- Forecasting using built-in analytics tools.
Integrating BIM Data
- Exporting data from BIM tools (e.g., Revit, Navisworks).
- Structuring BIM data for compatibility with Power BI.
- Visualizing BIM-related metrics and model attributes.
Publishing and Sharing
- Publishing reports to Power BI Service.
- Managing workspaces and access permissions.
- Sharing reports both internally and externally.
Summary and Future Steps
Requirements
- A solid grasp of data structures and visualization concepts.
- Practical experience with Excel or comparable tools.
- Familiarity with BIM processes is beneficial but not mandatory.
Target Audience
- Innovation and technology development managers.
- Data analysts working with construction or engineering data.
- BIM professionals aiming to enhance 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
