Objective:
This dashboard aims to analyze the shopping sales data of Istanbul and gain insights into sales patterns, popular products category, popular malls and customer behaviour. The project includes data cleaning, data visualization, and data analysis using only Excel.
Dataset:
The shopping sales data of Istanbul was obtained from Kaggle for the period between January 20121 and March 2023. The dataset contains information about the date of purchase, customer ID, product ID, product category, and the price of each product.
Methodology:
​
The analysis was conducted using Excel, where the data was cleaned, processed, and visualized. The following steps were taken:
-
Data Cleaning: The data were checked for missing values, duplicates, and incorrect entries. Any inconsistencies were corrected, and the data was standardized.
-
Data Processing: The data were grouped by product category, customer ID, and date of purchase. The total sales for each category, year, and month were calculated.
-
Data Visualization: The data was visualized using charts and graphs to understand the trends in sales, popular products, and customer behaviour.
Results:
​
-
Popular Products: The most popular products were found to be from the clothing category, followed by cosmetics, food and beverages, and toys.
-
Sales Trends: The sales trend showed a curvy graph from January 2021 to December 20221, with a peak in sales during the month of June. However, sales dropped in odd months (Feb, April, June etc) and increased in even months (Jan, March etc) with October being at its peak in 2022. Overall January has the max sales of ₺ 7.9M.
-
Customer Behavior: The analysis showed that the majority of customers were from the age group between 18-29 followed by 30-39 with female customers being the highest. The customer preferred payments through cash mode.
​
Conclusion:
​
In conclusion, the analysis of the shopping sales data of Istanbul using Excel provided valuable insights into the sales patterns, popular products category, and customer behaviour. The analysis showed that clothing was the most popular product category, and customers preferred to make purchases transactions by cash with the Mall of Istanbul being the top mall. These insights can be used by retail stores to optimize their sales strategy and improve customer satisfaction.
Insights:
​
-
To increase sales, the retail store should focus on promoting clothing, which is the most popular product category.
-
The retail store should consider offering discounts to their female customers as they are their target customers.