Complete vision for Inbounding and Outbounding of specific items
Schemas, Tables, Columns and Values are changed from the original ones to avoid sensitive data being released outside the company
Tool used:
- SQL, ETL Oracle
- Excel, Power Query
This project has been created for particular instances of fullness on specific items.
To have a complete vision there are 2 ETL Queries with weekly automated refreshes:
- The first one returns the Inventory quantity and the Shipment Pipeline at the Item level. We can analyze the Outbound possibility compared with the Inventory at Annual metric(Inventory Turns).
- The second one returns the Inbound Arrival for those specifics at the Item level.
The 2 Pipeline is extracted 2 times with Power Query, to have the vision with different granularity: Appointment Level and Item Level.
We create the Pivot Tables where we will extract all the data in a report page with the function GETPIVOTDATA
ACHIEVEMENTS
We decreased the overall Fullness of these specific items by 14% in 2 weeks.
The Inbounding of Low Turning items was decreased for 2 weeks.
The report helps in reducing the Fullness without affecting the availability of High Sales product