How to sum up space Area per level – Using SeveUp App BIM dataSet, Matrix and slicer power BI visual

Summarizing space area per level from SeveUp App

Click on “Create Dashboard” in the SeveUp app

At this end of the tutorial you will know how to condense space Area Optimization by Level with SeveUp BIM Data. Start off by logging in to your SeveUp App account and then click on the “Create Dashboard” button.

Click on “Start”

In the centre of the tutorial page you’ll find the “Start” button. Click on that to start creating your new dashboard.

Click on “Select Project”

At the top of the page, you’ll see the wizard is now showing your progress. Click on  the large “Select Project” button in the centre.

Click on “Select Existing Project”

A popup will appear, allowing you to choose whether to select an existing project or create a new project. Click on “Select Existing Project”.

Select your project

A selection of your projects will appear in a popup box. Choose the project you want to use by clicking on the small box to highlight it with a tick.

Click on “OK”

Now click on the “OK” button located in the bottom right corner.

Click on “Next”

Now you’ll see the project you’ve chosen appear in the wizard. Then click on “Next” at the bottom to move to the following stage.

Select your Dashboard Template

Now you’ll see that the wizard has moved you onto the “Select Dashboard Template” tab. Choose your template from the ones shown by clicking on the small box to highlight it with a tick. You’ll then see it show in the right hand pane next to the “Project” you’ve chosen.

Click on “Next”

Now click on “Next” on the bottom right of the page to move onto the next part in the wizard.

Select your BIM Models

Now the wizard has moved to the “Select BIM Models” tab. Click on the BIM model you would like to use by highlighting the small box with a tick.

Click on “Get Your Dashboards”

Now click on “Get Your Dashboards!” and your dashboard will automatically download onto your computer.

Save your Project

Click on the “Save” button to save your project to your computer.

Open Microsoft Power BI

Open up Microsoft Power BI and click on “File” on the top left of the page.

Click on “Browse this device”

A menu will open up. Click on the “Browse this device” button at the bottom of the screen to search for your newly downloaded dashboard.

Select “Extension File Type

On the “Open” window, go to the bottom right and choose the correct file extension. Choose “Power BI Template Files (*pbit). Any files of this type will now show in the window.

Click on your downloaded “Dashboard”

Select your newly downloaded template file and then click on “Open”.

Click on “Load”

A pop-up will appear showing the file details. Click on “Load” and your Dashboard Template file will start to load in Microsoft Power BI.

Once your new dashboard template has loaded, it will populate the Power BI interface with all of the BIM data that was in the files you added. 

Click on “File”

In order to build the template in Power BI we first need to save it as a Power BI file (.pbix). To do this click on “File” in the top left corner of the page.

Click on “Save As”

Select “Save As” in order to save your file.

Name your file

Choose an appropriate name for your file and then click on the “Save” button. These first twenty steps can be found in several of our tutorials: here for example (how to count bim properties with Power BI in 1 min)

How to sum up space Area per level

Go to “Table View” for optimize the spacial surface by level with SeveUp BIM data

On the left hand side of the report there are several options for viewing the data. Click on the second option, “Table View” in order to display the data as a table. 

Choose a Working Table

Now, choose a WT_Qto from the list on the right hand side under the Data pane. Now you can view all of the major information about your assets within your BIM Model. 

The column ‘Asset ID’ is a common dataset for creating the relationship between WT_QTO and WT_ASSETS. 

Select “Manage Relationships”

The relationships between the data can be seen by clicking on “Manage Relationships” at the top of the screen.

Explore the data in “Name”

The “Name” column refers to the name or type of the quantity. If you drop the menu down at the side then you’ll see a filter for multiple quantities. This is all the base quantities per class that you will need and it provides more than a correctly exported .ifc can handle.

Explore the data in “Unit”

The ‘Unit’ column is an associated unit according to the quantity name. If you click on the drop down menu then you’ll be able to filter the data. 

Explore the data in “Value”

The “Value” column gives you the precise measurements relating to the Quantity “Name”.

Go back to the “Report View”

