3D warehouse in Power BI - using 3DBI
ฝัง
- เผยแพร่เมื่อ 2 ต.ค. 2024
- Video demonstrating the workflow needed to get a Trimble® SketchUp® model of a warehouse into Microsoft® Power BI® to be able to dynamically filter and colorize pallet locations based on various data fields. Read more about it here: kg-dev.be/2021...
I know nothing about Power BI, but this looks pretty cool!
Power BI is a tool by Microsoft that let's you connect to various data sources (Excel files, xml/json, databases, webservices,...) and use that data to create interactive dashboards in just a few clicks. It cannot, out of the box, visualize 3D models. That is the part we added, with 3DBI you are able to bring in any SketchUp model (or Revit) into Power BI and use the data that is there to colorize and filter objects in that 3D model. In this video it is a warehouse, but it could also have been a collection of rooms in a building where you use IoT sensor data to colorize and filter rooms, or parts of a machine that are highlighted based on when they require maintenance, ...
The goal is to add spatial insight to data, so you can see what is where.
I have idea to import 3D solids from mining planning software and import them in Power Bi with production data, but I don't know how to do this
Hi, if you can bring your 3D model into SketchUp, you could then use our custom 3DBI for SketchUp extension to bring it from there into Power BI: kg-dev.be/project/3dbi-for-sketchup/
완전 충격받았습니다...
Very interesting, I'm intermediate in PBI, I will start to apply 3d visualising with PBI in mining and geology field
That is awesome. May I have this 3D model and dataset for exercise this? sincerely
Yes, it can be downloaded directly from the tutorial page: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/
How did the excel file is made... pls help us making that excel file
Thanks in advance
Wow, This is exactly what my manager is expecting me to do.
Hello please I have the data set you used for this?
Hi, you can download the complete .pbix on the following page: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/
thanks a lot for the video
can i use another location id and it still works?
Yes, you can add any ID to each element. You can learn here how to do that: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/
Hi, I'm really interested but i dont find how to download add on in power bi thx
Hi, thank you for your message. The steps needed to get this visual in Power BI are described in the following tutorial: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/
@@informaxyz thank u so much!!!!
trying to have heat maps in that would be cool
You could use conditional formatting to achieve that. More information can be obtained here: kg-dev.be/2022/11/17/new-feature-conditional-formatting-in-3dbi/
hey, do you still work on warehouse 3d visualizing?
This is what i want to learn
Yes, you can learn how to create these yourself over here: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/
Bro how to link 3d model to data.
We have quite some tutorials available on our website that cover various topics: kg-dev.be/2022/11/07/how-to-3d-real-estate-dashboard-in-power-bi/
how do i Get this Rack Stand in SketchUP
Great video. How do I name each pallet position so it links with my data? Do I select the pallet, enter the location into the Definition field?
Hi, thank you for your message. The following tutorial handles in depth about this type of workflow: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/
Please give me the 3dbi download file
skusavvy has something similar
That might be possible. The benefit of 3DBI is that it runs in Power BI, which gives you the possibility to load and display any data you have.
Great video, inspired me! Which SketchUp license did you used for this?
Only SketchUp Pro is capable of loading extensions, which 3DBI for SketchUp is.
i have tryed to make this but for some reason my model is working really slow
You get the best performance when you keep geometry as abstract as possible. For example, the following report contains roughly 30.000 objects while still performing well: app.powerbi.com/view?r=eyJrIjoiZDcwZjg0NmUtY2EyMS00OGQ3LWJjYjAtYWQ3ZTY2YWM5YmUzIiwidCI6ImFlYzBjYTkzLTc5MGEtNDU0MC05NjY3LWI2ODdmNjViNGNkZCIsImMiOjl9
Kindly share the data..
Please find a step-by-step tutorial as well as related data on the following page: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/
This is great~!
3DBI free or paid ?
How to sort order when export location. ex: A-3-12 to A-12-3
Hi, Always start right to left. If the last character of your location is 1, 2, 3 then first make 3 pallets (or other objects) and assign a 1, 2 and 3 as their ID. Then group them en duplicate them as per the second set of characters (1...12 for example) and assign those IDs to each group of pallets. You can learn more about it here: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/
name aplikasi
This is actually pretty neat
Thank you Ahmad. Feel free to let us know if you have any questions.
Olá, sou do Brasil, consigo criar um modelo personalizado para minha empresa?
Hi, yes, you can follow the steps from the following tutorial to create a custom model suitable for your needs; kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/
Or, we can also create the model for you and help you getting started with Power BI. Please feel free to reach out if you want us to create the model and dashboard for you.
How to add project winform?
That's amazing
Glad that you like it!
The best
Thank you, Michel.
Price ?
Shooow