Multi-Phase-SKU-Analysis

Project Objective:

Provide analysis for priority-wise quantity sold share (%) in each phase.
List items/SKUs with no change in priorities through the 5 phases.
Provide catalogue distribution priority-wise for each phase.

Purpose of the Catalogue Analysis:

To help the organization understand the distribution of items sold across different phases based on their priority.

Importance of Analyzing Catalogue Data:

Identify consistent top-performing items/SKUs.
Understand the shift in item priorities over different phases.
Support decision-making for future product launches and inventory management.

Role of Reports:

Provide insights into the most and least prioritized items in each phase.
Help track the performance of items consistently prioritized across phases.
Facilitate strategic planning for product distribution and marketing efforts.

Phases and Date Ranges:

Phase 1: 1 Jan 2020 – 23 April 2023
Phase 2: 24 April 2023 – 3 August 2023
Phase 3: 4 August 2023 – 9 November 2023
Phase 4: 10 November 2023 – 26 February 2024
Phase 5: 27 February 2024 – 31 March 2024

Technical Skills:

Proficiency in data analysis using Excel.
Ability to create and format comprehensive reports in Excel.
Knowledge of extracting and transforming data to analyze sales performance.

Soft Skills:

Understanding of product and sales analytics.
Ability to present data in a user-friendly and understandable manner.
Systematic approach to analyzing and reporting data.

Project Files:

Priority Details: Contains priority details of SKUs across different phases.
- Columns: SKU, Phase, Priority
- Rows: 5K+
Database: Contains details of quantity sold for each SKU.
- Columns: PO Date, SKU, Quantity
- Rows: 215K+

Detailed Report:

The detailed report for this project is provided in the attached PDF files: