Inventory Management Dashboard and Visualization

Show the Community!
1

Hey all!

I’ve been developing inventory tracking algorithms using pandas and in-house APIs for inventory/sales analytics for e-com.

Common across all my clients is a lack of clear visual for current inventory stock levels.

I feel Streamlit is a natural, easy means of spinning up instances for them to access on mobile devices and connect to an SQL server with their specific details.

Most frequently requested KPI is low inventory levels.

What would y’all recommend? I’m at an impasse for visuals.
Thank you in advance! :balloon:

1 Like
2

This seems like a great idea because it also opens the door for more advanced ML based analytics down the line like predictive purchasing suggestions! At first glance, I would think that one or more bar charts would be an ideal solution, with the key being that you would need to normalize each inventory metric against some benchmark that makes sense for each (e.g. an “ideal” inventory number, or a theoretical/practical max) so that you could display dimensionless values that are worth showing side by side. For this you can use streamlit’s built in bar_chart, altair_chart, or vega_lite_chart.

For displaying low inventory, you might have a separate bar chart that only displays normalized inventories below an alarm value (again this would have to be set per item for it to make sense).

Hopefully that’s helpful,
Charlie

1 Like
3

Great ! working inventory tracking use cases,Streamlit is definitely a solid choice for mobile-friendly dashboards.

For low inventory visualization, here are a few approaches that might help:

Bar Charts with Alerts
Gauge Charts
Heatmaps
Interactive Tables
Time-Series Trends

If you’re using Pandas heavily, combining it with plotly.express in Streamlit could give you dynamic, real-time updates.