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
Getting Started with Power BI
- Introduction to Power BI Desktop and the Power BI Service
- Applications in engineering, construction, and BIM contexts
- Fundamental understanding of the Power BI architecture
Data Access and Connectivity
- Establishing connections to diverse sources such as SQL, Excel, and cloud services
- Ingesting both structured and semi-structured data formats
- Configuring scheduled and instant data refresh strategies
Data Transformation and Modeling
- Processing and refining data using Power Query
- Defining logical connections between different data collections
- Developing efficient, reusable data models
Crafting Visual Analytics
- Building dashboards utilizing charts, maps, and tabular displays
- Implementing drill-through features and dynamic filtering interactions
- Leveraging custom visuals and adhering to design best practices
Utilizing AI for Pattern Recognition
- Integrating Power BI’s AI visuals and intelligent narrative features
- Identifying temporal trends and generating time-based insights
- Generating forecasts with native analytics capabilities
Bridging Power BI and BIM Data
- Extracting data from BIM software like Revit and Navisworks
- Formatting BIM information for optimal compatibility with Power BI
- Visualizing key BIM metrics and model characteristics
Distribution and Collaboration
- Deploying solutions to the Power BI Service
- Managing workspaces and controlling user access
- Facilitating internal and external report sharing
Conclusion and Future Directions
Requirements
- A solid grasp of data organization and visualization principles
- Proficiency with Excel or comparable spreadsheet applications
- Familiarity with BIM workflows is an asset, though not mandatory
Target Audience
- Leaders in innovation and technology development
- Data analysts specializing in construction or engineering sectors
- BIM experts looking to elevate their 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
