💡Leveraging Interactive Warehouse Floor Maps in Power BI
#powerbi, #imageinteractive, #shapeinteractive, #warehousefloormap, #inventoryOnhand
Last updated
#powerbi, #imageinteractive, #shapeinteractive, #warehousefloormap, #inventoryOnhand
Last updated
Recently, when I worked with my wife to draw her company's Warehouse Floor Map, it was exciting to me. Then, I think about how to show the Warehouse Floor Map as a visualization in the Power BI. That can help my wife track & analyze inventory on hand, finding items by Warehouse Location easily.
Using the Warehouse Floor maps in Power BI can greatly enhance data visualization and analysis for inventory management. Here's a brief outline of my article.
I created a sample Warehouse Floor Map and Sample Dataset which is being used for my instance.
File name | |
---|---|
Now, I will describe my data sample - file "Sampe_DS.xlsx"
Data Model in Power BI:
In the Power BI, I found and used 2 visuals to make it.
Visio Visual: You must create the Warehouse Floor Map Visio file Sample Visio file for "Warehouse Floor Map" - each warehouse location is a Shape with a unique Name. This Shape Name will be used to map with the Warehouse Location in the data source file "Sample_DS.xlsx"
Important: Ensure that the Visio shapes that you want to link to Power BI data within your diagram have unique text.
Synoptic Visual: You must make some areas for the Warehouse Floor Map image by using the Synoptic Designer at the link https://synoptic.design/. How to make an area for any image by Synoptic Designer?
Important: Ensure that the Area name that you want to link to Power BI data within your image has unique value.
You must get Visio Visual first ( ... > Get more visuals > Visio Visual). After that, we add this Viso Visual to the Report page and configure it as the image below.
Due to the Visio Visual connecting exclusively through URL, it's necessary to upload the completed Visio File to a cloud service (e.g., SharePoint, OneDrive) upon design completion.
Configuration:
Now we move to configure on another Visual - Synoptic Panel.
Configuration:
That's all for my ideas.
Thank you for watching & Hoping well! ... [NTD]yns.asia
Sample Inventory On-hand Data
Sample Warehouse Floor Maps (Visio)
Sample Warehouse Floor Maps (SVG) - Synoptic Designer
Sample - Power BI report file