Get in Touch
 Duration 21 hours

Course Outline

Introduction to Power BI

  • Overview of Power BI Desktop and Power BI Service.
  • Application scenarios in engineering, construction, and BIM.
  • Understanding the Power BI architecture.

Data Retrieval and Connectivity

  • Establishing connections to multiple data sources (SQL, Excel, cloud services).
  • Importing both structured and semi-structured data.
  • Utilizing scheduled and real-time refresh mechanisms.

Data Preparation and Modeling

  • Transforming data using Power Query.
  • Defining relationships between different datasets.
  • Constructing reusable data models.

Creating Visual Reports

  • Designing dashboards featuring charts, maps, and tables.
  • Implementing drill-through and filter-based interactions.
  • Applying custom visuals and design best practices.

Leveraging AI Tools for Trend Analysis

  • Utilizing Power BI AI visuals and smart narratives.
  • Identifying trends and extracting time-based insights.
  • Performing forecasting using built-in analytics tools.

Integration with BIM Data

  • Exporting data from BIM tools (e.g., Revit, Navisworks).
  • Structuring BIM data for compatibility with Power BI.
  • Visualizing BIM-specific metrics and model attributes.

Publishing and Distribution

  • Publishing reports to Power BI Service.
  • Managing workspaces and access controls.
  • Sharing reports with internal and external stakeholders.

Conclusion and Future Steps

Requirements

  • A foundational understanding of data structures and visualization principles.
  • Proficiency with Excel or comparable spreadsheet tools.
  • Knowledge of BIM processes is beneficial but not mandatory.

Target Audience

  • Innovation and technology development managers.
  • Data analysts handling construction or engineering datasets.
  • BIM professionals aiming to enhance their data reporting capabilities.

Number of participants


Price per participant

Testimonials (2)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories