Query created to see the balance for specific items between the sites of the country
Schemas, Tables, Columns and Values are changed from the original ones to avoid sensitive data being released outside the company.
Tool used:
- SQL
This project has been created to see the balancing of items between sites of the same country.
The Query shapes the Data of the table from a vertical vision of the sites to a horizontal one.
This way we can calculate easy insight into the percentage share and in case to analyze if the stock is unique in only 1 site.
ACHIEVEMENTS
We redirected the items to have a balance between them.
Decreased the Outbound expenses by 1.3% in Italy and 0.6% in France having the availability in different parts of the country