Pipeline of inventory for country and sites with control for deep diving

Schemas, Tables, Columns and Values are changed from the original ones to avoid sensitive data being released outside the company

Tool used:

• SQL
• Quicksight

This project has been created to have complete check and control of the inventory present in the countries and warehouses.

The data is sourced with a SQL query directly from the Data Lake, utomatically refreshed every Monday.

The controls at the top give us the possibility to dive deep into different kinds of items and different granularity(ex: countries and warehouses).

With the historical data returned, we can deep dive into the situation for the past week and check the variance Week on Week and have a graph with the trend.

ACHIEVEMENT

The trend graphs help us in spotting the period where the bulk fullness had a spike in France and we were able to decrease the volume by 10% giving a smoother inbounding of the items.

The filter for a product type can see where most of the volume is found and be able to take action in balancing the sites in the country.