How to Display Stock

[EduardoLIma]

Good morning!

I was hoping you could help me with the best way to display information on inventory.

The company I work at has 120 tanks (all numbered 1-120) that have 3 types of juice stored in them. Between production and sales, the stock/amount of juice available varies throughout the week/month/year.

What I would like to do is have a sort of map/visual that could show me all 120 tanks at a glance, with the amount of juice available in each one, and that, depending on what type of juice is stored  in it, displayed a specific color, so there'd be 3 colors = 3 types juice

Also I should be able to see the certain info regarding the juice in each tank, specifically 4 parameters given by the lab.

The closest I've come was with a tree visual, but the squares didn't come out all in the same size and i wasn't able to add the additional info. I also tried a bar chart but it just wasn't working at all.

Any ideas on how I could achieve this? I'm able to send sample data.

Thank you in advance.

Regards

Eduardo Lima

[EduardoLIma]

Thank you for your suggestions, I-ll be giving them a try! I was just attempting to put into excel how I imagine in my head i would like to visualize the info i Power BI, i'm posting a picture. 

Something like this, except the colors would be determined by the product in each tank and then i'd also be able to see those parameters seen in the table (brix, ratio, etc) and the total kg of each tank would show instead of that date 

[foodd]

Less is more.  Add padding between each visual.   Think in small multiples

that are immediately picked up by the user to tell a particular status.  Think icons

and infographics.  Just remember, this will be fun, folks will love it, and ask for more 🙂

Inviting @technolog into the discussion.   @technolog , how would you approach this, thoughts?

[foodd]

In production, how is this currently visualized on a status board or process control system,

and what would provide the most information in the first 1-3 seconds.

Suggest making this similar visually to what is in use now.   You can get very creative with 

this without breaking the bank on effort or maintenance.  Basically, you are working around 

tables of events in progress that would drive what is at the visual layer.

What other systems produce visuals and information that folks are familiar with?

[Sergii24 · Accepted solution]

Hello @EduardoLIma,

If your data is structured in the following way:

Date Stamp	Tank	Juice	Qty	Parameter 1	Parameter 2	Parameter 3	Parameter 4
29/08/2023	1	Juice 1	374	3,0	2,0	1,0	2,0
29/08/2023	2	Juice 3	641	3,0	3,0	1,0	2,0
29/08/2023	3	Juice 2	296	2,0	1,0	2,0	3,0

I would suggest the following proposals:

Stacked Bar Chart - it will give a possibility to see at glance many tanks, however I suggest to add "Zoom slider" as you probably won't be able to visualize all values.

Matrix - you won't be able to see all tanks, but total row can help to have an idea of total stock, numbers are readable and conditional formatting is showing whether tank is full or not.

Table with sparkline - in case you need to show change of tank's filled capacity over time for all 120 tanks.

For additional information on parameters I suggest to use a built-in tooltip for a bar chart and manually created one for matrix/table (video on tooltip).

I hope it will inspire you for creating a great report! 🙂