Course Code: powerbidia
Duration: 20 hours
Prerequisites:
  • 了解数据结构和可视化概念
  • 具备使用Excel或类似工具的经验
  • 熟悉BIM流程者优先,但不强制要求

目标受众

  • 创新与技术开发经理
  • 处理建筑或工程数据的数据分析师
  • 希望提升数据报告的BIM专业人员
Overview:

Power BI 是 Microsoft 提供的一款商业智能工具,能够跨多个数据源(包括BIM平台)实现即时数据整合、视觉化与分析。

这是一个由讲师指导的线上或线下培训,针对希望使用 Power BI 从多个数据库和BIM模型中检索和分析数据的中级专业人士,并利用AI工具进行趋势检测与报告。

培训结束后,参与者将能够:

  • 实施 Power BI 进行即时数据整合。
  • 从多个数据库和BIM来源中检索并分析数据。
  • 使用AI支持的趋势分析创建视觉化报告。
  • 整合BIM数据模型以获取技术与管理洞察。

课程形式

  • 互动式讲座与讨论。
  • 大量练习与实践。
  • 在实时实验室环境中进行实作。

课程定制选项

  • 如需为本课程定制培训,请联系我们安排。
Course Outline:

Power BI 简介

  • Power BI Desktop 和 Service 概述
  • 在工程、建筑和BIM中的应用案例
  • Power BI 架构概述

数据检索与连接

  • 连接到多个数据源(SQL、Excel、云)
  • 导入结构化和半结构化数据
  • 使用定时和实时刷新选项

数据准备与建模

  • 使用 Power Query 转换数据
  • 创建数据集之间的关系
  • 构建可重用的数据模型

构建可视化报告

  • 使用图表、地图和表格创建仪表板
  • 钻取和基于筛选的交互
  • 自定义视觉元素和设计最佳实践

应用AI工具进行趋势分析

  • 使用 Power BI AI 视觉元素和智能叙述
  • 趋势检测和基于时间的洞察
  • 使用内置分析工具的 Forecasting

与BIM数据集成

  • 从BIM工具(如 Revit、Navisworks)导出数据
  • 结构化BIM数据以兼容 Power BI
  • 可视化BIM相关指标和模型属性

发布与分享

  • 发布到 Power BI Service
  • 工作空间和访问管理
  • 内部和外部共享报告

总结与下一步

Sites Published:

United Arab Emirates - Power BI for Data Integration, Analysis, and BIM

Qatar - Power BI for Data Integration, Analysis, and BIM

Egypt - Power BI for Data Integration, Analysis, and BIM

Saudi Arabia - Power BI for Data Integration, Analysis, and BIM

South Africa - Power BI for Data Integration, Analysis, and BIM

Brasil - Power BI for Data Integration, Analysis, and BIM

Canada - Power BI for Data Integration, Analysis, and BIM

中国 - Power BI for Data Integration, Analysis, and BIM

香港 - Power BI for Data Integration, Analysis, and BIM

澳門 - Power BI for Data Integration, Analysis, and BIM

台灣 - Power BI for Data Integration, Analysis, and BIM

USA - Power BI for Data Integration, Analysis, and BIM

Österreich - Power BI for Data Integration, Analysis, and BIM

Schweiz - Power BI for Data Integration, Analysis, and BIM

Deutschland - Power BI for Data Integration, Analysis, and BIM

Czech Republic - Power BI for Data Integration, Analysis, and BIM

Denmark - Power BI for Data Integration, Analysis, and BIM

Estonia - Power BI for Data Integration, Analysis, and BIM

Finland - Power BI for Data Integration, Analysis, and BIM

Greece - Power BI for Data Integration, Analysis, and BIM

Magyarország - Power BI for Data Integration, Analysis, and BIM

Ireland - Power BI for Data Integration, Analysis, and BIM

Luxembourg - Power BI for Data Integration, Analysis, and BIM

Latvia - Power BI for Data Integration, Analysis, and BIM

España - Power BI for Data Integration, Analysis, and BIM

Italia - Power BI for Data Integration, Analysis, and BIM

Lithuania - Power BI for Data Integration, Analysis, and BIM

Nederland - Power BI for Data Integration, Analysis, and BIM

Norway - Power BI for Data Integration, Analysis, and BIM

Portugal - Power BI for Data Integration, Analysis, and BIM

România - Power BI for Data Integration, Analysis, and BIM

Sverige - Power BI for Data Integration, Analysis, and BIM

Türkiye - Power BI for Data Integration, Analysis, and BIM

Malta - Power BI for Data Integration, Analysis, and BIM

Belgique - Power BI for Data Integration, Analysis, and BIM

France - Power BI for Data Integration, Analysis, and BIM

日本 - Power BI for Data Integration, Analysis, and BIM

Australia - Power BI for Data Integration, Analysis, and BIM

Malaysia - Power BI for Data Integration, Analysis, and BIM

New Zealand - Power BI for Data Integration, Analysis, and BIM

Philippines - Power BI for Data Integration, Analysis, and BIM

Singapore - Power BI for Data Integration, Analysis, and BIM

Thailand - Power BI for Data Integration, Analysis, and BIM

Vietnam - Power BI for Data Integration, Analysis, and BIM

India - Power BI for Data Integration, Analysis, and BIM

Argentina - Power BI for Data Integration, Analysis, and BIM

Chile - Power BI for Data Integration, Analysis, and BIM

Costa Rica - Power BI for Data Integration, Analysis, and BIM

Ecuador - Power BI for Data Integration, Analysis, and BIM

Guatemala - Power BI for Data Integration, Analysis, and BIM

Colombia - Power BI for Data Integration, Analysis, and BIM

México - Power BI for Data Integration, Analysis, and BIM

Panama - Power BI for Data Integration, Analysis, and BIM

Peru - Power BI for Data Integration, Analysis, and BIM

Uruguay - Power BI for Data Integration, Analysis, and BIM

Venezuela - Power BI for Data Integration, Analysis, and BIM

Polska - Power BI for Data Integration, Analysis, and BIM

United Kingdom - Power BI for Data Integration, Analysis, and BIM

South Korea - Power BI for Data Integration, Analysis, and BIM

Pakistan - Power BI for Data Integration, Analysis, and BIM

Sri Lanka - Power BI for Data Integration, Analysis, and BIM

Bulgaria - Power BI for Data Integration, Analysis, and BIM

Bolivia - Power BI for Data Integration, Analysis, and BIM

Indonesia - Power BI for Data Integration, Analysis, and BIM

Kazakhstan - Power BI for Data Integration, Analysis, and BIM

Moldova - Power BI for Data Integration, Analysis, and BIM

Morocco - Power BI for Data Integration, Analysis, and BIM

Tunisia - Power BI for Data Integration, Analysis, and BIM

Kuwait - Power BI for Data Integration, Analysis, and BIM

Oman - Power BI for Data Integration, Analysis, and BIM

Slovakia - Power BI for Data Integration, Analysis, and BIM

Kenya - Power BI for Data Integration, Analysis, and BIM

Nigeria - Power BI for Data Integration, Analysis, and BIM

Botswana - Power BI for Data Integration, Analysis, and BIM

Slovenia - Power BI for Data Integration, Analysis, and BIM

Croatia - Power BI for Data Integration, Analysis, and BIM

Serbia - Power BI for Data Integration, Analysis, and BIM

Bhutan - Power BI for Data Integration, Analysis, and BIM

Nepal - Power BI for Data Integration, Analysis, and BIM

Uzbekistan - Power BI for Data Integration, Analysis, and BIM