TITLE: INITIAL  ANALYSIS OF RETAIL SALES DATA

Introduction:

This analysis aims to provide an initial overview of retail sales data, focusing on identifying sales and strength, top performing product, and keep customer segment.

Data Overview:

The data contain information on orders, including order number, quantity order, price, sales, product details, customer information, and sales dates, it consist of 25 columns and 2823 rows.

Data cleaning: checked missing values, duplicates, and replace to correct data types.

Initial Insights

1.   1.  Sales Trend Over Time: Analysis of monthly sales trends revealed that sales peak during the end of August, and drops back in December. The highest sales were recorded in August, which could be preparation for end of the year.

2.   2.  Top Performing Products: The top-performing products, based on total sales, include products codes 5700_4002, 5700_3505, 5700_3962, 572_1253, and 572_3212. These are the top five selling products.

3.    3. These products consistently show high sales volume.

Customer Insights: Sales analysis by country highlighted that the USA, Australia, and Canada are the top markets, contributing significantly to overall sales.

CONCLUSION: The initial analysis provides valuable insights into sales patterns, product performance, and customer segments, Further analysis could explore the impact of promotions and discounts on sales, customer segments. Further analysis could explore the impact of promotions and discounts on sales, customer lifetime value, and predictive modelling for future sales trend.   


 

Comments

Post a Comment

Popular posts from this blog

Image
 Title: Hotel Booking Predictive Analysis INTRODUCTION Hospitality Haven's humble beginnings with a single hotel in Accra, Ghana have blossom into a global hotel chain across continent. Hospitality Haven pride itself on an unwavering commitment in luxury,  impeccable service and guest satisfaction. Their properties includes luxury hotels, boutique gems, stunning resort. They are strategically located business hotels, each designed to provide unique and exceptional experience. Business Challenge The prevailing challenge: Hospitality Haven faces the challenge of efficiently managing the hotel bookings, pricing and occupancy rates. The challenge is further exacerbated by the competitive nature of the travel and tourism, industry which is influenced seasonality, market demand fluctuations, and evolving customer preference. The specific obstacles the company encounter includes: Seasonal variation. Pricing Dilemma. Customer Behavior Understanding. Demand Forecasting. Competitive Int...
Read more

DIGITAL MARKETING ANALYSIS

Image
  TITLE:   Maximizing E-commerce Impact with Precision Digital Marketing Analysis   INTRODUCTION:   Fresh Cart is an online grocery platform that simplify grocery shopping for customers. The platform offers a wide range of fresh and quality products, all delivered right to their doorstep.       Fresh Cart was launched in 2018 and has quickly gained a loyal customer base due to it impeccable service, diverse product range, and competitive pricing. The platform seamless online experience and dedicated customer service have made it a major player in the online grocery market.        Project Objectives:  The aim of this project is to analyze fresh cart past advertising data and create a strategy to optimize their digital ad spending. The specific objective are: 1. Evaluate the effectiveness of current campaigns across platforms. 2. Identify top-performing channels for advertising.  3. Assesses demography engagement a...
Read more