SALES ANALYSIS REPORT – SMARTPHONES & GADGETS COMPANY

SALES ANALYSIS REPORT – SMARTPHONES & GADGETS COMPANY Author : Karim Bennaceur Date : September 2025

1- INTRODUCTION The company wants to analyze its monthly sales to identify consumer trends and optimize its business strategy. The dataset contains sales data of smartphones and gadgets. The main objectives of this analysis are to:

Identify the month with the highest revenue.

️ Determine the city with the maximum number of orders.

⏰ Identify the best time to run advertising campaigns to increase sales.

Identify the best-selling product.

Identify the most popular product combinations.

2- DATA CLEANING AND PREPARATION Before analyzing the data, the following steps were performed: • ? Removal of missing values and duplicate entries. • Conversion of columns to appropriate formats (dates, numeric values). • Creation of additional columns (month, order time) to facilitate analysis. The dataset is now clean and ready for analysis.

3- ANALYSIS AND ANSWERS TO THE QUESTIONS 3.1 Month with the Highest Revenue The monthly revenue analysis shows that December achieved the highest revenue, reaching approximately 4,613,443.34 €/$. This peak is likely due to the holiday season, including Christmas and New Year celebrations, when people purchase gifts and take advantage of seasonal promotions. This period is therefore a key opportunity to plan inventory, marketing campaigns, and special offers.

3.2 ️ City with the Maximum Orders The city of [San Francisco] recorded the largest number of orders, representing a significant portion of total sales. This city is therefore a priority market for commercial campaigns and distribution.

3.3 ⏰ Best Time for an Advertising Campaign Hourly analysis shows that peak orders occur between 12:00 and 13:00. This is likely because people take a lunch break during this time and often use the opportunity to browse and place orders online. Advertising campaigns scheduled around this hour can therefore maximize visibility and sales.

3.4 Best-Selling Product The product AAA Batteries (4-Pack) is the best-seller, with the highest number of sales. This is likely because it is the least expensive product, making it an easy and frequent purchase for customers. Highlighting this product in promotions can help boost sales further.

3.5 Most Popular Product Combinations Certain product combinations frequently appear in orders: • Google Phone + USD-C Charging Cable • iPhone + Lightning Charging Cable These combinations are likely popular because customers who buy a smartphone usually also need a compatible charging cable. These trends suggest creating promotional bundles to encourage combined purchases and increase revenue.

4- CONCLUSION AND RECOMMENDATIONS Key Points: • Top revenue month: [December] • Top-performing city: [San Francisco] • Best campaign timing: [between 12H-13H] • Flagship product: [AAA Batteries(4-Pack)] • Popular product combinations: [Google Phone + USD-C Charging-cable, Iphone + Lightning charging cable]

Recommendations: 1- Focus promotions during the highest revenue month (December). Take advantage of the holiday season, including Christmas and New Year, when people are more likely to purchase gifts. Plan special offers, discounts, and marketing campaigns to maximize sales. 2- Strengthen distribution and marketing visibility in the top-performing city. Ensure that stock levels are sufficient and increase local advertising to capture the high demand in this key market. 3- Schedule advertising campaigns during peak hours (12:00–13:00). Launch promotions around lunch breaks, when people are more likely to browse online and place orders, to maximize engagement and sales. 4- Highlight the best-selling product (AAA Batteries 4-Pack) in all promotions. Promote this affordable and popular product, as its low price encourages frequent purchases and can attract more customers to your store. 5- Create promotional bundles for the most popular product combinations. Offer bundles such as Google Phone + USB-C Charging Cable or iPhone + Lightning Charging Cable, since customers buying a smartphone usually also need a compatible charger. Bundling can increase combined sales and overall revenue.