"In this analysis, I will examine a spreadsheet containing data randomly collected from the internet. For a more realistic dataset, one could consider utilizing resources such as data.gov.in."
Spreadsheet link : https://1drv.ms/x/s!Ar_x33EqQD_igzcihJrgiUcuMiKN ( copy & paste if you r not able to access )
Rows: Each row in the dataset represents a specific transaction or sale. It provides information about which product was sold to which customer in a particular shop, along with the corresponding sales amount.
Columns:
Product: This column indicates the name of the product sold.
Customer: Represents the customer to whom the product was sold.
Shop-1, Shop-2, Shop-3, Shop-4: These columns show the sales amount for the respective product and customer combination in each shop.
Analysis:
Top Products: Alice Mutton, Boston Crab Meat, and Chef Anton's Cajun Seasoning are notable top-selling products. Some customers, like BERGS and BOTTM, consistently make purchases, while others show more sporadic buying patterns.
Shop-3 stands out with the highest total sales, suggesting it might be a more profitable location.
So, Shop-3 leads in total revenue, contributing significantly to the overall sales.
Alice Mutton: Popular across multiple shops, especially at BOLID, ERNSH, and SAVEA.
Aniseed Syrup: LINOD and QUICK show significant sales.
Boston Crab Meat: Distributed sales across various shops, with notable sales at BONAP, OTTIK, and QUICK.
Camembert Pierrot: Quick and WARHT have high sales for this product.