Click on “Report View” on the left-hand side of the screen to go back to the dashboard and see progress in optimizing space area per level with SeveUp BIM data.

Add a visual to your dashboard

On the right hand side of the Power BI Interface is the ‘Visualisations’ pane. Click on the ‘Matrix’ button to add the visual to your dashboard.

Utilize “WT_Assets” for optimization space area by level

Under the Data pane, click on the drop down button on “WT_Assets” to expand the menu.

Add data to your visual

Drag and drop “Name” over to the “Rows” field under “Add data to my visual”.

Add a value to your visual

Drag and drop “LongName” over to the “Values” field under “Add data to my visual”.

Select “Filters”

Click to expand the “Filters” pane that is located next to the “Visualisations” pane.

Add a filter to your visual

Drag and drop “Class” over to “Filters” so that it sits just below “Name”. 

Change the “Filter Type”

Make sure that it’s set to “Basic Filtering” under “Filter Type” and then scroll down and select “ifcspace”. This will ensure that this table will only show space related information.

Select “WT_AssetSpatial” for optimization space area by level

Under the Data pane, click on the drop down button on “WT_AssetSpatial” to expand the menu, enhancing the optimization space are per level in SeveUp BIM data.

Add data to your visual

Drag and drop “BuildingStoreyAssetName” over to the “Rows” field so it sits above “Name”. Make sure it sits above ‘Name’ and not below it as this does affect how the data is shown in the visual.

Select “WT_QTO”

Under the Data pane, click on the drop down button on “WT_Qto” to expand the menu.

Add data to your visual

Drag and drop “Value” and then “Unit” over to the “Values” section so they sit underneath “FirstLongName”.

Add another filter to your visual

Drag and drop “Name” over to “Filters”.

Change the “Filter Type”

Now move “Name” so it sits just below “Class”.  Then under “Filter Type” select “NetFloorArea”. This visual matrix is now only displaying the NetFloorArea data for ifcSpace.

Example

Select “+”

Click on the “+” icon next to Level 2 in the Matrix. This will drop the information so you can see more information with all of the values and names as well as the total.

Explore the data as a table

Click on “Focus” button in the top right of the “Matrix”. This will allow you to see it as a full table dedicated to the parameters you’ve just set.

Go back to your dashboard

Click on “Back to Report” to go back to the dashboard.

Saving the new Power BI dashboard as a project file

Open the File menu

Before uploading the Power BI custom template back into the SeveUp app, it needs to be saved as a template file with the extension .PBIT. To do this click on ‘File’ in the top left corner.

Select “Save As”

Select “Save As” from the drop down menu.

Click on “Browse this Device”

Click on “Browse this device” at the bottom of the screen. 

Choose a file type

Choose to save the file as a Power BI template file (.pbit).

Save your project

Click on the “Save” button to save your project to your computer. 

Export your template

Press on “ok” when the “Export a Template” popup appears.

Upload your template file into the SeveUp App

Click on “Dashboard Templates”

Open the SeveUp App again and click on “Dashboard Templates” on the left hand side.

Click on “Upload Dashboard Template”

Click on the large “Upload Dashboard Template” button in the centre of the folder. 

Choose your Data Sources

When the pop-up appears, click on “Data Source”.

Check off all of the groups of tables under BIM and also make sure to check the BIM 3D option so that the 3D model is included as well.

Enter the project details

Enter the name and description of your project. You can also attach a cover image or choose a different language. 

Attach your template file

Click on the “Attach File” icon on the “Template File” line.

Choose “Local Source”

From the pop-up menu choose “Local Source” to attach the file from your computer. 

Select your template

Select your template and click on “Open”.

Finalise creating your template

Click on “Create” to finish uploading your template into the SeveUp app. 

Your newly created template file will now appear in the Dashboard Templates folder and it can be used in any number of projects without the need to create a brand new template each time.

Create Your Own Free SeveUp Account

Want to get started with your very own BIM project? You’ll be surprised by just how easy it is. Create your own free account is SeveUp today and give it a try.

Create a free account