This project addresses the ongoing organizational restructuring by implementing a robust Data Warehouse solution for the KGB dataset. The objective is to provide actionable insights and support informed decision-making to streamline operations.
- Streamline spending across diverse markets.
- Implement sustainable procedures for improved logistical systems.
- Enhance insights into sales for strategic decision-making.
- Identify top-selling products by market and date.
- Analyze average transportation costs by transport type, product, and market.
- Determine the client segment with the biggest sales by market and date.
- Create a comprehensive customer profile based on products, categories, and subcategories.
- Analyze product sales variations throughout the year.
- Calculate average revenue per sale per product type.
- Evaluate regional profits and recommend optimal investment resolutions.