Leveraging Interactive Warehouse Floor Maps in Power BI

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

PreviousDataverse link to Microsoft Fabric NextCalculation Group for Time Intelligence

Last updated 10 months ago

Was this helpful?

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 Warehouse Floor Maps (Visio)

Sample Warehouse Floor Maps (SVG) - Synoptic Designer

Sample - Power BI report file

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

Data Model in Power BI:

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"
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.

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.

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:

3.2 Add Synoptic Panel visual

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

Configuration:

That's all for my ideas.

PreviousDataverse link to Microsoft Fabric NextCalculation Group for Time Intelligence

Last updated 10 months ago

Was this helpful?

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 Warehouse Floor Maps (Visio)

Sample Warehouse Floor Maps (SVG) - Synoptic Designer

Sample - Power BI report file

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

Data Model in Power BI:

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"
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.

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.

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:

3.2 Add Synoptic Panel visual

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