Get in Touch

Course Outline

Introduction to Power BI

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

Data Extraction and Connectivity

  • Establishing connections to various data sources (SQL, Excel, cloud)
  • Ingesting structured and semi-structured data
  • Utilizing scheduled and real-time refresh features

Data Processing and Modeling

  • Data transformation using Power Query
  • Establishing relationships between datasets
  • Developing reusable data models

Developing Visual Reports

  • Constructing dashboards with charts, maps, and tables
  • Interactions based on drill-through and filters
  • Custom visuals and design best practices

Leveraging AI Tools for Trend Analysis

  • Utilizing Power BI AI visuals and smart narratives
  • Identifying trends and deriving time-based insights
  • Performing forecasts with built-in analytics tools

Integrating BIM Data

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

Publishing and Distribution

  • Publishing content to Power BI Service
  • Managing workspaces and access permissions
  • Distributing reports internally and externally

Conclusion and Subsequent Steps

Requirements

  • A solid grasp of data structures and visualization concepts.
  • Proficiency with Excel or comparable tools.
  • Knowledge of BIM processes is advantageous but not mandatory.

Target Audience

  • Innovation and technology development managers.
  • Data analysts handling construction or engineering data.
  • BIM specialists looking to improve data reporting capabilities.
 21 Hours

Testimonials (2)

Upcoming Courses

Related Categories