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 Service.
- Relevant use cases in engineering, construction, and BIM.
- Overview of Power BI architecture.
Data Retrieval and Connection
- Connecting to multiple data sources (SQL, Excel, cloud).
- Importing structured and semi-structured data.
- Utilizing scheduled and real-time refresh options.
Data Preparation and Modeling
- Transforming data with Power Query.
- Establishing relationships between data sets.
- Building reusable data models.
Building Visual Reports
- Creating 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
- Using Power BI AI visuals and smart narratives.
- Detecting trends and generating time-based insights.
- Forecasting with 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 the Power BI Service.
- Managing workspaces and access rights.
- Sharing reports both internally and externally.
Summary and Next Steps
Requirements
- A foundational understanding of data structures and visualization concepts.
- Practical experience with Excel or similar tools.
- Familiarity with BIM processes is beneficial but not mandatory.
Audience
- Innovation and technology development managers.
- Data analysts working with construction or engineering data.
- BIM professionals looking to enhance 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 -