Warehouse and Retail Sales Analysis

Warehouse and Retail Sales data process Data processing was performed using Python (pandas, numpy), and the following processing procedures were followed: Check basic data details, such as the number of rows and columns and the data type for each column. Check for duplicates. Deal with null values ​​appropriately for each column. An example of this is the null value in the Suppliers column. The null value was dealt with by grouping the data based on the item type and considering the most common supplier for each item type to fill in the corresponding null values. Check for outliers and their impact on the analysis process. Deal with text columns to ensure uniform character formatting. Create a date column for chronological comparisons. Creating a column for the month, quarter, and total number of cases for subsequent analysis. In the second phase, we conducted an exploratory analysis. 1 - When creating line charts to track sales over time (months), we observed a clear seasonal trend. We also noted an unexpected drop in sales in December, which is unusual given that it is a holiday month. This issue warrants further study. We also recommend paying attention to inventory management during peak periods to ensure that market demand is met during peak periods, as well as for the marketing and human resources departments. It is also necessary to study how to increase sales in the first quarter of the year, which showed a significant decline. We also note the dominance of warehouse sales over the sales process, which deserves further attention. 2 - Analysis of categorical variables revealed the following: Beer dominates warehouse sales, while both wine and liquor surpass it in transfers and retail sales. However, beer's dominance remains constant as the best-selling product. Therefore, caution when dealing with the largest source of sales is essential. This section does not contain all the observations, but the graph provides details. 3 - When analyzing suppliers, we analyzed the largest suppliers of the most important types of items to investigate the risks of monopolization of a particular supplier and other supply chain problems. We found that there are approximately three major suppliers for the three largest categories of sales, which is beneficial when negotiating and avoids monopoly problems. There are also many smaller suppliers, which means a smooth supply chain. 4 - We studied the various relationships between warehouse sales, retail sales, and retail transfers. We found a positive relationship between retail sales and retail sales. TRANSFERS, as well as the absolute dominance of warehouse sales, and the stable ratio of retail sales to transfers, do not indicate bottlenecks in transfers. In conclusion, we can focus on studying the warehouse due to its absolute dominance over sales and examining seasonal causes.