This project is about the Amazon Sales Analysis Report. Amazon is an American multinational technology company, engaged in e-commerce, cloud computing, online advertising, digital streaming, and artificial intelligence. It is considered one of the Big Five American technology companies; the other four being Alphabet, Apple, Meta, and Microsoft. Amazon has a reputation as a disruptor of industries through technological innovation and aggressive reinvestment of profits into capital expenditures. As of 2023, it is the world's largest online retailer and marketplace, smart speaker provider, cloud computing service through AWS, live-streaming service through Twitch, and Internet company as measured by revenue and market share. It is the second-largest private employer in the United States and the second-largest company in the World and in the US by revenue as of 2024. As of October 2023, Amazon is the 12th-most visited website in the world and 82% of its traffic comes from the United States. Amazon is also the global leader in research and development spending, with R&D expenditure of US$73 billion in 2022. The motive of this report is to analyze its Sales report from the period 2012 to 2015.
- Data Import : Connected data from the Text File and Transform it by ensuring accurate Data Type.
- Data Processing : Ensured accuracy and consistency in the data with the help of Excel Advanced features like Text to Column, changed Data Type, Remove Duplicates etc.
- Performing Descriptive Analysis : Created various Calculated Fields, generated KPI by selecting the significant columns from vast data
- Data Visualization : Constructed some meaningful insights from the processed data through Show me Field and alter the format of charts in Marks Pane.
- Creation of Dashboard : Assembled all the significant worksheets in the dashboard sheet with some additional features like Filters, Buttons, Images, Text Box etc. from the Objects field.
In this Project I have generated Calculated Fields like, Total Orders i.e. 51.3K, Total Sales i.e. $12.6M, Total Profit i.e. $1.5M, Total Quantity Sold i.e. 178.3K, Average Discount i.e. 14.3% and Profit Percent i.e. 11.6%. I have presented these in the form of KPI in the Dashboard.
- Which Region has highest Sale with the maximum Profit and which Region is suffering from greater loss ?
- Which Category and Sub-Category has the highest Sale with maximum Profit and which Category and Sub-Category has the least ?
- Which Market is contributing highest in Amazon total sales and profit ?
- Which Country has highest shipping cost and from which Region does it belong ?
- From which Country, company has got maximum order ?
- In which year the total order has maximized ?
- Which Category and Sub-Category has maximum total order ?
- Which Segment has maximum ordered from the Amazon Company ?
- Which Ship mode and Order Priority together has got maximum order ?
- What are the product id, category and sub-category of the top 3 products on the basis of total orders ?
In this Report, I have used three dashboards and those are controlled by Buttons inside the Menu Box. These dashboards are Summary, Overview and Detail Dashboards.
- In this Bar and Line Combo Chart, I got that in Western Europe it has the maximum sales and profit whereas in Central Asia it has the least sales and in Western Asia it is suffering from greater loss followed by Western Africa and Central Asia.
- In this Bar and Line Combo Chart, I found that Technology category has the highest sale and maximum profit and Copiers, its sub-category is highest in sale but Machines, another sub-category is lowest in sale whereas Office Supplies category has the lowest sale but Furniture category has the lowest profit and Tables, its sub-category is suffering from loss.
- In this Area and Bar Combo Chart, I got that in Asia Pacific it has maximum sale but in Europe it has highest profit whereas in Africa sales as well as profit is the least followed by LATAM and USCA.
- In this Word Chart, I found that Taiwan country which belongs from Eastern Asia has the maximum shipping cost followed by Chad and Lesotho whereas The Gambia country which belongs from Western Africa has the least shipping cost followed by Suriname and Cyprus
- From this Map Chart, I found that from United States company has got maximum order followed by Australia and France whereas the country from which company has got least order is The Gambia which belongs from Western Africa, followed by Malawi and Bhutan.
- In this Lollipop Chart, I found that in 2015, Company has got maximum order followed by 2014 whereas in 2012, Company has got the least order followed by 2013.
- In this Sunburst Chart, I got that maximum order came from Office Supplies category in which Binders sub-category is highly popular whereas the category from which company has got least number of orders was Furniture in which Tables sub-category was on the last position.
- From this Donut Chart, I came to know that company has got maximum number of orders from the Consumer segment whereas they have got the least number of orders from the Home Office segment.
- From this Pie Chart, I got that from Standard Class ship mode with Medium order priority, company has got the maximum order whereas from Same Day ship mode with Critical order priority, company has got the least number of orders.
10.(a) In this Product Detail Table, I came to know that the top 3 Product on the basis of total sales are as follow :
- TEC-PH-3148 : Phones-Technology category
- TEC-PH-3806 : Phones-Technology category
- TEC-PH-5268 : Phones-Technology category
10.(b) Whereas the bottom 3 Product on the basis of total sales are as follow :
- OFF-AP-4215 : Appliances-Office Supplies category
- OFF-LA-3220 : Labels-Office Supplies category
- OFF-PA-6560 : Paper-Office Supplies category
From this report, I found that Amazon Company was not at the adequate operating margin as its overall profit percent was just almost 11%. As we can see from the above insights that in many countries Company has suffered from losses. To recover from this situation Company should focus on the customer behaviour, their requirements and should improve its service facilities in order to get better feedback otherwise company will might be passed out by its competitors if it will loses the opportunity. This report and dashboard is helpful for gaining knowledge about the circumstances of the Amazon Company and to do comparison between its various categories, regions and countries, to know in which Country Amazon is highly popular and in which region it was suffering from loss and we can derive other meaningful information according to our requirement from this report.
- @Ritika821
- Ritika - Data Analyst