CAD Forum - Database of tips, tricks and utilities for AutoCAD, Inventor and other Autodesk products [www.cadforum.cz]
Czech English Deutsch
Login/Register:
 Visitors: 6724 
RSS tips RSS channel - CAD tips
RSS discussion RSS channel - CAD discussion

Discussion Discussion forum

HelpCAD discussion

CAD Forum - Homepage CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.

Please abide by the rules of this forum.

How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Sam Nseir: Integrate BIM 360 data with PowerBI using R

 Post Reply Post Reply
Author
AliveInTheLab View Drop Down
RSS robots
RSS robots


Joined: 20.Nov.2009
Status: Offline
Points: 426
Post Options Post Options   Thanks (0) Thanks(0)   Quote AliveInTheLab Quote  Post ReplyReply Direct Link To This Post Topic: Sam Nseir: Integrate BIM 360 data with PowerBI using R
    Posted: 13.Nov.2017 at 04:00

Sam Nseir is an Autodesk Building Information Modeling Premium Support Specialist who supports the Architecture, Engineering, and Construction and Engineering, Natural resources, and Infrastructure industries. As part of our efforts to help Autodesk BIM customers leverage Forge capabilities, Sam developed some examples of BIM 360 data with PowerBI.


Integrate BIM 360 data with PowerBI using R

BIM 360 products enable project teams to coordinate better, communicate more effectively, and resolve issues more quickly, resulting in faster and more efficient project delivery. As cloud-based software, BIM 360 products are designed with data at the center. Data analytics is part of the standard functionalities that are offered by BIM 360 products such as the analytics tab in BIM 360 Account Administration or the Project Overview tab in BIM 360 Field. With different teams having different use of the data, the in-product analytics might not answer all of the needs. Custom analytics could enable teams to drill down to specific details and identify correlations that would not have been possible otherwise. These days, one of the commonly used tools for custom analytics is "PowerBI." Power BI is a data analytics product from Microsoft that allows users to create reports and dashboards powered by interactive visualizations to analyze data. The question here is how do we integrate BIM 360 data with PowerBI?

Autodesk Forge offers a group of APIs that provide access to BIM 360 data such as BIM 360 API (for BIM 360 Account Administration) and Data Management API (for BIM 360 Docs). By utilizing Forge APIs, we can send BIM 360 Data for additional analytics. To connect BIM 360 data to PowerBI, Forge APIs calls can be made from within Power BI using R programming. R is an incredibly easy to learn programming language that is designed for statisticians and data scientists and can be executed in PowerBI. To access BIM 360 data using Forge APIs, a Forge app will need to be created and integrated with BIM 360 Account Administration. For more details, check the following articles:

The examples below are sample custom analytics that can be performed by integrating BIM 360 data with Power BI using R programming. Each example is provided with a Power BI template to test the integration, setup instructions, a GitHub repository to access the R script.

 

Example 1: Analyze documents’ attributes from a BIM 360 Docs project

The template in this example offers the ability to analyze documents’ attributes from a project in BIM 360 Docs. This type of analysis could help the project team in the document control process such as monitoring file types, naming convention, and file versioning for documents hosted on a BIM 360 Docs project.

image01

image03

Example 2: Analyze projects’ data from a BIM 360 Account

The template in this example allows us to examine profiles’ data projects from BIM 360 Account Administration. This type of data can be useful if integrated with data from maintenance and operation systems. It also can help in drilling down to details about projects such as locations, types, and values.

image05

image07

Example 3: Analyze companies’ data from a BIM 360 Account

The template in this example provides us with an insight into companies’ data from BIM 360 Account Administration. Companies’ information such as location and trade could be beneficial if mapped with data from enterprise resource planning systems (ERP).

image09

image11


Thanks, Sam.

Examples are alive in the lab.

Go to the original post...

It's Alive in ihe Lab - Autodesk Labs blog by Scott Sheppard
Back to Top

Related CAD tips:


 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0,047 seconds.