Introduction
The retail dataset contains the sales at a retail store. The data includes the following details: Cost of goods sold, customer assessment of sales rep, Discount applied, cost of goods etc
Data Cleaning and Preparation
The dataset was loaded into power BI’s power query editor for cleaning in preparation for analysis. Initially the dataset contained empty rows and column, which were removed. Additionally, misspellings and duplicates were corrected or removed to ensure only accurate values were used.
Analysis and Insights
The analysis revealed that the total cost of goods by the retail store is 90K with the total sales price as 128K and Total Discount being 40.04.
Cost of Goods Sold by Product Category
The product category with the most cost in this retail store is the electronic category while automotive parts has the least cost.
Cost of Goods sold by Customer Segment
In the dataset retail customer had the highest cost of goods sold while institutional customers had the least cost of goods sold.
Sales Amount by Customer assessment of sale rep
In the dataset customers assessed as positive had the highest sales amount of 63K(49.35%) while the ones assessed as negative had the lowest sales of 31K(24.59%).
Cost of Goods Sold by Customer Assessment of Sales Rep
In the dataset the customers assessed Positive had higher cost of product sold of 44k(48.76%) while the customers that were assessed as Negative has the least cost of goods sold of 22K(24.78%).
Here is an overview of the analysis:
