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
- Review of Power BI Desktop and Service components
- Application scenarios in engineering, construction, and BIM
- Fundamental architecture of Power BI
Data Acquisition and Connectivity
- Establishing links to diverse sources such as SQL, Excel, and cloud services
- Ingesting both structured and semi-structured datasets
- Configuring scheduled updates and real-time refresh mechanisms
Data Processing and Modeling
- Manipulating data via Power Query
- Defining connections between different datasets
- Constructing reusable data models
Developing Visual Reports
- Designing dashboards featuring charts, maps, and tabular data
- Implementing drill-through features and filter-based interactions
- Utilizing custom visuals and adhering to design best practices
Leveraging AI for Trend Analysis
- Utilizing Power BI AI visuals and intelligent narratives
- Identifying trends and gaining time-based insights
- Performing forecasts using integrated analytics tools
BIM Data Integration
- Extracting data from BIM applications like Revit and Navisworks
- Organizing BIM data to ensure compatibility with Power BI
- Displaying BIM-related metrics and model characteristics
Distribution and Collaboration
- Deploying content to Power BI Service
- Managing workspaces and access permissions
- Sharing reports with internal and external stakeholders
Recap and Future Directions
Requirements
- Proficiency in data structures and visualization principles
- Practical experience with Excel or comparable analytical tools
- Knowledge of BIM workflows is advantageous but not mandatory
Target Audience
- Managers focused on innovation and technology development
- Data analysts specializing in construction or engineering datasets
- BIM specialists aiming to elevate 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
