The dataset comprises with Amazon Sales Data details of 12 different products in 76 countries to help optimize product profitability by answering several key questions related to the sales data.
Objective of this project is to find key metrics and factors and then show meaningful relationships between them and to create visualizations for better understanding trends and patterns
Data extraction, cleaning, and transformation using pandas, visualization with Matplotlib/Seaborn;
Python, Pandas, Numpy, Matplotlib, Seaborn
Exploratory Data Analysis (EDA)
- Absence of null values in the data.
- Most sales occurrences happened in the country 'The Gambia' so, most received orders are from Sub-Saharan Africa. Also maximum revenue generated and yielded maximum profitability.
- Lithuania is the country where maximum revenue generated
- Clothes and cosmetics are the most needed items by customers while meat is the least.
- Outliers found in Total Cost, Total Profit and Total Revenue.
![tab_amaz](https://private-user-images.githubusercontent.com/84937491/336924813-c935c228-d048-44d5-bbe7-df9cf8178766.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjYxMjkxNzUsIm5iZiI6MTcyNjEyODg3NSwicGF0aCI6Ii84NDkzNzQ5MS8zMzY5MjQ4MTMtYzkzNWMyMjgtZDA0OC00NGQ1LWJiZTctZGY5Y2Y4MTc4NzY2LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA5MTIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwOTEyVDA4MTQzNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIwZmI1NGY3MTZiOWM3ZjkyZGE4ZDE1NjQxNTcxMjBhNzg5Nzg0M2IyMmQwOWY1ZmQxZTllODMzOGZhOWY2YTImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.uAYAwnEqhKcLeAh66u4z_PQCQM35qLQfG4n4ku9Bzd0)
Tableau 2024.1
https://public.tableau.com/app/profile/sai.m.s/vizzes
Here, bar charts, area chart and map and pie chart are used to perform data visualization to show trends and insights. We can see how the sales data varies by countries, regions and item-types.