SALES DATA ANALYSIS WITH POWER BI

Project Goal: Analyze the sales data to identity trends ,top -selling products and revenue metrics for business decision- making.

Tools : Ms Excel and Power BI

Data Source: From MeriSKILL

The following are the steps carried out for the analysis.

Data Exploration: The original Excel spreadsheet of the sales data sets were duplicated to avoid lossing the data completely in case of error during analysis. I went through the datasets to get familiar with them.This aids me to comprehend the data , to ascertain the number of columns that require cleaning and necessary columns needed to manipulate for the project goals.

The table has 10 columns which include Serial Number , Order ID, Product,Price each,Order Date, Purchase address, Month,Sales City and hour. It has 185950 rows.

Data Preparation: Analyses were carried out on the link above (Duplicated of Original files). Month column was renamed as Month number.

Calculations were done as below in Excel Environment:

Revenue = Quantity* Sales

Profit = Revenue — Total Cost

Profit Margin =( profit/Revenue)* 100

Data Analysis : The analyzed Excel Sales datasets were load ,extracted to power BI and transformed to answer required questions.

Below are the insights generated from the data analysis.

• Bar Chart used to illustrate the top 5 selling products
• Line charts were used to illustrate both monthly and daily profit trend
• Column chart to illustrate top 5 cities by sales
• Table was used to illustrate product, Total Profit and profit margin at a glance.

Insights Drawn

• April has the highest profit (17k) followed by October (13k) and then December (12k).
• Highest sales and profit were made mostly on Monday followed by Saturday.
• MacBook Pro Laptop and IPhone are the most sold products among the top 5 best selling products
• The products are mostly sold in San Francisco and Los Angeles. Hence, they generated most revenue.

Recommendations

1. During the month of February where there was a drop in sales , more campaigns adverts should carried out and implemented as soon as possible

2. Developing promotions or deals on the products Think Pad Laptop, Google Phone , 27 in Gaming Monitor.