Oluwafunmilayo-Analyst/Excel--ABC-Retail-Store-Sales-Analysis

This is an Excel project that Analyzes a year Sales for a Retail Electronic Store in Nigeria ## ABC Retail Store Sales Analysis --- ### Table of Content - Project Overview - Data Source - Tools - Data Cleaning and Preparation - Exploratory Data Analysis - Data Analysis - Key Findings and Visualizations - Recommendations - References ### Project Overview --- ABC Retail Store is a regional retailer specializing in Electronics, Furniture and Home Appliances. This Data analysis project aims to provide insight into the Sales Performance for the year 2025. The Management could not easily identify which products contribute most to the bottom line versus those that just have high sales volume. Operational costs (COGS) are rising in certain cities without a clear explanation. Monthly sales trends are inconsistent, and the company needs to identify “slump” months to better plan marketing campaigns. By analyzing Various aspect of the Sales data, we seek to create an interactive executive dashboard to monitor KPIs, identify the product with the highest profit,evaluate sales representative performance, Cost of Goods Sold by Citiesand Monthly Customer Trend. ### Data Source --- The Dataset used for this project is attached for your reference ### Tools Used: --- - Microsoft Excel(Power Query, Pivot Tables, Pivot Charts) - Data Cleaning, Analysis and Visualization Download here ### Data Cleaning and Preparation --- In the data preparation phase, the following task was performed: 1. Data loading and inspection : The dataset was verified that Unit Price, Quantity and Cost Price were numerical types and that the Dates field were consistently formatted to allow for Time Series analysis 2. Handling Missing Values : The Data was inspected for missing and Null Values. The data did not need so much cleaning. 3. Data Cleaning: Power Query (Data > Get Data) was used to remove duplicates and ensure dates are formatted correctly. There was no duplicate in this dataset. ### Exploratory Data Analysis --- EDA invloved reploring the sales data to answer key questions such as: - …