[Extension] new version of 3DBI will let you generate reports - looking for feedback

Hi there,

A few months ago I published a first version of 3DBI for SketchUp, which allowed you to export your SketchUp model geometry to Microsoft Power BI where you could then link in any kind of data, and use that to create interactive 3D dashboards.

However, what that version was missing, was a way to use the data that is already present in your SketchUp model. Things like: materials, volumes, tags, dc attributes, classification values, … you name it. The typical things you would like to get out of SketchUp to create part lists, quantity takeoffs, … using generate report for example.

Well, I have just uploaded a new version of 3DBI to the SketchUp Extension warehouse, waiting for approval, that does all this. It will allow you to bring your SketchUp model to Power BI and get all your SketchUp model data in Power BI (or Excel if you want). Additionally, it comes with all the goodies Power BI comes with, so you can still link in all kind of external data sources (pricing tables, product information, sensor data, scheduling data, …) and publish your model online (with an Power BI Pro subscription).

Here, for example, in a few clicks I was able to create a quantities takeoff interactive dashboard, using the 3D model and the volume, material an tag assigned to each component instance. Also, I was able to publish it online so that my partners and clients could also consult it:

Now, what I am looking for, is a few (around 5 to 10) people here on the forum that are willing to give it a try and share some feedback in return for free access during an extended (let’s say 4 - 6 months) time.

I strongly believe this has the potential to not only use your sketchup model and data during the design stage, but, with the additional extra data you can link to your SketchUp model, leverage the model for the entire period a building or machine exists.

For example, a hotel manager already has data about which rooms are rented what day. With this tool, you could sell him a SketchUp model and let him highlight all rooms that are currently occupied in a 3d dashboard. Or, with sensor data, show all rooms that are currently too hot/too cold/have too high co2 levels, …

There are a few demo’s showing a link with external data already on my webpage: https://kg-dev.be/project/3dbi-for-sketchup

But first, let’s make this the best report generator you have had in SketchUp, with your feedback.

3 Likes

@Dunno.458 @Bryceosaurus @FredsTinyHouses @crlrd

2 Likes

Here is the report from the movie in my first post here above, made publicly available on the web: Microsoft Power BI

Not the best modelling skills I agree, with just some blocks. But it should show you the potential of having your SketchUp data + geometry available in Power BI, ready for you to craft any dashboard you desire. Not satisfied with the bar chart I have chosen? No problem, you can freely add other graphs and link in other data.

Also, this new version has been approved by the SketchUp team just minutes ago, so these new functionalities are available for everyone: Extension | SketchUp Extension Warehouse

Hello Kenny,

I am truly impressed with the functionality of your tool. I work for an engineering firm and work extensively in Power BI, using dashboards forrisk assessments and recommendations of water and wastewater municipalities assets. I have searched for ways to integrate a 3D component into PowerBI, and have found nothing that has worked, until your extension. I would be happy to test this out and provide feedback if you are still looking for volunteers. I used to worked at Gensler (Architecture firm) and have years of experience with Sketchup as well. We have mutliple projects with extensive data that would really benefit with adding a 3D component to them, as they all are real life buildings and locations. Looking forward to helping out any way I can.

Thanks!

-Tom

How would I use this with a fully framed model of a house using my plugins? This looks very interesting.

Hi @Tomchee , please feel free to give the extension a try. It is available on the extension warehouse: Extension | SketchUp Extension Warehouse

You can activate a trial by using the following key: 3DBI-SKETCHUP-TRIAL-14DAYS

If you have external data regarding your assets already in Power BI and you are just interested in getting the geometry from SketchUp into BI, then the most important part is to define how your assets are identified and assign the same ID to your SketchUp objects.

There are a few options to define what data is used to assign an ID to the exported model. By default it is the entity’s persistent id that SketchUp gives each entity. You can also specify that you prefer a DC attribute, or the name of each instance, or even the material. Finally, you can specify if id’s should be concatenated.

For example, if you have a group named GROUP_A, which contains component instances INSTANCE_1 and INSTANCE_2 and you specify to concatenate IDs, then your resulting model will have 2 objects, one with ID GROUP_A.INSTANCE_1 and the other with ID GROUP_A.INSTANCE_2. Without concatenation, it would just be INSTANCE_1 and INSTANCE_2

I am working on a wiki and tutorials, so please have a look at our website: https://kg-dev.be/project/3dbi-for-sketchup/ every now and then, or if you have LinkedIn, I am fairly active over there: https://www.linkedin.com/company/kg-dev

@medeek , if you have a model that you would like me to give a go, please feel free to share it with me and I will be happy to give it a try and share my findings about it here. Does your extension also assign meta data to objects? 3DBI is not only capable of exporting the geometry, but I have also added functionality to export data, such as the obvious ComponentDefintionName, Volume, Tag, … but also all DC attributes as well as all classifications and classification values. (IFC for example)

Finally, maybe this movie says a little more about the potential:

1 Like