Get in Touch

Course Outline

Introduction to Power BI

  • Overview of Power BI Desktop and Power BI Service
  • Use cases within engineering, construction, and BIM sectors
  • Understanding the Power BI architecture

Data Retrieval and Connectivity

  • Connecting to various data sources (SQL, Excel, cloud)
  • Importing both structured and semi-structured data
  • Utilizing scheduled and real-time refresh capabilities

Data Preparation and Modelling

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

Developing Visual Reports

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

Utilizing AI Tools for Trend Analysis

  • Leveraging Power BI AI visuals and smart narratives
  • Detecting trends and extracting time-based insights
  • Performing forecasts with built-in analytics tools

BIM Data Integration

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

Publishing and Collaboration

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

Summary and Recommended Next Steps

Requirements

  • A solid grasp of data structures and visualisation concepts
  • Practical experience with Excel or comparable tools
  • Familiarity with BIM processes is beneficial but not mandatory

Target Audience

  • Innovation and technology development managers
  • Data analysts working with construction or engineering data
  • BIM professionals aiming to enhance data reporting capabilities
 21 Hours

Testimonials (2)

Upcoming Courses

Related Categories