Domain : Consumer Goods
Function :
Analyze the sales data of Atliq Exclusive and provide insights into the company's performance in various areas.
Problem Statement
Atliq Exclusive is a company operating in the APAC region and wants to analyze its sales
data to gain insights into its performance. The company wants to know the markets it operates in,
the product performance, customer performance, and channel performance.
The company also wants to identify areas for improvement and growth opportunities.
Objective:
Analyze the sales data of Atliq Exclusive and provide insights into various aspects of the sales data. The project aims to achieve the 10 Ad Hoc requests given by the company to which the business needs insights:
Click to view Ad Hoc Requests
- Provide the list of markets in which customer "Atliq Exclusive" operates its business in the APAC region.
- What is the percentage of unique product increase in 2021 vs. 2020?
- Provide the unique product counts for each segments.
- Follow-up: Which segment had the most increase in unique products in 2021 vs 2020?
- What are the products that have the highest and lowest manufacturing costs.
- Generate a report which contains the top 5 customers who received an average high pre_invoice_discount_pct for the fiscal year 2021 and in the Indian market.
- What is the Gross sales amount for the customer “Atliq Exclusive” for each month .
- In which quarter of 2020, got the maximum total_sold_quantity?
- Which channel helped to bring more gross sales in the fiscal year 2021 and the percentage of contribution?
- What are the Top 3 products in each division that have a high total_sold_quantity in the fiscal_year 2021?
Methodology :
The methodology for this project involves data collection, data cleaning, data transformation, and data analysis. The project uses various statistical and analytical methods to analyze the data and provide insights. The project also involves creating visualizations to present the results in an easy-to-understand format.