Ifc space asset details Power BI template

Posted by Admin

Business intelligence, Ifc, Integration, Microsoft, Power BI, Report, Template, Vcad

16 November 2020

In this post we will see an overview of the Space  Asset Details template, which can be downloaded from the Vcad file manager.

During this post I will assume you already know how to upload a BIM file to Vcad and how to download a Power BI template containing the Vcad custom viewer. For more information on these topics checkout our other blog posts and our tutorial videos on YouTube.

Focus of the template

The Space Asset Details template is of course focused on the spaces and assets defined in our BIM file. The information regarding the spaces and assets have already been automatically extracted by Vcad when the file was first uploaded. In particular, the example shown in this article is an .ifc file and it goes without saying that it must contain spaces to use this type of template.

Template structure

The Space Asset Details template has several visuals, in particular:

  1. Vcad custom visual with the model already setup
  2. Floor Level
  3. Asset per floors
  4. Asset Type
  5. Asset per types
  6. Asset attributes
  7. Asset name

Let’s review these visuals in detail.

1.  Vcad custom visual

The Vcad custom visual is already loaded in the template and set up with the model we had selected when downloading the template. The visualizer is linked to the data displayed in the other visuals allowing us to filter and highlight elements of the model base on selections in the other visuals as well as filter the data in the other visuals based on selections in the visualizer.

2. Floor level

The Floor Level visual displays the list of all the floors defined in the model.

3. Asset per floors

The Asset per fFoors visual displays the number of assets present into the selected floor.

4.  Asset type

The Asset Type visual displays the list of all the asset category.

5.  Asset per types

The Asset per Type visual displays the number of asset by category.

6.  Asset attributes

The Asset Attributes visual displays the attributes of the selected assets.

7.  Asset name

The Asset Name visual displays the names of the selected assets.

Available data tables

The Power BI template we have downloaded is only the starting place to create our own report with all the information and visuals we may need. To allow further analysis, in the template we ca find several data tables with information extracted from the model. Let’s have a look.

  1. Assets – List of all the elements in the model.
  2. AssetAttributes – List of the attributes of the assets.
  3. Floors – List of the various floors in the model.
  4. FloorsAttributes – List of the attributes of the floors.
  5. Spaces – List of all the spaces defined in the model.
  6. SpaceAttributes – List of the attributes of the spaces.
  7. SpacesFloors – Relation between spaces and floors.
  8. SpacesAssets – Relation between spaces and assets.

The data in these tables can then be linked to external data sources to create an infinite number of reports.

Conclusion

In this post we looked at the Space  Asset Details template, in particular the visuals it starts out with and the data tables that are preloaded in the template when we download it.

Thank you for reading.

You May Also Like…

CONTACTS

Blogic s.r.l.
via F. Mengotti, 15
00191 Rome (RM) Italy
P.Iva 05731610720
support@bimservices.it

FOLLOW US

If you want to be updated on future Vcad developments please follow us on