Inventory Stockout Monitoring with Snowflake
The workflow processes stockout data about different item categories and across different warehouses in the US, for the years 2022 and 2023. After connecting and loading the data to Snowflake, the workflow trims warehouse location names to keep only the city, aggregates stockout counts for all cities by month, and sorts the results by date. Next, it visualizes the monthly stockout trend for selected warehouse locations in respective item categories and returns stockout predictions for the current month.