💡Leveraging Interactive Warehouse Floor Maps in Power BI

#powerbi, #imageinteractive, #shapeinteractive, #warehousefloormap, #inventoryOnhand

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.

1. Source Files

I created a sample Warehouse Floor Map and Sample Dataset which is being used for my instance.

File name
Sample Inventory On-hand Data	Sample_DS.xlsx
Sample Warehouse Floor Maps (Visio)	Warehouse_floor_layout.vsdx
Sample Warehouse Floor Maps (SVG) - Synoptic Designer	Synoptic_WH_Floor_Map.svg
Sample - Power BI report file	sample_power_bi_warehouse.pbix

Now, I will describe my data sample - file "Sampe_DS.xlsx"

Overview - Sample Data

Data Model in Power BI:

Power BI - Data Model

2. Make a Warehouse Floor Map design for 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"

  

  Visio Design - Warehouse Floor Map

  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?

  

  Make Area for Warehouse Location by Synoptic Designer

  Important: Ensure that the Area name that you want to link to Power BI data within your image has unique value.

3. Create a Power BI report

3.1 Using Visio Visual

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.

Add Visio Visual in Power BI

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:

Add - Visio Visual

3.2 Add Synoptic Panel visual

Now we move to configure on another Visual - Synoptic Panel.

Configuration:

Add - Synoptic Visual

That's all for my ideas.

Thank you for watching & Hoping well! ... 🥅🎉 [NTD]yns.asia