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.
Course Outline
Introduction to Power BI
- Overview of Power BI Desktop and Power BI Service.
- Relevant use cases within engineering, construction, and BIM.
- Overview of Power BI architecture.
Data Retrieval and Connection
- Connecting to diverse data sources (SQL, Excel, cloud environments).
- Importing structured and semi-structured data.
- Utilizing scheduled and real-time data refresh options.
Data Preparation and Modeling
- Transforming data using Power Query.
- Establishing relationships between different data sets.
- Constructing reusable data models.
Building Visual Reports
- Designing dashboards with charts, maps, and tables.
- Implementing drill-through and filter-based interactions.
- Applying custom visuals and design best practices.
Applying AI Tools for Trend Analysis
- Leveraging Power BI AI visuals and smart narratives.
- Identifying trends and gaining time-based insights.
- Forecasting utilizing built-in analytics tools.
Integrating with 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 internally and with external stakeholders.
Summary and Next Steps
Requirements
- A foundational understanding of data structures and visualization concepts.
- Practical experience with Excel or similar spreadsheet tools.
- Familiarity with BIM processes is advantageous but not mandatory.
Target Audience
- Managers focused on innovation and technology development.
- Data analysts working with construction or engineering datasets.
- BIM professionals looking to upgrade their data reporting capabilities.
21 Hours
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
- Building dashboards - Learning the counts and SUMs and SWITCH -